import pandas as pd
# a = pd.Series([‘a‘,‘b‘,‘c‘,‘d‘])
# print(a)
# b = pd.DataFrame({‘NAME‘:[‘tom‘,‘wendy‘,‘dancy‘],
# ‘GENDER‘:[‘MALE‘,‘FEMALE‘,‘FEMALE‘],
# ‘AGE‘:[‘32‘,‘43‘,‘76‘],
# ‘math‘:[‘67‘,‘78‘,‘92‘],
# ‘english‘:[‘87‘,‘77‘,‘86‘],
# ‘computer‘:[‘88‘,‘56‘,‘88‘]
# })
# print(b)
e_file = pd.ExcelFile(r‘C:/Users/13375/Desktop/python/统计表_模板.xlsx‘)
data = e_file.parse(‘Sheet1‘)
print(data)
原文:https://www.cnblogs.com/tomhu/p/12342906.html