使用pandas数据帧复制和重命名文件

import pandas as pd
import shutil
import os

# 创建一个示例数据帧
data = {
    'original_path': ['path/to/file1.txt', 'path/to/file2.txt'],
    'new_name': ['new_file1.txt', 'new_file2.txt']
}
df = pd.DataFrame(data)

# 定义目标目录
target_directory = 'path/to/target_directory'

# 确保目标目录存在
os.makedirs(target_directory, exist_ok=True)

# 遍历数据帧并复制及重命名文件
for index, row in df.iterrows():
    original_file_path = row['original_path']
    new_file_name = row['new_name']
    new_file_path = os.path.join(target_directory, new_file_name)
    
    # 复制文件
    shutil.copy(original_file_path, new_file_path)
    
    print(f'Copied and renamed: {original_file_path} -> {new_file_path}')

if not os.path.exists(original_file_path):
    print(f'File not found: {original_file_path}')
    continue