Search code examples
pythonpandasdrop

Pandas drop all cells with Values and leave only blank cells


I want to do the following:

index A1
0 1
1
2 -8
3 Hello
4

to:

index A1
1
4

Is there like a reverse .dropna function?


Solution

  • Assuming real NaNs:

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

    If empty strings:

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

    For both:

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