Python Dataframe drop rows of multi columns with specific values

Question

My dataframe is given below. i want to drop rows in two columns which have less than 0 value.

df = 
         name     value1  value2
    0      A      10      10
    1      B     -10      10       #drop
    2      A      10      10
    3      A      40     -10       #drop
    4      C      50      10
    5      C      60      10
    6      D     -70     -10       #drop

I want to drop rows with negative values in value1 and value2 columns. My expected output:

df = 
         name     value1  value2
    0      A      10      10
    1      A      10      10
    2      C      50      10
    3      C      60      10

My present code:

df = df[df['value1','value2']>0]

Output:

KeyError: ('value1','value2')

@Ch3steR I just updated my question to indicate the rows I want to drop. Between, how do I specifically mention those two specific columns? I think your code considers all the numeric columns. — Mainland
– Mainland, Commented Jul 10, 2020 at 18:14
df[df[['value1', 'value2']].gt(0).all(1)]? gt is greater than, ge greater than equal to — Ch3steR
– Ch3steR, Commented Jul 10, 2020 at 18:16
@Ch3steR df[df[['value1', 'value2']].gt(0).all(1)] This worked. Thanks — Mainland
– Mainland, Commented Jul 10, 2020 at 18:27

Javad Rezaei · Accepted Answer · 2020-07-10 18:15:45Z

1

i guess you mean that if one of the 'value1' or 'value2' are negative, you want to drop the row. so use: df = df[(df['value1'] >= 0) & (df['value2'] >= 0)])

edited Jul 10, 2020 at 18:15

answered Jul 10, 2020 at 18:14

Javad Rezaei

1,1307 silver badges9 bronze badges

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

3 Comments

Mainland Over a year ago

what if I want to select five columns out of ten total columns.

Mainland Over a year ago

I like this code. But, the only problem is, I have to specifically mention the condition specifically to each column. Is there a way by which I can simply denote the names of the columns to be considered?

Javad Rezaei Over a year ago

if you want some column out of total columns, you can first drop negative columns and indicate wanted column from new dataframe. for example if you want 'name' and 'value1' column, you can use df = df[(df['value1'] >= 0) & (df['value2'] >= 0)]); df = df[["name", "value1"]]

Collectives™ on Stack Overflow

Python Dataframe drop rows of multi columns with specific values

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related