pandas读取excel文件时表头有特殊字符使用itertuples迭代发生异常

Question

pandas读取excel文件时表头有特殊字符发生异常

原表

anno = pd.read_excel(excel_file, header=0, dtype=object)
    clo_name = list(anno)
    for row in anno.itertuples():
        result_dict = {}
        dataJson_dict = {}
        for i in range(len(clo_name)):
            name = clo_name[i]
            if i == 0:
                names = 'serialCode'
                value = getattr(row, '{}'.format(name))
            else:
                names = str(name)
                tmp = getattr(row, '{}'.format(name))
                if '计数' in names:
                    value = int(right_round(tmp, 0))
                else:
                    value = '%.2f' % float(right_round(tmp, 2))

            result_dict[names] = value
            result_dict['type'] = '流式'

        dataJson_dict['dataJson'] = result_dict
        dataJson_dict['fileUrl'] = ['']
        report_list.append(dataJson_dict)

    return report_list

运行结果及详细报错内容

'Pandas' object has no attribute '抑制细胞毒T淋巴细胞穿孔素(CD3CD8Perforin)'
######
我把表中表头的"()"不保留特殊字符就运行正常。

Answer 1

使用下方的迭代器迭代
for idx, row in anno.iterrows():