id

281900

Untitled

Untitled

import pandas as pd
all_data = pd.read_csv("out.csv")
isPulse1 = all_data["typeM"]  == 'Pulse1'
pulse1_data = all_data[isPulse1]
pulse1_data= pulse1_data.sort_values('time')
s = pulse1_data[pulse1_data["ManagedObjectid"] == 281900]
s.head()
s = s[["time","Value"]]
s["time"] = pd.to_datetime(s["time"], infer_datetime_format=True)
s.set_index('time', inplace=True)
s.index = pd.to_datetime(s.index)
s = s.resample('1D').sum()
l30d = s[len(s)-31:]