Pandas Setting with copy warning

Question

I am trying to slice a dataframe in pandas and save it to another dataframe. Let's say df is an existing dataframe and I want to slice a certain section of it into df1. However, I am getting this warning:

/usr/local/lib/python3.5/dist-packages/ipykernel_launcher.py:25: SettingWithCopyWarning:
A value is trying to be set on a copy of a slice from a DataFrame

I have checked various posts in SO discussing the similar issue (two of them are following):

Going through these links, I was able to find issue in following line

   Years=['2010','2011']
   for key in Years:
        df1['GG'][key]=df[key][df[key].Consumption_Category=='GG']

which I then changed to following

   Years=['2010','2011']
   for key in Years:
        df1['GG'][key]=df[key].loc[df['2010'].iloc[:,0]=='GG']

and get away with the warning.

However, when I included another line to drop a certain column from this dataframe, I again this got warning which I am unable to dort out.

   Years=['2010','2011']
   for key in Years:
        df1['GG'][key]=df[key].loc[df['2010'].iloc[:,0]=='GG']
        df1['GG'][key]=df1['GG'][key].drop(['Consumption_Category'],axis=1,inplace=True)

I leave it here for people with similar problems, as it helps finding such problems way faster: stackoverflow.com/questions/22373927/get-traceback-of-warnings — Piotr
– Piotr, Commented Mar 29, 2021 at 14:09

Pankaj · Accepted Answer · 2017-06-15 03:12:44Z

3

Finally after lot of research and going through pandas documentation, I found the answer to my question. The warning which I was getting is because I have put inplace=True in the drop() function. So, I removed the inplace=True and saved the result into new datafrmae. Now I do not get any warning.

   Years=['2010','2011']
   for key in Years:
        df1['GG'][key]=df[key].loc[df['2010'].iloc[:,0]=='GG']
        df1['GG'][key]=df1['GG'][key].drop(['Consumption_Category'],axis=1)

answered Jun 15, 2017 at 3:12

Pankaj

5172 gold badges6 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pandas Setting with copy warning

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related