I want to replace dataframe column-specific value which start or ends with specific strings.

Like in below Dataframe I want to replace value with blanks if it contains specific eg.updated string in words

Dataframe

Expected Output

CodePudding user response：

Use Series.str.contains with regex with . for any value before updated, $ for end of strings and case=False for ignore cases:

df.loc[df['Sr no#'].str.contains(r'. updated$', case=False), 'Sr no#'] = ''