pandas replace word begins with contains

df['sport'] = df.sport.str.replace(r'(^.*ball.*$)', 'ball sport')
df

View another examples Add Own solution

The Rascal King 95 points

                                    df.sport = df.sport.apply(lambda x: 'ball sport' if 'ball' in x else x)

Thank you! 2

5 (2 Votes)

4.83

LearningandWorking 95 points

                                    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

Thank you! 6

4.83 (6 Votes)

Deadcode 90 points

                                    df.sport.str.replace(r'(^.*ball.*$)', 'ball sport')

0        tennis
1    ball sport
2    ball sport
Name: sport, dtype: object

Thank you! 7

4 (7 Votes)

Are there any code examples left?

Find Add Code snippet

New code examples in category Python

Python 2023-04-11 03:04:20
Python 2022-03-27 22:40:04 pycharm no module named
Python 2022-03-27 22:25:05 assign multiple variablesin one line
Python 2022-03-27 22:20:02 levenshtein distance
Python 2022-03-27 21:35:09 get text from url python last slash
Python 2022-03-27 21:30:30 df concatenate df
Python 2022-03-27 21:25:09 python odd or even
Python 2022-03-27 21:15:32 python include function from another file
Python 2022-03-27 21:10:01 color module python
Python 2022-03-27 21:00:27 python tkinter cursor types

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

replace all substring words in dataframe how to replace value ina string pandas If value in row in DataFrame contains string rename if dataframe column contains value change value python pandas dataframe string manipulation inplace replace python pandas dataframe string manipulation replace change all strings in pandas replace function pandas pandas replace if contains replace if contains replace in lambda pandas replace pandas series values based on time index pandas replace python pandas dataframe replace column values containing text in list python pandas dataframe replace column values containing text panda search replace pandas replace series replace string with chacter pandas replace the value in data frame if it maches a sub string myDF ['mySeries'].str.replace('[', '').str.replace(']', '') string replace pandas pandas replace string values modify string value in dataframe how to replace string with a number of characters in pandas replace after character pandas pandas replace string regex lreplace conatins pandas columns contain pandas replace python data.str.replace change string value if it contains substring pandas python dataframe replace string in column str contains pnadas dataframe replkace replace str contains numeber pandas replace str contains pandas pandas replace string in a column find substring and replace entire string python rename value if string found python replace value based on str contain python replace value based on str contains condition python pandas if str contains = True, then replace value in python string contains then replace python if string contains replace python if string contains then replace python pandas dataframe replace part of string replace a string in pandas dataframe pandas if column contains string change pandas dataframe string search and replace pandas dataframe convert string search and replace pandas how to edit a dataframe cotents string change string into series python replace string python pandas replace string pandas column df str replace replace string in pandas column replace strings in dataframe python pandas replace string values in column replace contains pandas replace string in a column pandas replace parts of strings in pandas column replace last part of a string in pandas column pandas inplace in string method replace pandas string pandas replace string startswith pandas column find and replace replace sub string from pandas replace part of string dataframe pandas apply lambda replace string how to replace string in pandas dataframe pandas apply string replace to column python series replace string perform replace on string in pandas series replace a string in pandas

pandas replace word begins with contains

Welcome Back!

Create a Free Account