3 ms·
This looks very simple and easy to use. Are there any differences with using this instead of CSVKit? https://csvkit.readthedocs.io/en/1.0.3/ https://csvkit.re
by ConceitedCode 9y ago
This looks very simple and easy to use.
Are there any differences with using this instead of CSVKit?
https://csvkit.readthedocs.io/en/1.0.3/ https://csvkit.readthedocs.io/en/1.0.3/
It includes a tool called csvsql.
Example usage -
csvsql --query "select name from data where age > 30" data.csv > new.csv
- deleted 9y ago[deleted]
- donarb 9y agoPython's pandas library can also do sql-like queries against csv data. https://pandas.pydata.org/pandas-docs/stable/comparison_with_sql.html https://pandas.pydata.org/pandas-docs/stable/comparison_with...
- jillesvangurp 8y agoWas wondering the same. I've been using csvkit a lot lately. This looks like a subset of functionality using more or less the same approach. Csvsql uses sqlite under neath and you can do some nice things with this like joins, using sql functions, etc. There is also stuff like amazon athena that allows you to do similar things in s3 at scale. Csvkit is great with pipes and you can also easily convert between csv tsv and even stuff like json.
- michaelmior 8y agoAlthough csvsql is great, the real reason I love csvkit is that most of the tools feel like standard *nix tools that just operate on CSV files (csvcut, csvgrep, etc.)