News for hackers. Stuff that matters.
Re:Ask HN: How are you cleaning and transforming data before... by atentaten on Wednesday May 14, 2025 @02:40PM (#43987847)
I use Sqlite. We use csvs and Google Sheets a lot, so I usually import the csv as a sqlite table, use sql to create templates as the query results and then export those as csv for input into the templated system.
Re:Ask HN: How are you cleaning and transforming data before... by dataflowmapper on Thursday May 15, 2025 @12:01AM (#43991730)
Nice, sounds like a pretty standard approach. Have you had any issues or time sinks around repeatability where you need to tweak scripts or create new ones for different CSVs?