How to remove all those rows from a csv file that are empty of a specific column

Question

In the following csv I want to remove all rows that are empty with respect to column 'Age' only (i.e. row 4 & 5 to be removed of entire file)

I tried

df['Age'].dropna(how ='any')

But this isn't the solution.

How to make good reproducible pandas examples. Why should I not upload images of ... when asking a question?. — wwii
– wwii, Commented Oct 19, 2022 at 18:37
Does - Drop rows containing empty cells from a pandas DataFrame - answer your question? — wwii
– wwii, Commented Oct 19, 2022 at 18:39
how to remove a row which has empty column in a dataframe using pandas — wwii
– wwii, Commented Oct 19, 2022 at 18:42

Sheldon · Accepted Answer · 2022-10-19 18:39:24Z

2

Use dropna with the subset argument:

df.dropna(subset=['Age'], how='any')

answered Oct 19, 2022 at 18:39

Sheldon

4,7804 gold badges28 silver badges53 bronze badges

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

1 Answer 1