直接学习:https://edu.csdn.net/course/play/6861/326774
冗余值、异常值和缺失值的处理
1、数据类型的修改
pd.to_datetime()
df.column.astype()
import pandas as pd
sec_car = pd.read_csv(r'D:\Teach Plan\CSDN\PPT\第7章 pandas模块的介绍\sec_cars.csv')
sec_car.head()
#查看列的数据类型
sec_car.dtypes
#数据类型的修改
sec_car.Boarding_time = pd.to_datetime(sec_car.Boarding_time, format = '%Y年%m月')
sec_car.New_price = sec_car.New_price.str[:-1].astype(float)
2、冗余数据的识别及处理
df.duplicated()
df.drop_duplicates()
import pandas as pd
data = pd.read_excel(r'D:\Teach Plan\CSDN\PPT\第7章 pandas模块的介绍\data_test04.xlsx')
data.head()
data.duplicated(subset = 'appname')
data.drop_duplicates(inplace= True)
print(data)