python - 在python中将Excel文件与 Pandas 合并

Question

我几乎完成了将 excel 文件与 python 中的 pandas 合并，但是当我给出路径时它不会工作。我收到错误“没有这样的文件或目录:'file1.xlsx''”。当我将路径留空时，它可以工作，但我想决定它应该从哪个文件夹中获取文件。我将文件保存在文件夹“excel”中

cwd = os.path.abspath('/Users/Viktor/downloads/excel') #If i leave it empty and have files in /Viktor it works but I have the desired excel files in /excel 

print(cwd)
files = os.listdir(cwd)  
df = pd.DataFrame()
for file in files:
   if file.endswith('.xlsx'):
       df = df.append(pd.read_excel(file), ignore_index=True) 
df.head() 
df.to_excel(r'/Users/Viktor/Downloads/excel/resultat/merged.xlsx')

Answer 1

pd.read_excel(file) 查找相对于脚本执行路径的文件。如果您在“/Users/Viktor/”中执行，请尝试:

import os
import pandas as pd

cwd = os.path.abspath('/Users/Viktor/downloads/excel') #If i leave it empty and have files in /Viktor it works but I have the desired excel files in /excel 

#print(cwd)
files = os.listdir(cwd)  


df = pd.DataFrame()
for file in files:
   if file.endswith('.xlsx'):
       df = df.append(pd.read_excel('downloads/excel/' + file), ignore_index=True) 
df.head() 
df.to_excel(r'/Users/Viktor/downloads/excel/resultat/merged.xlsx')