{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Diarie Linköpings kommun\n",
"* Denna [Jupyter Notebook](https://github.com/salgo60/open-data-examples/blob/master/Diarie%20Link%C3%B6pings%20kommun.ipynb)\n",
"\n",
"* om [ärenden Linköping](https://www.linkoping.se/open/data/arende/)\n",
"\n",
"OBS unik nyckel måste begäras se [open](https://www.linkoping.se/open/)\n",
"\n",
"GITHUB [open-data-examples](https://github.com/salgo60/open-data-examples) \n"
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"'http://arendedata.linkoping.se/api/v1/Cases?maxItemsInResult=1000&api_key=e4628c0b272a454f855ec3784b7b61a0'"
]
},
"execution_count": 1,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"from IPython.display import JSON\n",
"import requests\n",
"import json\n",
"key = \"e4628c0b272a454f855ec3784b7b61a0\"\n",
"baseUrl = \"http://arendedata.linkoping.se/api/v1/\"\n",
"endpoint = \"Cases?maxItemsInResult=1000&api_key=\"\n",
"headers = {'content-type': 'application/json'}\n",
"url = baseUrl + endpoint + key\n",
"url\n"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"<Response [200]>"
]
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"req = requests.get(url,headers=headers)\n",
"data = json.loads(req.text)\n",
"import pandas as pd\n",
"df = pd.DataFrame(data)\n",
"df.head(n=40) \n",
"req"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [],
"source": [
"import matplotlib.pyplot as plt\n",
"%matplotlib inline \n"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {
"scrolled": true
},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"<class 'pandas.core.frame.DataFrame'>\n",
"RangeIndex: 1000 entries, 0 to 999\n",
"Data columns (total 6 columns):\n",
" # Column Non-Null Count Dtype \n",
"--- ------ -------------- ----- \n",
" 0 caseNumber 1000 non-null object\n",
" 1 subject 1000 non-null object\n",
" 2 registeredDate 1000 non-null object\n",
" 3 closedDate 109 non-null object\n",
" 4 diary 1000 non-null object\n",
" 5 hasEvents 1000 non-null bool \n",
"dtypes: bool(1), object(5)\n",
"memory usage: 40.2+ KB\n"
]
}
],
"source": [
"df.info()"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>caseNumber</th>\n",
" <th>subject</th>\n",
" <th>registeredDate</th>\n",
" <th>closedDate</th>\n",
" <th>diary</th>\n",
" <th>hasEvents</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>SON 2021-779</td>\n",
" <td>Statlig ersättning för försörjningsstöd för en...</td>\n",
" <td>2021-06-24T14:05:00</td>\n",
" <td>None</td>\n",
" <td>SON 2021</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>KOF 2021-160</td>\n",
" <td>Friidrottshallen från och med 2021</td>\n",
" <td>2021-06-24T14:02:00</td>\n",
" <td>None</td>\n",
" <td>KOF 2021</td>\n",
" <td>False</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>SON 2021-778</td>\n",
" <td>Sätt stopp för bidragsfusk i välfärd svar på m...</td>\n",
" <td>2021-06-24T13:49:00</td>\n",
" <td>None</td>\n",
" <td>SON 2021</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>SON 2021-777</td>\n",
" <td>Stoppa dem som skor sig på vård välfärd svar p...</td>\n",
" <td>2021-06-24T13:43:00</td>\n",
" <td>None</td>\n",
" <td>SON 2021</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>BOU 2021-591</td>\n",
" <td>--- Sekretess ---</td>\n",
" <td>2021-06-24T13:34:32.083</td>\n",
" <td>None</td>\n",
" <td>BOU 2021</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>BOU 2021-590</td>\n",
" <td>--- Sekretess ---</td>\n",
" <td>2021-06-24T13:26:35.47</td>\n",
" <td>None</td>\n",
" <td>BOU 2021</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>BIN 2021-450</td>\n",
" <td>--- Sekretess ---</td>\n",
" <td>2021-06-24T13:14:29.53</td>\n",
" <td>None</td>\n",
" <td>BIN 2021</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>BIN 2021-449</td>\n",
" <td>--- Sekretess ---</td>\n",
" <td>2021-06-24T13:11:58.07</td>\n",
" <td>None</td>\n",
" <td>BIN 2021</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>KS 2021-560</td>\n",
" <td>Förslag till lokal utvecklingsstrategi</td>\n",
" <td>2021-06-24T12:52:00</td>\n",
" <td>None</td>\n",
" <td>KS 2021</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>BIN 2021-448</td>\n",
" <td>--- Sekretess ---</td>\n",
" <td>2021-06-24T12:14:19.57</td>\n",
" <td>None</td>\n",
" <td>BIN 2021</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>BMN 2021-79</td>\n",
" <td>Remiss: Förslag till föreskrifter om bekämpnin...</td>\n",
" <td>2021-06-24T11:33:19.37</td>\n",
" <td>None</td>\n",
" <td>BMN 2021</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>SON 2021-776</td>\n",
" <td>Upphandling av bankkort</td>\n",
" <td>2021-06-24T11:27:00</td>\n",
" <td>None</td>\n",
" <td>SON 2021</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>VN 2021-41</td>\n",
" <td>Jämställdhetsbokslut för 2019 och 2020</td>\n",
" <td>2021-06-24T10:51:00</td>\n",
" <td>None</td>\n",
" <td>VN 2021</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>VN 2021-42</td>\n",
" <td>Uppföljningen av måluppfyllelse för 2018 för m...</td>\n",
" <td>2021-06-24T10:51:00</td>\n",
" <td>None</td>\n",
" <td>VN 2021</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>VN 2021-40</td>\n",
" <td>Barnbokslut 2019 och 2020</td>\n",
" <td>2021-06-24T10:50:00</td>\n",
" <td>None</td>\n",
" <td>VN 2021</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>VN 2021-39</td>\n",
" <td>Energi- och klimatbokslut verksamhetsåret 2019</td>\n",
" <td>2021-06-24T10:48:00</td>\n",
" <td>None</td>\n",
" <td>VN 2021</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>VN 2021-38</td>\n",
" <td>Riktlinje för IT-styrning</td>\n",
" <td>2021-06-24T10:46:00</td>\n",
" <td>None</td>\n",
" <td>VN 2021</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>VN 2021-37</td>\n",
" <td>Reklam inför valet</td>\n",
" <td>2021-06-24T10:44:00</td>\n",
" <td>None</td>\n",
" <td>VN 2021</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>SON 2021-775</td>\n",
" <td>Avropsavtal för handledningstjänster IFO BoU u...</td>\n",
" <td>2021-06-24T10:03:00</td>\n",
" <td>None</td>\n",
" <td>SON 2021</td>\n",
" <td>True</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>SBN 2021-661</td>\n",
" <td>Kontrakt Hanorpsvägen</td>\n",
" <td>2021-06-24T09:21:00</td>\n",
" <td>None</td>\n",
" <td>SBN 2021</td>\n",
" <td>True</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" caseNumber subject \\\n",
"0 SON 2021-779 Statlig ersättning för försörjningsstöd för en... \n",
"1 KOF 2021-160 Friidrottshallen från och med 2021 \n",
"2 SON 2021-778 Sätt stopp för bidragsfusk i välfärd svar på m... \n",
"3 SON 2021-777 Stoppa dem som skor sig på vård välfärd svar p... \n",
"4 BOU 2021-591 --- Sekretess --- \n",
"5 BOU 2021-590 --- Sekretess --- \n",
"6 BIN 2021-450 --- Sekretess --- \n",
"7 BIN 2021-449 --- Sekretess --- \n",
"8 KS 2021-560 Förslag till lokal utvecklingsstrategi \n",
"9 BIN 2021-448 --- Sekretess --- \n",
"10 BMN 2021-79 Remiss: Förslag till föreskrifter om bekämpnin... \n",
"11 SON 2021-776 Upphandling av bankkort \n",
"12 VN 2021-41 Jämställdhetsbokslut för 2019 och 2020 \n",
"13 VN 2021-42 Uppföljningen av måluppfyllelse för 2018 för m... \n",
"14 VN 2021-40 Barnbokslut 2019 och 2020 \n",
"15 VN 2021-39 Energi- och klimatbokslut verksamhetsåret 2019 \n",
"16 VN 2021-38 Riktlinje för IT-styrning \n",
"17 VN 2021-37 Reklam inför valet \n",
"18 SON 2021-775 Avropsavtal för handledningstjänster IFO BoU u... \n",
"19 SBN 2021-661 Kontrakt Hanorpsvägen \n",
"\n",
" registeredDate closedDate diary hasEvents \n",
"0 2021-06-24T14:05:00 None SON 2021 True \n",
"1 2021-06-24T14:02:00 None KOF 2021 False \n",
"2 2021-06-24T13:49:00 None SON 2021 True \n",
"3 2021-06-24T13:43:00 None SON 2021 True \n",
"4 2021-06-24T13:34:32.083 None BOU 2021 True \n",
"5 2021-06-24T13:26:35.47 None BOU 2021 True \n",
"6 2021-06-24T13:14:29.53 None BIN 2021 True \n",
"7 2021-06-24T13:11:58.07 None BIN 2021 True \n",
"8 2021-06-24T12:52:00 None KS 2021 True \n",
"9 2021-06-24T12:14:19.57 None BIN 2021 True \n",
"10 2021-06-24T11:33:19.37 None BMN 2021 True \n",
"11 2021-06-24T11:27:00 None SON 2021 True \n",
"12 2021-06-24T10:51:00 None VN 2021 True \n",
"13 2021-06-24T10:51:00 None VN 2021 True \n",
"14 2021-06-24T10:50:00 None VN 2021 True \n",
"15 2021-06-24T10:48:00 None VN 2021 True \n",
"16 2021-06-24T10:46:00 None VN 2021 True \n",
"17 2021-06-24T10:44:00 None VN 2021 True \n",
"18 2021-06-24T10:03:00 None SON 2021 True \n",
"19 2021-06-24T09:21:00 None SBN 2021 True "
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.head(20)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Ärenden"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>eventNumber</th>\n",
" <th>eventName</th>\n",
" <th>direction</th>\n",
" <th>date</th>\n",
" <th>eventType</th>\n",
" <th>senderOrReceiver</th>\n",
" <th>case</th>\n",
" <th>caseNumber</th>\n",
" <th>diary</th>\n",
" <th>diaryId</th>\n",
" <th>documentNumber</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>SON 2020-593: 6</td>\n",
" <td>Hemlöshetsundersökning i Linköpings kommun 2020</td>\n",
" <td>In</td>\n",
" <td>2021-06-24T15:32:19.11</td>\n",
" <td>Skrivelse</td>\n",
" <td>None</td>\n",
" <td>Hemlöshet i Linköpings kommun</td>\n",
" <td>SON 2020-593</td>\n",
" <td>Social- och omsorgsnämnden</td>\n",
" <td>215</td>\n",
" <td>6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>SON 2021-776: 1</td>\n",
" <td>Avbrytande beslut</td>\n",
" <td>In</td>\n",
" <td>2021-06-24T15:25:07.83</td>\n",
" <td>Beslut</td>\n",
" <td>{'name': '', 'organization': None}</td>\n",
" <td>Upphandling av bankkort</td>\n",
" <td>SON 2021-776</td>\n",
" <td>Social- och omsorgsnämnden</td>\n",
" <td>215</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>KOF 2019-14: 22</td>\n",
" <td>Avtal Linköpings Sporthall - TG 1</td>\n",
" <td>Upp</td>\n",
" <td>2021-06-24T15:24:53.303</td>\n",
" <td>Avtal</td>\n",
" <td>{'name': '', 'organization': None}</td>\n",
" <td>Upphandling drift och skötsel - Linköpings Spo...</td>\n",
" <td>KOF 2019-14</td>\n",
" <td>Kultur- och fritidsnämnden</td>\n",
" <td>49</td>\n",
" <td>22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>SON 2020-1206: 8</td>\n",
" <td>SBN § 116 Policy för ett ökat träbyggande i Li...</td>\n",
" <td>In</td>\n",
" <td>2021-06-24T15:23:45.747</td>\n",
" <td>Beslut</td>\n",
" <td>{'name': '', 'organization': None}</td>\n",
" <td>Handlingar för kännedom</td>\n",
" <td>SON 2020-1206</td>\n",
" <td>Social- och omsorgsnämnden</td>\n",
" <td>215</td>\n",
" <td>8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>SBN 2021-10: 188</td>\n",
" <td>Grannehörande - Idrottsgrenen 2 (Drabantgatan 37)</td>\n",
" <td>Ut</td>\n",
" <td>2021-06-24T15:22:48.243</td>\n",
" <td>Yttrande</td>\n",
" <td>{'name': '', 'organization': 'mos/mex'}</td>\n",
" <td>Remiss grannehörande - Grannemedgivande bygglov</td>\n",
" <td>SBN 2021-10</td>\n",
" <td>Samhällsbyggnadsnämnden</td>\n",
" <td>118</td>\n",
" <td>188</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>KOF 2021-58: 7</td>\n",
" <td>Granskning och samråd aktiviteter Handlingspla...</td>\n",
" <td>In</td>\n",
" <td>2021-06-24T15:22:31.497</td>\n",
" <td>Skrivelse</td>\n",
" <td>{'name': '', 'organization': None}</td>\n",
" <td>Handlingsplan för Linköpings kommuns kulturpol...</td>\n",
" <td>KOF 2021-58</td>\n",
" <td>Kultur- och fritidsnämnden</td>\n",
" <td>49</td>\n",
" <td>7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>SON 2020-1206: 7</td>\n",
" <td>Kf § 276 Stoppa dem som skor sig på vår välfärd</td>\n",
" <td>In</td>\n",
" <td>2021-06-24T15:22:15.537</td>\n",
" <td>Beslut</td>\n",
" <td>{'name': '', 'organization': None}</td>\n",
" <td>Handlingar för kännedom</td>\n",
" <td>SON 2020-1206</td>\n",
" <td>Social- och omsorgsnämnden</td>\n",
" <td>215</td>\n",
" <td>7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>SON 2021-777: 1</td>\n",
" <td>Kf § 276 Stoppa dem som skor sig på vår välfärd</td>\n",
" <td>In</td>\n",
" <td>2021-06-24T15:21:25.133</td>\n",
" <td>Beslut</td>\n",
" <td>{'name': '', 'organization': None}</td>\n",
" <td>Stoppa dem som skor sig på vård välfärd svar p...</td>\n",
" <td>SON 2021-777</td>\n",
" <td>Social- och omsorgsnämnden</td>\n",
" <td>215</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>SBN 2021-10: 187</td>\n",
" <td>Grannehörande - Glasfatet 3 (Roxtorpsgatan 14)</td>\n",
" <td>Ut</td>\n",
" <td>2021-06-24T15:21:20.017</td>\n",
" <td>Yttrande</td>\n",
" <td>{'name': '', 'organization': 'mos/mex'}</td>\n",
" <td>Remiss grannehörande - Grannemedgivande bygglov</td>\n",
" <td>SBN 2021-10</td>\n",
" <td>Samhällsbyggnadsnämnden</td>\n",
" <td>118</td>\n",
" <td>187</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>SON 2020-1206: 6</td>\n",
" <td>Kf § 275 Sätt stopp för bidragsfusk i välfärde...</td>\n",
" <td>In</td>\n",
" <td>2021-06-24T15:19:44.73</td>\n",
" <td>None</td>\n",
" <td>{'name': '', 'organization': None}</td>\n",
" <td>Handlingar för kännedom</td>\n",
" <td>SON 2020-1206</td>\n",
" <td>Social- och omsorgsnämnden</td>\n",
" <td>215</td>\n",
" <td>6</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" eventNumber eventName \\\n",
"0 SON 2020-593: 6 Hemlöshetsundersökning i Linköpings kommun 2020 \n",
"1 SON 2021-776: 1 Avbrytande beslut \n",
"2 KOF 2019-14: 22 Avtal Linköpings Sporthall - TG 1 \n",
"3 SON 2020-1206: 8 SBN § 116 Policy för ett ökat träbyggande i Li... \n",
"4 SBN 2021-10: 188 Grannehörande - Idrottsgrenen 2 (Drabantgatan 37) \n",
"5 KOF 2021-58: 7 Granskning och samråd aktiviteter Handlingspla... \n",
"6 SON 2020-1206: 7 Kf § 276 Stoppa dem som skor sig på vår välfärd \n",
"7 SON 2021-777: 1 Kf § 276 Stoppa dem som skor sig på vår välfärd \n",
"8 SBN 2021-10: 187 Grannehörande - Glasfatet 3 (Roxtorpsgatan 14) \n",
"9 SON 2020-1206: 6 Kf § 275 Sätt stopp för bidragsfusk i välfärde... \n",
"\n",
" direction date eventType \\\n",
"0 In 2021-06-24T15:32:19.11 Skrivelse \n",
"1 In 2021-06-24T15:25:07.83 Beslut \n",
"2 Upp 2021-06-24T15:24:53.303 Avtal \n",
"3 In 2021-06-24T15:23:45.747 Beslut \n",
"4 Ut 2021-06-24T15:22:48.243 Yttrande \n",
"5 In 2021-06-24T15:22:31.497 Skrivelse \n",
"6 In 2021-06-24T15:22:15.537 Beslut \n",
"7 In 2021-06-24T15:21:25.133 Beslut \n",
"8 Ut 2021-06-24T15:21:20.017 Yttrande \n",
"9 In 2021-06-24T15:19:44.73 None \n",
"\n",
" senderOrReceiver \\\n",
"0 None \n",
"1 {'name': '', 'organization': None} \n",
"2 {'name': '', 'organization': None} \n",
"3 {'name': '', 'organization': None} \n",
"4 {'name': '', 'organization': 'mos/mex'} \n",
"5 {'name': '', 'organization': None} \n",
"6 {'name': '', 'organization': None} \n",
"7 {'name': '', 'organization': None} \n",
"8 {'name': '', 'organization': 'mos/mex'} \n",
"9 {'name': '', 'organization': None} \n",
"\n",
" case caseNumber \\\n",
"0 Hemlöshet i Linköpings kommun SON 2020-593 \n",
"1 Upphandling av bankkort SON 2021-776 \n",
"2 Upphandling drift och skötsel - Linköpings Spo... KOF 2019-14 \n",
"3 Handlingar för kännedom SON 2020-1206 \n",
"4 Remiss grannehörande - Grannemedgivande bygglov SBN 2021-10 \n",
"5 Handlingsplan för Linköpings kommuns kulturpol... KOF 2021-58 \n",
"6 Handlingar för kännedom SON 2020-1206 \n",
"7 Stoppa dem som skor sig på vård välfärd svar p... SON 2021-777 \n",
"8 Remiss grannehörande - Grannemedgivande bygglov SBN 2021-10 \n",
"9 Handlingar för kännedom SON 2020-1206 \n",
"\n",
" diary diaryId documentNumber \n",
"0 Social- och omsorgsnämnden 215 6 \n",
"1 Social- och omsorgsnämnden 215 1 \n",
"2 Kultur- och fritidsnämnden 49 22 \n",
"3 Social- och omsorgsnämnden 215 8 \n",
"4 Samhällsbyggnadsnämnden 118 188 \n",
"5 Kultur- och fritidsnämnden 49 7 \n",
"6 Social- och omsorgsnämnden 215 7 \n",
"7 Social- och omsorgsnämnden 215 1 \n",
"8 Samhällsbyggnadsnämnden 118 187 \n",
"9 Social- och omsorgsnämnden 215 6 "
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"endpointEvent = \"Events?maxItemsInResult=1000&api_key=f3d212d2700f4c80aba7d2a88bc94529\"\n",
"urlEvent = baseUrl + endpointEvent \n",
"dataEvent = json.loads(requests.get(urlEvent).text)\n",
"import pandas as pd\n",
"dfEvent = pd.DataFrame(dataEvent)\n",
"dfEvent.head(n=10)"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"Barn- och ungdomsnämnden 213\n",
"Social- och omsorgsnämnden 177\n",
"Äldrenämnden 145\n",
"Samhällsbyggnadsnämnden 135\n",
"Kommunstyrelsen 127\n",
"Bildningsnämnden 84\n",
"Kultur- och fritidsnämnden 44\n",
"Arbetsmarknadsnämnden 38\n",
"Överförmyndarnämnden 19\n",
"Valnämnden 14\n",
"Bygg- och Miljönämnden 4\n",
"Name: diary, dtype: int64"
]
},
"execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pd.set_option('display.max_rows', None) \n",
"dfEvent[\"diary\"].value_counts()"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.9.4"
}
},
"nbformat": 4,
"nbformat_minor": 4
}