Search and replace dots and commas in pandas dataframe

by

The best is use if possible parameters in read_csv:

df = pd.read_csv(file, thousands=".", decimal=",")

If not possible, then replace should help:

df['col2'] = (df['col2'].replace('\.','', regex=True)
                        .replace(',','.', regex=True)
                        .astype(float))

More Related Contents:

  1. How to change column names from numbers to names [closed]
  2. How to provide a reproducible copy of your DataFrame with to_clipboard()
  3. Concatenate strings from several rows using Pandas groupby
  4. Replace values in a pandas series via dictionary efficiently
  5. Find column whose name contains a specific string
  6. FutureWarning: elementwise comparison failed; returning scalar, but in the future will perform elementwise comparison
  7. pandas: merge (join) two data frames on multiple columns
  8. Pandas Extract Number from String
  9. Moving Average Pandas
  10. How to deal with multi-level column names downloaded with yfinance
  11. Rolling Mean on pandas on a specific column
  12. Pandas deleting row with df.drop doesn’t work
  13. How to melt 2 columns at the same time?
  14. Count number of words per row
  15. pandas or python equivalent of tidyr complete
  16. What is the fastest and most efficient way to append rows to a DataFrame?
  17. Pandas number rows within group in increasing order
  18. pandas.io.json.json_normalize with very nested json
  19. pandas.read_csv from string or package data
  20. FutureWarning: The default value of regex will change from True to False in a future version
  21. Python pandas: how to remove nan and -inf values
  22. Check if rows in one dataframe exist in another dataframe
  23. Pandas ParserError EOF character when reading multiple csv files to HDF5
  24. Plot two levels of x_ticklabels on a pandas multi-index dataframe [duplicate]
  25. Python making combined bar and line plot with secondary y-axis
  26. AttributeError: module ‘numpy’ has no attribute ‘__version__’
  27. Pandas rank by multiple columns
  28. How to convert string representation of dictionary in Pandas DataFrame to a new columns?
  29. Python Pandas – Lookup a variable column depending on another column’s value
  30. Confusion about pandas copy of slice of dataframe warning

Leave a Comment