Last update: 19.05.2019 16:14:33 # Sample code generated by DasData www.DasData.co import requests import pandas as pd import matplotlib.pyplot as plt plt.style.use('seaborn-whitegrid') import numpy as np %matplotlib inline data_url = 'https://DasData.co/e.aspx?das=l8xjg18bpAO8exltb3CjqUuLsZq9OJ/8rTuMIv6KnhKq73PGywtVdtezj/GwzXM+vzom+f+tl2mazFEr3/qoBA==&from=0&to=500&json=1' response = requests.get(data_url, data={"limit" : "500"}) if response.status_code == 200: df = pd.DataFrame.from_records(response.json()) print(df) #==================================================================== df[['id','AIDate','SoilHumidity','RoomTemp','RoomHumid','AirQVal','AirAlarm','RoomLight','UltraViolet' ]] = df['Table'].apply(pd.Series) #==================================================================== df["AIDate"] = pd.to_datetime(df["AIDate"]) df.set_index('AIDate', inplace=True) df.head() SoilHumidity=df[['SoilHumidity']] RoomTemp=df[['RoomTemp']] RoomHumid=df[['RoomHumid']] AirQVal=df[['AirQVal']] AirAlarm=df[['AirAlarm']] RoomLight=df[['RoomLight']] UltraViolet=df[['UltraViolet']] #==================================================================== df_rm = pd.concat([SoilHumidity.rolling(12).mean(),RoomTemp.rolling(12).mean(),RoomHumid.rolling(12).mean(),AirQVal.rolling(12).mean(),AirAlarm.rolling(12).mean(),RoomLight.rolling(12).mean(),UltraViolet.rolling(12).mean()], axis=1) #==================================================================== df_rm.plot(figsize=(20,10), linewidth=2, fontsize=15) x = np.linspace(0, 10, 50) plt.xlabel('AIDate', fontsize=12);