挑选出行数足够的excel文件

**

遍历文件夹下的所有excel文件，并将数据量超过指定标准的文件拷贝到指定文件夹中 import os.path import shutil import pandas as pd def 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 = 50 copy_excel_files(source_folder, target_folder, row_threshold)