How to copy one column into another new one properly(without copy error)?

Question

I want to copy one column into a new one. I use this code:

df['income10']=df['income'].copy(deep=False)

I get this error:

/Users/hairy/ipykernel/ipykernel_launcher.py:2: 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: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy

By adding shallow copy I thought I would've prevented the error.

Use `df = df.assign(income10 = df.income)`. It will create a new object which wont be a reference. Then again, might be best to fix the problem further up in your code. — ALollz, Jan 31 '19 at 19:39

score 1 · Accepted Answer · answered Jan 31 '19 at 19:16

1

Try doing this way:

df['income10']=df.loc[:, ['income']]

answered Jan 31 '19 at 19:16

taurus05

2,491
15
28

I still get SetWithCopyWarning from this. – ALollz Jan 31 '19 at 19:40
What is the version of pandas you are using? – taurus05 Jan 31 '19 at 19:41
pd.__version__ : '0.24.0' – ALollz Jan 31 '19 at 19:42
mine is 0.22.0 and it works fine.. – taurus05 Jan 31 '19 at 19:42

score 0 · Answer 2 · answered Jan 31 '19 at 19:21

0

I reran the whole Jupyter notebook and it worked for some reason.

answered Jan 31 '19 at 19:21

Hairy

393
1
10

How to copy one column into another new one properly(without copy error)?

2 Answers2