Create duplicate column in pandas dataframe

Question

I want to duplicate a column which has numerical character in the start position. ie(1stfloor)

In simple term, I want to convert column 1stfloor to FirstFloor

Tried using the below code,

df['FirstFloor'] = df['1stfloor']

encountered with below error message:

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

Expected output:

df

FirstFloor 
456 
784
746
44 
9984

Possible duplicate of Confusion re: pandas copy of slice of dataframe warning — Yuca
– Yuca, Commented Aug 15, 2019 at 18:46

Charles · Accepted Answer · 2021-03-11 14:55:08Z

28

df['FirstFloor'] = df['1stfloor'] 
df['FirstFloor'] = df.loc[:, '1stfloor']

Both worked!

Charles

10412 bronze badges

answered Mar 15, 2020 at 21:25

5611 gold badge5 silver badges12 bronze badges

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

1 Answer 1