关于pandas的read_excle属性报不存在的问题
import pandas as pd
df = pd.DataFrame(pd.read_excle('hxz111.xlsx'))
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)
运行代码总是报错:AttributeError: module 'pandas' has no attribute 'read_excle'