python读取指定文件名下的xls文件

import numpy as np
import pandas as pd
import os

filepath = r'E:\ty\小论文new\data\TY_EPI\tydata1\数据结果\indices1'
filepath = os.path.normpath(filepath)

for filename in os.listdir(filepath):
    if filename.endswith('.xls'):
        filepath = r'E:\ty\小论文new\data\TY_EPI\tydata1\数据结果\indices1'
        filepath = os.path.normpath(filepath)
        filepath = os.path.join(filepath, filename)
        df = pd.read_excel(filepath)
        data1 = np.array(df)