Exploratory data analysis for humanities data
I'm all for this kind of exploratory hacking around before booting up python/R/Excel/duckdb, especially in constrained environments. A classic pain point is having to deal with column numbers, so I'll share my favorite trick:<p>`head -n1 /path/to/file.csv | tr ',' '\n' | nl | grep desired_column`<p>gives you the column number of desired_column