News for hackers. Stuff that matters.

A comment on You Suck at Excel (2015) [video]. Parent comment

Re:You Suck at Excel (2015) [video] by dbeley on Friday December 20, 2019 @06:31PM (#21848320)
What's the quickest way to query a simple CSV file with SQL ? Interested in any gui or cli tools.
[ Parent | on HN ]
Re:You Suck at Excel (2015) [video] by hoistbypetard on Friday December 20, 2019 @07:24PM (#21848632)
If you're accustomed to windows/office you can just set up a CSV as an ODBC data source and use access.

Otherwise [csvkit](https://csvkit.readthedocs.io/en/latest/) gives a pretty good command line interface to make sql queries against a CSV or dump the CSV into a database so you can use any standard database tool to query.

[ Parent | on HN ]
Re:You Suck at Excel (2015) [video] by slowhand09 on Saturday December 21, 2019 @12:08PM (#21852185)
In Oracle I 'd just set up an External Table. Trivial to do.
[ Parent | on HN ]
Re:You Suck at Excel (2015) [video] by cgarvis on Friday December 20, 2019 @06:43PM (#21848390)
not sql, but xsv is awesome: https://github.com/BurntSushi/xsv
[ Parent | on HN ]