pandas.DataFrame
({"POC":['K3525','P022','P0025'],
"AREA":['3','',''],
"COUNTRIES":['KR,US,MO','MY,IN,ZW,KR,US','VN,UK,ZW']})

in this DataFrame, i want replace ',ZW' or 'ZW,' to ' '(i mean delete it) at one data(row is 'P0025', column is 'COUNTRIES')

i searched about it, but i can't find any method to set column and row. i found something like

df.replace({'COUNTRIES': {',ZW':'', 'ZW,':''}})

but it doesn't set row and column, just set column only.

desired result is

not desired result is

CodePudding user response：

Use:

m = df['POC'].eq('P0025')

df[m] = df[m].replace({'COUNTRIES': {',ZW':'', 'ZW,':''}})

Or:

 df.loc[m, 'COUNTRIES'] = df.loc[m, 'COUNTRIES'].replace({',ZW':'', 'ZW,':''})