python代码，合并同表头文件

最新推荐文章于 2024-09-25 08:02:18 发布

原创最新推荐文章于 2024-09-25 08:02:18 发布 · 420 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#python

已有相同表结构不同日期的excel数据

import pandas as pd
import os
import warnings
warnings.filterwarnings('ignore')

def traverse_directory(path):
combined_data = pd.DataFrame()

# 目录下文件遍历
for root, dirs, files in os.walk(path):
for file in files:
path_dev =os.path.join(root, file)
print(path_dev)

# 合并数据帧
df = pd.read_excel(path_dev, engine='openpyxl')
combined_data = pd.concat([combined_data, df], ignore_index=True)
return combined_data

path =r'C:\Users\pengli.she\Desktop\账户表分表'
df_merged = traverse_directory(path)

# 将合并后的数据框保存到新的Excel文件
df_merged.to_excel('001.xlsx', index=False)
df_merged.info()

import pandas as pd
import os
import warnings
warnings.filterwarnings('ignore')

def traverse_directory(path):
    combined_data = pd.DataFrame()

    # 目录下文件遍历
    for root, dirs, files in os.walk(path):
        for file in files:
            path_dev =os.path.join(root, file)
            print(path_dev)

            # 合并数据帧
            df = pd.read_excel(path_dev, engine='openpyxl')  
            combined_data = pd.concat([combined_data, df], ignore_index=True)
    return combined_data

path =r'C:\Users\pengli.she\Desktop\账户表分表'
df_merged = traverse_directory(path)

# 将合并后的数据框保存到新的Excel文件
df_merged.to_excel('001.xlsx', index=False)
df_merged.info()