Replace whole string if it contains substring in pandas

by

You can use str.contains to mask the rows that contain ‘ball’ and then overwrite with the new value:

In [71]:
df.loc[df['sport'].str.contains('ball'), 'sport'] = 'ball sport'
df

Out[71]:
    name       sport
0    Bob      tennis
1   Jane  ball sport
2  Alice  ball sport

To make it case-insensitive pass `case=False:

df.loc[df['sport'].str.contains('ball', case=False), 'sport'] = 'ball sport'

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. Why does concatenation of DataFrames get exponentially slower?
  5. Remove unwanted parts from strings in a column
  6. Combine Date and Time columns using python pandas
  7. Accessing Pandas column using squared brackets vs using a dot (like an attribute)
  8. Pandas Timedelta in Days
  9. how to get ticks every hour?
  10. How to add value labels on a bar chart
  11. How to remove blanks/NA’s from dataframe and shift the values up
  12. Why does my Pandas DataFrame not display new order using `sort_values`?
  13. How to check if a column exists in Pandas
  14. Difference(s) between merge() and concat() in pandas
  15. Seaborn showing scientific notation in heatmap for 3-digit numbers
  16. Format certain floating dataframe columns into percentage in pandas
  17. How can I see the formulas of an excel spreadsheet in pandas / python?
  18. Count distinct words from a Pandas Data Frame
  19. How to annotate each segment of a stacked bar chart
  20. How to define format when using pandas to_datetime?
  21. python pandas groupby() result
  22. How to implode(reverse of pandas explode) based on a column
  23. Pandas concat yields ValueError: Plan shapes are not aligned
  24. Creating dummy variables in pandas for python
  25. Apply function to each row of pandas dataframe to create two new columns
  26. How to parse complex text files using Python?
  27. Pandas DataFrame search is linear time or constant time?
  28. Plotting multiple boxplots in seaborn
  29. Pandas to_csv call is prepending a comma
  30. Search and replace dots and commas in pandas dataframe

Leave a Comment