Convert number strings with commas in pandas DataFrame to float

by

If you’re reading in from csv then you can use the thousands arg:

df.read_csv('foo.tsv', sep='\t', thousands=",")

This method is likely to be more efficient than performing the operation as a separate step.

You need to set the locale first:

In [ 9]: import locale

In [10]: from locale import atof

In [11]: locale.setlocale(locale.LC_NUMERIC, '')
Out[11]: 'en_GB.UTF-8'

In [12]: df.applymap(atof)
Out[12]:
      0        1
0  1200  4200.00
1  7000    -0.03
2     5     0.00

More Related Contents:

  1. How do I select rows from a DataFrame based on column values?
  2. Aggregation in Pandas
  3. Pandas Melt Function
  4. pandas DataFrame: replace nan values with average of columns
  5. add a string prefix to each value in a string column using Pandas
  6. Pretty Printing a pandas dataframe
  7. Pandas: Multiple columns into one column
  8. FailedPreconditionError: Attempting to use uninitialized in Tensorflow
  9. re.sub erroring with “Expected string or bytes-like object”
  10. Pandas: Subindexing dataframes: Copies vs views
  11. pandas DataFrame output end of csv
  12. Pandas compare next row
  13. Comparing floats in a pandas column
  14. Pandas sparse dataFrame to sparse matrix, without generating a dense matrix in memory
  15. Dictionary column in pandas dataframe
  16. How do I split a string into several columns in a dataframe with pandas Python?
  17. Expanding pandas data frame with date range in columns
  18. Convert a columns of string to list in pandas
  19. Loading multiple csv files of a folder into one dataframe
  20. Pandas: combining header rows of a multiIndex DataFrame
  21. Python Pandas: Get index of rows where column matches certain value
  22. pandas groupby and join lists
  23. Row-wise average for a subset of columns with missing values
  24. Plot multiple columns of pandas DataFrame using Seaborn
  25. Pandas and Matplotlib – fill_between() vs datetime64
  26. How to solve import error for pandas?
  27. Dynamically filtering a pandas dataframe
  28. How to use str.contains() with multiple expressions in pandas dataframes
  29. Pandas: Knowing when an operation affects the original dataframe
  30. Pandas Secondary Axis

Leave a Comment