import pandas as pd
import numpy as np
from datetime import date
today=date.today()
downpath='/Users/kangyongqing/Downloads/'
file_dangan='20230726_095440.csv'
file_banke='我的趣味中国之旅C12023-07-26.xlsx'
dt1=pd.read_csv(downpath+file_dangan)
# print(dt1.columns)
# print(dt1.loc[dt1['教师姓名']=='武月园'].T)
dt2=pd.read_excel(downpath+file_banke,engine='openpyxl')
for sheet_name,df in dt2.items():
print(sheet_name)
print(df.head())
pd.read_excel(filepath,engine='openpyxl')默认读取sheet_name=0,不填写和填写sheet_name=0的效果是一致的;
items会显示各列列名和数据明细;
sheet_name=None,则是导入所有的sheet,items方法会显示出sheet名称和各个sheet的数据示例;
sheet_name=['','']可以导入多个sheet,但是只输入一个,也会默认是导入了多个sheet