#!/usr/bin/env python
# coding: utf-8

# ## Diarie Linköpings kommun
# * Denna [Jupyter Notebook](https://github.com/salgo60/open-data-examples/blob/master/Diarie%20Link%C3%B6pings%20kommun.ipynb)
# 
# * om [ärenden Linköping](https://www.linkoping.se/open/data/arende/)
# 
# OBS unik nyckel måste begäras se [open](https://www.linkoping.se/open/)
# 
# GITHUB [open-data-examples](https://github.com/salgo60/open-data-examples)   
# 

# In[1]:


from IPython.display  import JSON
import requests
import json
key = "e4628c0b272a454f855ec3784b7b61a0"
baseUrl = "http://arendedata.linkoping.se/api/v1/"
endpoint = "Cases?maxItemsInResult=1000&api_key="
headers = {'content-type': 'application/json'}
url = baseUrl + endpoint + key
url


# In[2]:


req = requests.get(url,headers=headers)
data = json.loads(req.text)
import pandas as pd
df = pd.DataFrame(data)
df.head(n=40) 
req


# In[3]:


import matplotlib.pyplot as plt
get_ipython().run_line_magic('matplotlib', 'inline')


# In[5]:


df.info()


# In[9]:


df.head(20)


# ### Ärenden

# In[12]:


endpointEvent = "Events?maxItemsInResult=1000&api_key=f3d212d2700f4c80aba7d2a88bc94529"
urlEvent = baseUrl + endpointEvent 
dataEvent = json.loads(requests.get(urlEvent).text)
import pandas as pd
dfEvent = pd.DataFrame(dataEvent)
dfEvent.head(n=10)


# In[13]:


pd.set_option('display.max_rows', None) 
dfEvent["diary"].value_counts()


# In[ ]: