Python : How can I remove this "SettingWithCopyWarning (dataframe)?

Asked Mar 19 '21 at 09:18

Active Dec 20 '21 at 14:09

Viewed 15 times

I am sorry if this question has already been answered. In my code, I create a new column in my dataframe ("PaymentIdentificationEnd") by changing one letter in the data of the column ("PaymentIdentification").

The line code is :

dataframe['PaymentIdentificationEnd'] = dataframe['PaymentIdentification'].apply(lambda x : x[:-2] + "E" + x[-1])

An example of data in the column ("PaymentIdentification") : MCRM-QRR-20210226-120000-02PI1I1

My code works but I have few warnings like this one, how can I remove it ?

SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  dataframe['PaymentIdentificationEnd'] = dataframe['PaymentIdentification'].apply(lambda x : x[:-2] + "E" + x[-1])

Thank you

edited Dec 20 '21 at 14:09

Ismael Padilla

5,246
4
23
35

asked Mar 19 '21 at 09:18

Maikiii

Waht is code before `dataframe` ? there is some filtering? – jezrael Mar 19 '21 at 09:18
If yes, add `.copy()` – jezrael Mar 19 '21 at 09:19
Btw it's just a warning not an error so you can ignore it if you want!!!...and you are getting this because you are changing a part of `Series` not the whole `Series` – Anurag Dabas Mar 19 '21 at 09:20

Python : How can I remove this "SettingWithCopyWarning (dataframe)?

0 Answers0