python dd 合并二进制文件_Python合并多个文件的同构数据

一、预览

二、参考代码

#!/usr/bin/env python

# coding: utf-8

# 导入模块

import glob

import pandas as pd

import time

import tkinter

from tkinter.filedialog import askdirectory

# 获取输入文件名

root = tkinter.Tk()

diretory = askdirectory()

root.withdraw()

print(diretory)

indicator_files = sorted(glob.glob(diretory+r"/*.csv"), reverse=True)

print(indicator_files)

# 合并多个文件的同构数据

df = pd.concat((pd.read_csv(file, encoding='gbk') for file in indicator_files),axis='index', ignore_index=True)

# 输出合并文件

output_file_name = '分级监控_合并后指标' + time.strftime('%Y-%m-%d %H:%M:%S', time.localtime()) + ".csv"

print(output_file_name)

df.to_csv(output_file_name, index=False, encoding='gbk')