python dataframe获取excel数据

-- coding: UTF-8 --

import pandas as pd
import sys

if sys.getdefaultencoding() != ‘utf-8’:
reload(sys)
sys.setdefaultencoding(‘utf-8’)

list = [r’2_10s.xlsx’,r’2_20s.xlsx’,r’2_30s.xlsx’,r’2_40s.xlsx’,r’2_81s.xlsx’]
for xlsxName in list:
excelFile = xlsxName
sheetName =‘牵引所区段电压统计’
df = pd.DataFrame(pd.read_excel(excelFile,sheetName))
print excelFile+’-’+sheetName+‘最小值<1000’
print df[df[‘最小值’]<1000]
# df1= df[[‘变电所名称’, ‘最小值’]]
# print(df1)