Other references and guides¶
- The official csvkit tutorial, which includes how to get things installed, how to try the commands, and even an example of how to use csvkit as the “Excel killer”
- Journocoder/educator Amanda Hickman has a csvkit tutorial among her many data journalism workshop guides and tipsheets.
- Another csvkit tutorial/example from data journalist Daniela Q. Lépiz, aptly titled, “Too much data? Use the command-line”
- A csvkit workshop at NICAR18, by Christian McDonald of UT-Austin
- A csvkit workshop at NICAR16, by data journalist Karrie Kehoe
- “Extracting and Working with CSV files” - a nice writeup by Dj Walker-Morgan in context of how csvkit can fit into the developer’s workflow.
- Eleven Awesome Things You Can Do with csvkit - A listicle of more advanced, esoteric data-wrangling techniques by csvkit’s author, Christopher Groskopf
- The slidedeck used by Groskopf and Anthony DeBarros when introducing csvkit to NICAR12 as “a suite of utilities for converting to and working with CSV, the king of tabular file formats”
I also have a few Gists in which I’ve copied-pasted some crazy one-off scenarios to look at later. At the time, csvkit fit in perfectly as a nice hack before doing “actual” coding/engineering – no guarantees if the gists make sense or even work (all of them refer to many other tools used in combination with csvkit):
- Fitting 2016 FEC campaign donor data into your humble spreadsheet
- Importing FEC bulk data with bash and csvkit
- Use public data, t, and csvkit to find Congressmembers on Twitter from the command-line
- How to download, import, and analyze San Francisco restaurant inspection data using SQLite3 and csvkit from the command-line.
- Using mdbtools to extract CSV data from the FAA Wildlife Strike database (.accdb, Microsoft Access)
- Using the t and csvkit to quickly collect and analyze #nicar16 tweets from the command-line