#52
in
Command line interface
#41
in
PostgreSQL
qsv (https://github.com/jqnatividad/qsv) also has a sqlp command which lets you run Polars SQL queries on CSV(s).
Here I'll:
- Send the csv data from stdin (using echo and referred to in the command by -)
- Refer to the data in the query by stdin. You may also use the _t_N syntax (first table is _t_1, then _t_2, etc.), or the file name itself before the .csv extension if we were using files.
- Pipe the output to the table command for formatting.
- Also, the shape of the result is printed to stderr (the (4, 2) below).
$ echo 'Name,Department,Salary
John Doe,IT,60000
Jane Smith,Finance,75000
Alice Johnson,HR,65000
Bob Anderson,IT,71000' |
qsv sqlp - 'SELECT Name, Salary FROM stdin ORDER BY Salary DESC' |
qsv table
(4, 2)
Name Salary
Jane Smith 75000
Bob Anderson 71000
Alice Johnson 65000
John Doe 60000
I shared the qsv fork [1] yesterday which is more active.
xsv is more lean while qsv tries to support every action that you might want to perform on CSV files.[2]
[1] https://github.com/jqnatividad/qsv
[2] https://github.com/jqnatividad/qsv/discussions/290#discussio...
There's a fork with new features: https://github.com/jqnatividad/qsv
I was using xsv a lot at work (it is so much faster than csvkit) but I've recently jumped to qsv, a fork with more features.