cedian-extract_分钟.py 1.2 KB

123456789101112131415161718192021222324252627282930313233
  1. import os
  2. import pandas as pd
  3. def add_minute_table(df):
  4. del df['历史采样表名']
  5. del df['历史采样域名']
  6. min_table_path = r'C:\Users\wzl\Desktop\中广核104测点\分钟级表-字段.csv'
  7. min_df = pd.read_csv(min_table_path, encoding='gbk', usecols=['遥测ID', '历史采样表名', '历史采样域名'])
  8. min_df['遥测ID'] = min_df['遥测ID'].apply(lambda x: x.replace('遥测定义表 ', '').replace('遥测值', '').strip())
  9. min_df.rename(columns={'遥测ID': '遥测名称'}, inplace=True)
  10. df = df.merge(min_df, on='遥测名称', how='left')
  11. return df
  12. if __name__ == '__main__':
  13. read_file = r'C:\Users\wzl\Desktop\中广核104测点\0416部署需要\最终测点配置.xlsx'
  14. df = pd.read_excel(read_file)
  15. # df = add_minute_table(df)
  16. # df.to_excel('最终测点配置.xlsx', index=False)
  17. wind_names = df['场站'].unique()
  18. for wind_name in wind_names:
  19. now_df = df[df['场站'] == wind_name]
  20. port = now_df['端口'].unique()[0]
  21. os.makedirs(str(port), exist_ok=True)
  22. now_df.sort_values(by=['风机号', '测点'], inplace=True)
  23. now_df.to_csv(os.path.join(str(port), wind_name + '.csv'))