Welcome to Learn Command-Line CSV Tools

Why learning to work with data from the command-line (e.g. csvkit/xsv) is the best thing you can do for yourself no matter how good/bad/overwhelmed you think you already are at Excel/SQL/RStudio/Jupyter/pandas ffs why do we learn all that fancy syntax and GUIs and encumber our soft delicate brains when we could be doing data work like they did it in the awesome 80s but with way less effort and much better looking laptops.

cat fec-contribs.csv \
| csvgrep -c committee_name -r 'BETO|CRUZ' \
| csvgrep -c contributor_employer -r 'FACEBOOK|APPLE|AMAZON|NETFLIX|GOOGLE' \
> senate-faangs.csv
_images/csvkit-filter-texas-senate-fec.gif _images/senate-faangs-csv-crop.png

senate-faangs.csv

Indices and tables