pandas applying regex to replace values

by

You could use Series.str.replace:

import pandas as pd

df = pd.DataFrame(['$40,000*','$40000 conditions attached'], columns=['P'])
print(df)
#                             P
# 0                    $40,000*
# 1  $40000 conditions attached

df['P'] = df['P'].str.replace(r'\D+', '', regex=True).astype('int')
print(df)

yields

       P
0  40000
1  40000

since \D matches any character that is not a decimal digit.

More Related Contents:

  1. Fast punctuation removal with pandas
  2. Create Pandas DataFrame from txt file with specific pattern
  3. How to filter rows in pandas by regex
  4. How to remove parentheses and all data within using Pandas/Python?
  5. re.sub erroring with “Expected string or bytes-like object”
  6. Strip / trim all strings of a dataframe
  7. FutureWarning: The default value of regex will change from True to False in a future version
  8. applying regex to a pandas dataframe
  9. Python: UserWarning: This pattern has match groups. To actually get the groups, use str.extract
  10. How to use str.contains() with multiple expressions in pandas dataframes
  11. How to parse complex text files using Python?
  12. cartesian product in pandas
  13. Keep other columns when doing groupby
  14. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  15. Convert the string 2.90K to 2900 or 5.2M to 5200000 in pandas dataframe
  16. What does `ValueError: cannot reindex from a duplicate axis` mean?
  17. Regex matching 5-digit substrings not enclosed with digits
  18. Conditionally fill column values based on another columns value in pandas
  19. Search for String in all Pandas DataFrame columns and filter
  20. Regular expression to extract URL from an HTML link
  21. Normalize columns of a dataframe
  22. Python Pandas, write DataFrame to fixed-width file (to_fwf?)
  23. How to check whether a pandas DataFrame is empty?
  24. import pandas_datareader gives ImportError: cannot import name ‘is_list_like’
  25. PIP Install Numpy throws an error “ascii codec can’t decode byte 0xe2”
  26. vectorize conditional assignment in pandas dataframe
  27. Read csv from Google Cloud storage to pandas dataframe
  28. How can I make multiple replacements in a string using a dictionary?
  29. Pandas: drop columns with all NaN’s
  30. How to convert R dataframe back to Pandas using rpy2?

Leave a Comment