generate_trans_cols.py 416 B

1234567891011
  1. # -*- coding: utf-8 -*-
  2. # @Time : 2024/5/31
  3. # @Author : 魏志亮
  4. import numpy as np
  5. import pandas as pd
  6. df = pd.read_excel(r"C:\Users\Administrator\Desktop\点检表配置.xls", sheet_name="昌西一风电场-甘肃-大唐")
  7. df.replace(np.nan, 'null', inplace=True)
  8. for cn, en, sec, min in zip(df['中文名'], df['英文名'], df['秒级映射'], df['分钟级映射']):
  9. print(f"\t#{cn}\n\t{en}: {min}")