Hacker News new | ask | show | jobs
by setopt 746 days ago
Comma is the decimal separator in many European languages. It’s also not uncommon in strings.
1 comments

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