weixin_45052608的博客

1、数据读取、输出excel读取图例1excel读取图例2数据读取函数图例2、数据创建3、数据预览4、数据清洗5、数据预处理6、数据筛选7、运算8、统计分析分类统计描述统计描述统计方法图例...

实例：运算import pandas as pda=pd.DataFrame({'name':['cindy','alice','ared'],'grade':[80,90,75],'age':[18,19,20]})b=pd.DataFrame({'name':['cindy','alice','bob','ared'],'grade':[95,70,60,50]})#表a的grade列计算极差f=lambda x:x.max()-x.min()print('a的grade列的极差：')p.

1、数据清洗2、数据预处理实例：排序、排名import pandas as pdst=pd.DataFrame({'id':[0,1,3,2],'name':['alice','cindy','bob','bruce']},index=[0,1,2,3])gr=pd.DataFrame({'id_no':[0,3,2],'name':['alice','cindy','bob'],'age':[18,18,20],'grade':['A-90','B-85','C-80']},index=[1

实例：数据查看#切片import pandas as pdimport numpy as npdata = pd.DataFrame({'id':[1,3,2],'name':['a','b','c']},index=[0,1,2])print('data：\n',data)#查看指定列print('id列：\n',pd.DataFrame(data['id']))print('id、name两列：\n',data.loc[:,['id','name']])print('第2列：\n',.

实例：一维数组Seriesimport pandas as pd#默认索引data = pd.Series([1,2,3])print('data:')print(data.index)print(data.values)print(data)print(data[2])print(data*2)print(4 in data)print(2 in data)print('\n')#自制索引data1 = pd.Series(['a','b','c'],index=['x','.

数据读取函数图例实例：多sheet的excel读取与保存import pandas as pdwriter = pd.ExcelWriter(r'C:\Users\xyy\Desktop\city_id_io9xlsx',engine='openpyxl')io = pd.io.excel.ExcelFile(r'C:\Users\xyy\Desktop\city_id.xlsx')print(io.sheet_names) #查看sheet列表#多sheet循环读取并保存num = 1.