3 ms·
Pretty much every programming language in existence has a utility for parsing CSVs into tabular data while handling commas sanely. (using awk for processing is
by minimaxir 11y ago
Pretty much every programming language in existence has a utility for parsing CSVs into tabular data while handling commas sanely. (using awk for processing is not a typical pipeline)
More importantly, CSVs are handled natively by statistical programs such as Excel and R (you can change the expected delimiter while importing, but in my experience that leads to unexpected results)
- gruez 11y ago>More importantly, CSVs are handled natively by statistical programs such as Excel and R in excel or R? Because I've never encountered problems with tsv files with excel
- semi-extrinsic 11y agoR can also read both CSV and TSV just fine. Just use read.csv() or read.table() as you want. Same goes for Pandas.
- Pxtl 11y agoMicrosoft often fails with CSVs actually. I've found I can't copy/paste from Sql Server Management Studio into Excel if you have a mismatched double-quote in a cell - it fails silently and garbles your data. That was embarrassing. The CSV format is so messy that even big corporate implementations will have subtle bugs like that. Do not trust it.
- 0x0 11y agoMicrosoft excel has the worst CSV defaults. The separating character is even locale-specific! Many locales use semicolon ";" instead of "," as a separator. Great stuff when creating web app exporters.
- muddi900 11y agoExcel can handle TSV's if you name them .txt
- hiperlink 11y ago> using awk for processing is not a typical pipeline except it is. (g)awk is more often part of the pipe(d)line than other programming langueage(s) interpreter(s).