Replacing values and getting "SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame"

Asked Sep 28 '20 at 18:04

Active Sep 28 '20 at 18:04

Viewed 66 times

I'm trying to replace 0s and 1s with 'No' and 'Yes'.

I know there'll be a cleaner way of writing but main problem is I cant understand why I get the warning and code doesnt work.

age_group_clean['has_health_problem'].replace(['0'],'No', inplace=True)
age_group_clean['has_health_problem'].replace(['1'],'Yes', inplace=True)

/Users/kerrimac/opt/anaconda3/lib/python3.8/site-packages/pandas/core/generic.py:6746: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  self._update_inplace(new_data)

asked Sep 28 '20 at 18:04

Kerr McIntosh

1

is `age_group_clean` a part of a bigger dataframe? maybe doing `age_group_clean = age_group_clean.copy()` before any modification helps. – Quang Hoang Sep 28 '20 at 18:06
1

Might be better to use `np.where()`, or `map()` the values – G. Anderson Sep 28 '20 at 18:07
1

Does this answer your question? [How to deal with SettingWithCopyWarning in Pandas?](https://stackoverflow.com/questions/20625582/how-to-deal-with-settingwithcopywarning-in-pandas) – Trenton McKinney Sep 28 '20 at 18:18
Trenton McKinney, Many thanks, that web page didn't solve problem but it gave me better understanding – Kerr McIntosh Sep 29 '20 at 17:38
np.where(), or map() just gave same result :-) – Kerr McIntosh Sep 29 '20 at 17:38
It was part of a bigger dataframe. I actually just went back and made the change in the data frame ... Didn't try .copy() but will give it a go next time I face . Thanks for advice. – Kerr McIntosh Sep 29 '20 at 17:39

Replacing values and getting "SettingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame"

0 Answers0