Remove Rows in Dataframe with custom condition

Question

df = pd.DataFrame({
'Number' : ['IN-60','IN-60','AMD-60','AMD-60','IN-60','AMD-60','AMD-62','AMD-62']
'Value':['0','10','51','50','20','0','0','0']

})

Input :-

Number   Value
IN-60     0       
IN-60     10      
AMD-60    51      
AMD-60    50      
IN-60     20      
AMD-60    0      
AMD-62    0       
AMD-62    0

I want drops rows where Number are same and value is 0 and if 2 more same number entry with zero then i want one number in dataframe.
I want to Output like :

Output:-

Number   Value   
IN-60     10      
IN-60     20      
AMD-60    51      
AMD-60    50      
AMD-62    0

Can you please show what you have tried so far ?

heretolearn
– heretolearn

2021-07-22 13:06:49 +00:00
Commented Jul 22, 2021 at 13:06 — heretolearn
– heretolearn, Commented Jul 22, 2021 at 13:06

not_speshal · Accepted Answer · 2021-07-22 16:22:14Z

1

Try:

df = pd.DataFrame({'Number' : ['IN-60','IN-60','AMD-60','AMD-60','IN-60','AMD-60','AMD-62'],
                   'Value': ['0','10','51','50','20','0','0']
                   })

df = df[~((df["Number"].duplicated(keep=False))&(df["Value"]==0))]

>>>df
   Number  Value
1   IN-60     10
2  AMD-60     51
3  AMD-60     50
4   IN-60     20
6  AMD-62      0

Edit:

If your numbers are strings as in your example, try:

df = df[~((df["Number"].duplicated(keep=False))&(df["Value"]=='0'))]

Edit 2:

For rows that have 2 or more 0 values, you can append back one of them like so:

keep_rows = df.where(df[df["Value"]=="0"].duplicated()).dropna()
df = pd.concat([df[~((df["Number"].duplicated(keep=False))&(df["Value"]=='0'))], keep_rows])
>>> df
   Number Value
1   IN-60    10
2  AMD-60    51
3  AMD-60    50
4   IN-60    20
7  AMD-62     0

edited Jul 22, 2021 at 16:22

answered Jul 22, 2021 at 13:13

not_speshal

23.2k2 gold badges18 silver badges33 bronze badges

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

5 Comments

Akshay Tarpara Over a year ago

df are same after executing df[~((df["Number"].duplicated(keep=False))&(df["Value"]==0))].

not_speshal Over a year ago

You have to assign it back to df. See my edited answer.

Akshay Tarpara Over a year ago

I did it but still not working check it again.

not_speshal Over a year ago

@AkshayTarpara - I think your numbers are strings. See my edit and try that.

Akshay Tarpara Over a year ago

Thank you.your answer is right but i have some issue in this. If 2 entry of invoice number are same with zero and try to this solution so both same row are drop but i want to 1 entry this number. I edited my question please see this.

Collectives™ on Stack Overflow

Remove Rows in Dataframe with custom condition

1 Answer 1

Edit:

Edit 2:

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Edit:

Edit 2:

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related