Python熊猫读取文件问题

Question

Getting FileNotFoundError:[Erno 2]没有这样的文件或目录：'Incomeearnedreport_(26(.xls'错误。即使文件存在于我给出的路径中。这是我的代码：

import pandas as pd
import numpy as np
import os
path = os.getcwd()
path = path + "/Incomeearned/"
files = os.listdir(path)
df = pd.DataFrame()
print(files)
for f in files:
data = pd.read_excel(f, 'Report')
df = df.append(data)
print(f)

Answer 1

尝试更改：

data = pd.read_excel(f, 'Report')

带有：

data = pd.read_excel(os.path.join(path, f), 'Report')