... csvkit: sql


The following commands are run in this video;

in2csv pokemon.csv | csvsql --query "select * from stdin where hp > 200"
csvsql --db "sqlite:///dummy.db" --tables "pokemon" --insert pokemon.csv
sql2csv --db "sqlite:///dummy.db" --query "select * from pokemon limit 5;"

Note that sqlite needs to be installed on your system for this to work. You can also connect to other databases. You can find the documentation here.

Feedback? See an issue? Something unclear? Feel free to mention it here.

If you want to be kept up to date, consider signing up for the newsletter.