本文梳理了利用Python按指定命名规则批量创建文件/文件夹常用的方法。
- 批量创建文件夹
import os
file_path=os.path.abspath(r"C:\Users\Owen\PycharmProjects\Create_File")
for i in range(1,13):
a="{}月销售数据".format(i)
file_name=file_path + "\\"+a
os.makedirs(file_name)
- 批量创建Excel文件
import pandas as pd
import numpy as np
#全年每月数据存放在单独的excel表中
for i in np.arange(1,13):
data4 = pd.DataFrame()
a = "{}月销售业绩".format(i)
b = a + '.xlsx'
writer = pd.ExcelWriter(b, engine='xlsxwriter')
data4.to_excel(writer, 'Sheet1',index=0)
writer.save()
- 批量存放不同工作表到同一工作簿
import pandas as pd
import numpy as np
#计算每月销售数据并保存在Excel不同的工作表中
data = pd.DataFrame()
writer = pd.ExcelWriter('2019年销售业绩.xlsx', engine='xlsxwriter')
for i in np.arange(1,13):
data = pd.DataFrame()
a = "{}月".format(i)
data.to_excel(writer,a,index=0)
writer.save()