123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141 |
- import pandas as pd
- from matplotlib import pyplot as plt
- from matplotlib.pyplot import MultipleLocator
- import os
- import numpy as np
- from LIB.BACKEND import DBManager
- import pymysql
- import datetime
- filepath=r'D:\01WorkSpace\python\data_analyze_platform\USER\SPF\alibaba\99Result'
- files=os.listdir(filepath)
- for filename in files:
- if '内短路' in filename:
- vin=filename[:-4]
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- df_short= pd.read_excel(filepath+'\\'+filename)
- cellnums=len(eval(df_short.loc[0,'short_current']))
- cellvolt_name=['单体'+str(x) for x in range(1,cellnums+1)]
- plt.figure(figsize=(20,9))
- for i in range(len(df_short)):
- x=list(range(1,cellnums+1))
- y=eval(df_short.loc[i,'short_current'])
- y1=[-30]*cellnums
- plt.plot(x, y,marker='*',markersize=15)
- plt.plot(x, y1,color='r')
- plt.title(filename[0:17],fontsize=24)
- plt.xlabel('电芯序号', fontsize=20)
- plt.ylabel('内短路电流', fontsize=20)
- plt.xticks(fontsize=22)
- plt.yticks(fontsize=22)
-
- plt.ylim(-35,35)
-
- plt.legend(bbox_to_anchor=(1, 0), loc=3, borderaxespad=0)
- plt.rcParams['font.sans-serif']=['SimHei']
- plt.rcParams['axes.unicode_minus']=False
- plt.savefig(filepath+'\\'+vin+".png")
- plt.show()
- plt.close()
|