How to drop a row from Pandas dataframe?

Question

This question is similar to this question posted before. However, I want to do something different, here is my df:

      pos  event
A     4    d5
A     2    d3
B     3    d3
B     6    u3

I want to get:

      pos  event
A     4    d5
A     2    d3
B     6    u3

I wrote this code but it is not working! any suggestion?

df.drop(df.ix[B]['event']=='d3', inplace=True)

My actual dataframe is big and I want to drop the row that I want with index and value in event column.

Sorry what are you wanting here? drop all rows with event == 'd3' or all rows with that event and row label B? — EdChum, Aug 18 '16 at 10:45
Sorry, I updated the dataframe, now question should be clear. — NamAshena, Aug 18 '16 at 10:50

score 3 · Accepted Answer · answered Aug 18 '16 at 10:53

3

You can use boolean indexing with | (or):

print (df[(df['event']!='d3') | (df.index != 'B')])
   pos event
A    4    d5
A    2    d3
B    6    u3

answered Aug 18 '16 at 10:53

jezrael

1 Answers1