待读取文件预览:
代码:
import pandas as pd
#读取excel
file_path = r'C:\Users\123\Desktop\pandastest\example.xlsx'
df = pd.read_excel(file_path, sheet_name=0, header=0, skipfooter=0)
#查询df的数据类型
print(df.dtypes)
#根据数据类型查询列
print(df.select_dtypes('int64'))
print(df.select_dtypes('object'))
print(df.select_dtypes('float64'))
print(df.select_dtypes('datetime64[ns]'))
输出结果: