将1-80文件夹按照excel列表进行命名

import os
import pandas as pd

# 读取Excel文件
df = pd.read_excel('s1.xlsx', header=None)

# 获取文件夹名称的列表
folder_names = df[0].tolist()

# 当前目录路径
current_dir = os.getcwd()

# 遍历文件夹并重命名
for index, folder_name in enumerate(folder_names):
    old_folder_path = os.path.join(current_dir, str(index + 1))  # 假设原文件夹名称是1-80
    new_folder_path = os.path.join(current_dir, folder_name)
    if os.path.exists(old_folder_path):
        os.rename(old_folder_path, new_folder_path)
    else:
        print(f"文件夹 {old_folder_path} 不存在")

print("重命名完成")

改进：将80个名称为excel表第一列名称的文件夹改为相对应的第二列名称

import os
import pandas as pd

# 读取Excel文件
df = pd.read_excel('s1.xlsx', header=None)

# 获取文件夹名称的列表
old_folder_names = df[0].tolist()  # 第一列：当前文件夹名称
new_folder_names = df[1].tolist()  # 第二列：新的文件夹名称

# 当前目录路径
current_dir = os.getcwd()

# 遍历文件夹并重命名
for old_folder_name, new_folder_name in zip(old_folder_names, new_folder_names):
    old_folder_path = os.path.join(current_dir, str(old_folder_name))
    new_folder_path = os.path.join(current_dir, str(new_folder_name))
    if os.path.exists(old_folder_path):
        os.rename(old_folder_path, new_folder_path)
    else:
        print(f"文件夹 {old_folder_path} 不存在")

print("重命名完成")