how to solve (settingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame.)?

Asked Aug 16 '20 at 03:48

Active Aug 16 '20 at 03:48

Viewed 10 times

This my code to create a new column with a calculation in a data frame

df1['Cases/Tests/1M pop']= (df1['Tot Cases/1M pop']/ df1['Tests/ 1M pop'])*100

and I got this error message in the output

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
 df1['Cases/Tests/1M pop']= (df1['Tot Cases/1M pop']/ df1['Tests/ 1M pop'])*100

asked Aug 16 '20 at 03:48

Samar Abdelraheem

1

Add `.copy()` when creating df1. – Scott Boston Aug 16 '20 at 03:54
1

yes it works now. Thank you @ScottBoston !! – Samar Abdelraheem Aug 16 '20 at 03:58
yes, it works @TrentonMcKinney – Samar Abdelraheem Aug 16 '20 at 03:59

how to solve (settingWithCopyWarning: A value is trying to be set on a copy of a slice from a DataFrame.)?

0 Answers0