Re:TSV – Alternative to CSV
by setopt on Sunday June 09, 2024 @03:09PM
(#40626717)
Comma is the decimal separator in many European languages. It’s also not uncommon in strings.
[ Parent
| on HN ]
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...)