News for hackers. Stuff that matters.
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).
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.
Re:TSV – Alternative to CSV by kjkjadksj on Sunday June 09, 2024 @11:45PM (#40629942)
Pandas can handle that with a flag
Re:TSV – Alternative to CSV by setopt on Monday June 10, 2024 @08:40AM (#40632940)
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...)