Creating a sub-set of data having only null values

Question

I have a data as under in a pandas dataframe [Original shape of the data : 149347 rows and 2 columns]. Purpose includes a text/strings and employeeID includes floats.

Purpose : Text,Text,Text, ,Text,Text, , ,Text | Employee : 1,2,3,4,5,6,7,8,9

I want to create a subset of the data, having only blanks "purpose" and also include relevant employee ID's against such blanks as shown under.

Code used to achieve the above

null_Values = sample['Purpose'].isnull()
# Employee IDs against null values
null_Values['Employee ID'].value_counts()

I understand the error in the above code, however unable to achieve the purpose mentioned.

Can you edit your question and put the sample data in text form (so we can copy-paste it)? Also, the blanks are empty strings ("")? Or NaNs? — Andrej Kesely
– Andrej Kesely, Commented Jul 20, 2021 at 10:25
Blanks are empty strings. (Blank row as shown in the pic and no entries in the same) — Sid
– Sid, Commented Jul 20, 2021 at 10:33

Andrej Kesely · Accepted Answer · 2021-07-20 10:39:42Z

1

Try:

print(df[df.Purpose.eq("")])

Prints:

  Purpose  Employee
2                 3
4                 5

df used:

  Purpose  Employee
0    Text         1
1    Text         2
2                 3
3    Text         4
4                 5

answered Jul 20, 2021 at 10:39

Andrej Kesely

196k15 gold badges60 silver badges105 bronze badges

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

2 Comments

Sid Over a year ago

I tried the above, Im getting empty dataframe, however I tried the below code null_Entries = sample[sample['Purpose'].isnull()] print(null_Entries)

Chris Wesseling Over a year ago

@Sid From the doctext of .isnull(): "Characters such as empty strings '' or numpy.inf are not considered NA values"

SKY · Accepted Answer · 2022-11-09 11:37:42Z

0

df :

  Purpose  Employee
0    Text         1
1    Text         2
2                 3
3    Text         4
4                 5

Answer:

print(df[df.Purpose.isna()])

answered Nov 9, 2022 at 11:37

SKY

1772 silver badges8 bronze badges

Collectives™ on Stack Overflow

Creating a sub-set of data having only null values

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related