安装模块

pip3 install numpy pip3 install pandas pip3 install openpyxl

示例

import numpy as np import pandas as pd import openpyxl df = pd.DataFrame({"id":[1001,1002,1003,1004,1005,1006], "date":pd.date_range('20130102', periods=6), "city":['Beijing ', 'SH', ' guangzhou ', 'Shenzhen', 'shanghai', 'BEIJING '], "age":[23,44,54,32,34,32], "category":['100-A','100-B','110-A','110-C','210-A','130-F'], "price":[1200,np.nan,2133,5433,np.nan,4432]}, columns =['id','date','city','category','age','price']) #查看数据表的维度 # print(df.shape) #数据表信息 # print(df.info()) #查看数据表各列格式 # print(df.dtypes) #查看单列格式 # print(df['city'].dtype) #查看前3行数据 # print(df.head(3)) #输出到Excel格式 df.to_excel('Excel_to_Python.xlsx', sheet_name='bluewhale_cc')