Forsakringskassan.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Dataset Pågående sjukfall per diagnos, specifikt för stressrelaterade sjukdomar 2005–\n",
    "\n",
    "[Datamängd tillhandahållen av Försäkringskassan](https://oppnadata.se/datamangd/#esc_entry=4778&esc_context=547)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'https://catalog.forsakringskassan.se/rowstore/dataset/bc40aa99-d0a1-4ee0-853c-2d4306c7fad2'"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from IPython.display  import JSON\n",
    "import requests\n",
    "import json\n",
    "baseUrl = \"https://catalog.forsakringskassan.se/rowstore/dataset/\"\n",
    "endpoint = \"bc40aa99-d0a1-4ee0-853c-2d4306c7fad2\"\n",
    "headers = {'content-type': 'application/json'}\n",
    "url = baseUrl + endpoint\n",
    "url"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "list"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Call the API\n",
    "req = requests.get(url,headers=headers)\n",
    "data = json.loads(req.text)\n",
    "type(data['results'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "100"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(data['results'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from pandas.io.json import json_normalize\n",
    "\n",
    "df = json_normalize(data['results'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>andel_f43_kvinna</th>\n",
       "      <th>andel_f43_man</th>\n",
       "      <th>andel_f43_samtliga</th>\n",
       "      <th>antal_f43_kvinna</th>\n",
       "      <th>antal_f43_man</th>\n",
       "      <th>antal_f43_samtliga</th>\n",
       "      <th>ar</th>\n",
       "      <th>kommun_kod</th>\n",
       "      <th>kommun_text</th>\n",
       "      <th>kvartal</th>\n",
       "      <th>lan_kod</th>\n",
       "      <th>lan_text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>12.34952547</td>\n",
       "      <td>7.0528619141</td>\n",
       "      <td>10.432669665</td>\n",
       "      <td>18907</td>\n",
       "      <td>6124</td>\n",
       "      <td>25031</td>\n",
       "      <td>2005</td>\n",
       "      <td>0000</td>\n",
       "      <td>Samtliga kommuner</td>\n",
       "      <td>1</td>\n",
       "      <td>00</td>\n",
       "      <td>Riket</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>14.971428571</td>\n",
       "      <td>11.486486486</td>\n",
       "      <td>13.79833207</td>\n",
       "      <td>131</td>\n",
       "      <td>51</td>\n",
       "      <td>182</td>\n",
       "      <td>2005</td>\n",
       "      <td>0160</td>\n",
       "      <td>Täby</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>14.125200642</td>\n",
       "      <td>8.3582089552</td>\n",
       "      <td>12.108559499</td>\n",
       "      <td>88</td>\n",
       "      <td>28</td>\n",
       "      <td>116</td>\n",
       "      <td>2005</td>\n",
       "      <td>0114</td>\n",
       "      <td>Upplands-Väsby</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>9.8455598456</td>\n",
       "      <td>5.035971223</td>\n",
       "      <td>8.1658291457</td>\n",
       "      <td>51</td>\n",
       "      <td>14</td>\n",
       "      <td>65</td>\n",
       "      <td>2005</td>\n",
       "      <td>0115</td>\n",
       "      <td>Vallentuna</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>13.962720055</td>\n",
       "      <td>8.6455143658</td>\n",
       "      <td>12.121212121</td>\n",
       "      <td>4045</td>\n",
       "      <td>1327</td>\n",
       "      <td>5372</td>\n",
       "      <td>2005</td>\n",
       "      <td>0100</td>\n",
       "      <td>Samtliga kommuner</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>14.124293785</td>\n",
       "      <td>9.3841642229</td>\n",
       "      <td>12.583412774</td>\n",
       "      <td>100</td>\n",
       "      <td>32</td>\n",
       "      <td>132</td>\n",
       "      <td>2005</td>\n",
       "      <td>0138</td>\n",
       "      <td>Tyresö</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>17.578125</td>\n",
       "      <td>9.5744680851</td>\n",
       "      <td>14.947552448</td>\n",
       "      <td>135</td>\n",
       "      <td>36</td>\n",
       "      <td>171</td>\n",
       "      <td>2005</td>\n",
       "      <td>0163</td>\n",
       "      <td>Sollentuna</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>11.47260274</td>\n",
       "      <td>9.0634441088</td>\n",
       "      <td>10.601092896</td>\n",
       "      <td>67</td>\n",
       "      <td>30</td>\n",
       "      <td>97</td>\n",
       "      <td>2005</td>\n",
       "      <td>0117</td>\n",
       "      <td>Österåker</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>10.792951542</td>\n",
       "      <td>5.0251256281</td>\n",
       "      <td>9.0352220521</td>\n",
       "      <td>49</td>\n",
       "      <td>10</td>\n",
       "      <td>59</td>\n",
       "      <td>2005</td>\n",
       "      <td>0139</td>\n",
       "      <td>Upplands-Bro</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9.7276264591</td>\n",
       "      <td>6.25</td>\n",
       "      <td>8.4266926449</td>\n",
       "      <td>125</td>\n",
       "      <td>48</td>\n",
       "      <td>173</td>\n",
       "      <td>2005</td>\n",
       "      <td>0127</td>\n",
       "      <td>Botkyrka</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>15.28150134</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>57</td>\n",
       "      <td>2005</td>\n",
       "      <td>0128</td>\n",
       "      <td>Salem</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11.592076302</td>\n",
       "      <td>7.358738502</td>\n",
       "      <td>10.075329567</td>\n",
       "      <td>158</td>\n",
       "      <td>56</td>\n",
       "      <td>214</td>\n",
       "      <td>2005</td>\n",
       "      <td>0181</td>\n",
       "      <td>Södertälje</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>9.3808630394</td>\n",
       "      <td>7.662835249</td>\n",
       "      <td>8.8161209068</td>\n",
       "      <td>50</td>\n",
       "      <td>20</td>\n",
       "      <td>70</td>\n",
       "      <td>2005</td>\n",
       "      <td>0183</td>\n",
       "      <td>Sundbyberg</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13.735108619</td>\n",
       "      <td>8.2644628099</td>\n",
       "      <td>11.890385509</td>\n",
       "      <td>196</td>\n",
       "      <td>60</td>\n",
       "      <td>256</td>\n",
       "      <td>2005</td>\n",
       "      <td>0126</td>\n",
       "      <td>Huddinge</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>11.111111111</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22</td>\n",
       "      <td>2005</td>\n",
       "      <td>0140</td>\n",
       "      <td>Nykvarn</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>18.713450292</td>\n",
       "      <td>9.7902097902</td>\n",
       "      <td>16.082474227</td>\n",
       "      <td>64</td>\n",
       "      <td>14</td>\n",
       "      <td>78</td>\n",
       "      <td>2005</td>\n",
       "      <td>0162</td>\n",
       "      <td>Danderyd</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>11.681643132</td>\n",
       "      <td>7.299270073</td>\n",
       "      <td>10.168067227</td>\n",
       "      <td>91</td>\n",
       "      <td>30</td>\n",
       "      <td>121</td>\n",
       "      <td>2005</td>\n",
       "      <td>0120</td>\n",
       "      <td>Värmdö</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>13.978494624</td>\n",
       "      <td>9.3639575972</td>\n",
       "      <td>12.334801762</td>\n",
       "      <td>143</td>\n",
       "      <td>53</td>\n",
       "      <td>196</td>\n",
       "      <td>2005</td>\n",
       "      <td>0123</td>\n",
       "      <td>Järfälla</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>15.406976744</td>\n",
       "      <td>8.7719298246</td>\n",
       "      <td>13.203883495</td>\n",
       "      <td>53</td>\n",
       "      <td>15</td>\n",
       "      <td>68</td>\n",
       "      <td>2005</td>\n",
       "      <td>0125</td>\n",
       "      <td>Ekerö</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>12.962962963</td>\n",
       "      <td>6.657223796</td>\n",
       "      <td>10.739260739</td>\n",
       "      <td>168</td>\n",
       "      <td>47</td>\n",
       "      <td>215</td>\n",
       "      <td>2005</td>\n",
       "      <td>0136</td>\n",
       "      <td>Haninge</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>14.645858343</td>\n",
       "      <td>10.3926097</td>\n",
       "      <td>13.191153239</td>\n",
       "      <td>122</td>\n",
       "      <td>45</td>\n",
       "      <td>167</td>\n",
       "      <td>2005</td>\n",
       "      <td>0184</td>\n",
       "      <td>Solna</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>15.056473443</td>\n",
       "      <td>9.7161762145</td>\n",
       "      <td>13.192756441</td>\n",
       "      <td>1613</td>\n",
       "      <td>558</td>\n",
       "      <td>2171</td>\n",
       "      <td>2005</td>\n",
       "      <td>0180</td>\n",
       "      <td>Stockholm</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>13.807829181</td>\n",
       "      <td>7.34870317</td>\n",
       "      <td>11.672224869</td>\n",
       "      <td>194</td>\n",
       "      <td>51</td>\n",
       "      <td>245</td>\n",
       "      <td>2005</td>\n",
       "      <td>0182</td>\n",
       "      <td>Nacka</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>9.6350364964</td>\n",
       "      <td>5.5555555556</td>\n",
       "      <td>8.1406105458</td>\n",
       "      <td>66</td>\n",
       "      <td>22</td>\n",
       "      <td>88</td>\n",
       "      <td>2005</td>\n",
       "      <td>0191</td>\n",
       "      <td>Sigtuna</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>13.272311213</td>\n",
       "      <td>8.1632653061</td>\n",
       "      <td>11.436950147</td>\n",
       "      <td>58</td>\n",
       "      <td>20</td>\n",
       "      <td>78</td>\n",
       "      <td>2005</td>\n",
       "      <td>0192</td>\n",
       "      <td>Nynäshamn</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>12.8</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>32</td>\n",
       "      <td>2005</td>\n",
       "      <td>0187</td>\n",
       "      <td>Vaxholm</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>14.20233463</td>\n",
       "      <td>11.392405063</td>\n",
       "      <td>13.315579228</td>\n",
       "      <td>73</td>\n",
       "      <td>27</td>\n",
       "      <td>100</td>\n",
       "      <td>2005</td>\n",
       "      <td>0186</td>\n",
       "      <td>Lidingö</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>17.738359202</td>\n",
       "      <td>7.4712643678</td>\n",
       "      <td>13.974719101</td>\n",
       "      <td>160</td>\n",
       "      <td>39</td>\n",
       "      <td>199</td>\n",
       "      <td>2005</td>\n",
       "      <td>0188</td>\n",
       "      <td>Norrtälje</td>\n",
       "      <td>1</td>\n",
       "      <td>01</td>\n",
       "      <td>Stockholms län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>9.0163934426</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>33</td>\n",
       "      <td>2005</td>\n",
       "      <td>0330</td>\n",
       "      <td>Knivsta</td>\n",
       "      <td>1</td>\n",
       "      <td>03</td>\n",
       "      <td>Uppsala län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>8.5294117647</td>\n",
       "      <td>6.9212410501</td>\n",
       "      <td>7.9162875341</td>\n",
       "      <td>58</td>\n",
       "      <td>29</td>\n",
       "      <td>87</td>\n",
       "      <td>2005</td>\n",
       "      <td>0381</td>\n",
       "      <td>Enköping</td>\n",
       "      <td>1</td>\n",
       "      <td>03</td>\n",
       "      <td>Uppsala län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>10.029498525</td>\n",
       "      <td>5.7591623037</td>\n",
       "      <td>8.4905660377</td>\n",
       "      <td>34</td>\n",
       "      <td>11</td>\n",
       "      <td>45</td>\n",
       "      <td>2005</td>\n",
       "      <td>0687</td>\n",
       "      <td>Tranås</td>\n",
       "      <td>1</td>\n",
       "      <td>06</td>\n",
       "      <td>Jönköpings län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>10.240963855</td>\n",
       "      <td>8.4745762712</td>\n",
       "      <td>9.5070422535</td>\n",
       "      <td>17</td>\n",
       "      <td>10</td>\n",
       "      <td>27</td>\n",
       "      <td>2005</td>\n",
       "      <td>0684</td>\n",
       "      <td>Sävsjö</td>\n",
       "      <td>1</td>\n",
       "      <td>06</td>\n",
       "      <td>Jönköpings län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>5.6603773585</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>21</td>\n",
       "      <td>2005</td>\n",
       "      <td>0686</td>\n",
       "      <td>Eksjö</td>\n",
       "      <td>1</td>\n",
       "      <td>06</td>\n",
       "      <td>Jönköpings län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>4.4642857143</td>\n",
       "      <td>5.1724137931</td>\n",
       "      <td>4.7535211268</td>\n",
       "      <td>15</td>\n",
       "      <td>12</td>\n",
       "      <td>27</td>\n",
       "      <td>2005</td>\n",
       "      <td>0683</td>\n",
       "      <td>Värnamo</td>\n",
       "      <td>1</td>\n",
       "      <td>06</td>\n",
       "      <td>Jönköpings län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>11.34751773</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>32</td>\n",
       "      <td>2005</td>\n",
       "      <td>0763</td>\n",
       "      <td>Tingsryd</td>\n",
       "      <td>1</td>\n",
       "      <td>07</td>\n",
       "      <td>Kronobergs län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>16.887709991</td>\n",
       "      <td>9.8471986418</td>\n",
       "      <td>14.476744186</td>\n",
       "      <td>191</td>\n",
       "      <td>58</td>\n",
       "      <td>249</td>\n",
       "      <td>2005</td>\n",
       "      <td>0780</td>\n",
       "      <td>Växjö</td>\n",
       "      <td>1</td>\n",
       "      <td>07</td>\n",
       "      <td>Kronobergs län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>14.979757085</td>\n",
       "      <td>8.0152671756</td>\n",
       "      <td>12.566137566</td>\n",
       "      <td>74</td>\n",
       "      <td>21</td>\n",
       "      <td>95</td>\n",
       "      <td>2005</td>\n",
       "      <td>0781</td>\n",
       "      <td>Ljungby</td>\n",
       "      <td>1</td>\n",
       "      <td>07</td>\n",
       "      <td>Kronobergs län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>7.8651685393</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>21</td>\n",
       "      <td>2005</td>\n",
       "      <td>0767</td>\n",
       "      <td>Markaryd</td>\n",
       "      <td>1</td>\n",
       "      <td>07</td>\n",
       "      <td>Kronobergs län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>15.19121813</td>\n",
       "      <td>8.0200501253</td>\n",
       "      <td>12.601809955</td>\n",
       "      <td>429</td>\n",
       "      <td>128</td>\n",
       "      <td>557</td>\n",
       "      <td>2005</td>\n",
       "      <td>0700</td>\n",
       "      <td>Samtliga kommuner</td>\n",
       "      <td>1</td>\n",
       "      <td>07</td>\n",
       "      <td>Kronobergs län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>20.746887967</td>\n",
       "      <td>10.317460317</td>\n",
       "      <td>17.166212534</td>\n",
       "      <td>50</td>\n",
       "      <td>13</td>\n",
       "      <td>63</td>\n",
       "      <td>2005</td>\n",
       "      <td>0765</td>\n",
       "      <td>Älmhult</td>\n",
       "      <td>1</td>\n",
       "      <td>07</td>\n",
       "      <td>Kronobergs län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>6.746031746</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>17</td>\n",
       "      <td>2005</td>\n",
       "      <td>0760</td>\n",
       "      <td>Uppvidinge</td>\n",
       "      <td>1</td>\n",
       "      <td>07</td>\n",
       "      <td>Kronobergs län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>8.8353413655</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22</td>\n",
       "      <td>2005</td>\n",
       "      <td>0761</td>\n",
       "      <td>Lessebo</td>\n",
       "      <td>1</td>\n",
       "      <td>07</td>\n",
       "      <td>Kronobergs län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>12.698412698</td>\n",
       "      <td>8.4905660377</td>\n",
       "      <td>11.0056926</td>\n",
       "      <td>40</td>\n",
       "      <td>18</td>\n",
       "      <td>58</td>\n",
       "      <td>2005</td>\n",
       "      <td>0764</td>\n",
       "      <td>Alvesta</td>\n",
       "      <td>1</td>\n",
       "      <td>07</td>\n",
       "      <td>Kronobergs län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>7.3349633252</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>30</td>\n",
       "      <td>2005</td>\n",
       "      <td>0840</td>\n",
       "      <td>Mörbylånga</td>\n",
       "      <td>1</td>\n",
       "      <td>08</td>\n",
       "      <td>Kalmar län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>8.5106382979</td>\n",
       "      <td>7.1428571429</td>\n",
       "      <td>8</td>\n",
       "      <td>24</td>\n",
       "      <td>12</td>\n",
       "      <td>36</td>\n",
       "      <td>2005</td>\n",
       "      <td>0860</td>\n",
       "      <td>Hultsfred</td>\n",
       "      <td>1</td>\n",
       "      <td>08</td>\n",
       "      <td>Kalmar län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>5.7471264368</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>10</td>\n",
       "      <td>2005</td>\n",
       "      <td>0821</td>\n",
       "      <td>Högsby</td>\n",
       "      <td>1</td>\n",
       "      <td>08</td>\n",
       "      <td>Kalmar län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>2005</td>\n",
       "      <td>0834</td>\n",
       "      <td>Torsås</td>\n",
       "      <td>1</td>\n",
       "      <td>08</td>\n",
       "      <td>Kalmar län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>10.110386352</td>\n",
       "      <td>5.7632398754</td>\n",
       "      <td>8.407079646</td>\n",
       "      <td>403</td>\n",
       "      <td>148</td>\n",
       "      <td>551</td>\n",
       "      <td>2005</td>\n",
       "      <td>0800</td>\n",
       "      <td>Samtliga kommuner</td>\n",
       "      <td>1</td>\n",
       "      <td>08</td>\n",
       "      <td>Kalmar län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>10.037174721</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>27</td>\n",
       "      <td>2005</td>\n",
       "      <td>0862</td>\n",
       "      <td>Emmaboda</td>\n",
       "      <td>1</td>\n",
       "      <td>08</td>\n",
       "      <td>Kalmar län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>12.387612388</td>\n",
       "      <td>6.589785832</td>\n",
       "      <td>10.199004975</td>\n",
       "      <td>124</td>\n",
       "      <td>40</td>\n",
       "      <td>164</td>\n",
       "      <td>2005</td>\n",
       "      <td>0880</td>\n",
       "      <td>Kalmar</td>\n",
       "      <td>1</td>\n",
       "      <td>08</td>\n",
       "      <td>Kalmar län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>8.4444444444</td>\n",
       "      <td>9.8039215686</td>\n",
       "      <td>8.9947089947</td>\n",
       "      <td>19</td>\n",
       "      <td>15</td>\n",
       "      <td>34</td>\n",
       "      <td>2005</td>\n",
       "      <td>0861</td>\n",
       "      <td>Mönsterås</td>\n",
       "      <td>1</td>\n",
       "      <td>08</td>\n",
       "      <td>Kalmar län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>5.1044083527</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>22</td>\n",
       "      <td>2005</td>\n",
       "      <td>0884</td>\n",
       "      <td>Vimmerby</td>\n",
       "      <td>1</td>\n",
       "      <td>08</td>\n",
       "      <td>Kalmar län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>10.850439883</td>\n",
       "      <td>3.90625</td>\n",
       "      <td>7.8726968174</td>\n",
       "      <td>37</td>\n",
       "      <td>10</td>\n",
       "      <td>47</td>\n",
       "      <td>2005</td>\n",
       "      <td>0881</td>\n",
       "      <td>Nybro</td>\n",
       "      <td>1</td>\n",
       "      <td>08</td>\n",
       "      <td>Kalmar län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>6.3829787234</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>21</td>\n",
       "      <td>2005</td>\n",
       "      <td>0885</td>\n",
       "      <td>Borgholm</td>\n",
       "      <td>1</td>\n",
       "      <td>08</td>\n",
       "      <td>Kalmar län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>7.9207920792</td>\n",
       "      <td>5.3191489362</td>\n",
       "      <td>6.9885641677</td>\n",
       "      <td>40</td>\n",
       "      <td>15</td>\n",
       "      <td>55</td>\n",
       "      <td>2005</td>\n",
       "      <td>0882</td>\n",
       "      <td>Oskarshamn</td>\n",
       "      <td>1</td>\n",
       "      <td>08</td>\n",
       "      <td>Kalmar län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>13.627992634</td>\n",
       "      <td>5.5137844612</td>\n",
       "      <td>10.191082803</td>\n",
       "      <td>74</td>\n",
       "      <td>22</td>\n",
       "      <td>96</td>\n",
       "      <td>2005</td>\n",
       "      <td>0883</td>\n",
       "      <td>Västervik</td>\n",
       "      <td>1</td>\n",
       "      <td>08</td>\n",
       "      <td>Kalmar län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>9.9747474747</td>\n",
       "      <td>5.7939914163</td>\n",
       "      <td>8.426073132</td>\n",
       "      <td>79</td>\n",
       "      <td>27</td>\n",
       "      <td>106</td>\n",
       "      <td>2005</td>\n",
       "      <td>0980</td>\n",
       "      <td>Gotland</td>\n",
       "      <td>1</td>\n",
       "      <td>09</td>\n",
       "      <td>Gotlands län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>9.9747474747</td>\n",
       "      <td>5.7939914163</td>\n",
       "      <td>8.426073132</td>\n",
       "      <td>79</td>\n",
       "      <td>27</td>\n",
       "      <td>106</td>\n",
       "      <td>2005</td>\n",
       "      <td>0900</td>\n",
       "      <td>Samtliga kommuner</td>\n",
       "      <td>1</td>\n",
       "      <td>09</td>\n",
       "      <td>Gotlands län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>8.3612040134</td>\n",
       "      <td>8.1081081081</td>\n",
       "      <td>8.2644628099</td>\n",
       "      <td>25</td>\n",
       "      <td>15</td>\n",
       "      <td>40</td>\n",
       "      <td>2005</td>\n",
       "      <td>1083</td>\n",
       "      <td>Sölvesborg</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>Blekinge län</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>14.208633094</td>\n",
       "      <td>8.5443037975</td>\n",
       "      <td>12.155963303</td>\n",
       "      <td>158</td>\n",
       "      <td>54</td>\n",
       "      <td>212</td>\n",
       "      <td>2005</td>\n",
       "      <td>1080</td>\n",
       "      <td>Karlskrona</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>Blekinge län</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   andel_f43_kvinna andel_f43_man andel_f43_samtliga antal_f43_kvinna  \\\n",
       "0       12.34952547  7.0528619141       10.432669665            18907   \n",
       "1      14.971428571  11.486486486        13.79833207              131   \n",
       "2      14.125200642  8.3582089552       12.108559499               88   \n",
       "3      9.8455598456   5.035971223       8.1658291457               51   \n",
       "4      13.962720055  8.6455143658       12.121212121             4045   \n",
       "5      14.124293785  9.3841642229       12.583412774              100   \n",
       "6         17.578125  9.5744680851       14.947552448              135   \n",
       "7       11.47260274  9.0634441088       10.601092896               67   \n",
       "8      10.792951542  5.0251256281       9.0352220521               49   \n",
       "9      9.7276264591          6.25       8.4266926449              125   \n",
       "10                                       15.28150134                    \n",
       "11     11.592076302   7.358738502       10.075329567              158   \n",
       "12     9.3808630394   7.662835249       8.8161209068               50   \n",
       "13     13.735108619  8.2644628099       11.890385509              196   \n",
       "14                                      11.111111111                    \n",
       "15     18.713450292  9.7902097902       16.082474227               64   \n",
       "16     11.681643132   7.299270073       10.168067227               91   \n",
       "17     13.978494624  9.3639575972       12.334801762              143   \n",
       "18     15.406976744  8.7719298246       13.203883495               53   \n",
       "19     12.962962963   6.657223796       10.739260739              168   \n",
       "20     14.645858343    10.3926097       13.191153239              122   \n",
       "21     15.056473443  9.7161762145       13.192756441             1613   \n",
       "22     13.807829181    7.34870317       11.672224869              194   \n",
       "23     9.6350364964  5.5555555556       8.1406105458               66   \n",
       "24     13.272311213  8.1632653061       11.436950147               58   \n",
       "25                                              12.8                    \n",
       "26      14.20233463  11.392405063       13.315579228               73   \n",
       "27     17.738359202  7.4712643678       13.974719101              160   \n",
       "28                                      9.0163934426                    \n",
       "29     8.5294117647  6.9212410501       7.9162875341               58   \n",
       "..              ...           ...                ...              ...   \n",
       "70     10.029498525  5.7591623037       8.4905660377               34   \n",
       "71     10.240963855  8.4745762712       9.5070422535               17   \n",
       "72                                      5.6603773585                    \n",
       "73     4.4642857143  5.1724137931       4.7535211268               15   \n",
       "74                                       11.34751773                    \n",
       "75     16.887709991  9.8471986418       14.476744186              191   \n",
       "76     14.979757085  8.0152671756       12.566137566               74   \n",
       "77                                      7.8651685393                    \n",
       "78      15.19121813  8.0200501253       12.601809955              429   \n",
       "79     20.746887967  10.317460317       17.166212534               50   \n",
       "80                                       6.746031746                    \n",
       "81                                      8.8353413655                    \n",
       "82     12.698412698  8.4905660377         11.0056926               40   \n",
       "83                                      7.3349633252                    \n",
       "84     8.5106382979  7.1428571429                  8               24   \n",
       "85                                      5.7471264368                    \n",
       "86                                                                      \n",
       "87     10.110386352  5.7632398754        8.407079646              403   \n",
       "88                                      10.037174721                    \n",
       "89     12.387612388   6.589785832       10.199004975              124   \n",
       "90     8.4444444444  9.8039215686       8.9947089947               19   \n",
       "91                                      5.1044083527                    \n",
       "92     10.850439883       3.90625       7.8726968174               37   \n",
       "93                                      6.3829787234                    \n",
       "94     7.9207920792  5.3191489362       6.9885641677               40   \n",
       "95     13.627992634  5.5137844612       10.191082803               74   \n",
       "96     9.9747474747  5.7939914163        8.426073132               79   \n",
       "97     9.9747474747  5.7939914163        8.426073132               79   \n",
       "98     8.3612040134  8.1081081081       8.2644628099               25   \n",
       "99     14.208633094  8.5443037975       12.155963303              158   \n",
       "\n",
       "   antal_f43_man antal_f43_samtliga    ar kommun_kod        kommun_text  \\\n",
       "0           6124              25031  2005       0000  Samtliga kommuner   \n",
       "1             51                182  2005       0160               Täby   \n",
       "2             28                116  2005       0114     Upplands-Väsby   \n",
       "3             14                 65  2005       0115         Vallentuna   \n",
       "4           1327               5372  2005       0100  Samtliga kommuner   \n",
       "5             32                132  2005       0138             Tyresö   \n",
       "6             36                171  2005       0163         Sollentuna   \n",
       "7             30                 97  2005       0117          Österåker   \n",
       "8             10                 59  2005       0139       Upplands-Bro   \n",
       "9             48                173  2005       0127           Botkyrka   \n",
       "10                               57  2005       0128              Salem   \n",
       "11            56                214  2005       0181         Södertälje   \n",
       "12            20                 70  2005       0183         Sundbyberg   \n",
       "13            60                256  2005       0126           Huddinge   \n",
       "14                               22  2005       0140            Nykvarn   \n",
       "15            14                 78  2005       0162           Danderyd   \n",
       "16            30                121  2005       0120             Värmdö   \n",
       "17            53                196  2005       0123           Järfälla   \n",
       "18            15                 68  2005       0125              Ekerö   \n",
       "19            47                215  2005       0136            Haninge   \n",
       "20            45                167  2005       0184              Solna   \n",
       "21           558               2171  2005       0180          Stockholm   \n",
       "22            51                245  2005       0182              Nacka   \n",
       "23            22                 88  2005       0191            Sigtuna   \n",
       "24            20                 78  2005       0192          Nynäshamn   \n",
       "25                               32  2005       0187            Vaxholm   \n",
       "26            27                100  2005       0186            Lidingö   \n",
       "27            39                199  2005       0188          Norrtälje   \n",
       "28                               33  2005       0330            Knivsta   \n",
       "29            29                 87  2005       0381           Enköping   \n",
       "..           ...                ...   ...        ...                ...   \n",
       "70            11                 45  2005       0687             Tranås   \n",
       "71            10                 27  2005       0684             Sävsjö   \n",
       "72                               21  2005       0686              Eksjö   \n",
       "73            12                 27  2005       0683            Värnamo   \n",
       "74                               32  2005       0763           Tingsryd   \n",
       "75            58                249  2005       0780              Växjö   \n",
       "76            21                 95  2005       0781            Ljungby   \n",
       "77                               21  2005       0767           Markaryd   \n",
       "78           128                557  2005       0700  Samtliga kommuner   \n",
       "79            13                 63  2005       0765            Älmhult   \n",
       "80                               17  2005       0760         Uppvidinge   \n",
       "81                               22  2005       0761            Lessebo   \n",
       "82            18                 58  2005       0764            Alvesta   \n",
       "83                               30  2005       0840         Mörbylånga   \n",
       "84            12                 36  2005       0860          Hultsfred   \n",
       "85                               10  2005       0821             Högsby   \n",
       "86                                   2005       0834             Torsås   \n",
       "87           148                551  2005       0800  Samtliga kommuner   \n",
       "88                               27  2005       0862           Emmaboda   \n",
       "89            40                164  2005       0880             Kalmar   \n",
       "90            15                 34  2005       0861          Mönsterås   \n",
       "91                               22  2005       0884           Vimmerby   \n",
       "92            10                 47  2005       0881              Nybro   \n",
       "93                               21  2005       0885           Borgholm   \n",
       "94            15                 55  2005       0882         Oskarshamn   \n",
       "95            22                 96  2005       0883          Västervik   \n",
       "96            27                106  2005       0980            Gotland   \n",
       "97            27                106  2005       0900  Samtliga kommuner   \n",
       "98            15                 40  2005       1083         Sölvesborg   \n",
       "99            54                212  2005       1080         Karlskrona   \n",
       "\n",
       "   kvartal lan_kod        lan_text  \n",
       "0        1      00           Riket  \n",
       "1        1      01  Stockholms län  \n",
       "2        1      01  Stockholms län  \n",
       "3        1      01  Stockholms län  \n",
       "4        1      01  Stockholms län  \n",
       "5        1      01  Stockholms län  \n",
       "6        1      01  Stockholms län  \n",
       "7        1      01  Stockholms län  \n",
       "8        1      01  Stockholms län  \n",
       "9        1      01  Stockholms län  \n",
       "10       1      01  Stockholms län  \n",
       "11       1      01  Stockholms län  \n",
       "12       1      01  Stockholms län  \n",
       "13       1      01  Stockholms län  \n",
       "14       1      01  Stockholms län  \n",
       "15       1      01  Stockholms län  \n",
       "16       1      01  Stockholms län  \n",
       "17       1      01  Stockholms län  \n",
       "18       1      01  Stockholms län  \n",
       "19       1      01  Stockholms län  \n",
       "20       1      01  Stockholms län  \n",
       "21       1      01  Stockholms län  \n",
       "22       1      01  Stockholms län  \n",
       "23       1      01  Stockholms län  \n",
       "24       1      01  Stockholms län  \n",
       "25       1      01  Stockholms län  \n",
       "26       1      01  Stockholms län  \n",
       "27       1      01  Stockholms län  \n",
       "28       1      03     Uppsala län  \n",
       "29       1      03     Uppsala län  \n",
       "..     ...     ...             ...  \n",
       "70       1      06  Jönköpings län  \n",
       "71       1      06  Jönköpings län  \n",
       "72       1      06  Jönköpings län  \n",
       "73       1      06  Jönköpings län  \n",
       "74       1      07  Kronobergs län  \n",
       "75       1      07  Kronobergs län  \n",
       "76       1      07  Kronobergs län  \n",
       "77       1      07  Kronobergs län  \n",
       "78       1      07  Kronobergs län  \n",
       "79       1      07  Kronobergs län  \n",
       "80       1      07  Kronobergs län  \n",
       "81       1      07  Kronobergs län  \n",
       "82       1      07  Kronobergs län  \n",
       "83       1      08      Kalmar län  \n",
       "84       1      08      Kalmar län  \n",
       "85       1      08      Kalmar län  \n",
       "86       1      08      Kalmar län  \n",
       "87       1      08      Kalmar län  \n",
       "88       1      08      Kalmar län  \n",
       "89       1      08      Kalmar län  \n",
       "90       1      08      Kalmar län  \n",
       "91       1      08      Kalmar län  \n",
       "92       1      08      Kalmar län  \n",
       "93       1      08      Kalmar län  \n",
       "94       1      08      Kalmar län  \n",
       "95       1      08      Kalmar län  \n",
       "96       1      09    Gotlands län  \n",
       "97       1      09    Gotlands län  \n",
       "98       1      10    Blekinge län  \n",
       "99       1      10    Blekinge län  \n",
       "\n",
       "[100 rows x 12 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "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.6.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}