converting currency with $ to numbers in Python pandas

by

@EdChum’s answer is clever and works well. But since there’s more than one way to bake a cake…. why not use regex? For example:

df[df.columns[1:]] = df[df.columns[1:]].replace('[\$,]', '', regex=True).astype(float)

To me, that is a little bit more readable.

More Related Contents:

  1. Python returns "SyntaxError: invalid syntax sys module" [closed]
  2. How to write to an existing excel file without overwriting data (using pandas)?
  3. How to sort a dataFrame in python pandas by two or more columns?
  4. How to display pandas DataFrame of floats using a format string for columns?
  5. Why isn’t my Pandas ‘apply’ function referencing multiple columns working? [closed]
  6. Reading an Excel file in python using pandas
  7. How do I create test and train samples from one dataframe with pandas?
  8. How to map numeric data into categories / bins in Pandas dataframe
  9. Check if a string in a Pandas DataFrame column is in a list of strings
  10. Naturally sorting Pandas DataFrame
  11. Convert timedelta64[ns] column to seconds in Python Pandas DataFrame
  12. How to normalize json correctly by Python Pandas
  13. Insert a Pandas Dataframe into mongodb using PyMongo
  14. Improve Row Append Performance On Pandas DataFrames
  15. Comparing two pandas dataframes for differences
  16. Use Multiple Character Delimiter in Python Pandas read_csv
  17. Merging dataframes based on date range
  18. pandas: replace string with another string
  19. how to merge two data frames based on particular column in pandas python?
  20. How to solve import error for pandas?
  21. I want to multiply two columns in a pandas DataFrame and add the result into a new column
  22. pandas, melt, unmelt preserve index
  23. Parse a Pandas column to Datetime when importing table from SQL database and filtering rows by date
  24. Python Pandas – Read csv file containing multiple tables
  25. Group DataFrame in 5-minute intervals
  26. Python Pandas add column for row-wise max value of selected columns [duplicate]
  27. Python Pandas: remove entries based on the number of occurrences
  28. How to filter a DataFrame column of lists for those that contain a certain item
  29. Read .doc file with python
  30. How to slice a pandas DataFrame by position?

Leave a Comment