python - Pandas DataFrame 根据条件删除 NaN 行？

Question

Pandas DataFrame 根据条件删除 NaN 行。

我正在尝试删除gender==male 和status == NaN 的行。

示例 df:

        name     status        gender   leaves
0       tom        NaN          male      5 
1       tom        True         male      6
2       tom        True         male      7
3       mary       True         female    1
4       mary       NaN          female    10
5       mary       True         female    15
6       john       NaN          male       2
7       mark      True          male       3

预期输出:

        name     status        gender   leaves
0       tom        True         male      6
1       tom        True         male      7
2       mary       True         female    1
3       mary       NaN          female    10
4       mary       True         female    15
5       mark      True          male       3

Answer 1

您可以使用isna (或 isnull)函数来获取值为 NaN 的行。有了这些知识，您可以使用以下内容过滤数据框:

conditions = (df.gender == 'male')&(df.status.isna())
filtered_df = df[~conditions]