Re:TSV – Alternative to CSV
by kjkjadksj on Sunday June 09, 2024 @01:26PM
(#40625994)
Only if you anticipate your data having commas in fields, which is somewhat rare in my experience (as in I’ve never seen it at all).
[ Parent
| on HN ]
Comma is the decimal separator in many European languages. It’s also not uncommon in strings.
Pandas can handle that with a flag
Sure. Another option is semicolon-delimited files which are also in use in Europe, and Pandas handles that fine too.
I was responding to your comment that you had never seen commas in data fields in CSV files, and wanted to point out that this is a quite common issue in Europe.
(It also often wreaks havoc with Excel files btw, as Excel will then only casts strings to decimal numbers when a file is opened in some locales...)