Often you are handed-out big CSV files and need to sort, filter, update some cells or other tedious work.
You tried sed
, jq
, and maybe the mighty awk
.
But at the end of the day: You’re using the wrong tool for the job.
Here come csvkit’s csvsql, a small Python script to parse your CSV files and create the corresponding database. You now have the best tool, SQL, to answer your data questions: