Python Dataframe Column value update for multi condition

Question

Hello i want to simplfy the code below. It works but i want to create a dictionary for C9, 4A, C8 and want to do the same code with a single statement.

df.loc[df["Column"] =="C9","New_Column"]="LCV"
df.loc[df["Column"] =="4A"," New_Column"]="LCV"
df.loc[df["Column"] =="C8","New Column"]="LCV"

there is 10 lines of statament like that. If the column value is C9 or 4A or C8 i want to update the new column value to LCV.

i will be grateful if you can help me.

Best Regards..

anky · Accepted Answer · 2021-01-23 18:41:32Z

2

Use pd.Series.isin:

>>> df.loc[df["Column"].isin(["4A", "C8", "C9"]),"New_Column"]="LCV"

edited Jan 23, 2021 at 18:41

anky

75.3k11 gold badges46 silver badges76 bronze badges

answered Jan 23, 2021 at 18:40

Sayandip Dutta

15.9k4 gold badges27 silver badges57 bronze badges

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

Comments

frab · Accepted Answer · 2021-01-23 18:47:07Z

0

Try:

values = ["C9", "4A", "C8"]
df.loc[df["Column"].isin(values), "New_Column"]="LCV"

edited Jan 23, 2021 at 18:47

answered Jan 23, 2021 at 18:36

frab

1,1731 gold badge6 silver badges15 bronze badges

Comments

Azzedine · Accepted Answer · 2021-01-23 20:05:40Z

0

I use apply function, and I passed to it a lambda function that will check each row if the column value is in the items it will put the "LVC" to the value of New_Column otherwise it will put None.

items = ["C9", "4A", "C8"]
df["New_Column"] = df.apply(lambda row: "LVC" if row.Column in items else None, axis = 1)

answered Jan 23, 2021 at 20:05

Azzedine

5154 silver badges8 bronze badges

Collectives™ on Stack Overflow

Python Dataframe Column value update for multi condition

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related