uniqueI3.py 1.2 KB

123456789101112131415161718192021222324252627
  1. from LIB.BACKEND import DBManager
  2. from LIB.MIDDLE.CellStateEstimation.Common import log
  3. import datetime
  4. import pandas as pd
  5. import numpy as np
  6. import os
  7. from DataPreProcess import DataPreProcess
  8. dbManager = DBManager.DBManager()
  9. #basePath = r'C:\Users\zhuxi\My_VSCode\B 电池低温充电失败次数概率排名\result'
  10. fileNames = os.listdir('result') #获取文件夹中所有文件的名称
  11. data_GMGC=pd.DataFrame()
  12. for k in range(10):
  13. data_merge = pd.read_csv('result'+'\\'+fileNames[0])
  14. df_sheetCat=DataPreProcess.data_split_by_status(DataPreProcess,data_merge, drive_interval_threshold=120, charge_interval_threshold=300, drive_stand_threshold=120, charge_stand_threshold=300)
  15. data_charge=df_sheetCat[df_sheetCat['data_status']=='charge']
  16. unique_status_idx=np.unique(data_charge.data_split_by_status.values)
  17. data_I3=pd.DataFrame()
  18. for n in unique_status_idx:
  19. df_charge_buff=data_charge[data_charge.data_split_by_status==n]
  20. list_I=df_charge_buff.loc[2:6,'总电流[A]'].values.tolist()
  21. if((3 in list_I) and (df_charge_buff['总电流[A]'].value_counts()['3']>3)):
  22. data_I3=data_I3.append(df_charge_buff)
  23. data_GMGC=data_GMGC.append(data_I3)
  24. data_GMGC.to_csv('test7.csv')