Databases
How to Use csvsql and q to Run SQL on CSV Files the Safe Way
Run SQL on CSV files from the terminal with csvsql and q, or plain sqlite3: queries, type inference traps, joins across files and output formats.
6 min read
Tag
csv
3 posts
Python
How to Use Python to Parse CSV and Excel Files for Reports
Parse CSV and Excel files in Python to build reports: csv.DictReader, grouping totals, writing a summary, handling encodings, and reading xlsx with openpyxl.
6 min read
Text Processing
How to Extract Columns From CSV With Quoted Commas
Extract CSV columns in the shell when fields hold quoted commas: why cut fails, and how to use csvkit, Miller, awk FPAT and Python to select columns safely.
6 min read