Find and replace by locating column and row using Python

Asked Aug 02 '22 at 17:52

Active Aug 02 '22 at 17:52

Viewed 30 times

I have a dataframe where I would like to find a specific value in a row and column and replace it with a blank. I would like to replace the value in the ['type'] column in the row that contains 'CC'

Data

ID date      type
AA 1/1/2022  Ok
BB 2/1/2022  Hi
CC 2/1/2022  Hi

Desired

ID date      type
AA 1/1/2022  Ok
BB 2/1/2022  Hi
CC 2/1/2022

Doing

df['type'] = df['type'].str.replace('Hi','')

However this is removing all values in the column. Any suggestion is appreciated.

asked Aug 02 '22 at 17:52

Lynn

4,292
5
21
44

5

`df.loc[df['type'].eq('Hi') & df['ID'].eq('CC'), 'type'] = ''` – Quang Hoang Aug 02 '22 at 17:53
`mask = (df['ID'] == 'CC')` and `df.loc[mask, 'type'] = df.loc[mask, 'type'].str.replace('Hi','')` – furas Aug 03 '22 at 15:43

Find and replace by locating column and row using Python

0 Answers0