Replace one column with another in Pandas Dataframe

Question

I'm working with a dataset that has more than 40 columns and I want to replace two columns data with another two columns of data and want to remove the existing one.

Example Dataset:

v_4        v5             s_5     vt_5     ex_5          pfv           pfv_cat
0-50      StoreSale     Clothes   8-Apr   above 100   FatimaStore       Shoes
0-50      StoreSale     Clothes   8-Apr   0-50        DiscountWorld     Clothes
51-100    CleanShop     Clothes   4-Dec   51-100      BetterUncle       Shoes

I want to replace the v5 column with pfv and s_51 withpfv_cat, by replace I meanoverwrite`

Here's what I have tried:

df.replace(df['v_5'].tolist(), df['pfv'].tolist())
df.replace(df['s_5'].tolist(), df['pfv_cat'].tolist())

But it doesn't work, it's just stuck and no input.

moys · Accepted Answer · 2019-10-09 04:52:03Z

1

You can just do

df['v_5']=df['pfv']
df['s_5']=df['pfv_cat']
print(df)

Input

     v_4          v5    s_5         vt_5    ex_5             pfv        pfv_cat
0   0-50    StoreSale   Clothes     8-Apr   above100    FatimaStore     Shoes
1   0-50    StoreSale   Clothes     8-Apr   0-50        DiscountWorld   Clothes
2   51-100  CleanShop   Clothes     4-Dec   51-100      BetterUncle     Shoes

Output

v_4     v5  s_5     vt_5    ex_5    pfv     pfv_cat     v_5
0   0-50    StoreSale   Shoes   8-Apr   above100    FatimaStore     Shoes   FatimaStore
1   0-50    StoreSale   Clothes     8-Apr   0-50    DiscountWorld   Clothes     DiscountWorld
2   51-100  CleanShop   Shoes   4-Dec   51-100  BetterUncle     Shoes   BetterUncle

edited Oct 9, 2019 at 4:52

answered Oct 9, 2019 at 4:47

moys

8,1173 gold badges19 silver badges51 bronze badges

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

2 Comments

Abdul Rehman Over a year ago

for this code it's just stuck and no input ... still the same

moys Over a year ago

you need to print(df), to see the changes. added that to the code now.

Collectives™ on Stack Overflow

Replace one column with another in Pandas Dataframe

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related