pandas,Replace Values in a dataframe, depending on other Column [duplicate]

Question

I have A dataframe like below,

df = pd.Dataframe({'Col1' : pd.Series(['Abc','Cde','Efg','Abc'], index=['a', 'b', 'c','d']),
 'Col2' : pd.Series([10, 20, 30, 40], index=['a', 'b', 'c', 'd']),
 'Col3' : pd.Series([1, 2., 3., 4.], index=['a', 'b', 'c', 'd'])})

By Depending on the value of the column value in Col1, I want to replace Col3 Value by Col2,

In this case where Col1 value is "Abc" I want to update Col3 value with Col2 value , expecting output like

pd.Dataframe({'Col1' : pd.Series(['Abc','Cde','Efg','Abc'], index=['a', 'b', 'c','d']),
 'Col2' : pd.Series([10, 20, 30, 40], index=['a', 'b', 'c', 'd']),
 'Col3' : pd.Series([10, 2., 3., 40], index=['a', 'b', 'c', 'd'])})

Tried by filter , that aint generic, so any proper method to do same !!

jpp · Accepted Answer · 2018-01-29 11:51:49Z

5

This should work:

import pandas as pd

df = pd.DataFrame({'Col1' : pd.Series(['Abc','Cde','Efg','Abc'], index=['a', 'b', 'c','d']),
                   'Col2' : pd.Series([10, 20, 30, 40], index=['a', 'b', 'c', 'd']),
                   'Col3' : pd.Series([1, 2., 3., 4.], index=['a', 'b', 'c', 'd'])})

df.loc[df['Col1'] == 'Abc', 'Col3'] = df['Col2']

answered Jan 29, 2018 at 11:51

jpp

166k37 gold badges301 silver badges363 bronze badges

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

Collectives™ on Stack Overflow

pandas,Replace Values in a dataframe, depending on other Column [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related