3 ms·
Happy paying Modern CSV user here and I say Yes please to item 4. I recently was given a pile of hand-edited CSV files (a one off data transfer between two sys
by pbowyer 4y ago
Happy paying Modern CSV user here and I say Yes please to item 4.
I recently was given a pile of hand-edited CSV files (a one off data transfer between two systems). The original export was missing one column, so being able to merge that in would have been very useful.
I'm sure with Pandas if you know the magic incantation it's easy to do (join two files on the ID column, and add column X from file 2 to file 1) but I wrote my own script for these files.
In others I've resorted to opening the CSV in Excel, doing an XLOOKUP and then fixing up the mess Excel created in Modern CSV afterwards.
(To the sibling commenter saying you can do it with SQL: yes and I'd love to. But how do you pipeline that with multiple CSVs that may have slightly different column names? If done manually it seems quicker to do it my way)
- Closi 4y agoI think you can do this in PowerQuery in excel and export as a clean CSV for the future fyi
- pbowyer 4y agoThanks, I'll look for that next time. The problem with Excel and these CSV files was it mangled the date column, which I only found out about after a bunch had been fully edited. I used modern CSV to rescue this and so have been suspicous of going back to Excel to do any further manipulations.
- Closi 4y agoThe good news is PowerQuery has data types! Although it is not as flexible in editing particular records if that is a requirement (just bulk edits, joins and merges)