In [ ]:

    

%matplotlib inline
import pandas as pd
from pyot.models import *


    

In [ ]:

    

from datetime import timedelta, datetime
#TFMT = "%Y-%m-%d %H:%M:%S"
TFMT = "%H:%M"
lSens = Resource.objects.filter(title='Light')
d = {}

for l in lSens:
    lightSeries = CoapMsg.objects.filter(resource=l, timeadded__gt=datetime.now() - timedelta(hours=6))

    values = []
    indexes = []
    for i in lightSeries:
        try:
            values.append(int(i.payload))
        except:
            values.append(int(i.payload.split(';')[0]))
        indexes.append(i.timeadded.strftime(TFMT))
    
    d[str(l.host.ip6address)[-5:]] = pd.Series(values, indexes).groupby(level=0).last()
#print d
df = pd.DataFrame(d)
df.plot()