公司做网页去哪找_产品信息发布网站_网络营销与传统营销的区别_优云优客百度推广效果怎么样

**

遍历文件夹下的所有excel文件，并将数据量超过指定标准的文件拷贝到指定文件夹中

import os.path
import shutil
import pandas as pddef copy_excel_files(source_folder, target_folder, row_threshold):if not os.path.exists(target_folder):os.makedirs(target_folder)for filename in os.listdir(source_folder):if filename.endswith(('.xlsx', '.xls')):file_path = os.path.join(source_folder, filename)try:df = pd.read_excel(file_path)if len(df) > row_threshold:target_path = os.path.join(target_folder, filename)shutil.copy2(file_path, target_path)print(f"已复制文件{filename}")except Exception as e:print(f"处理文件{filename}时出错：{e}")if __name__ == "__main__":# 源文件夹路径source_folder = '自定义路径1'# 目标文件夹路径target_folder = '自定义路径2'# 行数阈值，可根据需要修改row_threshold = 50copy_excel_files(source_folder, target_folder, row_threshold)