HN Explorer

Ask HN: Interactive CSV Diffing Tool?

2 points by marto1 ↗ HN
How would you best diff two csv-s in 2021 ? And not just full matches, column by column too. Especially if you want to compare many thousands of rows.

2 comments

[ 3.1 ms ] story [ 12.5 ms ] thread
jstx1
I would use something like pandas or dplyr (Python and R libraries respectively). But that's for answering specific questions like finding duplicates, missing values, overlapping columns etc. - in my experience there's usually some more specific question to answer than just diffing in a general sense.
marto1
That's great. I use these myself on a daily basis, but it can turn into quite a grind, especially working with novel(to me) datasets.