{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "hideCode": false,
    "hidePrompt": false
   },
   "outputs": [],
   "source": [
    "%matplotlib inline\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import os\n",
    "import urllib.request"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "hideCode": false,
    "hidePrompt": false
   },
   "outputs": [],
   "source": [
    "data_url = \"https://www.sentiweb.fr/datasets/incidence-PAY-3.csv\"\n",
    "data_file = \"syndrome_grippal.csv\"\n",
    "if os.path.exists(data_file):\n",
    "    pass\n",
    "else:\n",
    "    urllib.request.urlretrieve(data_url, data_file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "hideCode": false,
    "hidePrompt": false
   },
   "outputs": [],
   "source": [
    "data = pd.read_csv(data_file, skiprows=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "hideCode": false,
    "hidePrompt": false
   },
   "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>week</th>\n",
       "      <th>indicator</th>\n",
       "      <th>inc</th>\n",
       "      <th>inc_low</th>\n",
       "      <th>inc_up</th>\n",
       "      <th>inc100</th>\n",
       "      <th>inc100_low</th>\n",
       "      <th>inc100_up</th>\n",
       "      <th>geo_insee</th>\n",
       "      <th>geo_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>202204</td>\n",
       "      <td>3</td>\n",
       "      <td>72585</td>\n",
       "      <td>65106.0</td>\n",
       "      <td>80064.0</td>\n",
       "      <td>109</td>\n",
       "      <td>98.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>FR</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>202203</td>\n",
       "      <td>3</td>\n",
       "      <td>74613</td>\n",
       "      <td>67144.0</td>\n",
       "      <td>82082.0</td>\n",
       "      <td>113</td>\n",
       "      <td>102.0</td>\n",
       "      <td>124.0</td>\n",
       "      <td>FR</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>202202</td>\n",
       "      <td>3</td>\n",
       "      <td>55920</td>\n",
       "      <td>49511.0</td>\n",
       "      <td>62329.0</td>\n",
       "      <td>84</td>\n",
       "      <td>74.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>FR</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>202201</td>\n",
       "      <td>3</td>\n",
       "      <td>57629</td>\n",
       "      <td>50699.0</td>\n",
       "      <td>64559.0</td>\n",
       "      <td>87</td>\n",
       "      <td>77.0</td>\n",
       "      <td>97.0</td>\n",
       "      <td>FR</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>202152</td>\n",
       "      <td>3</td>\n",
       "      <td>54349</td>\n",
       "      <td>47029.0</td>\n",
       "      <td>61669.0</td>\n",
       "      <td>82</td>\n",
       "      <td>71.0</td>\n",
       "      <td>93.0</td>\n",
       "      <td>FR</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     week  indicator    inc  inc_low   inc_up  inc100  inc100_low  inc100_up  \\\n",
       "0  202204          3  72585  65106.0  80064.0     109        98.0      120.0   \n",
       "1  202203          3  74613  67144.0  82082.0     113       102.0      124.0   \n",
       "2  202202          3  55920  49511.0  62329.0      84        74.0       94.0   \n",
       "3  202201          3  57629  50699.0  64559.0      87        77.0       97.0   \n",
       "4  202152          3  54349  47029.0  61669.0      82        71.0       93.0   \n",
       "\n",
       "  geo_insee geo_name  \n",
       "0        FR   France  \n",
       "1        FR   France  \n",
       "2        FR   France  \n",
       "3        FR   France  \n",
       "4        FR   France  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "hideCode": false,
    "hidePrompt": false
   },
   "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>week</th>\n",
       "      <th>indicator</th>\n",
       "      <th>inc</th>\n",
       "      <th>inc_low</th>\n",
       "      <th>inc_up</th>\n",
       "      <th>inc100</th>\n",
       "      <th>inc100_low</th>\n",
       "      <th>inc100_up</th>\n",
       "      <th>geo_insee</th>\n",
       "      <th>geo_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1939</th>\n",
       "      <td>198448</td>\n",
       "      <td>3</td>\n",
       "      <td>78620</td>\n",
       "      <td>60634.0</td>\n",
       "      <td>96606.0</td>\n",
       "      <td>143</td>\n",
       "      <td>110.0</td>\n",
       "      <td>176.0</td>\n",
       "      <td>FR</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1940</th>\n",
       "      <td>198447</td>\n",
       "      <td>3</td>\n",
       "      <td>72029</td>\n",
       "      <td>54274.0</td>\n",
       "      <td>89784.0</td>\n",
       "      <td>131</td>\n",
       "      <td>99.0</td>\n",
       "      <td>163.0</td>\n",
       "      <td>FR</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1941</th>\n",
       "      <td>198446</td>\n",
       "      <td>3</td>\n",
       "      <td>87330</td>\n",
       "      <td>67686.0</td>\n",
       "      <td>106974.0</td>\n",
       "      <td>159</td>\n",
       "      <td>123.0</td>\n",
       "      <td>195.0</td>\n",
       "      <td>FR</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1942</th>\n",
       "      <td>198445</td>\n",
       "      <td>3</td>\n",
       "      <td>135223</td>\n",
       "      <td>101414.0</td>\n",
       "      <td>169032.0</td>\n",
       "      <td>246</td>\n",
       "      <td>184.0</td>\n",
       "      <td>308.0</td>\n",
       "      <td>FR</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1943</th>\n",
       "      <td>198444</td>\n",
       "      <td>3</td>\n",
       "      <td>68422</td>\n",
       "      <td>20056.0</td>\n",
       "      <td>116788.0</td>\n",
       "      <td>125</td>\n",
       "      <td>37.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>FR</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        week  indicator     inc   inc_low    inc_up  inc100  inc100_low  \\\n",
       "1939  198448          3   78620   60634.0   96606.0     143       110.0   \n",
       "1940  198447          3   72029   54274.0   89784.0     131        99.0   \n",
       "1941  198446          3   87330   67686.0  106974.0     159       123.0   \n",
       "1942  198445          3  135223  101414.0  169032.0     246       184.0   \n",
       "1943  198444          3   68422   20056.0  116788.0     125        37.0   \n",
       "\n",
       "      inc100_up geo_insee geo_name  \n",
       "1939      176.0        FR   France  \n",
       "1940      163.0        FR   France  \n",
       "1941      195.0        FR   France  \n",
       "1942      308.0        FR   France  \n",
       "1943      213.0        FR   France  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "hideCode": false,
    "hidePrompt": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "week            int64\n",
      "indicator       int64\n",
      "inc             int64\n",
      "inc_low       float64\n",
      "inc_up        float64\n",
      "inc100          int64\n",
      "inc100_low    float64\n",
      "inc100_up     float64\n",
      "geo_insee      object\n",
      "geo_name       object\n",
      "dtype: object\n"
     ]
    },
    {
     "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>week</th>\n",
       "      <th>indicator</th>\n",
       "      <th>inc</th>\n",
       "      <th>inc_low</th>\n",
       "      <th>inc_up</th>\n",
       "      <th>inc100</th>\n",
       "      <th>inc100_low</th>\n",
       "      <th>inc100_up</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>1944.000000</td>\n",
       "      <td>1944.0</td>\n",
       "      <td>1.944000e+03</td>\n",
       "      <td>1943.000000</td>\n",
       "      <td>1.943000e+03</td>\n",
       "      <td>1944.000000</td>\n",
       "      <td>1943.000000</td>\n",
       "      <td>1943.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>200321.964506</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.006592e+04</td>\n",
       "      <td>52573.937210</td>\n",
       "      <td>6.767021e+04</td>\n",
       "      <td>100.750514</td>\n",
       "      <td>88.210499</td>\n",
       "      <td>113.476068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>1075.707510</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.135715e+05</td>\n",
       "      <td>107879.967912</td>\n",
       "      <td>1.194434e+05</td>\n",
       "      <td>193.441495</td>\n",
       "      <td>183.805111</td>\n",
       "      <td>203.392822</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>198444.000000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>199407.750000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.170750e+03</td>\n",
       "      <td>2048.500000</td>\n",
       "      <td>8.432500e+03</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>14.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>200324.500000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.618500e+04</td>\n",
       "      <td>10915.000000</td>\n",
       "      <td>2.161300e+04</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>36.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>201240.250000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.819375e+04</td>\n",
       "      <td>38644.500000</td>\n",
       "      <td>5.730750e+04</td>\n",
       "      <td>82.000000</td>\n",
       "      <td>66.000000</td>\n",
       "      <td>97.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>202204.000000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.001824e+06</td>\n",
       "      <td>974799.000000</td>\n",
       "      <td>1.028849e+06</td>\n",
       "      <td>1793.000000</td>\n",
       "      <td>1745.000000</td>\n",
       "      <td>1841.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                week  indicator           inc        inc_low        inc_up  \\\n",
       "count    1944.000000     1944.0  1.944000e+03    1943.000000  1.943000e+03   \n",
       "mean   200321.964506        3.0  6.006592e+04   52573.937210  6.767021e+04   \n",
       "std      1075.707510        0.0  1.135715e+05  107879.967912  1.194434e+05   \n",
       "min    198444.000000        3.0  0.000000e+00       0.000000  0.000000e+00   \n",
       "25%    199407.750000        3.0  5.170750e+03    2048.500000  8.432500e+03   \n",
       "50%    200324.500000        3.0  1.618500e+04   10915.000000  2.161300e+04   \n",
       "75%    201240.250000        3.0  4.819375e+04   38644.500000  5.730750e+04   \n",
       "max    202204.000000        3.0  1.001824e+06  974799.000000  1.028849e+06   \n",
       "\n",
       "            inc100   inc100_low    inc100_up  \n",
       "count  1944.000000  1943.000000  1943.000000  \n",
       "mean    100.750514    88.210499   113.476068  \n",
       "std     193.441495   183.805111   203.392822  \n",
       "min       0.000000     0.000000     0.000000  \n",
       "25%       9.000000     3.000000    14.000000  \n",
       "50%      27.000000    18.000000    36.000000  \n",
       "75%      82.000000    66.000000    97.500000  \n",
       "max    1793.000000  1745.000000  1841.000000  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "print(data.dtypes)\n",
    "data.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "hideCode": false,
    "hidePrompt": false
   },
   "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>week</th>\n",
       "      <th>indicator</th>\n",
       "      <th>inc</th>\n",
       "      <th>inc_low</th>\n",
       "      <th>inc_up</th>\n",
       "      <th>inc100</th>\n",
       "      <th>inc100_low</th>\n",
       "      <th>inc100_up</th>\n",
       "      <th>geo_insee</th>\n",
       "      <th>geo_name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1707</th>\n",
       "      <td>198919</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>FR</td>\n",
       "      <td>France</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        week  indicator  inc  inc_low  inc_up  inc100  inc100_low  inc100_up  \\\n",
       "1707  198919          3    0      NaN     NaN       0         NaN        NaN   \n",
       "\n",
       "     geo_insee geo_name  \n",
       "1707        FR   France  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "missing_data = data.loc[data.isna().any(axis=1), :]\n",
    "missing_data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "hideCode": false,
    "hidePrompt": false
   },
   "source": [
    "In the original datafile: data is simply missing for week \"198919\", hence the NaN obtained.\n",
    "We decide to continue the analysis without this line which, hopefully, should have little impact on the analysis."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "hideCode": false,
    "hidePrompt": false
   },
   "outputs": [],
   "source": [
    "data = data.drop(index=missing_data.index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "hideCode": false,
    "hidePrompt": false
   },
   "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>week</th>\n",
       "      <th>indicator</th>\n",
       "      <th>inc</th>\n",
       "      <th>inc_low</th>\n",
       "      <th>inc_up</th>\n",
       "      <th>inc100</th>\n",
       "      <th>inc100_low</th>\n",
       "      <th>inc100_up</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>1943.000000</td>\n",
       "      <td>1943.0</td>\n",
       "      <td>1.943000e+03</td>\n",
       "      <td>1943.000000</td>\n",
       "      <td>1.943000e+03</td>\n",
       "      <td>1943.000000</td>\n",
       "      <td>1943.000000</td>\n",
       "      <td>1943.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>200322.686567</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.009684e+04</td>\n",
       "      <td>52573.937210</td>\n",
       "      <td>6.767021e+04</td>\n",
       "      <td>100.802367</td>\n",
       "      <td>88.210499</td>\n",
       "      <td>113.476068</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>1075.513102</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.135925e+05</td>\n",
       "      <td>107879.967912</td>\n",
       "      <td>1.194434e+05</td>\n",
       "      <td>193.477779</td>\n",
       "      <td>183.805111</td>\n",
       "      <td>203.392822</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>198444.000000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>199408.500000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.177000e+03</td>\n",
       "      <td>2048.500000</td>\n",
       "      <td>8.432500e+03</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>14.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>200325.000000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.618800e+04</td>\n",
       "      <td>10915.000000</td>\n",
       "      <td>2.161300e+04</td>\n",
       "      <td>27.000000</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>36.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>201240.500000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.821350e+04</td>\n",
       "      <td>38644.500000</td>\n",
       "      <td>5.730750e+04</td>\n",
       "      <td>82.000000</td>\n",
       "      <td>66.000000</td>\n",
       "      <td>97.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>202204.000000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.001824e+06</td>\n",
       "      <td>974799.000000</td>\n",
       "      <td>1.028849e+06</td>\n",
       "      <td>1793.000000</td>\n",
       "      <td>1745.000000</td>\n",
       "      <td>1841.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                week  indicator           inc        inc_low        inc_up  \\\n",
       "count    1943.000000     1943.0  1.943000e+03    1943.000000  1.943000e+03   \n",
       "mean   200322.686567        3.0  6.009684e+04   52573.937210  6.767021e+04   \n",
       "std      1075.513102        0.0  1.135925e+05  107879.967912  1.194434e+05   \n",
       "min    198444.000000        3.0  0.000000e+00       0.000000  0.000000e+00   \n",
       "25%    199408.500000        3.0  5.177000e+03    2048.500000  8.432500e+03   \n",
       "50%    200325.000000        3.0  1.618800e+04   10915.000000  2.161300e+04   \n",
       "75%    201240.500000        3.0  4.821350e+04   38644.500000  5.730750e+04   \n",
       "max    202204.000000        3.0  1.001824e+06  974799.000000  1.028849e+06   \n",
       "\n",
       "            inc100   inc100_low    inc100_up  \n",
       "count  1943.000000  1943.000000  1943.000000  \n",
       "mean    100.802367    88.210499   113.476068  \n",
       "std     193.477779   183.805111   203.392822  \n",
       "min       0.000000     0.000000     0.000000  \n",
       "25%       9.000000     3.000000    14.000000  \n",
       "50%      27.000000    18.000000    36.000000  \n",
       "75%      82.000000    66.000000    97.500000  \n",
       "max    1793.000000  1745.000000  1841.000000  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "**TODO:** Change week format"
   ]
  }
 ],
 "metadata": {
  "celltoolbar": "Hide code",
  "hide_code_all_hidden": false,
  "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.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}