dataframe选取为空的行

要选取DataFrame中为空的行，可以使用pandas中的.isnull()和.any()方法。首先，使用.isnull()方法找到DataFrame中的空值元素。然后，使用.any()方法判断该行是否有空值。最后，使用布尔索引来选择为空的行。下面是一个示例代码：

import pandas as pd

# 创建DataFrame
n = np.arange(20, dtype=float).reshape(5,4)
n = np.nan
index = ['index1', 'index2', 'index3', 'index4', 'index5']
columns = ['column1', 'column2', 'column3', 'column4']
frame3 = pd.DataFrame(data=n, index=index, columns=columns)

# 选取为空的行
null_rows = frame3[frame3.isnull().any(axis=1)]

print(null_rows)

运行以上代码，将会输出DataFrame中为空的行。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* [Python-pandas.DataFrame-找出有空值的行](https://blog.csdn.net/weixin_46599926/article/details/124479796)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *3* [pandas.DataFrame选取/排除特定行的方法](https://download.csdn.net/download/weixin_38653602/12867853)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]