123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081 |
- import CBMSBatUniform
- import log
- import os
- import sys
- import datetime
- import pandas as pd
- from LIB.BACKEND import DBManager, Log
- from sqlalchemy import create_engine
- from sqlalchemy.orm import sessionmaker
- import time, datetime
- from urllib import parse
- from LIB.MIDDLE.CellStateEstimation.Common import DBDownload
- dbManager = DBManager.DBManager()
- if __name__ == "__main__":
- excelpath=r'D:\Platform\platform_python\data_analyze_platform\USER\01qixiang\sn-20210903.xlsx'
- SNdata_6060 = pd.read_excel(excelpath, sheet_name='科易6060')
- SNdata_6040 = pd.read_excel(excelpath, sheet_name='科易6040')
- SNdata_4840 = pd.read_excel(excelpath, sheet_name='科易4840')
- SNdata_L7255 = pd.read_excel(excelpath, sheet_name='格林美-力信7255')
- SNdata_C7255 = pd.read_excel(excelpath, sheet_name='格林美-CATL7255')
- SNdata_U7255 = pd.read_excel(excelpath, sheet_name='优旦7255')
- SNnums_6060=SNdata_6060['SN号'].tolist()
- SNnums_6040=SNdata_6040['SN号'].tolist()
- SNnums_4840=SNdata_4840['SN号'].tolist()
- SNnums_L7255=SNdata_L7255['SN号'].tolist()
- SNnums_C7255=SNdata_C7255['SN号'].tolist()
- SNnums_U7255=SNdata_U7255['SN号'].tolist()
- SNnums= SNnums_6060 + SNnums_L7255 + SNnums_C7255 + SNnums_6040 + SNnums_4840 + SNnums_U7255
- now_time=datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S')
- now_time=datetime.datetime.strptime(now_time,'%Y-%m-%d %H:%M:%S')
- start_time=now_time-datetime.timedelta(days=20)
- end_time=str(now_time)
- start_time=str(start_time)
-
- mylog=log.Mylog('log.txt','error')
- mylog.logcfg()
- for sn in SNnums:
- try:
- if 'PK500' in sn:
- celltype=1
- elif 'PK502' in sn:
- celltype=2
- elif 'K504B' in sn:
- celltype=99
- elif 'MGMLXN750' in sn:
- celltype=3
- elif 'MGMCLN750' or 'UD' in sn:
- celltype=4
- else:
- print('SN:{},未找到对应电池类型!!!'.format(sn))
- continue
-
-
-
-
-
-
-
-
- dbManager = DBManager.DBManager()
- df_data = dbManager.get_data(sn=sn, start_time=start_time, end_time=end_time, data_groups=['bms'])
- df_bms = df_data['bms']
-
-
- BatUniform=CBMSBatUniform.BatUniform(sn,celltype,df_bms)
- df_res=BatUniform.batuniform()
- df_res.to_csv(r'D:\Platform\platform_python\data_analyze_platform\USER\01qixiang\99Result\\'+'CBMS_Uniform'+sn+'_3.csv',encoding='GB18030')
-
-
- except IndexError as e:
- print(repr(e))
- mylog.logopt(sn,e)
- pass
|