How can I remove all non-numeric characters from all the values in a particular column in pandas dataframe?

by

Use str.extract and pass a regex pattern to extract just the numeric parts:

In[40]:
dfObject['C'] = dfObject['C'].str.extract('(\d+)', expand=False)
dfObject

Out[40]: 
        A         B    C
1   red78    square  235
2   green    circle  123
3  blue45  triangle  657

If needed you can cast to int:

dfObject['C'] = dfObject['C'].astype(int)

More Related Contents:

  1. Pandas conditional creation of a series/dataframe column
  2. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  3. How to unnest (explode) a column in a pandas DataFrame, into multiple rows
  4. Error: pandas hashtable keyerror
  5. Writing a pandas DataFrame to CSV file
  6. Remove unwanted parts from strings in a column
  7. pandas: How do I split text in a column into multiple rows?
  8. Find row where values for column is maximal in a pandas DataFrame
  9. How to filter rows containing a string pattern from a Pandas dataframe [duplicate]
  10. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  11. Why does my Pandas DataFrame not display new order using `sort_values`?
  12. python/pandas: convert month int to month name
  13. How to check if a column exists in Pandas
  14. How to form tuple column from two columns in Pandas
  15. Combining two Series into a DataFrame in pandas
  16. How to find which columns contain any NaN value in Pandas dataframe
  17. Converting a column within pandas dataframe from int to string
  18. Pandas – dataframe groupby – how to get sum of multiple columns
  19. pandas comparison raises TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]
  20. pandas: combine two columns in a DataFrame
  21. How do I filter a pandas DataFrame based on value counts?
  22. Lambda including if…elif…else
  23. Pandas query function not working with spaces in column names
  24. Pandas DataFrame sort by categorical column but by specific class ordering
  25. Remove NaN values from pandas dataframe and reshape table [duplicate]
  26. Pandas groupby and aggregation output should include all the original columns (including the ones not aggregated on)
  27. How to convert string representation of dictionary in Pandas DataFrame to a new columns?
  28. Selecting a range of columns in a dataframe
  29. Pandas explode multiple columns [duplicate]
  30. Get weekday/day-of-week for Datetime column of DataFrame

Leave a Comment