is there a way to combine these python dataframe modifications into one line

Question

I am just a beginner so I apologize for this remedial question. I am wanting to drop some observations from a dataframe.

Is there a way to combine these two lines in to one in python?

NHL_Team_R_Stats=NHL_Team_R_Stats[NHL_Team_R_Stats.competition_name != '2011 NHL Regular Season']
NHL_Team_R_Stats=NHL_Team_R_Stats[NHL_Team_R_Stats.competition_name != '2012 NHL Regular Season']

I tried

NHL_Team_R_Stats=NHL_Team_R_Stats[NHL_Team_R_Stats.competition_name != ('2011 NHL Regular Season','2012 NHL Regular Season')]

but it wouldn't work.

Thanks for your help!

try `not in ('2010 NHL Regular Season','2011 NHL Regular Season')`. — buran, Aug 12 '21 at 07:04
this will help https://stackoverflow.com/questions/13611065/efficient-way-to-apply-multiple-filters-to-pandas-dataframe-or-series — deadshot, Aug 12 '21 at 07:05
@deadshop: it worked when i used & but the line gets pretty long — Jeff Jones, Aug 12 '21 at 07:27

score 1 · Answer 1 · answered Aug 12 '21 at 07:31

1

NHL_Team_R_Stats=NHL_Team_R_Stats[(NHL_Team_R_Stats.competition_name != '2010 NHL Regular Season') & (NHL_Team_R_Stats.competition_name != '2011 NHL Regular Season')]

the above worked

answered Aug 12 '21 at 07:31

Jeff Jones

11
3

klegoff · Answer 2 · 2021-08-12T08:26:33.797

1

Using the keyword "isin" and the negation "~" should do the job.

# the values you want to filter out
val = ["2011 NHL Regular Season", "2012 NHL Regular Season"]

# ~ returns the inverse of the mask
NHL_Team_R_Stats=NHL_Team_R_Stats.loc[~NHL_Team_R_Stats.competition_name.isin(val)]

edited Aug 12 '21 at 08:26

answered Aug 12 '21 at 07:33

klegoff

51
3

Thanks! I did get it working but I learned something new from your response. Appreciated! – Jeff Jones Aug 13 '21 at 09:05

is there a way to combine these python dataframe modifications into one line

2 Answers2