python基础 字典

问题描述

---

Excel 表格中有多列数据，其中第一列为能量值，往后数列对应着各能量值是否存在于某特定核中。需要将其挑出，按核素-能量值重新写成 Excel 表格。

 

实现

# -*- coding: utf-8 -*-
"""
Created on Tue Jun 16 09:37:13 2020

@author: kurrrr
"""

import xlrd
import xlwt

file = xlrd.open_workbook('./归属_20200616.xlsx')
sheet_read = file.sheet_by_name('总投影谱')

excl_write = xlwt.Workbook(encoding='utf-8')
sheet_write = excl_write.add_sheet('归属细节')

row_nuclear = ({1: '84Rb', 2: '83Rb', 3: '82Rb', 4: '81Rb', 5: '80Rb',
                6: '79Rb', 7: '78Rb', 8: '83Kr', 9: '82Kr', 10: '81Kr',
                11: '80Kr', 12: '79Kr', 13: '78Kr', 14: '81Br', 15: '80Br',
                16: '78As'})

energy = sheet_read.col_values(0)

for row in row_nuclear:
    nuclear = sheet_read.col_values(row)
    nuclear_dic = dict(zip(energy, nuclear))
    sheet_write.write(0, row-1, row_nuclear[row])
    i = 1
    for key in nuclear_dic:
        if "√" in nuclear_dic[key]:
            sheet_write.write(i, row-1, key)
            i = i + 1

excl_write.save('./归属细节_20200616.xls')

• 对同一个 Excel 文件进行读写比较麻烦，不建议那样操作。
• 字典的定义与遍历