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](https://stackoverflow.com/questions/38835483/confusion-re-pandas-copy-of-slice-of-dataframe-warning) — Yuca, Aug 15 '19 at 18:46

score 24 · Answer 1 · edited Mar 11 '21 at 14:55

24

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

Both worked!

edited Mar 11 '21 at 14:55

Charles

answered Mar 15 '20 at 21:25

1 Answers1