python - 在excel上合并多个工作表
问题描述
嗨,我正在尝试合并一个文件夹中的所有 excel 工作表,但总是出现以下错误。'TypeError: listdir: path 应该是字符串、字节、os.PathLike 或 None,而不是列表。请帮忙。
import pandas as pd
import os
path = ['pythonProject']
combine = pd.DataFrame()
#2nd
for j in os.listdir(path):
df = pd.read_excel(path, skiprows=3)
combine = combine.append(df, ignore_index=True)
print(combine)
解决方案
由于[
and ,您不小心将路径列为列表]
。试试下面的代码
import pandas as pd
import os
path = 'pythonProject'
combine = pd.DataFrame()
#2nd
for j in os.listdir(path):
df = pd.read_excel(path, skiprows=3)
combine = combine.append(df, ignore_index=True)
print(combine)
推荐阅读
- android - Android 应用和 Xamarin.Forms 中的启动器图标
- websphere-liberty - 自由 18.0.0.3 中的 JPA2 使用 MySQL 数据库
- git - 默认为 git push
- r - R - Split time series into colums depending on weekday
- android - Firebase 执行代码 IF 子级已创建
- c++ - Send an array of Characters as a parameter to a function in C ++
- r - Identify rows which are lowering the correlation coefficient in R
- html - Hide overflow of an image with a greater width than the body
- python - heapq custom compareTo
- oracle - Issues with selection of DATES between START and END dates