我做了一个批量创建文件夹的代码,之前能用,现在老报错,求解答
import pandas as pd # 引入模块
import shutil # 引入模块
# 读取路径数据
asu_path = pd.read_excel(r'C:\Users\WZ003u\OneDrive - Linde Group\Desktop\Work Reference\ASU standard and Tonge.xlsx',
sheet_name='sheet1',
header=0)
# # 选取数据
asu_path = asu_path[['path', 'pd']]
# 获取行数
last_cols = len(asu_path)
filename = pd.read_excel(r'C:\Users\WZ003u\OneDrive - Linde Group\Desktop\1.xlsx',
sheet_name='sheet1',
header=0)
f_last_rows = len(filename)
print(f_last_rows)
pn = '1430A42G'
for j in range(f_last_rows):
po = filename['file'][j]
for i in range(last_cols):
if asu_path['pd'][i] == pn:
pth = asu_path['path'][i] + po
shutil.copytree(r'C:\Users\WZ003u\OneDrive - Linde Group\Desktop\Template', pth)
print('The file have been created successfully!')
break