pandas reading CSV data formatted with comma for thousands separator

by

Pass param thousands="," to read_csv to read those values as thousands:

In [27]:
import pandas as pd
import io

t="""id;value
0;123,123
1;221,323,330
2;32,001"""
pd.read_csv(io.StringIO(t), thousands=r',', sep=';')

Out[27]:
   id      value
0   0     123123
1   1  221323330
2   2      32001

More Related Contents:

  1. Convert commas decimal separators to dots within a Dataframe
  2. How do I read a large csv file with pandas?
  3. How to add pandas data to an existing csv file?
  4. Import CSV file as a pandas DataFrame
  5. Keep only date part when using pandas.to_datetime
  6. Pandas bar plot changes date format
  7. Pandas split column into multiple columns by comma
  8. Make Pandas DataFrame apply() use all cores?
  9. How to create a table with clickable hyperlink in pandas & Jupyter Notebook
  10. Encoding Error in Panda read_csv [duplicate]
  11. Pandas read csv file with float values results in weird rounding and decimal digits
  12. How to efficiently handle European decimal separators using the pandas read_csv function?
  13. After rename column get keyerror
  14. Python Pandas read_csv skip rows but keep header
  15. Precision lost while using read_csv in pandas
  16. Python Pandas: How to read only first n rows of CSV files in?
  17. Pandas – Strip white space
  18. Filter string data based on its string length
  19. Why is pandas.to_datetime slow for non standard time format such as ‘2014/12/31’
  20. UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0x96 in position 35: invalid start byte
  21. Standard implementation of vectorize_sequences
  22. Suppress output of object when plotting in IPython
  23. Pandas: convert date in month to the 1st day of next month
  24. Pandas ParserError EOF character when reading multiple csv files to HDF5
  25. Getting Colorbar instance of scatter plot in pandas/matplotlib
  26. Python Pandas – Read csv file containing multiple tables
  27. Is there a way to speed up handling large CSVs and dataframes in python?
  28. Pandas read_csv dtype read all columns but few as string
  29. How to remove illegal characters so a dataframe can write to Excel
  30. Turn pandas dataframe into a file-like object in memory?

Leave a Comment