3 ms·
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).
by kjkjadksj 2y 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).
- setopt 2y agoComma 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...)