warn_fault_yaml.py 702 B

1234567891011121314151617181920
  1. import pandas as pd
  2. import yaml
  3. df = pd.read_excel(r'C:\Users\wzl\Desktop\中广核104测点\0416部署需要\故障报警\故障代码表.xlsx')
  4. result_json = dict()
  5. for index, row in df.iterrows():
  6. mc_id = row['主控ID'].strip()
  7. code = row['状态编码']
  8. en_name = row['SC中文描述'].strip()
  9. level = str(row['告警等级']).strip()
  10. if mc_id in result_json.keys():
  11. result_json[mc_id][code] = {'en_name': en_name, 'level': level}
  12. else:
  13. result_json[mc_id] = {code: {'en_name': en_name, 'level': level}}
  14. yaml_str = yaml.dump(result_json, allow_unicode=True, sort_keys=False)
  15. with open('warn_fault.yaml', 'w', encoding='utf8') as f:
  16. f.write(yaml_str)