Weather API connect

In [60]:
import urllib.request
import pandas as pd
import numpy as np
import requests
from urllib.request import Request, urlopen
from import json_normalize

loc = "London,uk"
weatherurl ='' + loc + '?id=524901&APPID=b058d678cdbcdfdadaa17156d4a9a5fd'
data= requests.get(weatherurl)

objects = (loc, 'Max')
y_pos = np.arange(len(objects))
performance = [temp, 1], performance, align='center', alpha=0.5)
plt.xticks(y_pos, objects)
plt.title('Temp in '+loc)

In [ ]:
# For the future more sophisiticated transformations - to DataFrame
#import json
# Finish request

#pd.read_json(data.json(),orient='records', typ="series" )

Write diary to spreadsheet

via google API

  1. Define date (default=today)
  2. Define topic oAuth
  3. Append via API