Pandas读取Excel 、CSV文件

#-*- coding:utf-8 -*-
import xlrd
import pandas as pd
import numpy as np
#读取Excel文件
df1 = pd.read_excel(r'C:\Users\Administrator\Desktop\0717A.xlsx')
print("df1:\n{}\n".format(df1))
#读取CSV文件
df2 = pd.read_csv(r'C:\Users\Administrator\Desktop\0717A.csv')
print("df2:\n{}\n".format(df2))