csvkit logo csvkit: sql

1 2 3 4 5 6

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 online.