import os import pandas as pd import numpy import openpyxl def get_path(file_path): for root, dirs, files in os.walk(file_path): for file in files: filename = os.path.join(root, file) del_file(filename) def del_file(filename): size = os.path.getsize(filename) if size < 31 * 1024: print("remove", filename) os.remove(filename) del_excel(filename) def del_excel(filename): df = pd.read_excel(r"C:\Users\admir\Desktop\demo\security_id.xlsx",dtype = {‘stockid‘ : str}) df_del = df[df[‘stockid‘].str.contains("filename[0:6]")] print(df_del) # df_del.to_excel(r"C:\Users\admir\Desktop\stock.xlsx",index=None) del_excel("300751.SZ") if __name__ == "__main__": file_path = r"C:\Users\admir\Desktop\demo\stock_data\创业板+科创板all" get_path(file_path)
原文:https://www.cnblogs.com/celine227/p/14514618.html