In [3]:

    

import numpy as np
import matplotlib.pyplot as plt
import xlrd as xlrd
import datetime as dt
import pandas as pd


    

In [4]:

    

book = xlrd.open_workbook("data.xlsx")
sh = book.sheet_by_index(0)
sh21= book.sheet_by_index(1)


    

In [28]:

    

ca1 = sh.cell_value(1,0)
i=1
j=0
a1_time=[]
a1_value=[]
df = pd.DataFrame(columns=['value','time'])
while sh.cell_value(i,0)==ca1:
    a1_time.append(dt.datetime(*xlrd.xldate_as_tuple(sh.cell_value(i,1), book.datemode)))
    a1_value.append(sh.cell_value(i,2))
    i+=1
    df = df.append(pd.Series([a1_value[j],a1_time[j]], index=['value','time']), ignore_index=True)
    #print(a1_value[j])
    j+=1
#print(df)


    

In [27]:

    

ca12 = sh.cell_value(i,0)
a2_time=[]
a2_value=[]
while sh.cell_value(i,0)==ca12:
    a2_time.append(dt.datetime(*xlrd.xldate_as_tuple(sh.cell_value(i,1), book.datemode)))
    a2_value.append(sh.cell_value(i,2))
    i+=1


    

In [25]:

    

i+=1
ca13 = sh.cell_value(i,0)
a3_time=[]
a3_value=[]
while  i<sh.nrows-1 and sh.cell_value(i,0)==ca13:
    a3_time.append(dt.datetime(*xlrd.xldate_as_tuple(sh.cell_value(i,1), book.datemode)).timestamp())
    a3_value.append(sh.cell_value(i,2))
    i+=1


    

In [33]:

    

plt.plot(df)
#print(df)
plt.show()


    

In [ ]: