logo

... csvkit.


Sometimes you don't need pandas to handle csv files. Sometimes you'd just move data around and wrangle it without a jupyter notebook. During these times you might like to know about csvkit. You can do light analysis, but also exchange with fileformats and databases.


Notes

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 getting the newsletter.