Pandas: change values in selected columns

Asked Dec 17 '20 at 10:27

Active Dec 17 '20 at 10:35

Viewed 18 times

I have the following source dataframe

and would like to change values in selected columns to reciprocal. When I try to run the following script

df_bets.loc[:,'B365H':] = 1/df_bets.loc[:,'B365H':]

I get the warning:

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

Is there a better way how to do it?

edited Dec 17 '20 at 10:35

asked Dec 17 '20 at 10:27

madmax80

Problem is in code before `df_bets.loc[:,'B365H':] = 1/df_bets.loc[:,'B365H':]`, how is created `df_bets` ? – jezrael Dec 17 '20 at 10:36
Like this: `df_bets = df[cols_bets]` where `df` is a source dataframe and `cols_bets` is list of columns. – madmax80 Dec 28 '20 at 13:33
yop, use `df_bets = df[cols_bets].copy()` – jezrael Dec 28 '20 at 17:40

0 Answers0