python处理csv文件

# coding=utf-8
import pandas as pd
import os
import csv
import shutil
 
 
def sel_line(res_data):
    res_header = ['file', 'ending_time', 'part_id', 'lot_id', 'part_no', 'program', 'file_group', 'tempreature',
                  'retest', 'nt', 'value', 't_time', 'soft_bin', 'lots']
    df = pd.DataFrame(res_data, columns=res_header)
    df_group = df.groupby('part_id')
    for key in df_group.groups:
        pro_data = df_group.get_group(key)
        for idx, row in pro_data.iterrows():
            out_line = row
            line_3 = [out_line['file'], out_line['ending_time'], out_line['part_id'], out_line['lot_id'],
                      out_line['lot_id'],
                      out_line['part_no'], 0, 0, '', '', out_line['program'], out_line['file_group'],
                      out_line['tempreature'],
                      out_line['lots'], 0, 0, '', 'TF', 0, 0]
 
            line_1 = [out_line['part_id'], 0, 0, out_line['retest'], out_line['nt'], out_line['value'],
                      out_line['program'],
                      out_line['lot_id'], out_line['ending_time']]
            line_2 = [out_line['part_id'], 0, 0, out_line['retest'], out_line['t_time'], out_line['soft_bin'],
                      out_line['soft_bin'], out_line['lot_id'], '', 1, out_line['program']]
 
            prefix_dict_1[out_line['file_group']].append(line_1)
            if line_2 not in prefix_dict_2[out_line['file_group']]:
                prefix_dict_2[out_line['file_group']].append(line_2)
            all_ft.append(line_3)
 
 
def parse_excel(df, xlsx_file, file, program, lot_id, ending_time):
    print('当前文件：', file)
    file_group = file.replace('__', '_').split('_')[1]
    if file_group not in prefix_dict_1:
        prefix_dict_1[file_group]