Replies: 3 comments 1 reply
-
|
I'm also currently facing this issue. It should be noted that pandas read_csv already has this parameter, but the file I am working with is far too big for pandas to be useful there. |
Beta Was this translation helpful? Give feedback.
-
|
In the meantime, you can read the affected columns as strings and then do the cleaning and casting yourself. |
Beta Was this translation helpful? Give feedback.
-
|
I was so focused in trying to find ways to directly import from CSV that I overlooked this option. Thank you! It is a good workaround for now :) |
Beta Was this translation helpful? Give feedback.
-
|
I have the same problem with thousands separators in csv files. Example:
|
Beta Was this translation helpful? Give feedback.
Uh oh!
There was an error while loading. Please reload this page.
-
Especially in CSV files which are made using Excel ("export as CSV"), you get numbers with a thousands separator included. That looks as follows:
1,000,500.50
5,450.36
Or in European countries where the comma is used as a decimal separator:
1.000.500,50
5.450,36
This is a very common display format for currency values. It would be very helpful, if the
read_csv-function could get a parameterthousands_separatorto specify this situation and to enable it to interpret these values as numbers (as 1000500.50 or 5450.36).Beta Was this translation helpful? Give feedback.
All reactions