DataFrame condition on multiple values python

Question

I need to drop some lines from dataframe with python , based on multiple values

Code Names Country
1      a    France
2      b    France
3      c    USA
4      d    Canada
5      e    TOTO
6      f    TITI
7      g    Corona

I need to have this

Code Names Country
1      a    France
4      d    Canada
5      e    TOTO
7      g    Corona

I do this :

df.drop(df[('f','b','c')in df['names']].index)

But it doesnt work : KeyError: False

it works for only one key like this : df.drop(df['f' in df['names']].index)

Do you have any idea ?

Just , isin and inverseoutput = df[~df['Names'].isin(['f','b','c'])].copy() ? I dont hink you need the drop here , boolean indexing is enough — anky
– anky, Commented May 13, 2020 at 19:07
@ankyy "isin() takes 2 positional arguments but 3 were given " — betty
– betty, Commented May 13, 2020 at 19:13
Can you post the isin code you are trying. Looks like something is off — anky
– anky, Commented May 14, 2020 at 3:14

NYC Coder · Accepted Answer · 2020-05-13 19:17:23Z

1

To remove rows of certain values:

indexNames = df[df['Names'].isin(['f', 'b', 'c'])].index
df.drop(indexNames, inplace=True)
print(df)

Output:

   Code Names Country
0     1     a  France
3     4     d  Canada
4     5     e    TOTO
6     7     g  Corona

edited May 13, 2020 at 19:17

answered May 13, 2020 at 19:11

NYC Coder

7,6443 gold badges14 silver badges25 bronze badges

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

2 Comments

betty Over a year ago

Thanks but they are not really the same, so duplicated won't work :(

NYC Coder Over a year ago

Did this work? If yes, Mark this as the answer and close it.

DanDy · Accepted Answer · 2020-05-13 19:29:48Z

1

Based on your example, I think this may be what you are looking for.

new_df = df.loc[~df.Names.isin(['f','b','c'])].copy()
new_df

Output:

    Code    Names   Country
0   1       a       France
3   4       d       Canada
4   5       e       TOTO
6   7       g       Corona

answered May 13, 2020 at 19:29

DanDy

4615 silver badges10 bronze badges

Comments

Anshul Vyas · Accepted Answer · 2020-05-13 19:30:49Z

1

In pandas, we can use .drop() function to drop column and rows.

For dropping specific rows, we need to use axis = 0

So your required output can be achieved by following line of code :

df4.drop([1,2,5], axis=0)

The output will be :

code    Names   Country
1        a      France
4        d      Canada
5        e      TOTO
7        g      Corona

answered May 13, 2020 at 19:30

Anshul Vyas

6839 silver badges19 bronze badges

1 Comment

betty Over a year ago

I can't use isnin i have this error : isin() takes 2 positional arguments but 4 were give , Any other suggestions ?

Collectives™ on Stack Overflow

DataFrame condition on multiple values python

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related