How to remove numbers from string terms in a pandas dataframe

by

You can apply str.replace to the Name column in combination with regular expressions:

import pandas as pd

# Example DataFrame
df = pd.DataFrame.from_dict({'Name'  : ['May21', 'James', 'Adi22', 'Hello', 'Girl90'],
                             'Volume': [23, 12, 11, 34, 56],
                             'Value' : [21321, 12311, 4435, 32454, 654654]})

df['Name'] = df['Name'].str.replace('\d+', '')

print(df)

Output:

    Name   Value  Volume
0    May   21321      23
1  James   12311      12
2    Adi    4435      11
3  Hello   32454      34
4   Girl  654654      56

In the regular expression \d stands for “any digit” and + stands for “one or more”.

Thus, str.replace('\d+', '') means: “Replace all occurring digits in the strings with nothing”.

More Related Contents:

  1. Filter pandas DataFrame by substring criteria
  2. How to change the datetime format in Pandas
  3. How to test if a string contains one of the substrings in a list, in pandas?
  4. Fast punctuation removal with pandas
  5. Remove unwanted parts from strings in a column
  6. String concatenation of two pandas columns
  7. Find column whose name contains a specific string
  8. add a string prefix to each value in a string column using Pandas
  9. pandas dataframe str.contains() AND operation
  10. Pandas DataFrame stored list as string: How to convert back to list
  11. Pandas Extract Number from String
  12. Add Leading Zeros to Strings in Pandas Dataframe
  13. Pandas column access w/column names containing spaces
  14. Convert columns to string in Pandas
  15. Get last “column” after .str.split() operation on column in pandas DataFrame
  16. How to remove square bracket from pandas dataframe
  17. Remove non-ASCII characters from pandas column
  18. NLTK-based text processing with pandas
  19. Left justify string values in a pandas DataFrame
  20. Count number of words per row
  21. Converting a column within pandas dataframe from int to string
  22. removing newlines from messy strings in pandas dataframe cells?
  23. Print very long string completely in pandas dataframe
  24. Convert a columns of string to list in pandas
  25. pandas: replace string with another string
  26. Column of lists, convert list to string as a new column
  27. Filtering pandas dataframe rows by contains str
  28. Copy text between parentheses in pandas DataFrame column into another column
  29. pandas combine two strings ignore nan values
  30. pandas – convert string into list of strings [duplicate]

Leave a Comment