csvq

SQL-like query language for CSV files with powerful data analysis

brewmacoslinux

Try with needOr install directly

About

SQL-like query language for csv

csvq

Select specific columns from a CSV file$ csvq 'SELECT name, age FROM data.csv'

Filter rows with WHERE clause$ csvq 'SELECT * FROM data.csv WHERE age > 25'

Join multiple CSV files$ csvq 'SELECT a.id, a.name, b.email FROM file1.csv AS a INNER JOIN file2.csv AS b ON a.id = b.id'