如图,异常值已检测出,应该如何删除异常值,并将删除完异常值的文件另存为csv
找到异常值的索引,删除异常值:,将清理后的数据保存为CSV文件
import matplotlib.pyplot as plt
import pandas as pd
camera = pd.read_csv("data.csv")
plt.figure(figsize=(10, 31), dpi=1080)
p = plt.boxplot(camera['lif'])
values = p['fliers'][0].get_data()
plt.show()
print('异常值个数:', len(values))
print('异常值的最大值:', max(values))
print('异常值的最小值:', min(values))
outliers = camera[camera['lif'].isin(values[1])]
outlier_indices = outliers.index
camera_cleaned = camera.drop(outlier_indices)
camera_cleaned.to_csv("cleaned_data.csv", index=False)
python 遍历csv文件内容
源代码,换一下路径即可
import csv
with open('遍历csv文件的内容/reader_demo.csv','r',encoding='utf-8',newline='') as file:
content = csv.reader(file)
for row in content:
print(row)
‘’’