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.
[ Parent
| on HN ]
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?