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热门推荐
10 祝女儿简短祝福语大全
11 大学新年祝福语简短创意
12 元旦适合的祝福语简短
13 朋友出远门祝福语简短
14 初六简短的祝福语
15 祝男孩生日祝福语简短
16 同事调离的祝福语简短
17 拜年红包的祝福语简短
18 妈妈生日祝福语简短励志