#!/usr/bin/env python
# -*- coding: utf-8 -*-
# @Time : 2020/3/21 16:59
# @Author : ystraw
# @Site :
# @File : 合并excel.py
# @Software: PyCharm Community Edition
# @function: 合并指定文件夹下的所有excel
import os
import pandas as pd
import datetime
def getFileName(path):
files = os.listdir(path)
# print(files)
filenames = []
for file in files:
filenames.append(file)
# print(filenames)
return filenames
if __name__ == '__main__':
# 合并下面文件下所有excel文件:
path = r'D:\小的项目\旅游分析\数据'
# 读取该文件夹下的需要合并的文件路径
filelist = getFileName(path)
# 设置合并后文件的名字
file_time = datetime.datetime.now()
file_time = str(file_time).replace(' ', '_').replace(':','_&