Hacker News new | ask | show | jobs
by kjkjadksj 746 days ago
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).
1 comments

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...)