[Battery Test] Processing OCV(1) - Data 불러오기

2021. 1. 18. 20:42[Battery is my Life]

[Download Data]

http://mocha-java.uccs.edu/BMS2/

  • Chapter 2 : ESC Model Toolbox 클릭!

Data contains :

['Data_Point', 'Test_Time(s)', 'Date_Time', 'Step_Time(s)', 'Step_Index', 'Cycle_Index', 'Current(A)', 'Voltage(V)', 'Charge_Capacity(Ah)', 'Discharge_Capacity(Ah)', 'Charge_Energy(Wh)', 'Discharge_Energy(Wh)', 'dV/dt(V/s)', 'Internal_Resistance(Ohm)', 'Is_FC_Data', 'AC_Impedance(Ohm)', 'ACI_Phase_Angle(Deg)']

[Import data]

import pandas as pd 
import seaborn as sns
import numpy as np
import matplotlib.pyplot as plt

def reading(value) :
  df = pd.read_excel("/content/A123_OCV_N05_"+value+".xlsx",sheet_name='Channel_1-005')
  new_list = []
  for i in np.arange(start=0, stop=9466, step=10) :
    new_list.append(i)
  df1 = df.iloc[new_list]
  return df1
df1 = reading('S1')
df2 = reading('S2')
df3 = reading('S3')
df4 = reading('S4')

[Readme]

  • 데이터 양이 많다보니 index가 10의 배수인 데이터만 추출 (그래도 상당하더라..)

dataset

  • S1 : discharge
  • S2 : soak down to 0 SOC (at 25 ˚C)
  • S3 : charge
  • S4 : soak up to 100 SOC(at 25˚C)

[Visualization]

[time v.s. voltage]

S1, S2, S3, S4


[time v.s. current]

S1, S2, S3, S4


[Summary]

  • S2 와 S4 단계에서 fluctuation이 꽤 있다
728x90