Warning replace value pandas

Question

I have an error trying to replace the value

table.loc[table['Column1'].str.contains('Unnamed'), 'Column1'] = np.NaN

A value is trying to be set on a copy of a slice from a DataFrame

Any suggestion?

Does this answer your question? [How to deal with SettingWithCopyWarning in Pandas](https://stackoverflow.com/questions/20625582/how-to-deal-with-settingwithcopywarning-in-pandas) — mosc9575, Feb 24 '21 at 17:45
Are you trying to assign `np.NaN` if `table['Column1']` contains `Unnamed`? — Joe Ferndz, Feb 24 '21 at 17:45
Yes if table contains Unnamed change to NaN, because after that, I will go fill NaN by first values — Twwister8889, Feb 24 '21 at 19:49

Ade_1 · Answer 1 · 2021-02-25T18:29:49.220

0

You could use the apply method

def changer(x):
    if 'unnamed' in x:
         x= np.NaN
    return x

df['column'].apply(changer)

edited Feb 25 '21 at 18:29

answered Feb 24 '21 at 17:48

Ade_1

I need to contain, not == – Twwister8889 Feb 25 '21 at 16:45
Thanks, but not working yet table['Column1'] = table['Column1'].apply(changer) Try using .loc[row_indexer,col_indexer] = value instead If I try to table['Process'].apply(changer) is not change to NaN – Twwister8889 Feb 25 '21 at 20:21

score 0 · Accepted Answer · answered Feb 26 '21 at 17:57

0

Solved: table=table.copy() include before the code

answered Feb 26 '21 at 17:57

Twwister8889

2 Answers2