test if row NULL values in dataframe pandas

Question

I have to delete row if in the same line i have id1 and id2 are empty. I did these lines but got error.

d = {'id1': ['Y22', 'X23', None], 'id2': ['Y10', "Y14", None], 'id3':[77,22,13]}
df = pd.DataFrame(data=d)

df = df[df[pd.notnull(df['id1'])and df[pd.notnull(df['id2'])]]

df[~(df['id1'].isna() & df['id2'].isna())]

Michael H.
– Michael H.

2019-06-04 12:14:32 +00:00
Commented Jun 4, 2019 at 12:14 — Michael H.
– Michael H., Commented Jun 4, 2019 at 12:14

anky · Accepted Answer · 2019-06-04 12:15:54Z

6

Use df.all() on axis=1 and check if all values in id1 and id2 are not null, then use it as boolean mask:

df[~df[['id1','id2']].isna().all(axis=1)]

   id1  id2  id3
0  Y22  Y10   77
1  X23  Y14   22

edited Jun 4, 2019 at 12:15

answered Jun 4, 2019 at 12:12

anky

75.3k11 gold badges46 silver badges76 bronze badges

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

2 Comments

Miss Over a year ago

Thank you but it not what i want i want to delete just when the two values in the same row are NULL.

anky Over a year ago

@Miss so if both the ids are None dont select the row? Can you test again?

Collectives™ on Stack Overflow

test if row NULL values in dataframe pandas

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related