In [2]:

    

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


    

In [3]:

    

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


    

In [22]:

    

ca1 = sh.cell_value(1,0)
i=1
a1_time=[]
a1_value=[]
while sh.cell_value(i,0)==ca1:
    a1_time.append(dt.datetime(*xlrd.xldate_as_tuple(sh.cell_value(i,1), book.datemode)).timestamp())
    a1_value.append(sh.cell_value(i,2))
    i+=1


    

In [23]:

    

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)).timestamp())
    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 [29]:

    

plt.subplot(3,1,1)
plt.plot(a1_time,a1_value)
plt.title(ca1)
plt.subplot(3,1,2)
plt.plot(a2_time,a2_value)
plt.title(ca12)
plt.subplot(3,1,3)
plt.plot(a3_time,a3_value)
plt.title(ca13)
plt.show()


    

In [ ]: