DAT_copy 产生的问题 .

本文探讨了DMA传输过程中L2缓存的影响及解决方案。通过具体实例演示了如何确保DMA操作前后片内外存数据一致性,强调了缓存刷新的重要性。

//这个转载的东西,经我实验没有发现错误。就当学习了吧。

//我分析应该不会出错,因为编译器有一套维护cache的机制,否则不累死程序员了

 

#include <csl.h>
#include <csl_cache.h>
#include <csl_dat.h>
#include <stdio.h>

#pragma DATA_SECTION(external, "quickdata")
char external[352*416];                              // 片外

#pragma DATA_SECTION(internal, "quickdata")
char internal[16 * 352];                              // 片内

void main()
{
int i, j, id;
char x = 0;

CSL_init();                                            
CACHE_clean(CACHE_L2ALL, 0, 0);
CACHE_setL2Mode(CACHE_128KCACHE);      
CACHE_enableCaching(CACHE_EMIFA_CE00);
CACHE_enableCaching(CACHE_EMIFA_CE01);

for(i = 0; i < 352 * 416;++i)
{
   external[i] = (i & 0xff);
}

DAT_open(DAT_CHAANY, DAT_PRI_LOW, DAT_OPEN_2D);
id = DAT_copy2d(DAT_2D1D, &external[0], internal, 352, 16, 416);
DAT_wait(id);

for(i = 0; i < 16; ++i)   // 检查搬移是否正确
{
      if(memcmp(&external[i * 416], &internal[i * 352], 352) != 0)
   {
    fprintf(stderr, "error/n");
   }
}
fprintf(stderr, "end/n");
}

测试运行失败。DMA传输后片内与片外数据不一致。经分析后确认是因为程序开始打开了L2Cache,并且允许对片外存储器进行缓存,因此开始对external的初始化实际上实在L2Cache中做的,并未实时更新到片外external,故DMA不正确,解决办法是在external初始化之后调用下面的语句请求二级缓存立刻刷新数据:

CACHE_wbInvL2(external, 352*416, CACHE_WAIT);

则测试正确,注意这个函数的第二个参数有最大为65536*4的限制,如果要刷新的数据大小超过了这个值,则应该分为几块分别调用该函数。

 

 

###############################################################################

The DATA_SECTION pragma allocates space for the symbol in a section called section name.
The syntax for the pragma in C is:

#pragma DATA_SECTION (symbol, "section name");

我个人的理解是:

定义一个数据段:
          段名为:    "section name"
          段的内容在: symbol 里
在CCS编程中,如果我们不指定变量的存放位置,编译器会自动的给变量分配一个位置,但是如果有的时候需要把变量放在一个特定的空间内,我们应该如何操作呢,CCS提供了如下的两个指令
#pragma CODE_SECTION
#pragma DATA_SECTION
其中data_section是针对数据空间的,code_section是针对程序空间的,具体的使用办法是
#pragma DATA_SECTION(bufferB, ”my_sect”)
char bufferB[512];
在.cmd文件中建立对应的section就可以使用了。

注意:在使用#pragma DATA_SECTION时,应该先开辟一个空间,即:#pragma DATA_SECTION(bufferB, ”my_sect”),然后再定义该空间的大小:char bufferB[512];

