Conditional Function to a pandas dataframe, if vs else change the value

Question

I been trying to get my code to work but I am having some trouble here. It would be great if someone could assist me

DF

  Col1              Col2          
  2017-01-01        Coffee
  2017-01-01        Muffin
  2017-01-01        Donut
  2017-01-01        Toast

How can I change Col2 so that every value that isn't Coffee or Muffin becomes 'Other'?

  Col1              Col2          
  2017-01-01        Coffee
  2017-01-01        Muffin
  2017-01-01        Other
  2017-01-01        Other

MaxU - stand with Ukraine · Accepted Answer · 2018-01-29 23:42:06Z

1

In [265]: df.loc[~df.Col2.isin(['Coffee','Muffin']), 'Col2'] = 'Other'

In [266]: df
Out[266]:
         Col1    Col2
0  2017-01-01  Coffee
1  2017-01-01  Muffin
2  2017-01-01   Other
3  2017-01-01   Other

answered Jan 29, 2018 at 23:42

MaxU - stand with Ukraine

212k37 gold badges402 silver badges437 bronze badges

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

1 Comment

OptimusPrime Over a year ago

Thanks @MaxU I was wondering how would you change it to not change the missing values. df.loc[~df.Col2.isin(['Coffee','Muffin', 'nan' ]), 'Col2'] = 'Other' ????

Collectives™ on Stack Overflow

Conditional Function to a pandas dataframe, if vs else change the value

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related