select rows with null value python-pandas

Question

How can I select the rows with null values in respect of columns name?

What I have:

ID	A	B
1	a	b
2		v
3	y
4	w	j
5	w

What I want:

Select rows with null in respect with e.g. column B:

ID	B
3	y
5	w

Because I want to select the null values only in column B! — Jsmoka
– Jsmoka, Commented Feb 7, 2021 at 16:03

Sayandip Dutta · Accepted Answer · 2021-02-07 16:04:23Z

1

Use pandas.DataFrame.pop and pandas.Series.isna:

>>> df
   ID    A    B
0   1    a    b
1   2  NaN    v
2   3    y  NaN
3   4    w    j
4   5    w  NaN

>>> df[df.pop('B').isna()]

   ID  A
2   3  y
4   5  w

Use pop if you do not need column 'B' in the original dataframe afterwards. Otherwise, use pandas.DataFrame.drop:

>>> df[df['B'].isna()].drop('B', axis=1)

answered Feb 7, 2021 at 16:04

Sayandip Dutta

15.9k4 gold badges27 silver badges57 bronze badges

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

Comments

Senku · Accepted Answer · 2021-02-07 16:08:31Z

1

I guess you can use isna() or isnull() functions.

df[df['column name'].isna()]

(or)

df[df['column name'].isnull()]

answered Feb 7, 2021 at 16:08

Senku

532 silver badges8 bronze badges

Collectives™ on Stack Overflow

select rows with null value python-pandas

What I have:

What I want:

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

What I have:

What I want:

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related