#!/bin/env python # -*- coding: utf-8 -*- ################################################# # Author: songwenhua # Function: MI-13自动出具POFV孔口图纸 # Date: 2025-11-18 # v1.00 songwenhua 用户需求号: 2796 任务ID:2110 # LOAD_MODE__ import os import math import re import sys import string import faulthandler faulthandler.enable() from PyQt5.QtGui import * from PyQt5.QtCore import * from PyQt5.QtWidgets import * from PyQt5 import QtWidgets from py39COM import Gateway, InCAM from py39Tools import TableWidget from messageBox import messageBox from ICO import ICO from ICNET import ICNET from reportlab.pdfgen.canvas import Canvas as ReportCanvas from reportlab.platypus import PageBreak, FrameBreak, Frame, Table, TableStyle from reportlab.platypus.doctemplate import SimpleDocTemplate, PageTemplate, NextPageTemplate from DrawingCreate import DrawingTemplate from reportlab.lib import colors from Gerber2SVG import Origin, Feature from Gerber2Canvas import Gerber2Canvas, Dimension, Direct from reportlab.lib.pagesizes import A4 from reportlab.lib.units import mm from EqHelper import EqHelper import subprocess from ui.params_window import Ui_Form import json class Dr_POFV_Map(QWidget): # A5 = (100*mm, 100*mm) pageSize = (A4[0], A4[1]) # 页面大小 bgTemp: DrawingTemplate # 画PDF的模板类 doc: SimpleDocTemplate drawingVer = '01' # 版本号 drawingParams = dict() # PDF模板参数 canvas: ReportCanvas # 画布 tmpLays = [] # 需要删除的临时层 sigDimension = {} # 图纸编号 MI-13 drawNo = 'MI-13' # str # 铜厚测量图纸 drawName: str = '孔到孔距离标注图纸' workstation = None dirPath = None # 公共盘路径 filePath = None # 文件路径 datLay = None # datdatWork = 'dat_copy_work_lay' # dat复制的工作层 coorArr = [] # 坐标序列 def __init__(self): self.JOB = os.environ.get('JOB', None) self.STEP = os.environ.get('STEP', None) INCAM_DEBUG = os.getenv('INCAM_DEBUG', None) if INCAM_DEBUG == 'yes': self.incam = Gateway() self.JOB = self.incam.job_name self.STEP = self.incam.step_name self.pid = self.incam.pid else: self.incam = InCAM() self.pid = os.getpid() self.ico = ICO(incam=self.incam) self.icNet = ICNET(incam=self.incam) self.jobName = self.ico.SimplifyJobName(jobName=self.JOB) self.dbSite = self.ico.GetDBSite(JOB=self.JOB) self.SITE = self.ico.GetSite(JOB=self.JOB) self.layerMatrix = self.ico.GetLayerMatrix() self.step_list = self.ico.GetStepList() self.workStep = self.ico.GetEditList()[0] #得到edit步骤 # 获取基础 workfile 路径:/incam/gz-workfile/ base_work_path = self.ico.GetWorkFilePath() # 注意:不传 mode 或 mode 默认为空 # 构造目标输出目录 target_pdf_dir = os.path.join(base_work_path, 'output', 'pdf', self.jobName) # 确保目录存在 os.makedirs(target_pdf_dir, exist_ok=True) # 设置最终 PDF 输出路径 self.filePath = os.path.join(target_pdf_dir, f"{self.jobName}-MI-13-POFV.pdf") # self.imgPath = os.path.join(base_work_path, 'output', 'laser_image', self.jobName) os.makedirs(self.imgPath, exist_ok=True) self.imgPath = os.path.join(self.imgPath, 'pofv_ring.png') # 网络共享的基础路径(父目录) # base_network_path = '//10.10.80.178/workfile/output/pdf' # base_network_path = '\\\\10.10.80.178\\workfile\\output\\pdf' # job_folder = self.jobName # target_path = os.path.join(base_network_path, job_folder) # 完整目标路径 # basePath = '/tmp' # 默认降级路径 # try: # # 检查基础网络路径是否存在(即 pdf/ 目录) # if not os.path.exists(base_network_path): # raise OSError(f"Base network path does not exist: {base_network_path}") # if not os.path.isdir(base_network_path): # raise OSError(f"Base network path is not a directory: {base_network_path}") # # 尝试创建 jobName 子目录 # os.makedirs(target_path, exist_ok=True) # # 再次确认有写权限 # test_file = os.path.join(target_path, '.test_write') # with open(test_file, 'w') as f: # f.write('test') # os.remove(test_file) # # 如果一切正常,使用网络路径 # basePath = target_path # except Exception as e: # print(f"[WARNING] Cannot use network path: {e}") # messageBox.showDialog( # title='提示', # text=f'无法访问网络路径,将保存至临时目录 (/tmp)。\n错误: {str(e)}', # buttons=['OK'], # defaultButton='OK' # ) # basePath = '/tmp' # # === 设置最终路径 === # self.imgPath = os.path.join(self.ico.GetWorkFilePath(), 'output', 'laser_image', self.jobName) # os.makedirs(self.imgPath, exist_ok=True) # self.imgPath = os.path.join(self.imgPath, 'pofv_ring.png') # self.filePath = os.path.join(basePath, f"{self.jobName}-MI-13-POFV.pdf") self.totalPage = 1 # PDF总页数(外层) # 获取中文用户名 user = self.ico.GetUserName() usList = ICNET.GetCTypeUserInfo('user2CN') self.userCN = user if user in usList: self.userCN = usList[user] self.run() def find_keys_by_start_or_end(self, data, target): """ 查找所有 start 或 end 等于 target 的钻孔层 """ result = [] for key, value in data.items(): if isinstance(value, dict): # 确保是字典 start = value.get('start') end = value.get('end') if start == target or end == target: result.append(key) return result def chk_touch(self, dat_layer, intersect_layer): self.ico.ClearLayer() self.ico.DispWork(dat_layer) # 重置并设置基础过滤器 self.incam.COM("reset_filter_criteria,filter_name=,criteria=all") self.incam.COM("set_filter_type,filter_name=,lines=yes,pads=yes,surfaces=yes,arcs=yes,text=yes") self.incam.COM("set_filter_polarity,filter_name=,positive=yes,negative=yes") # 找到dat层中touch相交层的物体 self.incam.COM(f"sel_ref_feat,layers={intersect_layer},use=filter,mode=touch,pads_as=shape,f_types=line;pad;surface;arc;text,polarity=positive;negative,include_syms=,exclude_syms=") self.incam.COM('get_select_count') selected_features = int(self.incam.COMANS) return selected_features def get_coords(self, feature): """ 从任意图元中快速提取一个坐标点 (x, y) 特别处理 surface 的 orig 字段 """ # 优先返回已有的 cx/cy pad # all_cor = [] if 'cx' in feature and 'cy' in feature: return round(feature['cx'], 3), round(feature['cy'], 3) # 对于 line 等有 x0/y0 的类型 if 'x0' in feature and 'y0' in feature: return round(feature['x0'], 3), round(feature['y0'], 3) # 处理 surface 的 orig if feature.get('type') == 'surface' and isinstance(feature.get('orig'), list): pattern = r'#O[BS]\s+([-\d.]+)\s+([-\d.]+)' for line in feature['orig']: match = re.search(pattern, line) if match: x = float(match.group(1)) y = float(match.group(2)) return round(x, 3), round(y, 3) # 返回第一个有效坐标即可 return None # 提取SCC_PLUGGING_TYPE值 def get_plugging_type(self, item): return ( item.get("DATA", {}) .get("SCC_PLUGGING_TYPE", "") .strip() .upper() ) def run(self): self.ico.OpenStep(step=self.workStep, job=self.JOB) site = self.ico.GetSite(self.JOB) layerMatrix = self.ico.GetLayerMatrix() sig_out_list = layerMatrix['sigOutLay'] sm_lay_list = layerMatrix['smAllLay'] drill_through = layerMatrix['drlThrough'] helper = EqHelper(self.incam, self.JOB, self.workStep) # pofv_flag = helper.getIsPOFV() raw_data = helper.getDrillData() # print(data) # === 类型自适应解析 === if isinstance(raw_data, str): try: data = json.loads(raw_data) print("成功将 JSON 字符串解析为字典") except json.JSONDecodeError as e: messageBox.showDialog( title='错误', text=f'钻孔数据格式异常,无法解析为JSON。\n详情:{e}', bitmap='error', buttons=['OK'], defaultButton=['OK'] ) sys.exit(1) elif isinstance(raw_data, dict): data = raw_data # 直接使用 # 确保 data 是非空字典 if not data: messageBox.showDialog( title='错误', text='钻孔数据为空', bitmap='error', buttons=['OK'], defaultButton='OK' ) sys.exit(1) # 获取所有值 items = list(data.values()) # 提取第一个和最后一个的 SCC_PLUGGING_TYPE first_item = items[0] last_item = items[-1] first_type = self.get_plugging_type(first_item) last_type = self.get_plugging_type(last_item) # 判断是否都是 POFV if not (site == '301' and first_type == "POFV" and last_type == "POFV"): messageBox.showDialog( title='提示', text=f'此板件不需要出具POFV图纸', bitmap='warning', buttons=['OK'], defaultButton='OK' ) sys.exit() # 存储每层处理结果 layer_results = {} tmp_drill_layer = "drill_final" self.ico.CreateOrEmptyLay([tmp_drill_layer]) for i, sig_layer in enumerate(sig_out_list): sm_layer = sm_lay_list[i] matching_layers = self.find_keys_by_start_or_end(drill_through, sig_layer) temp_intersect = f"int_{sig_layer}" # is_front = i == 0 # 假设第一个为正面 if not matching_layers: continue # 清理并创建相交层 if self.ico.IsLayerExist([temp_intersect]): self.ico.DelLayer([temp_intersect]) self.ico.CreateOrEmptyLay([temp_intersect]) self.ico.ClearAll() self.ico.DispWork(layer=sig_layer) self.ico.DispLayer(layer=sm_layer) self.ico.GetLayIntersect(self.workStep, sm_layer, sig_layer, acc=0.01) self.incam.COM(f"matrix_rename_layer,job={self.JOB},matrix=matrix,layer=intersect,new_name={temp_intersect}") self.ico.ClearLayer() self.ico.DispWork(temp_intersect) inter_info = self.ico.GetFeatureFullInfo(self.workStep, layer=temp_intersect) if not inter_info: messageBox.showDialog( title='提示', text=f'{sm_layer} 和 {sig_layer} 没有相交部分', buttons=['OK'], defaultButton='OK' ) self.ico.DelLayer(temp_intersect) continue #开始检测该层是否有有效钻孔匹配 result = { 'has_full_match': False, # 缩小50um后仍匹配 'has_raw_match': False, # 原始匹配 'has_expanded_match': False, # 外扩100um后匹配 'dat_layer': None, 'temp_intersect': temp_intersect } found_in_this_layer = False for dat_layer in matching_layers: # 情况A:检查原始是否 touch selected_features = self.chk_touch(dat_layer, temp_intersect) if selected_features > 0: # 尝试缩小50um shrunk_layer = temp_intersect + '-100' self.ico.ClearLayer() self.ico.DispWork(temp_intersect) self.incam.COM( 'copy_layer, source_job = %s, source_step = %s, source_layer = %s, dest = layer_name, ' 'dest_step =, dest_layer = %s, mode = replace, invert = no, copy_notes = no, ' 'copy_attrs = new_layers_only, copy_sr_feat = no' % ( self.JOB, self.workStep, temp_intersect, shrunk_layer) ) self.ico.ClearLayer() # 缩小50um self.ico.DispWork(shrunk_layer) self.incam.COM("rv_tab_empty,report=resize_rep,is_empty=yes") self.incam.COM("sel_resize,size=-100,corner_ctl=no") self.incam.COM("rv_tab_view_results_enabled,report=resize_rep,is_enabled=no,serial_num=-1,all_count=-1") selected_shrunk = self.chk_touch(dat_layer, shrunk_layer) if selected_shrunk > 0: result['has_full_match'] = True result['dat_layer'] = dat_layer self.ico.DelLayer(shrunk_layer) found_in_this_layer = True break # 成功即退出 dat_layer 循环 else: result['has_raw_match'] = True result['dat_layer'] = dat_layer self.ico.DelLayer(shrunk_layer) #情况B:原始无 touch,尝试外扩+100um else: expanded_layer = temp_intersect + '+100' self.ico.ClearLayer() self.ico.DispWork(temp_intersect) self.incam.COM( 'copy_layer, source_job = %s, source_step = %s, source_layer = %s, dest = layer_name, ' 'dest_step =, dest_layer = %s, mode = replace, invert = no, copy_notes = no, ' 'copy_attrs = new_layers_only, copy_sr_feat = no' % ( self.JOB, self.workStep, temp_intersect, expanded_layer) ) self.ico.ClearLayer() # 外扩50um self.ico.DispWork(expanded_layer) self.incam.COM("rv_tab_empty,report=resize_rep,is_empty=yes") self.incam.COM("sel_resize,size=+100,corner_ctl=no") self.incam.COM("rv_tab_view_results_enabled,report=resize_rep,is_enabled=no,serial_num=-1,all_count=-1") selected_expanded = self.chk_touch(dat_layer, expanded_layer) if selected_expanded > 0: result['has_expanded_match'] = True result['dat_layer'] = dat_layer result['expanded_layer'] = expanded_layer # 保留用于后续复制 found_in_this_layer = True break # 成功即退出 else: self.ico.DelLayer(expanded_layer) # 保存当前层结果 if found_in_this_layer or result['has_raw_match']: layer_results[sig_layer] = result else: self.ico.DelLayer(temp_intersect) # 无任何匹配,清理 # 二、根据收集结果进行最终输出决策 final_copied = False best_sig_layer = None #记录最终要画图的 sig_layer # self.incam.COM(f"affected_layer,name={sig_layer},mode=single,affected=yes") # self.incam.COM(f"affected_layer,name={dat},mode=single,affected=yes") # 1. 优先:正面 缩小50um后有匹配 front_sig = sig_out_list[0] if front_sig in layer_results: res = layer_results[front_sig] if res['has_full_match']: temp = res['temp_intersect'] dat = res['dat_layer'] shrunk = temp + '-100' # 重建并使用缩小层 # self.incam.PAUSE("使用正面缩小") self.ico.ClearLayer() self.ico.DispWork(temp) self.incam.COM( 'copy_layer, source_job = %s, source_step = %s, source_layer = %s, dest = layer_name, ' 'dest_step =, dest_layer = %s, mode = replace, invert = no, copy_notes = no, ' 'copy_attrs = new_layers_only, copy_sr_feat = no' % (self.JOB, self.workStep, temp, shrunk)) self.incam.COM("sel_resize,size=-100,corner_ctl=no") self.chk_touch(dat, shrunk) self.incam.COM(f"sel_copy_other,dest=layer_name,target_layer={tmp_drill_layer},invert=no,dx=0,dy=0,size=0,x_anchor=-1.36612,y_anchor=-1.03115") self.ico.DelLayer(shrunk) final_copied = True best_sig_layer = front_sig # 记录正面 # 2. 背面 缩小50um后有匹配 if not final_copied: for i, sig_layer in enumerate(sig_out_list): if i == 0: continue # 跳过正面 if sig_layer in layer_results: res = layer_results[sig_layer] if res['has_full_match']: temp = res['temp_intersect'] dat = res['dat_layer'] shrunk = temp + '-100' # self.incam.PAUSE("使用背面缩小") self.ico.ClearLayer() self.ico.DispWork(temp) self.incam.COM( 'copy_layer, source_job = %s, source_step = %s, source_layer = %s, dest = layer_name, ' 'dest_step =, dest_layer = %s, mode = replace, invert = no, copy_notes = no, ' 'copy_attrs = new_layers_only, copy_sr_feat = no' % ( self.JOB, self.workStep, temp, shrunk_layer)) self.incam.COM("sel_resize,size=-100,corner_ctl=no") self.chk_touch(dat, shrunk) self.incam.COM(f"sel_copy_other,dest=layer_name,target_layer={tmp_drill_layer},invert=no,dx=0,dy=0,size=0,x_anchor=-1.36612,y_anchor=-1.03115") self.ico.DelLayer(shrunk) final_copied = True best_sig_layer = sig_layer # 记录背面 break # 3. 正面 有原始或外扩匹配(但没有进入缩小成功分支) if not final_copied and front_sig in layer_results: res = layer_results[front_sig] temp = res['temp_intersect'] dat = res['dat_layer'] self.ico.ClearLayer() self.ico.DispWork(temp) if res['has_raw_match']: # self.incam.PAUSE("使用正面原始") self.chk_touch(dat, temp) self.incam.COM(f"sel_copy_other,dest=layer_name,target_layer={tmp_drill_layer},invert=no,dx=0,dy=0,size=0,x_anchor=-1.36612,y_anchor=-1.03115") final_copied = True elif res['has_expanded_match']: # self.incam.PAUSE("使用正面扩大") exp_layer = temp + '+100' self.incam.COM( 'copy_layer, source_job = %s, source_step = %s, source_layer = %s, dest = layer_name, ' 'dest_step =, dest_layer = %s, mode = replace, invert = no, copy_notes = no, ' 'copy_attrs = new_layers_only, copy_sr_feat = no' % ( self.JOB, self.workStep, temp, exp_layer)) self.incam.COM("sel_resize,size=+100,corner_ctl=no") self.chk_touch(dat, exp_layer) self.incam.COM(f"sel_copy_other,dest=layer_name,target_layer={tmp_drill_layer},invert=no,dx=0,dy=0,size=0,x_anchor=-1.36612,y_anchor=-1.03115") self.ico.DelLayer(exp_layer) final_copied = True best_sig_layer = front_sig # # 4. 任意背面 有原始或外扩匹配 if not final_copied: for i, sig_layer in enumerate(sig_out_list): if i == 0: continue if sig_layer in layer_results: res = layer_results[sig_layer] temp = res['temp_intersect'] dat = res['dat_layer'] self.ico.ClearLayer() self.ico.DispWork(temp) if res['has_raw_match']: self.chk_touch(dat, temp) # self.incam.PAUSE("使用背面原始") elif res['has_expanded_match']: # self.incam.PAUSE("使用背面扩大") exp_layer = temp + '+100' self.incam.COM( 'copy_layer, source_job = %s, source_step = %s, source_layer = %s, dest = layer_name, ' 'dest_step =, dest_layer = %s, mode = replace, invert = no, copy_notes = no, ' 'copy_attrs = new_layers_only, copy_sr_feat = no' % ( self.JOB, self.workStep, temp, exp_layer)) self.incam.COM("sel_resize,size=+100,corner_ctl=no") self.chk_touch(dat, exp_layer) self.ico.DelLayer(exp_layer) # self.incam.COM(f"sel_copy_other,dest=layer_name,target_layer={tmp_drill_layer},invert=no,dx=0,dy=0,size=0,x_anchor=-1.36612,y_anchor=-1.03115,subsystem=1-Up-Edit") self.incam.COM(f"sel_copy_other,dest=layer_name,target_layer={tmp_drill_layer},invert=no,dx=0,dy=0,size=0,x_anchor=-1.36612,y_anchor=-1.03115") final_copied = True best_sig_layer = sig_layer # break # 5. 完全失败 if not final_copied: messageBox.showDialog( title='提示', text='此板件不需要出具POFV图纸', bitmap='warning', buttons=['OK'], defaultButton='OK' ) sys.exit() # 清理所有临时层 for sig_layer in sig_out_list: base = f"int_{sig_layer}" self.ico.DelLayer([base, base+'+100']) self.sigDimension[best_sig_layer] = {} self.sigDimension[best_sig_layer]['point_x'] = [] self.sigDimension[best_sig_layer]['point_y'] = [] self.ico.ClearLayer() # 获取要标注的孔坐标(来自 tmp_drill_layer) self.ico.DispWork(tmp_drill_layer) #获取最终孔层的信息,主要是要其中任意一个孔的中心坐标 padList = self.incam.INFO( '-t layer -e %s/%s/%s -m script -d FEATURES -o consider_origin+feat_index+f0' % ( self.JOB, self.workStep, tmp_drill_layer)) for pad in padList: pad.strip() # 3 #P 0.927 1.915 r261 P 1 0 N;.drill=via,.drill_flag=103,.combined_size=0.000000 strList = pad.split() match1 = re.search(r'#(\d+)\s+#P\s+', pad) if match1: midpointX = '%0.3f' % ( float(strList[2])) # 孔盘中点的X坐标 midpointY = '%0.3f' % ( float(strList[3])) # 孔盘中点的Y坐标 self.sigDimension[best_sig_layer]['point_x'].append(midpointX) self.sigDimension[best_sig_layer]['point_y'].append(midpointY) self.ico.ClearLayer() # self.ico.DispWork(sig_layer) # self.ico.DispLayer(sm_layer) # self.ico.DispLayer(dat_layer) self.__renderPDF(best_sig_layer) #在找到的那一层操作,正面或背面 self.ico.DelLayer(self.tmpLays) mes = f'输出目录:{self.filePath},继续将打开PDF' ans = messageBox.showMessage( bitmap='information', title='PDF输出完成', message=mes, buttons=['退出', '继续']) if ans == '继续': os.system(f"/usr/bin/evince {self.filePath} &") self.incam.COM('disp_on') # TODO 转换成png 放到output里面 self.__pdf2PNG() return 0 def __pdf2PNG(self): cmd = f"convert -density 120 -quality 80 -background white -alpha remove {self.filePath} {self.imgPath}" os.system(cmd) def __renderPDF(self, sig_lay): """ 渲染PDF:设置文档结构并构建内容 """ canv = ReportCanvas(self.filePath, pagesize=self.pageSize) self.canvas = canv self.drawingParams = self.__setTemplateParams() # 设置模板的默认参数 self.bgTemp = DrawingTemplate( canv, A4[0], A4[1], self.drawingParams) lM = 0 rM = 0 tM = 0 bM = 0 self.doc = SimpleDocTemplate(self.filePath, pagesize=self.pageSize, topMargin=tM, bottomMargin=bM, leftMargin=lM, rightMargin=rM, title="MI-13", author=self.userCN)#filePath:最终存放路径; pageSize:画布大小 self.__setPageFrame(self.doc) story = [] story.append(NextPageTemplate('p1')) g2c = self.__createGerber(sig_lay) story.append(FrameBreak()) story.append(g2c) story.append(PageBreak()) self.doc.build(story) # def __setPageFrame(self, doc: SimpleDocTemplate): """设置每一页框架分布 """ frames = [] fh = doc.height / 3 padX = self.drawingParams['padx'] padY = self.drawingParams['pady'] tableFrame = Frame(x1=padX, y1=padY + fh * 2, width=doc.width, height=fh, id='f1') gerberFrame = Frame( x1=padX, y1=padY, width=doc.width, height=fh * 2, id='f2') frames.append(tableFrame) frames.append(gerberFrame) doc.addPageTemplates([PageTemplate(id='p1', frames=frames)]) def getMergeLay(self, lay): """ 将lay备份并将备份层合并为surface """ mergeLay = f'{lay}_merge' self.ico.DelLayer(mergeLay) self.ico.ClearAll() self.ico.DispWork(lay, number=1) self.incam.COM( f'sel_copy_other,dest=layer_name,target_layer={mergeLay},invert=no,dx=0,dy=0,size=0,x_anchor=0,y_anchor=0') self.ico.DispWork(mergeLay, number=1) self.incam.COM( 'sel_cont_resize,accuracy=25.4,break_to_islands=yes,island_size=0,hole_size=0,drill_filter=no,corner_ctl=no') return mergeLay # 现在有个要求,如果是在背面,那么用sel_copy_other命令把对应的sig_lay、dat层、sm_lay复制出去,然后将复制后的sig_lay作为work层,并使用命令COM affected_layer,name={},mode=single,affected=yes将另外两个设为影响层,然后sel_all_feat全选,再执行命令COM sel_transform,oper=mirror,x_anchor=3,y_anchor=1.9,angle=0,direction=ccw,x_scale=1,y_scale=1,x_offset=5.1576625,y_offset=10.6256,mode=anchor,duplicate=no将这三层复制层Y镜像。并将镜像后的这三层作为__createGerber函数中画图的层(!只有背面需要这样) def getDnxSigLayMapping(self, lay: str): """ 获取dnx孔层与其钻带的起始信号层之间的映射关系(1:1) :param dnxLayers:线路层 :return:起始终止是线路层的所有钻孔 """ dnxSigLayMapping = [] for drl in self.ico.GetLayerMatrix()['drlAllLay']: startLay = self.ico.GetLayerMatrix()['drlThrough'][drl]['start'] endLay = self.ico.GetLayerMatrix()['drlThrough'][drl]['end'] if startLay == lay or endLay == lay: dnxSigLayMapping.append(drl) return dnxSigLayMapping # 分析创建光绘的关键部分 def __createGerber(self, sigLay): layerMatrix = self.ico.GetLayerMatrix() sig_out_list = layerMatrix['sigOutLay'] sm_lay_list = layerMatrix['smAllLay'] toRead = [] # 1. 合并信号层为 surface mergeSigLay = self.getMergeLay(sigLay) self.tmpLays.append(mergeSigLay) mergeSigLayFilePath = self.ico.getFeatureFile(self.JOB, self.workStep, mergeSigLay) toRead.append(Feature(mergeSigLayFilePath, layerType='signal')) # 2. 添加阻焊层 idx = sig_out_list.index(sigLay) # 合并阻焊层为 surface sm_layer = sm_lay_list[idx] smergLay = self.getMergeLay(sm_layer) self.tmpLays.append(smergLay) maskFilePath = self.ico.getFeatureFile(self.JOB, self.workStep, smergLay) toRead.append(Feature(maskFilePath, layerType='solder_mask')) # 3. 添加钻孔层 drlSet = self.getDnxSigLayMapping(sigLay) for drl in drlSet: drlFilePath = self.ico.getFeatureFile(self.JOB, self.workStep, drl) toRead.append(Feature(drlFilePath, layerType='document')) # 4. 创建高亮圆圈层 highlight_layer = "pofv_highlight_circle" if self.ico.IsLayerExist([highlight_layer]): self.ico.DelLayer([highlight_layer]) self.ico.CreateOrEmptyLay(layer_list=[highlight_layer]) # 获取要高亮的孔坐标(只标第一个) if sigLay not in self.sigDimension or not self.sigDimension[sigLay]['point_x']: # 没有坐标,跳过画圈 pass else: x = float(self.sigDimension[sigLay]['point_x'][0]) y = float(self.sigDimension[sigLay]['point_y'][0]) self.ico.ClearLayer() self.ico.DispWork(highlight_layer) self.incam.COM(f"add_pad,symbol=r180,polarity=positive,x={x},y={y},mirror=no,angle=0,direction=ccw,resize=0,xscale=1,yscale=1") self.incam.COM("sel_feat2outline,width=3.0,location=on_edge,offset=0.1,polarity=as_feature,keep_original=no,text2limit=no")# 轮廓线 self.incam.COM("arc2lines,arc_line_tol=1") self.ico.DelLayer(highlight_layer + '+++') self.ico.ClearLayer() # sys.exit(0) # 高亮层也导出为 Gerber Feature self.tmpLays.append(highlight_layer) # 确保后续清理" hlight_path = self.ico.getFeatureFile(self.JOB, self.workStep, highlight_layer) toRead.append(Feature(hlight_path, layerType='signal', strokeColor = "#fcfcf6")) # === 计算尺寸和偏移 === unitSizeX, unitSizeY = self.ico.GetStepSize(self.workStep)[0:2] gbWidth = self.doc.width * 0.6 gbHeigth = self.doc.height * 2 / 3 * 0.6 offsetX = self.getOffsetXY(gbWidth, gbHeigth, unitSizeX, unitSizeY, pagesize=( self.doc.width, self.doc.height * 2 / 3))[0] # 创建绘图对象 g2c = Gerber2Canvas( gbWidth, gbHeigth, unitSizeX, unitSizeY, offsetX, 0.1, Origin.leftdown, self.canvas, toRead, rotate=0 ) # === 添加标注箭头=== dimension = [] if sigLay in self.sigDimension and self.sigDimension[sigLay]['point_x']: pointX = self.sigDimension[sigLay]['point_x'][0] pointY = self.sigDimension[sigLay]['point_y'][0] dimensionSingle = Dimension( x0=unitSizeX / 2, y0=unitSizeY * 1.2, x1=float(pointX), y1=float(pointY), direct=Direct.one_arrow, dist='POFV孔铜厚度测量位置', dimColor="#0400FF", # dimLineColor="#0800FF" # ) dimension.append(dimensionSingle) if dimension: g2c.addDimension(dimension) return g2c @staticmethod def getOffsetXY(gbWidth: float, gbHeight: float, unitSizeX: float, unitSizeY: float, pagesize: tuple = (A4[0], A4[1])): """ 获取使Gerber在PDF中居中显示的偏移量 :param gbWidth: pdf中 gerber宽度 :param gbHeight: pdf中 gerber长度 :param unitSizeX: unit宽 :param unitSizeY: unit长 :param pagesize: PDF宽和长 :return: x,y的偏移量 # 创建绘图对象 g2c = Gerber2Canvas(gbWidth,gbHeight,unitSizeX,unitSizeY,offsetX, offsetY, Origin.leftdown,self.canvas,toRead, rotate=0) """ scale1 = math.ceil(gbWidth / unitSizeX) scale2 = math.ceil(gbHeight / unitSizeY) scale = scale1 if scale1 < scale2 else scale2 offsetX = (pagesize[0] - unitSizeX * scale) / (2 * scale) offsetY = (pagesize[1] - unitSizeY * scale) / (2 * scale) return offsetX, offsetY def __setTemplateParams(self): """设置模板的默认参数""" params = {"layer_side": None, "header": "文档密级:内部公开", "footer": "此资料属广芯基板有限公司所有,未经许可,不得扩散.", "note:": "", "tolerance": "", "workstation": "蚀刻开窗-激光钻-电镀-刷板I", "drawing_name": "90874外层最小环宽监控图纸", "jobname": self.jobName, "drawing_no": "MI-13", "drawing_version": self.drawingVer, "units": "mm", "num_page": "", "total_page": self.totalPage, "create": self.userCN, "confirm": "陈伟", "approved": "刘丹洪", "padx": 5 * mm, "pady": 5 * mm, } return params def drawBackground(self, canv: ReportCanvas, doc: SimpleDocTemplate): """ 画页眉页脚用的函数 """ num = canv.getPageNumber() if num == 1: face = 'Unit Top side' else: face = 'Unit Bottom side' params = self.drawingParams params["num_page"] = str(num) params['layer_side'] = face bgTemp = DrawingTemplate(canv, A4[0], A4[1], params) bgTemp.parser() if __name__ == "__main__": app = QApplication(sys.argv) analyzer = Dr_POFV_Map() 直接在这份代码里改
最新发布
12-03
源代码如下:# test2_fixed_clean_saved_files.py # coding: utf-8 # 在每年运行后,保存 result.dat 并把 ORYZA 产生的 BalanceCheck.txt 与 chart.txt 也逐年备份到汇总文件夹 import pandas as pd import subprocess import time import re import io import os import shutil from pathlib import Path # ========== 配置 ========== EXE_FILE = r'E:\learning\experiment03\ORYZA2000.exe' EXP_TEMPLATE = r'E:\learning\experiment03\experiment.dat_' CASE_DIR = r'E:\learning\experiment03' OUT_DIR = Path(r'E:\learning\experiment03') OUTCOME_TXT = OUT_DIR / 'outcome.txt' DVS_VALS = [0.4, 0.65, 1.0, 2.0] START_YEAR = 1981 END_YEAR = 1983 # ========== 初始化(目录、清理旧文件) ========== OUT_DIR.mkdir(parents=True, exist_ok=True) RESULTS_BY_YEAR = Path(CASE_DIR) / 'RESULTS_BY_YEAR' RESULTS_BY_YEAR.mkdir(parents=True, exist_ok=True) OUTCOME_PER_YEAR_DIR = OUT_DIR / 'outcomes_per_year' OUTCOME_PER_YEAR_DIR.mkdir(parents=True, exist_ok=True) # Balance & Chart 汇总目录(每年会把对应文件复制到这里) BALANCE_DIR = OUT_DIR / 'BalanceChecks' CHART_DIR = OUT_DIR / 'Charts' BALANCE_DIR.mkdir(parents=True, exist_ok=True) CHART_DIR.mkdir(parents=True, exist_ok=True) # 清空 outcome_txt(如果想保留以前请注释掉下面这行) if OUTCOME_TXT.exists(): try: OUTCOME_TXT.unlink() except Exception: pass # 删除旧的 DVS 文件 和 op_summary(如果希望每次全新开始) for val in DVS_VALS: fn = OUT_DIR / f'{val}.csv' if fn.exists(): try: fn.unlink() except Exception: pass op_summary_csv = OUT_DIR / 'op_summary.csv' if op_summary_csv.exists(): try: op_summary_csv.unlink() except Exception: pass # 清空逐年 outcome 文件夹中的旧文件 for p in OUTCOME_PER_YEAR_DIR.glob('*'): if p.is_file(): try: p.unlink() except Exception: pass # ========== 运行年份准备 ========== all_args = [[year, year] for year in range(START_YEAR, END_YEAR + 1)] print(f'准备跑的年份从 {START_YEAR} 到 {END_YEAR} (共 {len(all_args)} 年)') # 统计 total = len(all_args) ran_count = 0 skipped_count = 0 error_count = 0 # ========== 辅助:启动模型 ========== def start_model_process(exe_path, prefer_cwd, log_file_handle, encoding='gbk'): exe_path = Path(exe_path) prefer_cwd = Path(prefer_cwd) if prefer_cwd.is_dir(): chosen_cwd = prefer_cwd elif exe_path.is_file(): chosen_cwd = exe_path.parent log_file_handle.write(f'WARNING: prefer_cwd 不存在,改用 exe 所在目录作为 cwd: {chosen_cwd}\n') else: chosen_cwd = None log_file_handle.write('ERROR: prefer_cwd 不存在且 exe 文件也不存在\n') raise FileNotFoundError("prefer_cwd 和 exe 都不可用,请检查路径设置。") popt = { 'stdout': subprocess.PIPE, 'stderr': subprocess.STDOUT, 'encoding': encoding, 'universal_newlines': True, } if chosen_cwd is not None: popt['cwd'] = str(chosen_cwd) p = subprocess.Popen([str(exe_path)], **popt) log_file_handle.write(f'Process started, pid={p.pid}, cwd={popt.get("cwd", os.getcwd())}\n') return p # 解析 op.dat 的函数(如果你以后仍想用 op 汇总) def parse_op_dat(op_path): try: with open(op_path, 'r', encoding='gbk', errors='replace') as f: lines = [ln.rstrip('\n') for ln in f.readlines()] except Exception: with open(op_path, 'r', encoding='utf-8', errors='replace') as f: lines = [ln.rstrip('\n') for ln in f.readlines()] nonempty = [(i, l) for i, l in enumerate(lines) if l.strip()] if not nonempty: return None, None header_idx = None for i, l in nonempty: if re.search(r'[A-Za-z]', l): header_idx = i header_line = l.strip() break if header_idx is None: return None, None header_cols = re.split(r'\s+', header_line) data_rows = [] for ln in lines[header_idx + 1:]: if not ln.strip(): continue tokens = re.split(r'\s+', ln.strip()) tokens = tokens[:len(header_cols)] data_rows.append(tokens) if not data_rows: return header_cols, None df = pd.DataFrame(data_rows, columns=header_cols) for c in df.columns: df[c] = pd.to_numeric(df[c], errors='ignore') return header_cols, df # ========== 主循环 ========== for idx, one_row_args in enumerate(all_args): print(f'>>> 正在跑第 {idx + 1} 组参数 / 共 {len(all_args)} 组') year = int(one_row_args[0]) triggered_enter = False # ---- 读模板并替换年 ---- try: with open(EXP_TEMPLATE, 'r', encoding='utf-8') as f: content = f.read() except Exception as e: print(f' ! 无法读取模板 {EXP_TEMPLATE}: {e}') error_count += 1 continue content = content.replace('IYEAR = 1981', f'IYEAR = {year}') content = content.replace('EMYR = 1981', f'EMYR = {year}') real_input = EXP_TEMPLATE.rstrip('_') try: with open(real_input, 'w', encoding='utf-8') as f: f.write(content) except Exception as e: print(f' ! 无法写入 {real_input}: {e}') error_count += 1 continue print(f' 生成输入文件:{real_input}') case_dir_path = Path(CASE_DIR) case_dir_path.mkdir(parents=True, exist_ok=True) dest_input = case_dir_path / Path(real_input).name try: if Path(real_input).resolve() != dest_input.resolve(): shutil.copy2(real_input, dest_input) print(f' 已复制输入文件到工作目录:{dest_input}') else: print(' 源文件与目标相同,跳过复制(已在 CASE_DIR 中)') except Exception as e: print(f' ! 无法复制输入文件到 CASE_DIR: {e}') runlog_path = OUT_DIR / f'runlog_{year}.txt' with open(runlog_path, 'w', encoding='gbk', errors='replace') as logf: try: p = start_model_process(EXE_FILE, CASE_DIR, logf, encoding='gbk') except FileNotFoundError as e: print(" ! 无法启动模型:", e) logf.write(f'ERROR starting model: {e}\n') error_count += 1 continue except Exception as e: print(" ! 启动模型时发生未知错误:", e) logf.write(f'ERROR starting model unknown: {type(e)} {e}\n') error_count += 1 continue try: for line in p.stdout: if line is None: continue print(line, end='') logf.write(line) low = line.lower() if '<enter>' in low: print(f' ! 第 {idx+1} 组参数触发 <Enter> 报错,跳过') logf.write('Detected <Enter> error, killing process.\n') triggered_enter = True try: p.kill() except Exception: pass break if 'fse 2.1: terminate model' in low: logf.write('Normal termination detected.\n') break time.sleep(0.001) except Exception as e: logf.write(f'Exception while reading stdout: {e}\n') try: p.kill() except Exception: pass try: p.wait(timeout=60) except Exception: try: p.kill() except Exception: pass if triggered_enter: skipped_count += 1 continue # ========== 读取 CASE_DIR/result.dat ========== case_result_dat = case_dir_path / 'result.dat' if not case_result_dat.exists() or case_result_dat.stat().st_size == 0: print(f' ! 第 {idx + 1} 组(year={year}) 未在 CASE_DIR 生成有效 result.dat,跳过') skipped_count += 1 continue # 读取并写 outcome(代码与你之前一致) try: with open(case_result_dat, 'r', encoding='gbk', errors='replace') as f: lines = f.readlines() except Exception: with open(case_result_dat, 'r', encoding='utf-8', errors='replace') as f: lines = f.readlines() last_rows = [] for j, L in enumerate(lines): if L.lstrip().startswith('2'): if (j == len(lines) - 1) or lines[j + 1].strip() == '': last_rows.append(L) if not last_rows: print(f' ! 第 {idx + 1} 组未找到有效最后 2 行,跳过') skipped_count += 1 continue final_line = last_rows[-1] header_done = OUTCOME_TXT.exists() and OUTCOME_TXT.stat().st_size > 0 if not header_done: for L in lines: if 'TIME' in L and re.search(r'[A-Za-z]', L): with open(OUTCOME_TXT, 'a', encoding='utf-8') as f: f.write(','.join(L.split('\t')).strip() + '\n') header_done = True break with open(OUTCOME_TXT, 'a', encoding='utf-8') as f: f.write(','.join(final_line.split('\t')).strip() + '\n') # ========== 备份 result.dat(按年) ========== dest_result_copy = RESULTS_BY_YEAR / f'result_{year}.dat' try: shutil.copy2(case_result_dat, dest_result_copy) print(f' 已复制 result.dat -> {dest_result_copy}') except Exception as e: print(f' ! 复制 result.dat 失败(继续解析):{e}') # ------------------ 在这里插入:保存 BalanceCheck.txt 与 chart.txt(每年) ------------------ # 说明:我们会在 CASE_DIR 下寻找 BalanceCheck.txt 与 chart.txt,采用重试机制(最多 8 次,每次 0.5s) def try_copy_file(src_path, dest_path, max_attempts=8, delay=0.5): for attempt in range(max_attempts): if src_path.exists() and src_path.stat().st_size > 0: try: shutil.copy2(src_path, dest_path) return True except Exception as e: # 可能文件被占用,等待重试 time.sleep(delay) continue else: time.sleep(delay) return False # BalanceCheck.txt src_balance = case_dir_path / 'BalanceCheck.txt' dest_balance = BALANCE_DIR / f'BalanceCheck_{year}.txt' ok_balance = try_copy_file(src_balance, dest_balance) if ok_balance: print(f' 已备份 BalanceCheck -> {dest_balance}') else: print(f' ⚠ 未能找到或复制 BalanceCheck.txt(year={year})到 {dest_balance}') # chart.txt src_chart = case_dir_path / 'chart.txt' dest_chart = CHART_DIR / f'chart_{year}.txt' ok_chart = try_copy_file(src_chart, dest_chart) if ok_chart: print(f' 已备份 chart -> {dest_chart}') else: print(f' ⚠ 未能找到或复制 chart.txt(year={year})到 {dest_chart}') # ------------------ 保存 BalanceCheck/chart 结束 ------------------ # 后续的 DVS 提取等代码(保留你之前的逻辑) try: with open(case_result_dat, 'r', encoding='gbk', errors='replace') as f: txt = f.read() except Exception: with open(case_result_dat, 'r', encoding='utf-8', errors='replace') as f: txt = f.read() blocks = list(re.finditer(r'(^TIME[\s\S]*?)(?=^TIME|\Z)', txt, flags=re.MULTILINE)) dfs = [] for m in blocks: block = m.group(1).strip() try: df = pd.read_csv(io.StringIO(block), sep='\t', engine='python') except Exception: try: df = pd.read_csv(io.StringIO(block), sep=r'\s+', engine='python') except Exception: continue dfs.append(df) if not dfs: try: lines_short = txt.splitlines()[:200] sample = '\n'.join(lines_short) df_try = None try: df_try = pd.read_csv(io.StringIO(sample), sep='\t', engine='python') except Exception: try: df_try = pd.read_csv(io.StringIO(sample), sep=r'\s+', engine='python') except Exception: df_try = None if df_try is not None and 'DVS' in df_try.columns: dfs = [df_try] except Exception: pass dfs = [df for df in dfs if 'DVS' in df.columns] if not dfs: print(f' ! 第 {idx + 1} 组(year={year}) 找不到含 DVS 的块,跳过') skipped_count += 1 continue common_len = min(len(df) for df in dfs) dfs = [df.iloc[:common_len].reset_index(drop=True) for df in dfs] big_df = pd.concat(dfs, axis=1, keys=range(len(dfs))) dvs_series = None for k in range(len(dfs)): sub = big_df[k] if 'DVS' in sub.columns: dvs_series = pd.to_numeric(sub['DVS'], errors='coerce') break if dvs_series is None or dvs_series.isna().all(): print(f' ! 第 {idx + 1} 组(year={year}) DVS 无有效值,跳过') skipped_count += 1 continue base_df = dfs[0].copy() base_df['DVS_for_search'] = dvs_series.values if 'YEAR' in base_df.columns: base_df['YEAR'] = year else: base_df.insert(0, 'YEAR', year) out_year_fn = OUTCOME_PER_YEAR_DIR / f'outcome_{year}.csv' try: base_df.drop(columns=['DVS_for_search'], errors='ignore').to_csv(out_year_fn, index=False, encoding='utf-8-sig') print(f' 已保存年度 outcome -> {out_year_fn}') except Exception as e: print(f' ! 保存年度 outcome 失败(year={year}):{e}') for val in DVS_VALS: try: best_idx = (base_df['DVS_for_search'] - val).abs().idxmin() except Exception: print(f' ! 无法计算最接近 DVS={val} 的索引,跳过该阈值') continue row_df = base_df.iloc[[best_idx]].drop(columns=['DVS_for_search'], errors='ignore').copy() if 'YEAR' not in row_df.columns: row_df.insert(0, 'YEAR', year) else: cols = list(row_df.columns) cols.insert(0, cols.pop(cols.index('YEAR'))) row_df = row_df[cols] outname = OUT_DIR / f'{val}.csv' try: with open(outname, 'a', encoding='utf-8-sig'): pass except PermissionError: print(f' ! 文件被占用,无法写入:{outname}(year={year})— 请关闭占用程序再试') continue try: if not outname.exists(): row_df.to_csv(outname, mode='w', header=True, index=False, encoding='utf-8-sig') print(f' 写入(创建+表头) DVS={val} -> {outname} (year={year}, idx={best_idx})') else: try: existing_cols = pd.read_csv(outname, nrows=0, encoding='utf-8-sig').columns.tolist() except Exception: existing_cols = [] if not existing_cols: row_df.to_csv(outname, mode='w', header=True, index=False, encoding='utf-8-sig') print(f' 写入(重写+表头) DVS={val} -> {outname} (year={year}, idx={best_idx})') else: row_df.to_csv(outname, mode='a', header=False, index=False, encoding='utf-8-sig') print(f' 追加 DVS={val} -> {outname} (year={year}, idx={best_idx})') except Exception as e: print(f' ! 写入 DVS={val} 失败(year={year}):{e}') op_file = case_dir_path / 'op.dat' # 给模型一点时间来完成文件写入(若模型刚退出) time.sleep(0.5) # 重试读取 op.dat(最多尝试 6 次,每次等待 0.5s),以防模型还在写文件 op_header, op_df = None, None for attempt in range(6): if op_file.exists() and op_file.stat().st_size > 0: op_header, op_df = parse_op_dat(op_file) # 你上面已定义 parse_op_dat if op_header is not None: break time.sleep(0.5) if op_header is None: print(f' ⚠ 警告:未在 {op_file} 中识别到有效表头或数据 (year={year})') else: # 如果 parse_op_dat 返回 header 但没有数据(header-only),仍写表头(但不会写行) df_to_write = None if op_df is None: # header 存在但没有数据行 — 创建一行空值行以便写 YEAR(若你不想写空行可以改成跳过) df_to_write = pd.DataFrame(columns=op_header) else: df_to_write = op_df.copy() # 插入 YEAR 列在最前面(如果已有 YEAR 列则覆盖) df_to_write.insert(0, 'YEAR', year) # 写入 op_summary.csv(第一次写 header,以 ORYZA 的表头写列名) op_summary_csv = OUT_DIR / 'op_summary.csv' if not op_summary_csv.exists(): # 写入时使用 op_header(加 YEAR 列) df_to_write.to_csv(op_summary_csv, mode='w', header=True, index=False, encoding='utf-8-sig') print(f' 创建并写入 OP 汇总 -> {op_summary_csv} (year={year}, rows={len(df_to_write)})') else: # 追加(不写 header) df_to_write.to_csv(op_summary_csv, mode='a', header=False, index=False, encoding='utf-8-sig') print(f' 追加写入 OP 汇总 -> {op_summary_csv} (year={year}, rows={len(df_to_write)})') ran_count += 1 # ========== 主循环结束 ========== print('>>> 全部跑完!') print(f'总年份:{total}, 成功运行:{ran_count}, 跳过:{skipped_count}, 错误:{error_count}') # ========== 循环外:对每个 DVS 文件按 YEAR 排序并覆盖保存 ========== for val in DVS_VALS: fn = OUT_DIR / f'{val}.csv' if not fn.exists(): print(f'跳过(不存在):{fn}') continue try: dfv = pd.read_csv(fn, encoding='utf-8-sig') except Exception: dfv = pd.read_csv(fn, encoding='utf-8', errors='replace') if 'YEAR' in dfv.columns: dfv_sorted = dfv.sort_values(by='YEAR', ascending=True).reset_index(drop=True) else: dfv_sorted = dfv dfv_sorted.to_csv(fn, index=False, encoding='utf-8-sig') print(f'✅ 已排序并保存:{fn}(共 {len(dfv_sorted)} 行)')
10-27
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值