How to remove parentheses and all data within using Pandas/Python?

by 
df['name'].str.replace(r"\(.*\)","")

You can’t run re functions directly on pandas objects. You have to loop them for each element inside the object. So Series.str.replace((r"\(.*\)", "") is just syntactic sugar for Series.apply(lambda x: re.sub(r"\(.*\)", "", x)).

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. re.sub erroring with “Expected string or bytes-like object”
  5. Strip / trim all strings of a dataframe
  6. pandas applying regex to replace values
  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. Get the row(s) which have the max value in groups using groupby
  13. Error: pandas hashtable keyerror
  14. How to filter rows containing a string pattern from a Pandas dataframe [duplicate]
  15. Python regex match OR operator
  16. Pandas Merge – How to avoid duplicating columns
  17. import text to pandas with multiple delimiters
  18. How to plot stacked event duration (Gantt Charts)
  19. Print very long string completely in pandas dataframe
  20. Remove duplicate chars using regex?
  21. pandas comparison raises TypeError: cannot compare a dtyped [float64] array with a scalar of type [bool]
  22. How do I filter a pandas DataFrame based on value counts?
  23. Pandas query function not working with spaces in column names
  24. Remove NaN values from pandas dataframe and reshape table [duplicate]
  25. Python regex findall
  26. Changing certain values in multiple columns of a pandas DataFrame at once
  27. Round float columns in pandas dataframe
  28. Converting PANDAS dataframe from monthly to daily
  29. Pandas datetimes with different formats in the same column
  30. Get max value from row of a dataframe in python [duplicate]

Leave a Comment