Filter rows based on two columns together

Question

I am trying to filter out rows based on two rows values. Most of the questions' solution that I see use the following approach:

df.loc[(df['A'] != 'yes') & (df['B'] != 'no')]

This filters the rows with a A and B different than one value, what I want to do is to filter rows where the columns have the values I am filtering, example:

Player | action | result
1          A        B
2          B        A
3          C        A
4          A        B
5          A        C

In this example I want to remove rows that have action A and result B. Using the example above it would remove actions equal to A and rows with result equal to B. I want to remove actions A that have result B.

Output expected:

  Player | action | result
    2          B        A
    3          C        A
    5          A        C

Probably I am making a lot of confusion here and this is straightforward. Anyhow, any help would be appreciated!

Regards

df[(df["action"] != "A" & df["result"] != "B")] – yudhiesh Sep 20 '20 at 12:57 — yudhiesh, Sep 20 '20 at 12:57

score 4 · Answer 1 · answered Sep 20 '20 at 13:10

4

Could you please try following.

import pandas as pd
df2[~((df2["action"]=='A') & (df2["result"]=='B'))]

Output of data frame will be as follows.

  Player action result
1   2    B    A
2   3    C    A
4   5    A    C

answered Sep 20 '20 at 13:10

RavinderSingh13

130,504
14
57
93

score 2 · Accepted Answer · answered Sep 20 '20 at 13:12

2

I think this is what you want

pd.concat([df[(df['action'] == 'A') & (df['result'] != 'B')],df[(df['action'] != 'A')]])

answered Sep 20 '20 at 13:12

Advay168

607
6
10

Filter rows based on two columns together

2 Answers2