csvkit: Command-line tools for working with CSV(csvkit.readthedocs.io) |
csvkit: Command-line tools for working with CSV(csvkit.readthedocs.io) |
This was one of the reasons I wrote zsv (https://github.com/liquidaty/zsv). Maybe csvkit could incorporate the zsv engine and we could get the best of both worlds?
Examples (using majestic million csv):
---
csvcut -c 1,3 = 5.3 seconds
zsv select -n -- 1 3 = 0.19 seconds
28x faster
---
csvsql --query "select count(*) from file" file.csv = 148 seconds
zsv sql "select count(*) from data" file.csv = 0.68 seconds
216x faster
---
https://www.easydatatransform.com/data_wrangling_etl_tools.h...