Python - 删除 DataFrame 中缺失的 (NaN) 值
要删除缺失值，即NaN值，请使用该dropna()方法。首先，让我们导入所需的库-
import pandas as pd
读取CSV并创建一个DataFrame-
dataFrame = pd.read_csv("C:\\Users\\amit_\\Desktop\\CarRecords.csv")使用dropna()删除缺失值。NaN将在dropna()使用后显示缺失值-
dataFrame.dropna()
示例
以下是完整代码
import pandas as pd
#读取csv文件
dataFrame = pd.read_csv("C:\\Users\\amit_\\Desktop\\CarRecords.csv")
print("DataFrame with some NaN (missing) values...\n",dataFrame)
#计算DataFrame中的行和列
print("\nNumber of rows and column in our DataFrame = ",dataFrame.shape)
#删除缺失值
print("\nDataFrame after removing NaN values...\n",dataFrame.dropna())输出结果这将产生以下输出-
DataFrame with some NaN (missing) values...
Car Place UnitsSold
0 Audi Bangalore 80.0
1 Porsche Mumbai NaN
2 RollsRoyce Pune 100.0
3 BMW Delhi NaN
4 Mercedes Hyderabad 80.0
5 Lamborghini Chandigarh 80.0
6 Audi Mumbai NaN
7 Mercedes Pune 120.0
8 Lamborghini Delhi 100.0
Number of rows and colums in our DataFrame = (9, 3)
DataFrame after removing NaN values ...
Car Place UnitsSold
0 Audi Bangalore 80.0
2 RollsRoyce Pune 100.0
4 Mercedes Hyderabad 80.0
5 Lamborghini Chandigarh 80.0
7 Mercedes Pune 120.0
8 Lamborghini Delhi 100.0热门推荐
1 如何训练狗狗不叫
2 训练狗狗不叫
3 训练狗狗随行
4 怎么训练狗狗不叫
7 训练比熊狗狗教程
10 上海狗狗训练
11 怎么训练狗狗上厕所
12 训练狗狗趴下
13 狗狗服从训练
14 训练狗狗拒食
15 训练狗狗笑
16 训练狗狗大便
17 训练狗狗立
18 训练狗狗捡东西