3 ms·
Comma is the decimal separator in many European languages. It’s also not uncommon in strings.
by setopt 2y ago
Comma is the decimal separator in many European languages. It’s also not uncommon in strings.
- kjkjadksj 2y agoPandas can handle that with a flag
- setopt 2y agoSure. 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...)