(Python)[多个excel表处理]根据excel表 一字段内容 批量分类 至对应文件夹

shutil
os
pandas

path = '#' # 多个excel表所在的文件夹路径

files = os.listdir(path)

new_list = ['#']  # 分类的对应字段列表

not_path = '#' # 无法分类的文件

ad_list = ['#'] # 分类的对应文件夹名列表

for i in files:
    df = pd.read_excel(path + '\{}'.format(i), engine='openpyxl')
    a = df.values.tolist()
    url = '#' # 提取a列表的一特定字段内容  
    
    if url == new_list[0]:
        l_path = os.path.join(path, i)
        despath = ad_list[0] + i
        shutil.move(l_path, despath)  # 移动
    elif url == new_list[1]:
        l_path = os.path.join(path, i)
        despath = ad_list[1] + i
        shutil.move(l_path, despath)
    elif url == new_list[2]:
        l_path = os.path.join(path, i)
        despath = ad_list[2] + i
        shutil.move(l_path, despath)
    else:
        l_path = os.path.join(path, i)
        despath = not_path + i
        shutil.move(l_path, despath)