how to remove a row which has empty column in a dataframe using pandas

Question

I have to remove entire row with the column, which has no value my dataframe looks like

Name   place    phonenum

mike   china     12344
       ireland    897654
suzzi  japan      09876
chang  china      897654
       Australia  897654
       india      876543

required output should be

Name   place    phonenum

mike   china     12344
suzzi  japan      09876
chang  china      897654

I have used df1=df[df.Name == ''] I got output

  Name   place    phonenum

Please help me

What is print(df.index) ?

jezrael
– jezrael

2018-07-17 05:53:13 +00:00
Commented Jul 17, 2018 at 5:53 — jezrael
– jezrael, Commented Jul 17, 2018 at 5:53

jezrael · Accepted Answer · 2018-07-17 05:59:07Z

11

If Name is column:

print (df.columns)
Index(['Name', 'place', 'phonenum'], dtype='object')

Need change == to != for not equal if missing values are empty strings:

print (df)
    Name      place  phonenum
0   mike      china     12344
1           ireland    897654
2  suzzi      japan      9876
3  chang      china    897654
4         Australia    897654
5             india    876543

df1 = df[df.Name != '']
print (df1)
    Name  place  phonenum
0   mike  china     12344
2  suzzi  japan      9876
3  chang  china    897654

If in first columns are NaNs use dropna with specify column for check:

print (df)
    Name      place  phonenum
0   mike      china     12344
1    NaN    ireland    897654
2  suzzi      japan      9876
3  chang      china    897654
4    NaN  Australia    897654
5    NaN      india    876543

df1 = df.dropna(subset=['Name'])
print (df1)
    Name  place  phonenum
0   mike  china     12344
2  suzzi  japan      9876
3  chang  china    897654

edited Jul 17, 2018 at 5:59

answered Jul 17, 2018 at 5:51

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

2 Comments

tiru Over a year ago

I used it but rows with empty column is not removed

jezrael Over a year ago

Ok, what about df1 = df.dropna(subset=['Name']) ?

StudentAtLU · Accepted Answer · 2020-01-17 23:33:49Z

4

In my case, I had a bunch of fields with dates, strings, and one column for values (also called "Value"). I tried all suggestions above, but what actually worked was to drop NA records for the "Value" field.

df = df.dropna(subset=['Value'])

answered Jan 17, 2020 at 23:33

StudentAtLU

915 bronze badges

Comments

王士豪 · Accepted Answer · 2018-07-17 05:56:02Z

3

DataFrame dropna() method will drop entire row if any value in the row is missing.

df1 = df.dropna()

answered Jul 17, 2018 at 5:56

王士豪

516 bronze badges

1 Comment

tiru Over a year ago

by using this all columns which are empty entire row is deleting but i want to delete only Name column empty , then remove that itself.

Collectives™ on Stack Overflow

how to remove a row which has empty column in a dataframe using pandas

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related