Pandas drop all cells with Values and leave only blank cells

Question

I want to do the following:

to:

index	A1
1
4

Is there like a reverse .dropna function?

The input is ambiguous, are your `---` NaNs? empty strings? It would be preferable to provide a dictionary as input (`df.to_dict()`) — mozway, Jan 16 '23 at 14:19

score 2 · Accepted Answer · answered Jan 16 '23 at 14:18

2

Assuming real NaNs:

out = df[df['A1'].isna()]

If empty strings:

out = df[df['A1'].eq('')]

For both:

out = df[df['A1'].fillna('').eq('')]

answered Jan 16 '23 at 14:18

mozway

1 Answers1