1.Plot Open Data Files using Dash.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Open Data Sabadell\n",
    "\n",
    "\n",
    "http://opendata.sabadell.cat/ca/\n",
    "\n",
    "From main page **Catàleg** we select **Medi Ambient** (Environment) category.  \n",
    "In there, we can find a file related to municipal waste that can be downloaded from [here.](http://opendata.sabadell.cat/index.php?option=com_iasopendata&view=download&format=raw&urlOData=aHR0cDovL29kYXRhLnNhYmFkZWxsLmNhdC9vZGF0YTRQcm9kdWN0b3Ivb2RhdGE0UHJvZHVjdG9yLnN2Yy9NYXRlcmlhbHNSZXNpZHVzLz9mb3JtYXQ9Y3N2JmlkZGlzdD0xNDYyJiRzZWxlY3Q9T3JkcmUsQW55byxJZE1hdGVyaWFsLE5vbU1hdGVyaWFsLFF1YW50aXRhdCxVbml0YXRz) But you can find a copy of this file named **residus.csv** in this tutorial dataset in **DadesSabadell** folder.\n",
    "\n",
    "The file obtained is in a CSV format (Comma Separated Value). This means that it is \n",
    "like a table where the rows are registers and the columns are fields or values associated to this register. \n",
    "\n",
    "You can take a look into this file in table-like representation provided in the open data web page following this link: [OpenData Sabadell](http://opendata.sabadell.cat/ca/inici/odata?iddist=1462). Looking this table we can observe that every register represents an amount of waste origined in Sabadell in tones associated with a particular year and a waste type classification.\n",
    "\n",
    "In this exercice we are going to follow this steps:\n",
    "* Read residus.csv file.\n",
    "* Group data to obtain more readable information. Every row will be a type of waste and the columns will be a year related to this data.\n",
    "* Represent data in an interactive way.\n",
    "    \n",
    "**Important:** Nan values indicate that there is no infomation related to this type of waste and year.\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "To read data and manage it we are going to use [pandas](https://pandas.pydata.org/) library:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "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>Ordre</th>\n",
       "      <th>Anyo</th>\n",
       "      <th>IdMaterial</th>\n",
       "      <th>NomMaterial</th>\n",
       "      <th>Quantitat</th>\n",
       "      <th>Unitats</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>339</th>\n",
       "      <td>338</td>\n",
       "      <td>1984</td>\n",
       "      <td>28</td>\n",
       "      <td>Voluminosos</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>390</th>\n",
       "      <td>389</td>\n",
       "      <td>1984</td>\n",
       "      <td>2</td>\n",
       "      <td>Paper</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>179</td>\n",
       "      <td>1984</td>\n",
       "      <td>3</td>\n",
       "      <td>Envasos</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>246</td>\n",
       "      <td>1984</td>\n",
       "      <td>16</td>\n",
       "      <td>Piles</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>233</td>\n",
       "      <td>1984</td>\n",
       "      <td>9</td>\n",
       "      <td>Fracció vegetal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>575</th>\n",
       "      <td>573</td>\n",
       "      <td>1984</td>\n",
       "      <td>1</td>\n",
       "      <td>Vidre</td>\n",
       "      <td>46.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>1984</td>\n",
       "      <td>10</td>\n",
       "      <td>Tèxtil</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>131</td>\n",
       "      <td>1984</td>\n",
       "      <td>17</td>\n",
       "      <td>Medicaments i cosmètics</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>104</td>\n",
       "      <td>1984</td>\n",
       "      <td>25</td>\n",
       "      <td>Olis vegetals</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>483</th>\n",
       "      <td>482</td>\n",
       "      <td>1985</td>\n",
       "      <td>7</td>\n",
       "      <td>Resta</td>\n",
       "      <td>49485.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>581</th>\n",
       "      <td>579</td>\n",
       "      <td>1985</td>\n",
       "      <td>3</td>\n",
       "      <td>Envasos</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>460</th>\n",
       "      <td>459</td>\n",
       "      <td>1985</td>\n",
       "      <td>17</td>\n",
       "      <td>Medicaments i cosmètics</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>177</td>\n",
       "      <td>1985</td>\n",
       "      <td>1</td>\n",
       "      <td>Vidre</td>\n",
       "      <td>103.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>506</th>\n",
       "      <td>505</td>\n",
       "      <td>1985</td>\n",
       "      <td>28</td>\n",
       "      <td>Voluminosos</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>182</td>\n",
       "      <td>1985</td>\n",
       "      <td>9</td>\n",
       "      <td>Fracció vegetal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>572</th>\n",
       "      <td>571</td>\n",
       "      <td>1985</td>\n",
       "      <td>25</td>\n",
       "      <td>Olis vegetals</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>1986</td>\n",
       "      <td>17</td>\n",
       "      <td>Medicaments i cosmètics</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>86</td>\n",
       "      <td>1986</td>\n",
       "      <td>25</td>\n",
       "      <td>Olis vegetals</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445</th>\n",
       "      <td>444</td>\n",
       "      <td>1986</td>\n",
       "      <td>1</td>\n",
       "      <td>Vidre</td>\n",
       "      <td>204.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>112</td>\n",
       "      <td>1986</td>\n",
       "      <td>7</td>\n",
       "      <td>Resta</td>\n",
       "      <td>50894.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>424</th>\n",
       "      <td>423</td>\n",
       "      <td>1986</td>\n",
       "      <td>16</td>\n",
       "      <td>Piles</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>151</td>\n",
       "      <td>1986</td>\n",
       "      <td>28</td>\n",
       "      <td>Voluminosos</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519</th>\n",
       "      <td>518</td>\n",
       "      <td>1986</td>\n",
       "      <td>9</td>\n",
       "      <td>Fracció vegetal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>201</td>\n",
       "      <td>1986</td>\n",
       "      <td>2</td>\n",
       "      <td>Paper</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>342</th>\n",
       "      <td>341</td>\n",
       "      <td>1986</td>\n",
       "      <td>10</td>\n",
       "      <td>Tèxtil</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>1986</td>\n",
       "      <td>3</td>\n",
       "      <td>Envasos</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>444</th>\n",
       "      <td>443</td>\n",
       "      <td>1987</td>\n",
       "      <td>25</td>\n",
       "      <td>Olis vegetals</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <td>362</td>\n",
       "      <td>1987</td>\n",
       "      <td>1</td>\n",
       "      <td>Vidre</td>\n",
       "      <td>317.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>77</td>\n",
       "      <td>1987</td>\n",
       "      <td>9</td>\n",
       "      <td>Fracció vegetal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>34</td>\n",
       "      <td>1987</td>\n",
       "      <td>16</td>\n",
       "      <td>Piles</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tones</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>706</th>\n",
       "      <td>707</td>\n",
       "      <td>2017</td>\n",
       "      <td>38</td>\n",
       "      <td>Comburents</td>\n",
       "      <td>6.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>327</th>\n",
       "      <td>326</td>\n",
       "      <td>2017</td>\n",
       "      <td>49</td>\n",
       "      <td>RAEE FRA 4 (A2) Altres aparells amb tamany sup...</td>\n",
       "      <td>41.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>2017</td>\n",
       "      <td>7</td>\n",
       "      <td>Resta</td>\n",
       "      <td>60747.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>693</th>\n",
       "      <td>694</td>\n",
       "      <td>2017</td>\n",
       "      <td>37</td>\n",
       "      <td>Reactius de laboratori</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>303</th>\n",
       "      <td>302</td>\n",
       "      <td>2017</td>\n",
       "      <td>34</td>\n",
       "      <td>Àcids</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>439</th>\n",
       "      <td>438</td>\n",
       "      <td>2017</td>\n",
       "      <td>12</td>\n",
       "      <td>Ferralla</td>\n",
       "      <td>120.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>740</th>\n",
       "      <td>741</td>\n",
       "      <td>2017</td>\n",
       "      <td>41</td>\n",
       "      <td>Porexpan</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313</th>\n",
       "      <td>312</td>\n",
       "      <td>2018</td>\n",
       "      <td>30</td>\n",
       "      <td>Coure</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>41</td>\n",
       "      <td>2018</td>\n",
       "      <td>9</td>\n",
       "      <td>Fracció vegetal</td>\n",
       "      <td>112.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>438</th>\n",
       "      <td>437</td>\n",
       "      <td>2018</td>\n",
       "      <td>15</td>\n",
       "      <td>Tòners</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>543</th>\n",
       "      <td>542</td>\n",
       "      <td>2018</td>\n",
       "      <td>28</td>\n",
       "      <td>Voluminosos</td>\n",
       "      <td>4144.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>215</td>\n",
       "      <td>2018</td>\n",
       "      <td>13</td>\n",
       "      <td>Fusta</td>\n",
       "      <td>1700.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>642</th>\n",
       "      <td>640</td>\n",
       "      <td>2018</td>\n",
       "      <td>14</td>\n",
       "      <td>Runes</td>\n",
       "      <td>3268.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>412</td>\n",
       "      <td>2018</td>\n",
       "      <td>25</td>\n",
       "      <td>Olis vegetals</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>75</td>\n",
       "      <td>2018</td>\n",
       "      <td>41</td>\n",
       "      <td>Porexpan</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>37</td>\n",
       "      <td>2018</td>\n",
       "      <td>1</td>\n",
       "      <td>Vidre</td>\n",
       "      <td>2775.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>51</td>\n",
       "      <td>2018</td>\n",
       "      <td>16</td>\n",
       "      <td>Piles</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>556</th>\n",
       "      <td>555</td>\n",
       "      <td>2018</td>\n",
       "      <td>7</td>\n",
       "      <td>Resta</td>\n",
       "      <td>46530.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>629</th>\n",
       "      <td>627</td>\n",
       "      <td>2018</td>\n",
       "      <td>2</td>\n",
       "      <td>Paper</td>\n",
       "      <td>3613.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>410</td>\n",
       "      <td>2018</td>\n",
       "      <td>11</td>\n",
       "      <td>Vidre Pla</td>\n",
       "      <td>249.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>245</td>\n",
       "      <td>2018</td>\n",
       "      <td>26</td>\n",
       "      <td>Olis minerals</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>607</th>\n",
       "      <td>605</td>\n",
       "      <td>2018</td>\n",
       "      <td>47</td>\n",
       "      <td>RAEE FRA 2 (A3) Monitors i pantalles LED, CRT ...</td>\n",
       "      <td>28.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419</th>\n",
       "      <td>418</td>\n",
       "      <td>2018</td>\n",
       "      <td>3</td>\n",
       "      <td>Envasos</td>\n",
       "      <td>2576.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>2018</td>\n",
       "      <td>12</td>\n",
       "      <td>Ferralla</td>\n",
       "      <td>158.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>459</th>\n",
       "      <td>458</td>\n",
       "      <td>2018</td>\n",
       "      <td>43</td>\n",
       "      <td>Plàstic rígid</td>\n",
       "      <td>34.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>370</th>\n",
       "      <td>369</td>\n",
       "      <td>2018</td>\n",
       "      <td>51</td>\n",
       "      <td>RAEE FRA 6 (A4) Aparells petits d'informàtica ...</td>\n",
       "      <td>16.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>109</td>\n",
       "      <td>2018</td>\n",
       "      <td>4</td>\n",
       "      <td>Materia orgànica</td>\n",
       "      <td>4088.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>567</th>\n",
       "      <td>566</td>\n",
       "      <td>2018</td>\n",
       "      <td>50</td>\n",
       "      <td>RAEE FRA 5 (A4) Petits aparells sense dimensió...</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>549</th>\n",
       "      <td>548</td>\n",
       "      <td>2018</td>\n",
       "      <td>20</td>\n",
       "      <td>Bateries</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>96</td>\n",
       "      <td>2018</td>\n",
       "      <td>48</td>\n",
       "      <td>RAEE FRA 3 (A5) Lampares i fluorescents</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Tones</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>796 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Ordre  Anyo  IdMaterial  \\\n",
       "339    338  1984          28   \n",
       "390    389  1984           2   \n",
       "179    179  1984           3   \n",
       "247    246  1984          16   \n",
       "234    233  1984           9   \n",
       "575    573  1984           1   \n",
       "21      22  1984          10   \n",
       "131    131  1984          17   \n",
       "103    104  1984          25   \n",
       "483    482  1985           7   \n",
       "581    579  1985           3   \n",
       "460    459  1985          17   \n",
       "177    177  1985           1   \n",
       "506    505  1985          28   \n",
       "182    182  1985           9   \n",
       "572    571  1985          25   \n",
       "22      23  1986          17   \n",
       "85      86  1986          25   \n",
       "445    444  1986           1   \n",
       "111    112  1986           7   \n",
       "424    423  1986          16   \n",
       "151    151  1986          28   \n",
       "519    518  1986           9   \n",
       "201    201  1986           2   \n",
       "342    341  1986          10   \n",
       "6        7  1986           3   \n",
       "444    443  1987          25   \n",
       "363    362  1987           1   \n",
       "76      77  1987           9   \n",
       "33      34  1987          16   \n",
       "..     ...   ...         ...   \n",
       "706    707  2017          38   \n",
       "327    326  2017          49   \n",
       "12      13  2017           7   \n",
       "693    694  2017          37   \n",
       "303    302  2017          34   \n",
       "439    438  2017          12   \n",
       "740    741  2017          41   \n",
       "313    312  2018          30   \n",
       "40      41  2018           9   \n",
       "438    437  2018          15   \n",
       "543    542  2018          28   \n",
       "215    215  2018          13   \n",
       "642    640  2018          14   \n",
       "413    412  2018          25   \n",
       "74      75  2018          41   \n",
       "36      37  2018           1   \n",
       "50      51  2018          16   \n",
       "556    555  2018           7   \n",
       "629    627  2018           2   \n",
       "411    410  2018          11   \n",
       "246    245  2018          26   \n",
       "607    605  2018          47   \n",
       "419    418  2018           3   \n",
       "25      26  2018          12   \n",
       "459    458  2018          43   \n",
       "370    369  2018          51   \n",
       "108    109  2018           4   \n",
       "567    566  2018          50   \n",
       "549    548  2018          20   \n",
       "95      96  2018          48   \n",
       "\n",
       "                                           NomMaterial  Quantitat Unitats  \n",
       "339                                        Voluminosos        NaN   Tones  \n",
       "390                                              Paper        NaN   Tones  \n",
       "179                                            Envasos        NaN   Tones  \n",
       "247                                              Piles        NaN   Tones  \n",
       "234                                    Fracció vegetal        NaN   Tones  \n",
       "575                                              Vidre       46.0   Tones  \n",
       "21                                              Tèxtil        NaN   Tones  \n",
       "131                            Medicaments i cosmètics        NaN   Tones  \n",
       "103                                      Olis vegetals        NaN   Tones  \n",
       "483                                              Resta    49485.0   Tones  \n",
       "581                                            Envasos        NaN   Tones  \n",
       "460                            Medicaments i cosmètics        NaN   Tones  \n",
       "177                                              Vidre      103.0   Tones  \n",
       "506                                        Voluminosos        NaN   Tones  \n",
       "182                                    Fracció vegetal        NaN   Tones  \n",
       "572                                      Olis vegetals        NaN   Tones  \n",
       "22                             Medicaments i cosmètics        NaN   Tones  \n",
       "85                                       Olis vegetals        NaN   Tones  \n",
       "445                                              Vidre      204.0   Tones  \n",
       "111                                              Resta    50894.0   Tones  \n",
       "424                                              Piles        NaN   Tones  \n",
       "151                                        Voluminosos        NaN   Tones  \n",
       "519                                    Fracció vegetal        NaN   Tones  \n",
       "201                                              Paper        NaN   Tones  \n",
       "342                                             Tèxtil        NaN   Tones  \n",
       "6                                              Envasos        NaN   Tones  \n",
       "444                                      Olis vegetals        NaN   Tones  \n",
       "363                                              Vidre      317.0   Tones  \n",
       "76                                     Fracció vegetal        NaN   Tones  \n",
       "33                                               Piles        NaN   Tones  \n",
       "..                                                 ...        ...     ...  \n",
       "706                                         Comburents        6.0   Tones  \n",
       "327  RAEE FRA 4 (A2) Altres aparells amb tamany sup...       41.0   Tones  \n",
       "12                                               Resta    60747.0   Tones  \n",
       "693                             Reactius de laboratori        0.0   Tones  \n",
       "303                                              Àcids        0.0   Tones  \n",
       "439                                           Ferralla      120.0   Tones  \n",
       "740                                           Porexpan        1.0   Tones  \n",
       "313                                              Coure        1.0   Tones  \n",
       "40                                     Fracció vegetal      112.0   Tones  \n",
       "438                                             Tòners        3.0   Tones  \n",
       "543                                        Voluminosos     4144.0   Tones  \n",
       "215                                              Fusta     1700.0   Tones  \n",
       "642                                              Runes     3268.0   Tones  \n",
       "413                                      Olis vegetals       10.0   Tones  \n",
       "74                                            Porexpan        1.0   Tones  \n",
       "36                                               Vidre     2775.0   Tones  \n",
       "50                                               Piles        0.0   Tones  \n",
       "556                                              Resta    46530.0   Tones  \n",
       "629                                              Paper     3613.0   Tones  \n",
       "411                                          Vidre Pla      249.0   Tones  \n",
       "246                                      Olis minerals        4.0   Tones  \n",
       "607  RAEE FRA 2 (A3) Monitors i pantalles LED, CRT ...       28.0   Tones  \n",
       "419                                            Envasos     2576.0   Tones  \n",
       "25                                            Ferralla      158.0   Tones  \n",
       "459                                      Plàstic rígid       34.0   Tones  \n",
       "370  RAEE FRA 6 (A4) Aparells petits d'informàtica ...       16.0   Tones  \n",
       "108                                   Materia orgànica     4088.0   Tones  \n",
       "567  RAEE FRA 5 (A4) Petits aparells sense dimensió...       18.0   Tones  \n",
       "549                                           Bateries        2.0   Tones  \n",
       "95             RAEE FRA 3 (A5) Lampares i fluorescents        2.0   Tones  \n",
       "\n",
       "[796 rows x 6 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.read_csv(\"DadesSabadell/residus.csv\",sep=';')\n",
    "df.sort_values(by=\"Anyo\",inplace = True)\n",
    "\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "45 diferent types of wastes:\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "['Voluminosos',\n",
       " 'Paper',\n",
       " 'Envasos',\n",
       " 'Piles',\n",
       " 'Fracció vegetal',\n",
       " 'Vidre',\n",
       " 'Tèxtil',\n",
       " 'Medicaments i cosmètics',\n",
       " 'Olis vegetals',\n",
       " 'Ferralla',\n",
       " 'Vidre Pla',\n",
       " 'Runes',\n",
       " 'Fusta',\n",
       " 'Sòlids i Pastosos',\n",
       " 'Àcids',\n",
       " 'Aerosols',\n",
       " 'RAEE A1: Aparells de fred, frigorífics...',\n",
       " 'Tòners',\n",
       " 'Olis minerals',\n",
       " 'Dissolvents',\n",
       " 'Reactius de laboratori',\n",
       " 'Pneumàtics',\n",
       " 'RAEE A3: Televisors i monitors',\n",
       " 'Comburents',\n",
       " 'RAEE A2: Grans electrodomèstics assecadores, rentadores...',\n",
       " 'Coure',\n",
       " 'Càpsules de cafè',\n",
       " 'RAEE A5: làmpares fluorescents',\n",
       " 'Bases',\n",
       " 'Bateries',\n",
       " 'Medicaments',\n",
       " 'RAEE A4: Ordinadors, aspiradores, joguines elèctriques i electròniques....',\n",
       " 'Altres residus especials',\n",
       " 'Materia orgànica',\n",
       " 'Radiografies',\n",
       " 'Porexpan',\n",
       " 'Plàstic rígid',\n",
       " 'Cd i DVD',\n",
       " 'Cartró',\n",
       " \"RAEE FRA 6 (A4) Aparells petits d'informàtica i telecomunicacions \",\n",
       " 'RAEE FRA 5 (A4) Petits aparells sense dimensió superior a 50 cm',\n",
       " 'RAEE FRA 4 (A2) Altres aparells amb tamany superior a 50 cm no inclosos en FRA 1',\n",
       " 'RAEE FRA 3 (A5) Lampares i fluorescents',\n",
       " 'RAEE FRA 2 (A3) Monitors i pantalles LED, CRT i altres',\n",
       " \"RAEE FRA (A1) Grans aparells d'intercanvi de temperatura, frigotrifics, aire acondicionat...\"]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "materials = list(df.NomMaterial.unique())\n",
    "materials.remove(\"Resta\")\n",
    "\n",
    "print ('{} diferent types of wastes:'.format(len(materials)))\n",
    "materials"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>Anyo</th>\n",
       "      <th>1984</th>\n",
       "      <th>1985</th>\n",
       "      <th>1986</th>\n",
       "      <th>1987</th>\n",
       "      <th>1988</th>\n",
       "      <th>1989</th>\n",
       "      <th>1990</th>\n",
       "      <th>1991</th>\n",
       "      <th>1992</th>\n",
       "      <th>1993</th>\n",
       "      <th>...</th>\n",
       "      <th>2009</th>\n",
       "      <th>2010</th>\n",
       "      <th>2011</th>\n",
       "      <th>2012</th>\n",
       "      <th>2013</th>\n",
       "      <th>2014</th>\n",
       "      <th>2015</th>\n",
       "      <th>2016</th>\n",
       "      <th>2017</th>\n",
       "      <th>2018</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NomMaterial</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Aerosols</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Altres residus especials</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>37.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bases</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bateries</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>13.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cartró</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>52.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cd i DVD</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Comburents</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Coure</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Càpsules de cafè</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dissolvents</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>7.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Envasos</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4244.0</td>\n",
       "      <td>4318.0</td>\n",
       "      <td>4340.0</td>\n",
       "      <td>4057.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3999.0</td>\n",
       "      <td>3329.0</td>\n",
       "      <td>2665.0</td>\n",
       "      <td>2806.0</td>\n",
       "      <td>2576.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ferralla</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>378.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>166.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>111.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>109.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>158.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fracció vegetal</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>859.0</td>\n",
       "      <td>1040.0</td>\n",
       "      <td>345.0</td>\n",
       "      <td>137.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>274.0</td>\n",
       "      <td>867.0</td>\n",
       "      <td>559.0</td>\n",
       "      <td>112.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fusta</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2423.0</td>\n",
       "      <td>2568.0</td>\n",
       "      <td>2326.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1876.0</td>\n",
       "      <td>948.0</td>\n",
       "      <td>1233.0</td>\n",
       "      <td>1548.0</td>\n",
       "      <td>2279.0</td>\n",
       "      <td>1700.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Materia orgànica</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>6799.0</td>\n",
       "      <td>6896.0</td>\n",
       "      <td>7131.0</td>\n",
       "      <td>6924.0</td>\n",
       "      <td>7069.0</td>\n",
       "      <td>6596.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4897.0</td>\n",
       "      <td>4718.0</td>\n",
       "      <td>4088.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Medicaments</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>18.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Medicaments i cosmètics</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Olis minerals</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>26.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Olis vegetals</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>24.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Paper</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9029.0</td>\n",
       "      <td>7091.0</td>\n",
       "      <td>4971.0</td>\n",
       "      <td>4429.0</td>\n",
       "      <td>4340.0</td>\n",
       "      <td>3923.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4097.0</td>\n",
       "      <td>3613.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Piles</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>22.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Plàstic rígid</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>126.0</td>\n",
       "      <td>113.0</td>\n",
       "      <td>102.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>34.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pneumàtics</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>24.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Porexpan</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>24.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAEE A1: Aparells de fred, frigorífics...</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>34.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAEE A2: Grans electrodomèstics assecadores, rentadores...</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>66.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>36.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAEE A3: Televisors i monitors</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>159.0</td>\n",
       "      <td>107.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAEE A4: Ordinadors, aspiradores, joguines elèctriques i electròniques....</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>87.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>47.0</td>\n",
       "      <td>43.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAEE A5: làmpares fluorescents</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAEE FRA (A1) Grans aparells d'intercanvi de temperatura, frigotrifics, aire acondicionat...</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAEE FRA 2 (A3) Monitors i pantalles LED, CRT i altres</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>28.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAEE FRA 3 (A5) Lampares i fluorescents</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAEE FRA 4 (A2) Altres aparells amb tamany superior a 50 cm no inclosos en FRA 1</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAEE FRA 5 (A4) Petits aparells sense dimensió superior a 50 cm</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>18.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAEE FRA 6 (A4) Aparells petits d'informàtica i telecomunicacions</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Radiografies</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Reactius de laboratori</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Resta</th>\n",
       "      <td>NaN</td>\n",
       "      <td>49485.0</td>\n",
       "      <td>50894.0</td>\n",
       "      <td>54649.0</td>\n",
       "      <td>57987.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>63035.0</td>\n",
       "      <td>71728.0</td>\n",
       "      <td>77390.0</td>\n",
       "      <td>78710.0</td>\n",
       "      <td>...</td>\n",
       "      <td>69412.0</td>\n",
       "      <td>67551.0</td>\n",
       "      <td>64594.0</td>\n",
       "      <td>60046.0</td>\n",
       "      <td>56172.0</td>\n",
       "      <td>57009.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>61177.0</td>\n",
       "      <td>60747.0</td>\n",
       "      <td>46530.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Runes</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2905.0</td>\n",
       "      <td>3577.0</td>\n",
       "      <td>4565.0</td>\n",
       "      <td>4556.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3229.0</td>\n",
       "      <td>3387.0</td>\n",
       "      <td>4225.0</td>\n",
       "      <td>4299.0</td>\n",
       "      <td>3268.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sòlids i Pastosos</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>58.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>33.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>39.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tèxtil</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>200.0</td>\n",
       "      <td>213.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>195.0</td>\n",
       "      <td>277.0</td>\n",
       "      <td>273.0</td>\n",
       "      <td>344.0</td>\n",
       "      <td>391.0</td>\n",
       "      <td>408.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tòners</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vidre</th>\n",
       "      <td>46.0</td>\n",
       "      <td>103.0</td>\n",
       "      <td>204.0</td>\n",
       "      <td>317.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>373.0</td>\n",
       "      <td>397.0</td>\n",
       "      <td>560.0</td>\n",
       "      <td>735.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>3266.0</td>\n",
       "      <td>3129.0</td>\n",
       "      <td>3040.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3107.0</td>\n",
       "      <td>2956.0</td>\n",
       "      <td>3129.0</td>\n",
       "      <td>3030.0</td>\n",
       "      <td>3112.0</td>\n",
       "      <td>2775.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vidre Pla</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>409.0</td>\n",
       "      <td>379.0</td>\n",
       "      <td>332.0</td>\n",
       "      <td>285.0</td>\n",
       "      <td>293.0</td>\n",
       "      <td>276.0</td>\n",
       "      <td>342.0</td>\n",
       "      <td>322.0</td>\n",
       "      <td>301.0</td>\n",
       "      <td>249.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Voluminosos</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4544.0</td>\n",
       "      <td>4496.0</td>\n",
       "      <td>1866.0</td>\n",
       "      <td>1656.0</td>\n",
       "      <td>4160.0</td>\n",
       "      <td>4540.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5606.0</td>\n",
       "      <td>4144.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Àcids</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>46 rows × 35 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Anyo                                                1984     1985     1986  \\\n",
       "NomMaterial                                                                  \n",
       "Aerosols                                             NaN      NaN      NaN   \n",
       "Altres residus especials                             NaN      NaN      NaN   \n",
       "Bases                                                NaN      NaN      NaN   \n",
       "Bateries                                             NaN      NaN      NaN   \n",
       "Cartró                                               NaN      NaN      NaN   \n",
       "Cd i DVD                                             NaN      NaN      NaN   \n",
       "Comburents                                           NaN      NaN      NaN   \n",
       "Coure                                                NaN      NaN      NaN   \n",
       "Càpsules de cafè                                     NaN      NaN      NaN   \n",
       "Dissolvents                                          NaN      NaN      NaN   \n",
       "Envasos                                              NaN      NaN      NaN   \n",
       "Ferralla                                             NaN      NaN      NaN   \n",
       "Fracció vegetal                                      NaN      NaN      NaN   \n",
       "Fusta                                                NaN      NaN      NaN   \n",
       "Materia orgànica                                     NaN      NaN      NaN   \n",
       "Medicaments                                          NaN      NaN      NaN   \n",
       "Medicaments i cosmètics                              NaN      NaN      NaN   \n",
       "Olis minerals                                        NaN      NaN      NaN   \n",
       "Olis vegetals                                        NaN      NaN      NaN   \n",
       "Paper                                                NaN      NaN      NaN   \n",
       "Piles                                                NaN      NaN      NaN   \n",
       "Plàstic rígid                                        NaN      NaN      NaN   \n",
       "Pneumàtics                                           NaN      NaN      NaN   \n",
       "Porexpan                                             NaN      NaN      NaN   \n",
       "RAEE A1: Aparells de fred, frigorífics...            NaN      NaN      NaN   \n",
       "RAEE A2: Grans electrodomèstics assecadores, re...   NaN      NaN      NaN   \n",
       "RAEE A3: Televisors i monitors                       NaN      NaN      NaN   \n",
       "RAEE A4: Ordinadors, aspiradores, joguines elèc...   NaN      NaN      NaN   \n",
       "RAEE A5: làmpares fluorescents                       NaN      NaN      NaN   \n",
       "RAEE FRA (A1) Grans aparells d'intercanvi de te...   NaN      NaN      NaN   \n",
       "RAEE FRA 2 (A3) Monitors i pantalles LED, CRT i...   NaN      NaN      NaN   \n",
       "RAEE FRA 3 (A5) Lampares i fluorescents              NaN      NaN      NaN   \n",
       "RAEE FRA 4 (A2) Altres aparells amb tamany supe...   NaN      NaN      NaN   \n",
       "RAEE FRA 5 (A4) Petits aparells sense dimensió ...   NaN      NaN      NaN   \n",
       "RAEE FRA 6 (A4) Aparells petits d'informàtica i...   NaN      NaN      NaN   \n",
       "Radiografies                                         NaN      NaN      NaN   \n",
       "Reactius de laboratori                               NaN      NaN      NaN   \n",
       "Resta                                                NaN  49485.0  50894.0   \n",
       "Runes                                                NaN      NaN      NaN   \n",
       "Sòlids i Pastosos                                    NaN      NaN      NaN   \n",
       "Tèxtil                                               NaN      NaN      NaN   \n",
       "Tòners                                               NaN      NaN      NaN   \n",
       "Vidre                                               46.0    103.0    204.0   \n",
       "Vidre Pla                                            NaN      NaN      NaN   \n",
       "Voluminosos                                          NaN      NaN      NaN   \n",
       "Àcids                                                NaN      NaN      NaN   \n",
       "\n",
       "Anyo                                                   1987     1988   1989  \\\n",
       "NomMaterial                                                                   \n",
       "Aerosols                                                NaN      NaN    NaN   \n",
       "Altres residus especials                                NaN      NaN    NaN   \n",
       "Bases                                                   NaN      NaN    NaN   \n",
       "Bateries                                                NaN      NaN    NaN   \n",
       "Cartró                                                  NaN      NaN    NaN   \n",
       "Cd i DVD                                                NaN      NaN    NaN   \n",
       "Comburents                                              NaN      NaN    NaN   \n",
       "Coure                                                   NaN      NaN    NaN   \n",
       "Càpsules de cafè                                        NaN      NaN    NaN   \n",
       "Dissolvents                                             NaN      NaN    NaN   \n",
       "Envasos                                                 NaN      NaN    NaN   \n",
       "Ferralla                                                NaN      NaN    NaN   \n",
       "Fracció vegetal                                         NaN      NaN    NaN   \n",
       "Fusta                                                   NaN      NaN    NaN   \n",
       "Materia orgànica                                        NaN      NaN    NaN   \n",
       "Medicaments                                             NaN      NaN    NaN   \n",
       "Medicaments i cosmètics                                 NaN      NaN    NaN   \n",
       "Olis minerals                                           NaN      NaN    NaN   \n",
       "Olis vegetals                                           NaN      NaN    NaN   \n",
       "Paper                                                   NaN      NaN    NaN   \n",
       "Piles                                                   NaN      NaN    NaN   \n",
       "Plàstic rígid                                           NaN      NaN    NaN   \n",
       "Pneumàtics                                              NaN      NaN    NaN   \n",
       "Porexpan                                                NaN      NaN    NaN   \n",
       "RAEE A1: Aparells de fred, frigorífics...               NaN      NaN    NaN   \n",
       "RAEE A2: Grans electrodomèstics assecadores, re...      NaN      NaN    NaN   \n",
       "RAEE A3: Televisors i monitors                          NaN      NaN    NaN   \n",
       "RAEE A4: Ordinadors, aspiradores, joguines elèc...      NaN      NaN    NaN   \n",
       "RAEE A5: làmpares fluorescents                          NaN      NaN    NaN   \n",
       "RAEE FRA (A1) Grans aparells d'intercanvi de te...      NaN      NaN    NaN   \n",
       "RAEE FRA 2 (A3) Monitors i pantalles LED, CRT i...      NaN      NaN    NaN   \n",
       "RAEE FRA 3 (A5) Lampares i fluorescents                 NaN      NaN    NaN   \n",
       "RAEE FRA 4 (A2) Altres aparells amb tamany supe...      NaN      NaN    NaN   \n",
       "RAEE FRA 5 (A4) Petits aparells sense dimensió ...      NaN      NaN    NaN   \n",
       "RAEE FRA 6 (A4) Aparells petits d'informàtica i...      NaN      NaN    NaN   \n",
       "Radiografies                                            NaN      NaN    NaN   \n",
       "Reactius de laboratori                                  NaN      NaN    NaN   \n",
       "Resta                                               54649.0  57987.0    NaN   \n",
       "Runes                                                   NaN      NaN    NaN   \n",
       "Sòlids i Pastosos                                       NaN      NaN    NaN   \n",
       "Tèxtil                                                  NaN      NaN    NaN   \n",
       "Tòners                                                  NaN      NaN    NaN   \n",
       "Vidre                                                 317.0      NaN  373.0   \n",
       "Vidre Pla                                               NaN      NaN    NaN   \n",
       "Voluminosos                                             NaN      NaN    NaN   \n",
       "Àcids                                                   NaN      NaN    NaN   \n",
       "\n",
       "Anyo                                                   1990     1991     1992  \\\n",
       "NomMaterial                                                                     \n",
       "Aerosols                                                NaN      NaN      NaN   \n",
       "Altres residus especials                                NaN      NaN      NaN   \n",
       "Bases                                                   NaN      NaN      NaN   \n",
       "Bateries                                                NaN      NaN      NaN   \n",
       "Cartró                                                  NaN      NaN      NaN   \n",
       "Cd i DVD                                                NaN      NaN      NaN   \n",
       "Comburents                                              NaN      NaN      NaN   \n",
       "Coure                                                   NaN      NaN      NaN   \n",
       "Càpsules de cafè                                        NaN      NaN      NaN   \n",
       "Dissolvents                                             NaN      NaN      NaN   \n",
       "Envasos                                                 NaN      NaN      NaN   \n",
       "Ferralla                                                NaN      NaN      NaN   \n",
       "Fracció vegetal                                         NaN      NaN      NaN   \n",
       "Fusta                                                   NaN      NaN      NaN   \n",
       "Materia orgànica                                        NaN      NaN      NaN   \n",
       "Medicaments                                             NaN      NaN      NaN   \n",
       "Medicaments i cosmètics                                 NaN      NaN      NaN   \n",
       "Olis minerals                                           NaN      NaN      NaN   \n",
       "Olis vegetals                                           NaN      NaN      NaN   \n",
       "Paper                                                   NaN      NaN      NaN   \n",
       "Piles                                                   NaN      NaN      NaN   \n",
       "Plàstic rígid                                           NaN      NaN      NaN   \n",
       "Pneumàtics                                              NaN      NaN      NaN   \n",
       "Porexpan                                                NaN      NaN      NaN   \n",
       "RAEE A1: Aparells de fred, frigorífics...               NaN      NaN      NaN   \n",
       "RAEE A2: Grans electrodomèstics assecadores, re...      NaN      NaN      NaN   \n",
       "RAEE A3: Televisors i monitors                          NaN      NaN      NaN   \n",
       "RAEE A4: Ordinadors, aspiradores, joguines elèc...      NaN      NaN      NaN   \n",
       "RAEE A5: làmpares fluorescents                          NaN      NaN      NaN   \n",
       "RAEE FRA (A1) Grans aparells d'intercanvi de te...      NaN      NaN      NaN   \n",
       "RAEE FRA 2 (A3) Monitors i pantalles LED, CRT i...      NaN      NaN      NaN   \n",
       "RAEE FRA 3 (A5) Lampares i fluorescents                 NaN      NaN      NaN   \n",
       "RAEE FRA 4 (A2) Altres aparells amb tamany supe...      NaN      NaN      NaN   \n",
       "RAEE FRA 5 (A4) Petits aparells sense dimensió ...      NaN      NaN      NaN   \n",
       "RAEE FRA 6 (A4) Aparells petits d'informàtica i...      NaN      NaN      NaN   \n",
       "Radiografies                                            NaN      NaN      NaN   \n",
       "Reactius de laboratori                                  NaN      NaN      NaN   \n",
       "Resta                                               63035.0  71728.0  77390.0   \n",
       "Runes                                                   NaN      NaN      NaN   \n",
       "Sòlids i Pastosos                                       NaN      NaN      NaN   \n",
       "Tèxtil                                                  NaN      NaN      NaN   \n",
       "Tòners                                                  NaN      NaN      NaN   \n",
       "Vidre                                                 397.0    560.0    735.0   \n",
       "Vidre Pla                                               NaN      NaN      NaN   \n",
       "Voluminosos                                             NaN      NaN      NaN   \n",
       "Àcids                                                   NaN      NaN      NaN   \n",
       "\n",
       "Anyo                                                   1993   ...        2009  \\\n",
       "NomMaterial                                                   ...               \n",
       "Aerosols                                                NaN   ...         1.0   \n",
       "Altres residus especials                                NaN   ...         1.0   \n",
       "Bases                                                   NaN   ...         0.0   \n",
       "Bateries                                                NaN   ...        13.0   \n",
       "Cartró                                                  NaN   ...         NaN   \n",
       "Cd i DVD                                                NaN   ...         0.0   \n",
       "Comburents                                              NaN   ...         0.0   \n",
       "Coure                                                   NaN   ...         1.0   \n",
       "Càpsules de cafè                                        NaN   ...         3.0   \n",
       "Dissolvents                                             NaN   ...         7.0   \n",
       "Envasos                                                 NaN   ...      4244.0   \n",
       "Ferralla                                                NaN   ...       378.0   \n",
       "Fracció vegetal                                         NaN   ...       859.0   \n",
       "Fusta                                                   NaN   ...      2423.0   \n",
       "Materia orgànica                                        NaN   ...      6799.0   \n",
       "Medicaments                                             NaN   ...        18.0   \n",
       "Medicaments i cosmètics                                 NaN   ...         0.0   \n",
       "Olis minerals                                           NaN   ...        26.0   \n",
       "Olis vegetals                                           NaN   ...        24.0   \n",
       "Paper                                                   NaN   ...         NaN   \n",
       "Piles                                                   NaN   ...        22.0   \n",
       "Plàstic rígid                                           NaN   ...       126.0   \n",
       "Pneumàtics                                              NaN   ...        24.0   \n",
       "Porexpan                                                NaN   ...        24.0   \n",
       "RAEE A1: Aparells de fred, frigorífics...               NaN   ...        34.0   \n",
       "RAEE A2: Grans electrodomèstics assecadores, re...      NaN   ...        66.0   \n",
       "RAEE A3: Televisors i monitors                          NaN   ...         NaN   \n",
       "RAEE A4: Ordinadors, aspiradores, joguines elèc...      NaN   ...         NaN   \n",
       "RAEE A5: làmpares fluorescents                          NaN   ...         9.0   \n",
       "RAEE FRA (A1) Grans aparells d'intercanvi de te...      NaN   ...         NaN   \n",
       "RAEE FRA 2 (A3) Monitors i pantalles LED, CRT i...      NaN   ...         NaN   \n",
       "RAEE FRA 3 (A5) Lampares i fluorescents                 NaN   ...         NaN   \n",
       "RAEE FRA 4 (A2) Altres aparells amb tamany supe...      NaN   ...         NaN   \n",
       "RAEE FRA 5 (A4) Petits aparells sense dimensió ...      NaN   ...         NaN   \n",
       "RAEE FRA 6 (A4) Aparells petits d'informàtica i...      NaN   ...         NaN   \n",
       "Radiografies                                            NaN   ...         NaN   \n",
       "Reactius de laboratori                                  NaN   ...         2.0   \n",
       "Resta                                               78710.0   ...     69412.0   \n",
       "Runes                                                   NaN   ...      2905.0   \n",
       "Sòlids i Pastosos                                       NaN   ...        58.0   \n",
       "Tèxtil                                                  NaN   ...       200.0   \n",
       "Tòners                                                  NaN   ...         0.0   \n",
       "Vidre                                                   NaN   ...      3266.0   \n",
       "Vidre Pla                                               NaN   ...       409.0   \n",
       "Voluminosos                                             NaN   ...         NaN   \n",
       "Àcids                                                   NaN   ...         NaN   \n",
       "\n",
       "Anyo                                                   2010     2011     2012  \\\n",
       "NomMaterial                                                                     \n",
       "Aerosols                                                1.0      1.0      0.0   \n",
       "Altres residus especials                                1.0      1.0      2.0   \n",
       "Bases                                                   0.0      0.0      0.0   \n",
       "Bateries                                               12.0      9.0     14.0   \n",
       "Cartró                                                  NaN     52.0     20.0   \n",
       "Cd i DVD                                                2.0      NaN      1.0   \n",
       "Comburents                                              0.0      0.0      0.0   \n",
       "Coure                                                   1.0      1.0      NaN   \n",
       "Càpsules de cafè                                        NaN      NaN      NaN   \n",
       "Dissolvents                                             8.0      NaN      4.0   \n",
       "Envasos                                              4318.0   4340.0   4057.0   \n",
       "Ferralla                                                NaN    166.0     98.0   \n",
       "Fracció vegetal                                      1040.0    345.0    137.0   \n",
       "Fusta                                                2568.0   2326.0      NaN   \n",
       "Materia orgànica                                     6896.0   7131.0   6924.0   \n",
       "Medicaments                                            19.0      NaN      NaN   \n",
       "Medicaments i cosmètics                                 NaN      0.0      0.0   \n",
       "Olis minerals                                           NaN     15.0     12.0   \n",
       "Olis vegetals                                          29.0     28.0     26.0   \n",
       "Paper                                                9029.0   7091.0   4971.0   \n",
       "Piles                                                  22.0      9.0     16.0   \n",
       "Plàstic rígid                                         113.0    102.0     70.0   \n",
       "Pneumàtics                                              7.0      NaN      NaN   \n",
       "Porexpan                                                9.0     14.0      1.0   \n",
       "RAEE A1: Aparells de fred, frigorífics...              69.0     16.0      NaN   \n",
       "RAEE A2: Grans electrodomèstics assecadores, re...      NaN     40.0     27.0   \n",
       "RAEE A3: Televisors i monitors                        159.0    107.0     69.0   \n",
       "RAEE A4: Ordinadors, aspiradores, joguines elèc...     87.0     73.0     57.0   \n",
       "RAEE A5: làmpares fluorescents                          NaN      6.0      4.0   \n",
       "RAEE FRA (A1) Grans aparells d'intercanvi de te...      NaN      NaN      NaN   \n",
       "RAEE FRA 2 (A3) Monitors i pantalles LED, CRT i...      NaN      NaN      NaN   \n",
       "RAEE FRA 3 (A5) Lampares i fluorescents                 NaN      NaN      NaN   \n",
       "RAEE FRA 4 (A2) Altres aparells amb tamany supe...      NaN      NaN      NaN   \n",
       "RAEE FRA 5 (A4) Petits aparells sense dimensió ...      NaN      NaN      NaN   \n",
       "RAEE FRA 6 (A4) Aparells petits d'informàtica i...      NaN      NaN      NaN   \n",
       "Radiografies                                            NaN      NaN      1.0   \n",
       "Reactius de laboratori                                  NaN      2.0      1.0   \n",
       "Resta                                               67551.0  64594.0  60046.0   \n",
       "Runes                                                3577.0   4565.0   4556.0   \n",
       "Sòlids i Pastosos                                      57.0     45.0     20.0   \n",
       "Tèxtil                                                213.0      NaN    195.0   \n",
       "Tòners                                                  NaN      NaN      NaN   \n",
       "Vidre                                                3129.0   3040.0      NaN   \n",
       "Vidre Pla                                             379.0    332.0    285.0   \n",
       "Voluminosos                                          4544.0   4496.0   1866.0   \n",
       "Àcids                                                   0.0      0.0      0.0   \n",
       "\n",
       "Anyo                                                   2013     2014    2015  \\\n",
       "NomMaterial                                                                    \n",
       "Aerosols                                                NaN      1.0     NaN   \n",
       "Altres residus especials                               37.0      NaN     NaN   \n",
       "Bases                                                   NaN      0.0     NaN   \n",
       "Bateries                                               26.0      NaN     3.0   \n",
       "Cartró                                                  NaN      NaN     NaN   \n",
       "Cd i DVD                                                1.0      1.0     NaN   \n",
       "Comburents                                              NaN      NaN     NaN   \n",
       "Coure                                                   0.0      0.0     0.0   \n",
       "Càpsules de cafè                                        NaN      NaN     NaN   \n",
       "Dissolvents                                             6.0      5.0     NaN   \n",
       "Envasos                                                 NaN   3999.0  3329.0   \n",
       "Ferralla                                              111.0    127.0     NaN   \n",
       "Fracció vegetal                                       400.0      NaN   274.0   \n",
       "Fusta                                                1876.0    948.0  1233.0   \n",
       "Materia orgànica                                     7069.0   6596.0     NaN   \n",
       "Medicaments                                             NaN      NaN     NaN   \n",
       "Medicaments i cosmètics                                 NaN      3.0     NaN   \n",
       "Olis minerals                                          10.0      8.0     9.0   \n",
       "Olis vegetals                                           NaN     34.0    19.0   \n",
       "Paper                                                4429.0   4340.0  3923.0   \n",
       "Piles                                                  14.0     15.0     4.0   \n",
       "Plàstic rígid                                          86.0     45.0    33.0   \n",
       "Pneumàtics                                             20.0     15.0    15.0   \n",
       "Porexpan                                                1.0      1.0    10.0   \n",
       "RAEE A1: Aparells de fred, frigorífics...              12.0     15.0    20.0   \n",
       "RAEE A2: Grans electrodomèstics assecadores, re...     22.0     23.0    31.0   \n",
       "RAEE A3: Televisors i monitors                         63.0     56.0    52.0   \n",
       "RAEE A4: Ordinadors, aspiradores, joguines elèc...     49.0      NaN    47.0   \n",
       "RAEE A5: làmpares fluorescents                          3.0      7.0     NaN   \n",
       "RAEE FRA (A1) Grans aparells d'intercanvi de te...      NaN      NaN     NaN   \n",
       "RAEE FRA 2 (A3) Monitors i pantalles LED, CRT i...      NaN      NaN     NaN   \n",
       "RAEE FRA 3 (A5) Lampares i fluorescents                 NaN      NaN     NaN   \n",
       "RAEE FRA 4 (A2) Altres aparells amb tamany supe...      NaN      NaN     NaN   \n",
       "RAEE FRA 5 (A4) Petits aparells sense dimensió ...      NaN      NaN     NaN   \n",
       "RAEE FRA 6 (A4) Aparells petits d'informàtica i...      NaN      NaN     NaN   \n",
       "Radiografies                                            0.0      NaN     0.0   \n",
       "Reactius de laboratori                                  NaN      0.0     NaN   \n",
       "Resta                                               56172.0  57009.0     NaN   \n",
       "Runes                                                   NaN   3229.0  3387.0   \n",
       "Sòlids i Pastosos                                       NaN     33.0     NaN   \n",
       "Tèxtil                                                277.0    273.0   344.0   \n",
       "Tòners                                                  NaN      NaN     NaN   \n",
       "Vidre                                                3107.0   2956.0  3129.0   \n",
       "Vidre Pla                                             293.0    276.0   342.0   \n",
       "Voluminosos                                          1656.0   4160.0  4540.0   \n",
       "Àcids                                                   NaN      0.0     NaN   \n",
       "\n",
       "Anyo                                                   2016     2017     2018  \n",
       "NomMaterial                                                                    \n",
       "Aerosols                                                NaN      NaN      NaN  \n",
       "Altres residus especials                                NaN      6.0      NaN  \n",
       "Bases                                                   NaN      1.0      NaN  \n",
       "Bateries                                                3.0      2.0      2.0  \n",
       "Cartró                                                  NaN      NaN      NaN  \n",
       "Cd i DVD                                                NaN      1.0      NaN  \n",
       "Comburents                                              NaN      6.0      NaN  \n",
       "Coure                                                   1.0      0.0      1.0  \n",
       "Càpsules de cafè                                        NaN      2.0      NaN  \n",
       "Dissolvents                                             NaN      9.0      NaN  \n",
       "Envasos                                              2665.0   2806.0   2576.0  \n",
       "Ferralla                                              109.0    120.0    158.0  \n",
       "Fracció vegetal                                       867.0    559.0    112.0  \n",
       "Fusta                                                1548.0   2279.0   1700.0  \n",
       "Materia orgànica                                     4897.0   4718.0   4088.0  \n",
       "Medicaments                                             NaN      NaN      NaN  \n",
       "Medicaments i cosmètics                                 NaN      1.0      NaN  \n",
       "Olis minerals                                           8.0      NaN      4.0  \n",
       "Olis vegetals                                          33.0     31.0     10.0  \n",
       "Paper                                                   NaN   4097.0   3613.0  \n",
       "Piles                                                   0.0      6.0      0.0  \n",
       "Plàstic rígid                                          44.0     43.0     34.0  \n",
       "Pneumàtics                                              3.0      9.0      NaN  \n",
       "Porexpan                                                0.0      1.0      1.0  \n",
       "RAEE A1: Aparells de fred, frigorífics...              26.0      NaN      NaN  \n",
       "RAEE A2: Grans electrodomèstics assecadores, re...     36.0      NaN      NaN  \n",
       "RAEE A3: Televisors i monitors                          NaN      NaN      NaN  \n",
       "RAEE A4: Ordinadors, aspiradores, joguines elèc...     43.0      NaN      NaN  \n",
       "RAEE A5: làmpares fluorescents                          3.0      NaN      NaN  \n",
       "RAEE FRA (A1) Grans aparells d'intercanvi de te...      5.0     39.0      NaN  \n",
       "RAEE FRA 2 (A3) Monitors i pantalles LED, CRT i...     13.0     51.0     28.0  \n",
       "RAEE FRA 3 (A5) Lampares i fluorescents                 1.0      2.0      2.0  \n",
       "RAEE FRA 4 (A2) Altres aparells amb tamany supe...      4.0     41.0      NaN  \n",
       "RAEE FRA 5 (A4) Petits aparells sense dimensió ...      6.0     34.0     18.0  \n",
       "RAEE FRA 6 (A4) Aparells petits d'informàtica i...      4.0     27.0     16.0  \n",
       "Radiografies                                            NaN      0.0      NaN  \n",
       "Reactius de laboratori                                  NaN      0.0      NaN  \n",
       "Resta                                               61177.0  60747.0  46530.0  \n",
       "Runes                                                4225.0   4299.0   3268.0  \n",
       "Sòlids i Pastosos                                       NaN     39.0      NaN  \n",
       "Tèxtil                                                391.0    408.0      NaN  \n",
       "Tòners                                                  0.0      4.0      3.0  \n",
       "Vidre                                                3030.0   3112.0   2775.0  \n",
       "Vidre Pla                                             322.0    301.0    249.0  \n",
       "Voluminosos                                             NaN   5606.0   4144.0  \n",
       "Àcids                                                   NaN      0.0      NaN  \n",
       "\n",
       "[46 rows x 35 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.pivot_table(df,columns=\"Anyo\", index = \"NomMaterial\", values=\"Quantitat\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "All is prepared to plot our data. We are going to us Dash (web-based interfaces in Python) to plot information and give them interactivity.\n",
    "\n",
    "If you are interested to learn more about Dash you can follow the offical [tutorial.](https://dash.plot.ly/)\n",
    "\n",
    "[Dash installation:](https://dash.plot.ly/installation)\n",
    "\n",
    "* **pip install dash**  # The core dash backend\n",
    "* **pip install dash-html-components**  # HTML components\n",
    "* **pip install dash-core-components**  # Supercharged components\n",
    "* **pip install dash-table**  # Interactive DataTable component (new!)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Overwriting my_app1.py\n"
     ]
    }
   ],
   "source": [
    "%%writefile my_app1.py\n",
    "#Dash empty structure\n",
    "import dash\n",
    "import dash_core_components as dcc\n",
    "import dash_html_components as html\n",
    "\n",
    "app = dash.Dash()\n",
    "\n",
    "app.layout = html.Div('Hello Dash!')\n",
    "\n",
    "if __name__ == '__main__':\n",
    "    app.run_server(debug=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * Running on http://127.0.0.1:8050/ (Press CTRL+C to quit)\n",
      " * Restarting with stat\n",
      " * Debugger is active!\n",
      " * Debugger PIN: 102-099-753\n",
      "127.0.0.1 - - [27/Jan/2019 20:10:15] \"GET / HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [27/Jan/2019 20:10:16] \"GET /_dash-layout HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [27/Jan/2019 20:10:16] \"GET /_dash-dependencies HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [27/Jan/2019 20:10:16] \"GET /favicon.ico HTTP/1.1\" 200 -\n",
      "^C\n"
     ]
    }
   ],
   "source": [
    "!python3 my_app1.py"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Writing my_app2.py\n"
     ]
    }
   ],
   "source": [
    "%%writefile my_app2.py\n",
    "#Dash simple example\n",
    "import dash\n",
    "import dash_core_components as dcc\n",
    "import dash_html_components as html\n",
    "\n",
    "app = dash.Dash()\n",
    "\n",
    "app.layout = html.Div([html.H1(\"Hello Dash!\"),\n",
    "                       \n",
    "              html.Div('''\n",
    "                Dash: A web application framework for Python.\n",
    "              '''),\n",
    "                      \n",
    "              dcc.Graph(id='exmaple-graph',\n",
    "                        figure = {\n",
    "                            'data':[\n",
    "                                {'x': [1, 2, 3], 'y': [4.2, 1.8, 2.7], 'type': 'bar', 'name': 'Sabadell'},\n",
    "                                {'x': [1, 2, 3], 'y': [2.8, 4.9, 5.1], 'type': 'bar', 'name': 'Barcelona'},\n",
    "                            ],\n",
    "                            'layout':{\n",
    "                                'title' : 'Dash Data Visualisation'\n",
    "                            }\n",
    "              })\n",
    "])\n",
    "\n",
    "if __name__ == '__main__':\n",
    "    app.run_server(debug=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * Running on http://127.0.0.1:8050/ (Press CTRL+C to quit)\n",
      " * Restarting with stat\n",
      " * Debugger is active!\n",
      " * Debugger PIN: 102-099-753\n",
      "127.0.0.1 - - [27/Jan/2019 20:10:39] \"GET / HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [27/Jan/2019 20:10:41] \"GET /_dash-layout HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [27/Jan/2019 20:10:41] \"GET /_dash-dependencies HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [27/Jan/2019 20:10:41] \"GET /favicon.ico HTTP/1.1\" 200 -\n",
      "^C\n"
     ]
    }
   ],
   "source": [
    "!python3 my_app2.py"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Overwriting my_app3.py\n"
     ]
    }
   ],
   "source": [
    "%%writefile my_app3.py\n",
    "#Dash simple example\n",
    "import pandas as pd\n",
    "import dash\n",
    "import dash_core_components as dcc\n",
    "import dash_html_components as html\n",
    "import plotly.graph_objs as go\n",
    "from plotly import tools\n",
    "\n",
    "df = pd.read_csv(\"DadesSabadell/residus.csv\",sep=';')\n",
    "df.sort_values(by=\"Anyo\",inplace = True)\n",
    "\n",
    "materials = list(df.NomMaterial.unique())\n",
    "materials.remove(\"Resta\")\n",
    "\n",
    "pd.pivot_table(df,columns=\"Anyo\", index = \"NomMaterial\", values=\"Quantitat\")\n",
    "\n",
    "minim = 0\n",
    "maxim = 1000\n",
    "pas = 100\n",
    "\n",
    "app = dash.Dash()\n",
    "app.css.append_css({\"external_url\": \"https://codepen.io/chriddyp/pen/bWLwgP.css\"})\n",
    "\n",
    "app.layout = html.Div([html.Div([dcc.Graph(id='residus_graph')],\n",
    "                                style={'height':'80%','padding': '0px 20px 20px 20px'}),\n",
    "                                html.Div([html.H5(\"Materials amb mitjana de tones per any més grans que:\"),\n",
    "                                    dcc.Slider(id='avg-tones',step = pas,min=minim,max=maxim,value=maxim/2,       \n",
    "                                            marks={ str(tones): {'label':str(tones)} for tones in range(minim,maxim+pas,pas)})],\n",
    "                       style={'margin':'auto','height':'20%','width': '70%', 'padding': '0px 0px 40px 40px',\"display\":'inline_block'})])\n",
    "\n",
    "@app.callback(\n",
    "    dash.dependencies.Output('residus_graph', 'figure'),\n",
    "    [dash.dependencies.Input('avg-tones', 'value')])\n",
    "\n",
    "def update_figure(avg_tones):\n",
    "    fig = tools.make_subplots(rows=2, cols=1,shared_xaxes=True, vertical_spacing=0.001)\n",
    "    traces = []\n",
    "    \n",
    "    filtered= df[df['NomMaterial'] ==\"Resta\"]\n",
    "    trace_Resta = go.Scatter(\n",
    "                            x=filtered['Anyo'],y=filtered['Quantitat'],text=\"Resta\",\n",
    "                            mode='lines+markers',\n",
    "                            opacity=0.7,\n",
    "                            marker={\n",
    "                                'size': 15,\n",
    "                                'line': {'width': 0.5, 'color': 'white'}\n",
    "                            },\n",
    "                            name=\"Resta\"\n",
    "                        )  \n",
    "    \n",
    "    filtered = df[df['NomMaterial'].isin(materials)].groupby(\"Anyo\").sum()\n",
    "    trace_Total= go.Scatter(                      \n",
    "                            x=filtered.index,y=filtered['Quantitat'],text=\"Total Materials\",\n",
    "                            mode='lines+markers',\n",
    "                            opacity=0.7,\n",
    "                            marker={\n",
    "                                'size': 15,\n",
    "                                'line': {'width': 0.5, 'color': 'white'}\n",
    "                            },\n",
    "                            name=\"Total Materials\",\n",
    "                            \n",
    "                        )   \n",
    "    \n",
    "    fig.append_trace(trace_Resta, 1, 1)\n",
    "    fig.append_trace(trace_Total, 1, 1)\n",
    "    \n",
    "    for i in materials :\n",
    "        filtered= df[df['NomMaterial'] == i]\n",
    "        y=filtered['Quantitat']\n",
    "        if (y.mean()>avg_tones) :\n",
    "            x=filtered['Anyo']\n",
    "            traces.append(go.Scatter(x=x,y=y,text=i,mode='markers',opacity=0.7,\n",
    "                                marker={\n",
    "                                    'size': 15,\n",
    "                                    'line': {'width': 0.5, 'color': 'white'}\n",
    "                                }, name=i[0:30])) \n",
    "    for trace in traces:\n",
    "        fig.append_trace(trace, 2, 1)\n",
    "\n",
    "\n",
    "    fig['layout'].update(height=600,title=\"Residus a Sabadell\", margin={'l': 50, 'b': 40, 't': 40, 'r': 50},\n",
    "              yaxis1={\"title\":\"Totals\"}, yaxis2={\"title\":\"Materials\"},hovermode=\"closest\")\n",
    "    return fig\n",
    "\n",
    "\n",
    "if __name__ == '__main__':\n",
    "    app.run_server()\n",
    "    \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * Running on http://127.0.0.1:8050/ (Press CTRL+C to quit)\n",
      "127.0.0.1 - - [27/Jan/2019 20:24:48] \"GET / HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [27/Jan/2019 20:24:48] \"GET /_dash-layout HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [27/Jan/2019 20:24:48] \"GET /_dash-dependencies HTTP/1.1\" 200 -\n",
      "This is the format of your plot grid:\n",
      "[ (1,1) x1,y1 ]\n",
      "[ (2,1) x1,y2 ]\n",
      "\n",
      "127.0.0.1 - - [27/Jan/2019 20:24:53] \"POST /_dash-update-component HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [27/Jan/2019 20:24:53] \"GET /favicon.ico HTTP/1.1\" 200 -\n",
      "^C\n"
     ]
    }
   ],
   "source": [
    "!python3 my_app3.py"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "# Open Data Barcelona \n",
    "\n",
    "**EXERCICE**\n",
    "\n",
    "Using information of 2017's births in Barcelona Districts that you can find at [Open Data Barcelona](http://opendata-ajuntament.barcelona.cat/en/) that you can download [here](http://opendata-ajuntament.barcelona.cat/data/en/dataset/est-demo-naixements-sexe), try to obtain a fancy plot showing girls and boys births per different Barcelona District(Slicer is not necessary). \n",
    "\n",
    "You also can find this the CSV file with this information in `DadesBarcelona/2017_naixements_sexe.csv`\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>Any</th>\n",
       "      <th>Codi_Districte</th>\n",
       "      <th>Nom_Districte</th>\n",
       "      <th>Codi_Barri</th>\n",
       "      <th>Nom_Barri</th>\n",
       "      <th>Sexe</th>\n",
       "      <th>Nombre</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2017</td>\n",
       "      <td>1</td>\n",
       "      <td>Ciutat Vella</td>\n",
       "      <td>1</td>\n",
       "      <td>el Raval</td>\n",
       "      <td>Nens</td>\n",
       "      <td>283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2017</td>\n",
       "      <td>1</td>\n",
       "      <td>Ciutat Vella</td>\n",
       "      <td>2</td>\n",
       "      <td>el Barri Gòtic</td>\n",
       "      <td>Nens</td>\n",
       "      <td>56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2017</td>\n",
       "      <td>1</td>\n",
       "      <td>Ciutat Vella</td>\n",
       "      <td>3</td>\n",
       "      <td>la Barceloneta</td>\n",
       "      <td>Nens</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2017</td>\n",
       "      <td>1</td>\n",
       "      <td>Ciutat Vella</td>\n",
       "      <td>4</td>\n",
       "      <td>Sant Pere, Santa Caterina i la Ribera</td>\n",
       "      <td>Nens</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2017</td>\n",
       "      <td>2</td>\n",
       "      <td>Eixample</td>\n",
       "      <td>5</td>\n",
       "      <td>el Fort Pienc</td>\n",
       "      <td>Nens</td>\n",
       "      <td>117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2017</td>\n",
       "      <td>2</td>\n",
       "      <td>Eixample</td>\n",
       "      <td>6</td>\n",
       "      <td>la Sagrada Família</td>\n",
       "      <td>Nens</td>\n",
       "      <td>207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2017</td>\n",
       "      <td>2</td>\n",
       "      <td>Eixample</td>\n",
       "      <td>7</td>\n",
       "      <td>la Dreta de l'Eixample</td>\n",
       "      <td>Nens</td>\n",
       "      <td>185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2017</td>\n",
       "      <td>2</td>\n",
       "      <td>Eixample</td>\n",
       "      <td>8</td>\n",
       "      <td>l'Antiga Esquerra de l'Eixample</td>\n",
       "      <td>Nens</td>\n",
       "      <td>176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2017</td>\n",
       "      <td>2</td>\n",
       "      <td>Eixample</td>\n",
       "      <td>9</td>\n",
       "      <td>la Nova Esquerra de l'Eixample</td>\n",
       "      <td>Nens</td>\n",
       "      <td>218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2017</td>\n",
       "      <td>2</td>\n",
       "      <td>Eixample</td>\n",
       "      <td>10</td>\n",
       "      <td>Sant Antoni</td>\n",
       "      <td>Nens</td>\n",
       "      <td>172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2017</td>\n",
       "      <td>3</td>\n",
       "      <td>Sants-Montjuïc</td>\n",
       "      <td>11</td>\n",
       "      <td>el Poble Sec</td>\n",
       "      <td>Nens</td>\n",
       "      <td>156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2017</td>\n",
       "      <td>3</td>\n",
       "      <td>Sants-Montjuïc</td>\n",
       "      <td>12</td>\n",
       "      <td>la Marina del Prat Vermell</td>\n",
       "      <td>Nens</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2017</td>\n",
       "      <td>3</td>\n",
       "      <td>Sants-Montjuïc</td>\n",
       "      <td>13</td>\n",
       "      <td>la Marina de Port</td>\n",
       "      <td>Nens</td>\n",
       "      <td>119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2017</td>\n",
       "      <td>3</td>\n",
       "      <td>Sants-Montjuïc</td>\n",
       "      <td>14</td>\n",
       "      <td>la Font de la Guatlla</td>\n",
       "      <td>Nens</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2017</td>\n",
       "      <td>3</td>\n",
       "      <td>Sants-Montjuïc</td>\n",
       "      <td>15</td>\n",
       "      <td>Hostafrancs</td>\n",
       "      <td>Nens</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2017</td>\n",
       "      <td>3</td>\n",
       "      <td>Sants-Montjuïc</td>\n",
       "      <td>16</td>\n",
       "      <td>la Bordeta</td>\n",
       "      <td>Nens</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2017</td>\n",
       "      <td>3</td>\n",
       "      <td>Sants-Montjuïc</td>\n",
       "      <td>17</td>\n",
       "      <td>Sants - Badal</td>\n",
       "      <td>Nens</td>\n",
       "      <td>108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2017</td>\n",
       "      <td>3</td>\n",
       "      <td>Sants-Montjuïc</td>\n",
       "      <td>18</td>\n",
       "      <td>Sants</td>\n",
       "      <td>Nens</td>\n",
       "      <td>155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2017</td>\n",
       "      <td>4</td>\n",
       "      <td>Les Corts</td>\n",
       "      <td>19</td>\n",
       "      <td>les Corts</td>\n",
       "      <td>Nens</td>\n",
       "      <td>199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2017</td>\n",
       "      <td>4</td>\n",
       "      <td>Les Corts</td>\n",
       "      <td>20</td>\n",
       "      <td>la Maternitat i Sant Ramon</td>\n",
       "      <td>Nens</td>\n",
       "      <td>101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2017</td>\n",
       "      <td>4</td>\n",
       "      <td>Les Corts</td>\n",
       "      <td>21</td>\n",
       "      <td>Pedralbes</td>\n",
       "      <td>Nens</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2017</td>\n",
       "      <td>5</td>\n",
       "      <td>Sarrià-Sant Gervasi</td>\n",
       "      <td>22</td>\n",
       "      <td>Vallvidrera, el Tibidabo i les Planes</td>\n",
       "      <td>Nens</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2017</td>\n",
       "      <td>5</td>\n",
       "      <td>Sarrià-Sant Gervasi</td>\n",
       "      <td>23</td>\n",
       "      <td>Sarrià</td>\n",
       "      <td>Nens</td>\n",
       "      <td>122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2017</td>\n",
       "      <td>5</td>\n",
       "      <td>Sarrià-Sant Gervasi</td>\n",
       "      <td>24</td>\n",
       "      <td>les Tres Torres</td>\n",
       "      <td>Nens</td>\n",
       "      <td>74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2017</td>\n",
       "      <td>5</td>\n",
       "      <td>Sarrià-Sant Gervasi</td>\n",
       "      <td>25</td>\n",
       "      <td>Sant Gervasi - la Bonanova</td>\n",
       "      <td>Nens</td>\n",
       "      <td>104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2017</td>\n",
       "      <td>5</td>\n",
       "      <td>Sarrià-Sant Gervasi</td>\n",
       "      <td>26</td>\n",
       "      <td>Sant Gervasi - Galvany</td>\n",
       "      <td>Nens</td>\n",
       "      <td>206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2017</td>\n",
       "      <td>5</td>\n",
       "      <td>Sarrià-Sant Gervasi</td>\n",
       "      <td>27</td>\n",
       "      <td>el Putxet i el Farró</td>\n",
       "      <td>Nens</td>\n",
       "      <td>127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2017</td>\n",
       "      <td>6</td>\n",
       "      <td>Gràcia</td>\n",
       "      <td>28</td>\n",
       "      <td>Vallcarca i els Penitents</td>\n",
       "      <td>Nens</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2017</td>\n",
       "      <td>6</td>\n",
       "      <td>Gràcia</td>\n",
       "      <td>29</td>\n",
       "      <td>el Coll</td>\n",
       "      <td>Nens</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2017</td>\n",
       "      <td>6</td>\n",
       "      <td>Gràcia</td>\n",
       "      <td>30</td>\n",
       "      <td>la Salut</td>\n",
       "      <td>Nens</td>\n",
       "      <td>62</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>2017</td>\n",
       "      <td>8</td>\n",
       "      <td>Nou Barris</td>\n",
       "      <td>44</td>\n",
       "      <td>Vilapicina i la Torre Llobeta</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>2017</td>\n",
       "      <td>8</td>\n",
       "      <td>Nou Barris</td>\n",
       "      <td>45</td>\n",
       "      <td>Porta</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>2017</td>\n",
       "      <td>8</td>\n",
       "      <td>Nou Barris</td>\n",
       "      <td>46</td>\n",
       "      <td>el Turó de la Peira</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>2017</td>\n",
       "      <td>8</td>\n",
       "      <td>Nou Barris</td>\n",
       "      <td>47</td>\n",
       "      <td>Can Peguera</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>2017</td>\n",
       "      <td>8</td>\n",
       "      <td>Nou Barris</td>\n",
       "      <td>48</td>\n",
       "      <td>la Guineueta</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>2017</td>\n",
       "      <td>8</td>\n",
       "      <td>Nou Barris</td>\n",
       "      <td>49</td>\n",
       "      <td>Canyelles</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>2017</td>\n",
       "      <td>8</td>\n",
       "      <td>Nou Barris</td>\n",
       "      <td>50</td>\n",
       "      <td>les Roquetes</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>2017</td>\n",
       "      <td>8</td>\n",
       "      <td>Nou Barris</td>\n",
       "      <td>51</td>\n",
       "      <td>Verdun</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>2017</td>\n",
       "      <td>8</td>\n",
       "      <td>Nou Barris</td>\n",
       "      <td>52</td>\n",
       "      <td>la Prosperitat</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>2017</td>\n",
       "      <td>8</td>\n",
       "      <td>Nou Barris</td>\n",
       "      <td>53</td>\n",
       "      <td>la Trinitat Nova</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>2017</td>\n",
       "      <td>8</td>\n",
       "      <td>Nou Barris</td>\n",
       "      <td>54</td>\n",
       "      <td>Torre Baró</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>2017</td>\n",
       "      <td>8</td>\n",
       "      <td>Nou Barris</td>\n",
       "      <td>55</td>\n",
       "      <td>Ciutat Meridiana</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>2017</td>\n",
       "      <td>8</td>\n",
       "      <td>Nou Barris</td>\n",
       "      <td>56</td>\n",
       "      <td>Vallbona</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>2017</td>\n",
       "      <td>9</td>\n",
       "      <td>Sant Andreu</td>\n",
       "      <td>57</td>\n",
       "      <td>la Trinitat Vella</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>2017</td>\n",
       "      <td>9</td>\n",
       "      <td>Sant Andreu</td>\n",
       "      <td>58</td>\n",
       "      <td>Baró de Viver</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>2017</td>\n",
       "      <td>9</td>\n",
       "      <td>Sant Andreu</td>\n",
       "      <td>59</td>\n",
       "      <td>el Bon Pastor</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>2017</td>\n",
       "      <td>9</td>\n",
       "      <td>Sant Andreu</td>\n",
       "      <td>60</td>\n",
       "      <td>Sant Andreu</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>232</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>2017</td>\n",
       "      <td>9</td>\n",
       "      <td>Sant Andreu</td>\n",
       "      <td>61</td>\n",
       "      <td>la Sagrera</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>2017</td>\n",
       "      <td>9</td>\n",
       "      <td>Sant Andreu</td>\n",
       "      <td>62</td>\n",
       "      <td>el Congrés i els Indians</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>2017</td>\n",
       "      <td>9</td>\n",
       "      <td>Sant Andreu</td>\n",
       "      <td>63</td>\n",
       "      <td>Navas</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>2017</td>\n",
       "      <td>10</td>\n",
       "      <td>Sant Martí</td>\n",
       "      <td>64</td>\n",
       "      <td>el Camp de l'Arpa del Clot</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>2017</td>\n",
       "      <td>10</td>\n",
       "      <td>Sant Martí</td>\n",
       "      <td>65</td>\n",
       "      <td>el Clot</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>2017</td>\n",
       "      <td>10</td>\n",
       "      <td>Sant Martí</td>\n",
       "      <td>66</td>\n",
       "      <td>el Parc i la Llacuna del Poblenou</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>2017</td>\n",
       "      <td>10</td>\n",
       "      <td>Sant Martí</td>\n",
       "      <td>67</td>\n",
       "      <td>la Vila Olímpica del Poblenou</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>2017</td>\n",
       "      <td>10</td>\n",
       "      <td>Sant Martí</td>\n",
       "      <td>68</td>\n",
       "      <td>el Poblenou</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>2017</td>\n",
       "      <td>10</td>\n",
       "      <td>Sant Martí</td>\n",
       "      <td>69</td>\n",
       "      <td>Diagonal Mar i el Front Marítim del Poblenou</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>2017</td>\n",
       "      <td>10</td>\n",
       "      <td>Sant Martí</td>\n",
       "      <td>70</td>\n",
       "      <td>el Besòs i el Maresme</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>2017</td>\n",
       "      <td>10</td>\n",
       "      <td>Sant Martí</td>\n",
       "      <td>71</td>\n",
       "      <td>Provençals del Poblenou</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>2017</td>\n",
       "      <td>10</td>\n",
       "      <td>Sant Martí</td>\n",
       "      <td>72</td>\n",
       "      <td>Sant Martí de Provençals</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>2017</td>\n",
       "      <td>10</td>\n",
       "      <td>Sant Martí</td>\n",
       "      <td>73</td>\n",
       "      <td>la Verneda i la Pau</td>\n",
       "      <td>Nenes</td>\n",
       "      <td>107</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>146 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Any  Codi_Districte        Nom_Districte  Codi_Barri  \\\n",
       "0    2017               1         Ciutat Vella           1   \n",
       "1    2017               1         Ciutat Vella           2   \n",
       "2    2017               1         Ciutat Vella           3   \n",
       "3    2017               1         Ciutat Vella           4   \n",
       "4    2017               2             Eixample           5   \n",
       "5    2017               2             Eixample           6   \n",
       "6    2017               2             Eixample           7   \n",
       "7    2017               2             Eixample           8   \n",
       "8    2017               2             Eixample           9   \n",
       "9    2017               2             Eixample          10   \n",
       "10   2017               3       Sants-Montjuïc          11   \n",
       "11   2017               3       Sants-Montjuïc          12   \n",
       "12   2017               3       Sants-Montjuïc          13   \n",
       "13   2017               3       Sants-Montjuïc          14   \n",
       "14   2017               3       Sants-Montjuïc          15   \n",
       "15   2017               3       Sants-Montjuïc          16   \n",
       "16   2017               3       Sants-Montjuïc          17   \n",
       "17   2017               3       Sants-Montjuïc          18   \n",
       "18   2017               4            Les Corts          19   \n",
       "19   2017               4            Les Corts          20   \n",
       "20   2017               4            Les Corts          21   \n",
       "21   2017               5  Sarrià-Sant Gervasi          22   \n",
       "22   2017               5  Sarrià-Sant Gervasi          23   \n",
       "23   2017               5  Sarrià-Sant Gervasi          24   \n",
       "24   2017               5  Sarrià-Sant Gervasi          25   \n",
       "25   2017               5  Sarrià-Sant Gervasi          26   \n",
       "26   2017               5  Sarrià-Sant Gervasi          27   \n",
       "27   2017               6               Gràcia          28   \n",
       "28   2017               6               Gràcia          29   \n",
       "29   2017               6               Gràcia          30   \n",
       "..    ...             ...                  ...         ...   \n",
       "116  2017               8           Nou Barris          44   \n",
       "117  2017               8           Nou Barris          45   \n",
       "118  2017               8           Nou Barris          46   \n",
       "119  2017               8           Nou Barris          47   \n",
       "120  2017               8           Nou Barris          48   \n",
       "121  2017               8           Nou Barris          49   \n",
       "122  2017               8           Nou Barris          50   \n",
       "123  2017               8           Nou Barris          51   \n",
       "124  2017               8           Nou Barris          52   \n",
       "125  2017               8           Nou Barris          53   \n",
       "126  2017               8           Nou Barris          54   \n",
       "127  2017               8           Nou Barris          55   \n",
       "128  2017               8           Nou Barris          56   \n",
       "129  2017               9          Sant Andreu          57   \n",
       "130  2017               9          Sant Andreu          58   \n",
       "131  2017               9          Sant Andreu          59   \n",
       "132  2017               9          Sant Andreu          60   \n",
       "133  2017               9          Sant Andreu          61   \n",
       "134  2017               9          Sant Andreu          62   \n",
       "135  2017               9          Sant Andreu          63   \n",
       "136  2017              10           Sant Martí          64   \n",
       "137  2017              10           Sant Martí          65   \n",
       "138  2017              10           Sant Martí          66   \n",
       "139  2017              10           Sant Martí          67   \n",
       "140  2017              10           Sant Martí          68   \n",
       "141  2017              10           Sant Martí          69   \n",
       "142  2017              10           Sant Martí          70   \n",
       "143  2017              10           Sant Martí          71   \n",
       "144  2017              10           Sant Martí          72   \n",
       "145  2017              10           Sant Martí          73   \n",
       "\n",
       "                                        Nom_Barri   Sexe  Nombre  \n",
       "0                                        el Raval   Nens     283  \n",
       "1                                  el Barri Gòtic   Nens      56  \n",
       "2                                  la Barceloneta   Nens      51  \n",
       "3           Sant Pere, Santa Caterina i la Ribera   Nens      90  \n",
       "4                                   el Fort Pienc   Nens     117  \n",
       "5                              la Sagrada Família   Nens     207  \n",
       "6                          la Dreta de l'Eixample   Nens     185  \n",
       "7                 l'Antiga Esquerra de l'Eixample   Nens     176  \n",
       "8                  la Nova Esquerra de l'Eixample   Nens     218  \n",
       "9                                     Sant Antoni   Nens     172  \n",
       "10                                   el Poble Sec   Nens     156  \n",
       "11                     la Marina del Prat Vermell   Nens       4  \n",
       "12                              la Marina de Port   Nens     119  \n",
       "13                          la Font de la Guatlla   Nens      42  \n",
       "14                                    Hostafrancs   Nens      78  \n",
       "15                                     la Bordeta   Nens      81  \n",
       "16                                  Sants - Badal   Nens     108  \n",
       "17                                          Sants   Nens     155  \n",
       "18                                      les Corts   Nens     199  \n",
       "19                     la Maternitat i Sant Ramon   Nens     101  \n",
       "20                                      Pedralbes   Nens      32  \n",
       "21          Vallvidrera, el Tibidabo i les Planes   Nens      17  \n",
       "22                                         Sarrià   Nens     122  \n",
       "23                                les Tres Torres   Nens      74  \n",
       "24                     Sant Gervasi - la Bonanova   Nens     104  \n",
       "25                         Sant Gervasi - Galvany   Nens     206  \n",
       "26                           el Putxet i el Farró   Nens     127  \n",
       "27                      Vallcarca i els Penitents   Nens      66  \n",
       "28                                        el Coll   Nens      26  \n",
       "29                                       la Salut   Nens      62  \n",
       "..                                            ...    ...     ...  \n",
       "116                 Vilapicina i la Torre Llobeta  Nenes     108  \n",
       "117                                         Porta  Nenes     117  \n",
       "118                           el Turó de la Peira  Nenes      92  \n",
       "119                                   Can Peguera  Nenes       8  \n",
       "120                                  la Guineueta  Nenes      40  \n",
       "121                                     Canyelles  Nenes      14  \n",
       "122                                  les Roquetes  Nenes      83  \n",
       "123                                        Verdun  Nenes      48  \n",
       "124                                la Prosperitat  Nenes     124  \n",
       "125                              la Trinitat Nova  Nenes      28  \n",
       "126                                    Torre Baró  Nenes       8  \n",
       "127                              Ciutat Meridiana  Nenes      53  \n",
       "128                                      Vallbona  Nenes      11  \n",
       "129                             la Trinitat Vella  Nenes      55  \n",
       "130                                 Baró de Viver  Nenes      13  \n",
       "131                                 el Bon Pastor  Nenes      60  \n",
       "132                                   Sant Andreu  Nenes     232  \n",
       "133                                    la Sagrera  Nenes     100  \n",
       "134                      el Congrés i els Indians  Nenes      61  \n",
       "135                                         Navas  Nenes      83  \n",
       "136                    el Camp de l'Arpa del Clot  Nenes     159  \n",
       "137                                       el Clot  Nenes      82  \n",
       "138             el Parc i la Llacuna del Poblenou  Nenes      74  \n",
       "139                 la Vila Olímpica del Poblenou  Nenes      29  \n",
       "140                                   el Poblenou  Nenes     157  \n",
       "141  Diagonal Mar i el Front Marítim del Poblenou  Nenes      58  \n",
       "142                         el Besòs i el Maresme  Nenes      99  \n",
       "143                       Provençals del Poblenou  Nenes      80  \n",
       "144                      Sant Martí de Provençals  Nenes      98  \n",
       "145                           la Verneda i la Pau  Nenes     107  \n",
       "\n",
       "[146 rows x 7 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.read_csv(\"DadesBarcelona/2017_naixements_sexe.csv\",sep=',')\n",
    "\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>Sexe</th>\n",
       "      <th>Nenes</th>\n",
       "      <th>Nens</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nom_Barri</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Baró de Viver</th>\n",
       "      <td>13</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Can Baró</th>\n",
       "      <td>38</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Can Peguera</th>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Canyelles</th>\n",
       "      <td>14</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ciutat Meridiana</th>\n",
       "      <td>53</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Diagonal Mar i el Front Marítim del Poblenou</th>\n",
       "      <td>58</td>\n",
       "      <td>103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Horta</th>\n",
       "      <td>91</td>\n",
       "      <td>99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hostafrancs</th>\n",
       "      <td>64</td>\n",
       "      <td>78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Montbau</th>\n",
       "      <td>17</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Navas</th>\n",
       "      <td>83</td>\n",
       "      <td>98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pedralbes</th>\n",
       "      <td>32</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Porta</th>\n",
       "      <td>117</td>\n",
       "      <td>104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Provençals del Poblenou</th>\n",
       "      <td>80</td>\n",
       "      <td>106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sant Andreu</th>\n",
       "      <td>232</td>\n",
       "      <td>227</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sant Antoni</th>\n",
       "      <td>130</td>\n",
       "      <td>172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sant Genís dels Agudells</th>\n",
       "      <td>27</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sant Gervasi - Galvany</th>\n",
       "      <td>199</td>\n",
       "      <td>206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sant Gervasi - la Bonanova</th>\n",
       "      <td>95</td>\n",
       "      <td>104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sant Martí de Provençals</th>\n",
       "      <td>98</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sant Pere, Santa Caterina i la Ribera</th>\n",
       "      <td>90</td>\n",
       "      <td>90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sants</th>\n",
       "      <td>180</td>\n",
       "      <td>155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sants - Badal</th>\n",
       "      <td>96</td>\n",
       "      <td>108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sarrià</th>\n",
       "      <td>110</td>\n",
       "      <td>122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Torre Baró</th>\n",
       "      <td>8</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vallbona</th>\n",
       "      <td>11</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vallcarca i els Penitents</th>\n",
       "      <td>66</td>\n",
       "      <td>66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vallvidrera, el Tibidabo i les Planes</th>\n",
       "      <td>20</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Verdun</th>\n",
       "      <td>48</td>\n",
       "      <td>50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vilapicina i la Torre Llobeta</th>\n",
       "      <td>108</td>\n",
       "      <td>92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>el Baix Guinardó</th>\n",
       "      <td>93</td>\n",
       "      <td>97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>el Poblenou</th>\n",
       "      <td>157</td>\n",
       "      <td>160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>el Putxet i el Farró</th>\n",
       "      <td>138</td>\n",
       "      <td>127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>el Raval</th>\n",
       "      <td>219</td>\n",
       "      <td>283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>el Turó de la Peira</th>\n",
       "      <td>92</td>\n",
       "      <td>82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>l'Antiga Esquerra de l'Eixample</th>\n",
       "      <td>164</td>\n",
       "      <td>176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Barceloneta</th>\n",
       "      <td>50</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Bordeta</th>\n",
       "      <td>75</td>\n",
       "      <td>81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Clota</th>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Dreta de l'Eixample</th>\n",
       "      <td>159</td>\n",
       "      <td>185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Font d'en Fargues</th>\n",
       "      <td>33</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Font de la Guatlla</th>\n",
       "      <td>30</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Guineueta</th>\n",
       "      <td>40</td>\n",
       "      <td>47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Marina de Port</th>\n",
       "      <td>117</td>\n",
       "      <td>119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Marina del Prat Vermell</th>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Maternitat i Sant Ramon</th>\n",
       "      <td>105</td>\n",
       "      <td>101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Nova Esquerra de l'Eixample</th>\n",
       "      <td>242</td>\n",
       "      <td>218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Prosperitat</th>\n",
       "      <td>124</td>\n",
       "      <td>127</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Sagrada Família</th>\n",
       "      <td>183</td>\n",
       "      <td>207</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Sagrera</th>\n",
       "      <td>100</td>\n",
       "      <td>132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Salut</th>\n",
       "      <td>42</td>\n",
       "      <td>62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Teixonera</th>\n",
       "      <td>41</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Trinitat Nova</th>\n",
       "      <td>28</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Trinitat Vella</th>\n",
       "      <td>55</td>\n",
       "      <td>65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Vall d'Hebron</th>\n",
       "      <td>20</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Verneda i la Pau</th>\n",
       "      <td>107</td>\n",
       "      <td>122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Vila Olímpica del Poblenou</th>\n",
       "      <td>29</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>la Vila de Gràcia</th>\n",
       "      <td>236</td>\n",
       "      <td>241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>les Corts</th>\n",
       "      <td>175</td>\n",
       "      <td>199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>les Roquetes</th>\n",
       "      <td>83</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>les Tres Torres</th>\n",
       "      <td>61</td>\n",
       "      <td>74</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>73 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Sexe                                          Nenes  Nens\n",
       "Nom_Barri                                                \n",
       "Baró de Viver                                    13    11\n",
       "Can Baró                                         38    41\n",
       "Can Peguera                                       8     5\n",
       "Canyelles                                        14    35\n",
       "Ciutat Meridiana                                 53    49\n",
       "Diagonal Mar i el Front Marítim del Poblenou     58   103\n",
       "Horta                                            91    99\n",
       "Hostafrancs                                      64    78\n",
       "Montbau                                          17    26\n",
       "Navas                                            83    98\n",
       "Pedralbes                                        32    32\n",
       "Porta                                           117   104\n",
       "Provençals del Poblenou                          80   106\n",
       "Sant Andreu                                     232   227\n",
       "Sant Antoni                                     130   172\n",
       "Sant Genís dels Agudells                         27    28\n",
       "Sant Gervasi - Galvany                          199   206\n",
       "Sant Gervasi - la Bonanova                       95   104\n",
       "Sant Martí de Provençals                         98   100\n",
       "Sant Pere, Santa Caterina i la Ribera            90    90\n",
       "Sants                                           180   155\n",
       "Sants - Badal                                    96   108\n",
       "Sarrià                                          110   122\n",
       "Torre Baró                                        8    20\n",
       "Vallbona                                         11     5\n",
       "Vallcarca i els Penitents                        66    66\n",
       "Vallvidrera, el Tibidabo i les Planes            20    17\n",
       "Verdun                                           48    50\n",
       "Vilapicina i la Torre Llobeta                   108    92\n",
       "el Baix Guinardó                                 93    97\n",
       "...                                             ...   ...\n",
       "el Poblenou                                     157   160\n",
       "el Putxet i el Farró                            138   127\n",
       "el Raval                                        219   283\n",
       "el Turó de la Peira                              92    82\n",
       "l'Antiga Esquerra de l'Eixample                 164   176\n",
       "la Barceloneta                                   50    51\n",
       "la Bordeta                                       75    81\n",
       "la Clota                                          5     8\n",
       "la Dreta de l'Eixample                          159   185\n",
       "la Font d'en Fargues                             33    26\n",
       "la Font de la Guatlla                            30    42\n",
       "la Guineueta                                     40    47\n",
       "la Marina de Port                               117   119\n",
       "la Marina del Prat Vermell                        8     4\n",
       "la Maternitat i Sant Ramon                      105   101\n",
       "la Nova Esquerra de l'Eixample                  242   218\n",
       "la Prosperitat                                  124   127\n",
       "la Sagrada Família                              183   207\n",
       "la Sagrera                                      100   132\n",
       "la Salut                                         42    62\n",
       "la Teixonera                                     41    48\n",
       "la Trinitat Nova                                 28    38\n",
       "la Trinitat Vella                                55    65\n",
       "la Vall d'Hebron                                 20    12\n",
       "la Verneda i la Pau                             107   122\n",
       "la Vila Olímpica del Poblenou                    29    34\n",
       "la Vila de Gràcia                               236   241\n",
       "les Corts                                       175   199\n",
       "les Roquetes                                     83    88\n",
       "les Tres Torres                                  61    74\n",
       "\n",
       "[73 rows x 2 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.pivot_table(df,columns=\"Sexe\", index = \"Nom_Barri\", values=\"Nombre\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "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>Sexe</th>\n",
       "      <th>Nenes</th>\n",
       "      <th>Nens</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nom_Districte</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Ciutat Vella</th>\n",
       "      <td>412</td>\n",
       "      <td>480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Eixample</th>\n",
       "      <td>992</td>\n",
       "      <td>1075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gràcia</th>\n",
       "      <td>513</td>\n",
       "      <td>544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Horta-Guinardó</th>\n",
       "      <td>671</td>\n",
       "      <td>656</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Les Corts</th>\n",
       "      <td>312</td>\n",
       "      <td>332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nou Barris</th>\n",
       "      <td>734</td>\n",
       "      <td>742</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sant Andreu</th>\n",
       "      <td>604</td>\n",
       "      <td>660</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sant Martí</th>\n",
       "      <td>943</td>\n",
       "      <td>1096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sants-Montjuïc</th>\n",
       "      <td>744</td>\n",
       "      <td>743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sarrià-Sant Gervasi</th>\n",
       "      <td>623</td>\n",
       "      <td>650</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Sexe                 Nenes  Nens\n",
       "Nom_Districte                   \n",
       "Ciutat Vella           412   480\n",
       "Eixample               992  1075\n",
       "Gràcia                 513   544\n",
       "Horta-Guinardó         671   656\n",
       "Les Corts              312   332\n",
       "Nou Barris             734   742\n",
       "Sant Andreu            604   660\n",
       "Sant Martí             943  1096\n",
       "Sants-Montjuïc         744   743\n",
       "Sarrià-Sant Gervasi    623   650"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import numpy as np\n",
    "pd.pivot_table(df,columns=\"Sexe\", index = \"Nom_Districte\", values=\"Nombre\",aggfunc=np.sum)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Overwriting my_exercice.py\n"
     ]
    }
   ],
   "source": [
    "%%writefile my_exercice.py\n",
    "#Dash exercice\n",
    "import pandas as pd\n",
    "import dash\n",
    "import dash_core_components as dcc\n",
    "import dash_html_components as html\n",
    "import plotly.graph_objs as go\n",
    "from plotly import tools\n",
    "\n",
    "import numpy as np\n",
    "\n",
    "df = pd.read_csv(\"DadesBarcelona/2017_naixements_sexe.csv\",sep=',')\n",
    "pv = pd.pivot_table(df,columns=\"Sexe\", index = \"Nom_Districte\", values=\"Nombre\",aggfunc=np.sum)\n",
    "\n",
    "app = dash.Dash()\n",
    "app.css.append_css({\"external_url\": \"https://codepen.io/chriddyp/pen/bWLwgP.css\"})\n",
    "\n",
    "app.layout = html.Div([html.Div(\n",
    "    [dcc.Graph(id='birth_bcn',figure = {\n",
    "                            'data':[\n",
    "                                {'x': pv.index, 'y': pv[\"Nens\"], 'type': 'bar', 'name': 'Nens'},\n",
    "                                {'x': pv.index,  'y': pv[\"Nenes\"], 'type': 'bar', 'name': 'Nenes'},\n",
    "                                {'x': pv.index, 'y': pv[\"Nens\"], 'type': 'lines+markers', 'name': 'Nens', 'visible' : \"legendonly\"},\n",
    "                                {'x': pv.index,  'y': pv[\"Nenes\"], 'type': 'lines+markers', 'name': 'Nenes','visible' : \"legendonly\"},\n",
    "                            ],\n",
    "                            'layout':{\n",
    "                                'title' : 'Births Data Visualisation'\n",
    "                            }\n",
    "                              } )\n",
    "                                ],\n",
    "                                style={'height':'80%','padding': '0px 20px 20px 20px'},\n",
    "                                \n",
    "                               )])\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "if __name__ == '__main__':\n",
    "    app.run_server(debug=True)\n",
    "\n",
    "\n",
    "if __name__ == '__main__':\n",
    "    app.run_server()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * Running on http://127.0.0.1:8050/ (Press CTRL+C to quit)\n",
      " * Restarting with stat\n",
      " * Debugger is active!\n",
      " * Debugger PIN: 102-099-753\n",
      "127.0.0.1 - - [27/Jan/2019 20:53:17] \"GET / HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [27/Jan/2019 20:53:18] \"GET /_dash-layout HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [27/Jan/2019 20:53:18] \"GET /_dash-dependencies HTTP/1.1\" 200 -\n",
      "127.0.0.1 - - [27/Jan/2019 20:53:18] \"GET /favicon.ico HTTP/1.1\" 200 -\n",
      "^C\n",
      "Traceback (most recent call last):\n",
      "  File \"my_exercice.py\", line 42, in <module>\n",
      "    app.run_server()\n",
      "  File \"/Users/eloi/anaconda2/envs/py36/lib/python3.6/site-packages/dash/dash.py\", line 551, in run_server\n",
      "    self.server.run(port=port, debug=debug, **flask_run_options)\n",
      "  File \"/Users/eloi/anaconda2/envs/py36/lib/python3.6/site-packages/flask/app.py\", line 841, in run\n",
      "    run_simple(host, port, self, **options)\n",
      "  File \"/Users/eloi/anaconda2/envs/py36/lib/python3.6/site-packages/werkzeug/serving.py\", line 814, in run_simple\n",
      "    inner()\n",
      "  File \"/Users/eloi/anaconda2/envs/py36/lib/python3.6/site-packages/werkzeug/serving.py\", line 774, in inner\n",
      "    fd=fd)\n",
      "  File \"/Users/eloi/anaconda2/envs/py36/lib/python3.6/site-packages/werkzeug/serving.py\", line 666, in make_server\n",
      "    passthrough_errors, ssl_context, fd=fd)\n",
      "  File \"/Users/eloi/anaconda2/envs/py36/lib/python3.6/site-packages/werkzeug/serving.py\", line 574, in __init__\n",
      "    socket.SOCK_STREAM)\n",
      "  File \"/Users/eloi/anaconda2/envs/py36/lib/python3.6/socket.py\", line 460, in fromfd\n",
      "    nfd = dup(fd)\n",
      "OSError: [Errno 9] Bad file descriptor\n"
     ]
    }
   ],
   "source": [
    "!python3 my_exercice.py"
   ]
  }
 ],
 "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
}