测点转化为yaml.py 2.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  1. import pandas as pd
  2. df = pd.read_excel(r'C:\Users\wzl\Desktop\中广核104测点\0416部署需要\最终测点配置.xlsx',
  3. usecols=['标准化中文', '遥测别名', 'en_name', '场站', '风机号'])
  4. df['场站'] = df['场站'].apply(lambda x: x if x != '富风' else '太古')
  5. df['风机号'] = df['风机号'].apply(lambda x: int(x.split('WTG')))
  6. df['风机号'] = df.apply(lambda x: int(x.split('WTG')))
  7. # data_dict = dict()
  8. #
  9. # for _, data in df.iterrows():
  10. # cn_name = data['标准化中文']
  11. # bie_ming = data['遥测别名']
  12. # en_name = data['en_name']
  13. # changzhan = data['场站'] if data['场站'] != '富风' else '太古'
  14. # wind_no = int(data['风机号'].split('WTG')) if changzhan != '坡底' else data['风机号'].replace('WTG', 'F')
  15. # if changzhan in data_dict.keys():
  16. #
  17. # if wind_no in data_dict[changzhan].keys():
  18. # data_dict[changzhan][wind_no].append((bie_ming, cn_name, en_name))
  19. # else:
  20. # data_dict[changzhan][wind_no] = [(bie_ming, cn_name, en_name)]
  21. # else:
  22. # data_dict[changzhan] = {wind_no: [(bie_ming, cn_name, en_name)]}
  23. #
  24. # result = dict()
  25. # result_list = list()
  26. # shunxuhao = 0
  27. # for k, v in data_dict.items():
  28. # result_dict = dict()
  29. # result_dict['wind_factory'] = dict()
  30. # result_dict['wind_factory']['cn_name'] = k
  31. # result_dict['wind_factory']['wind_factory_no'] = ''
  32. # wind_turbine_list = list()
  33. # for k1, v1 in v.items():
  34. # wind_turbine_dict = dict()
  35. # wind_turbine_dict['wind_turbine_number'] = k1
  36. # wind_turbine_dict['measurepoints'] = list()
  37. # for v2 in v1:
  38. # point_dict = dict()
  39. # point_dict['point'] = dict()
  40. # point_dict['point']['shunxuhao'] = shunxuhao
  41. # shunxuhao = shunxuhao + 1
  42. # point_dict['point']['yc_name'] = v2[0]
  43. # point_dict['point']['standerd_cn_name'] = v2[1]
  44. # point_dict['point']['standerd_en_name'] = v2[2]
  45. # wind_turbine_dict['measurepoints'].append(point_dict)
  46. #
  47. # wind_turbine_list.append(wind_turbine_dict)
  48. # result_dict['wind_factory']['wind_turbine'] = wind_turbine_list
  49. # result_list.append(result_dict)
  50. # result['wind_factories'] = result_list
  51. #
  52. # yaml_str = yaml.dump(result, allow_unicode=True, sort_keys=False)
  53. # with open('mesurepoint.yaml', 'w', encoding='utf8') as f:
  54. # f.write(yaml_str)