Covid_vaccinations_Spain.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Sample of visualizations"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# https://www.eldiario.es/sociedad/tasa-incidencia-alcanza-nivel-agosto-ano-pasado-casos-100-000-habitantes_1_7973441.html"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "#file site https://www.mscbs.gob.es/profesionales/saludPublica/ccayes/alertasActual/nCov/vacunaCovid19.htm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# excelfile https://www.mscbs.gob.es/profesionales/saludPublica/ccayes/alertasActual/nCov/documentos/Informe_Comunicacion_20210527.ods"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "('/Users/pablofernandezrodriguez/Desktop/pythoncourse/2021/5/Covid_ES/updatedfile.ods',\n",
       " <http.client.HTTPMessage at 0x7fb0f4f8d400>)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import urllib.request\n",
    "url = 'https://www.mscbs.gob.es/profesionales/saludPublica/ccayes/alertasActual/nCov/documentos/Informe_Comunicacion_20210527.ods'\n",
    "urllib.request.urlretrieve(url, '/Users/pablofernandezrodriguez/Desktop/pythoncourse/2021/5/Covid_ES/updatedfile.ods')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "#conda install pandas-ods-reader"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "#pip install pandas_ods_reader"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "from pandas_ods_reader import read_ods"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "base_path = \"/Users/pablofernandezrodriguez/Desktop/pythoncourse/2021/5/Covid_ES/updatedfile.ods\"\n",
    "sheet_index = 1\n",
    "df = read_ods(base_path , sheet_index )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>unnamed.1</th>\n",
       "      <th>Dosis entregadas Pfizer (1)</th>\n",
       "      <th>Dosis entregadas Moderna (1)</th>\n",
       "      <th>Dosis entregadas AstraZeneca (1)</th>\n",
       "      <th>Dosis entregadas Janssen (1)</th>\n",
       "      <th>Total Dosis entregadas (1)</th>\n",
       "      <th>Dosis administradas (2)</th>\n",
       "      <th>% sobre entregadas</th>\n",
       "      <th>Nº Personas con al menos 1 dosis</th>\n",
       "      <th>Nº Personas vacunadas\\n(pauta completada)</th>\n",
       "      <th>Fecha de la última vacuna registrada (2)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Andalucía</td>\n",
       "      <td>2919240.0</td>\n",
       "      <td>447000.0</td>\n",
       "      <td>1054200.0</td>\n",
       "      <td>102800.0</td>\n",
       "      <td>4523240.0</td>\n",
       "      <td>4411991.0</td>\n",
       "      <td>0.975405</td>\n",
       "      <td>3014242.0</td>\n",
       "      <td>1446707.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Aragón</td>\n",
       "      <td>567765.0</td>\n",
       "      <td>84500.0</td>\n",
       "      <td>165600.0</td>\n",
       "      <td>16000.0</td>\n",
       "      <td>833865.0</td>\n",
       "      <td>800211.0</td>\n",
       "      <td>0.959641</td>\n",
       "      <td>522723.0</td>\n",
       "      <td>287048.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Asturias</td>\n",
       "      <td>520385.0</td>\n",
       "      <td>73600.0</td>\n",
       "      <td>127000.0</td>\n",
       "      <td>12400.0</td>\n",
       "      <td>733385.0</td>\n",
       "      <td>727195.0</td>\n",
       "      <td>0.991560</td>\n",
       "      <td>470971.0</td>\n",
       "      <td>264215.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Baleares</td>\n",
       "      <td>340830.0</td>\n",
       "      <td>54800.0</td>\n",
       "      <td>145800.0</td>\n",
       "      <td>14200.0</td>\n",
       "      <td>555630.0</td>\n",
       "      <td>518077.0</td>\n",
       "      <td>0.932414</td>\n",
       "      <td>371487.0</td>\n",
       "      <td>154356.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Canarias</td>\n",
       "      <td>710160.0</td>\n",
       "      <td>104800.0</td>\n",
       "      <td>271000.0</td>\n",
       "      <td>26400.0</td>\n",
       "      <td>1112360.0</td>\n",
       "      <td>995872.0</td>\n",
       "      <td>0.895279</td>\n",
       "      <td>710238.0</td>\n",
       "      <td>309230.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Cantabria</td>\n",
       "      <td>252285.0</td>\n",
       "      <td>36900.0</td>\n",
       "      <td>72500.0</td>\n",
       "      <td>6950.0</td>\n",
       "      <td>368635.0</td>\n",
       "      <td>346706.0</td>\n",
       "      <td>0.940513</td>\n",
       "      <td>230025.0</td>\n",
       "      <td>120945.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Castilla y Leon</td>\n",
       "      <td>1218855.0</td>\n",
       "      <td>180200.0</td>\n",
       "      <td>298300.0</td>\n",
       "      <td>29150.0</td>\n",
       "      <td>1726505.0</td>\n",
       "      <td>1598322.0</td>\n",
       "      <td>0.925756</td>\n",
       "      <td>1005002.0</td>\n",
       "      <td>615945.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Castilla La Mancha</td>\n",
       "      <td>797805.0</td>\n",
       "      <td>121100.0</td>\n",
       "      <td>253800.0</td>\n",
       "      <td>24675.0</td>\n",
       "      <td>1197380.0</td>\n",
       "      <td>1146802.0</td>\n",
       "      <td>0.957759</td>\n",
       "      <td>774216.0</td>\n",
       "      <td>393256.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Cataluña</td>\n",
       "      <td>2853080.0</td>\n",
       "      <td>437200.0</td>\n",
       "      <td>969100.0</td>\n",
       "      <td>94450.0</td>\n",
       "      <td>4353830.0</td>\n",
       "      <td>3995011.0</td>\n",
       "      <td>0.917585</td>\n",
       "      <td>2778155.0</td>\n",
       "      <td>1258088.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>C. Valenciana</td>\n",
       "      <td>1783270.0</td>\n",
       "      <td>272700.0</td>\n",
       "      <td>629800.0</td>\n",
       "      <td>61400.0</td>\n",
       "      <td>2747170.0</td>\n",
       "      <td>2632543.0</td>\n",
       "      <td>0.958275</td>\n",
       "      <td>1797349.0</td>\n",
       "      <td>881810.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Extremadura</td>\n",
       "      <td>459305.0</td>\n",
       "      <td>66700.0</td>\n",
       "      <td>132400.0</td>\n",
       "      <td>12900.0</td>\n",
       "      <td>671305.0</td>\n",
       "      <td>646531.0</td>\n",
       "      <td>0.963096</td>\n",
       "      <td>427510.0</td>\n",
       "      <td>228317.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Galicia</td>\n",
       "      <td>1280095.0</td>\n",
       "      <td>182600.0</td>\n",
       "      <td>336600.0</td>\n",
       "      <td>32900.0</td>\n",
       "      <td>1832195.0</td>\n",
       "      <td>1786951.0</td>\n",
       "      <td>0.975306</td>\n",
       "      <td>1194630.0</td>\n",
       "      <td>613146.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>La Rioja</td>\n",
       "      <td>133445.0</td>\n",
       "      <td>19500.0</td>\n",
       "      <td>39600.0</td>\n",
       "      <td>3900.0</td>\n",
       "      <td>196445.0</td>\n",
       "      <td>186704.0</td>\n",
       "      <td>0.950414</td>\n",
       "      <td>119865.0</td>\n",
       "      <td>70135.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Madrid</td>\n",
       "      <td>2357475.0</td>\n",
       "      <td>364200.0</td>\n",
       "      <td>844700.0</td>\n",
       "      <td>82300.0</td>\n",
       "      <td>3648675.0</td>\n",
       "      <td>3410710.0</td>\n",
       "      <td>0.934780</td>\n",
       "      <td>2319092.0</td>\n",
       "      <td>1139171.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Murcia</td>\n",
       "      <td>504995.0</td>\n",
       "      <td>77300.0</td>\n",
       "      <td>188100.0</td>\n",
       "      <td>18300.0</td>\n",
       "      <td>788695.0</td>\n",
       "      <td>703427.0</td>\n",
       "      <td>0.891887</td>\n",
       "      <td>462994.0</td>\n",
       "      <td>250064.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Navarra</td>\n",
       "      <td>255795.0</td>\n",
       "      <td>38800.0</td>\n",
       "      <td>82300.0</td>\n",
       "      <td>8050.0</td>\n",
       "      <td>384945.0</td>\n",
       "      <td>379747.0</td>\n",
       "      <td>0.986497</td>\n",
       "      <td>256006.0</td>\n",
       "      <td>131982.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>País Vasco</td>\n",
       "      <td>925290.0</td>\n",
       "      <td>136200.0</td>\n",
       "      <td>276500.0</td>\n",
       "      <td>26950.0</td>\n",
       "      <td>1364940.0</td>\n",
       "      <td>1306191.0</td>\n",
       "      <td>0.956959</td>\n",
       "      <td>908202.0</td>\n",
       "      <td>421203.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ceuta</td>\n",
       "      <td>24210.0</td>\n",
       "      <td>3800.0</td>\n",
       "      <td>11000.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>40060.0</td>\n",
       "      <td>36761.0</td>\n",
       "      <td>0.917649</td>\n",
       "      <td>28671.0</td>\n",
       "      <td>8867.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Melilla</td>\n",
       "      <td>24210.0</td>\n",
       "      <td>3700.0</td>\n",
       "      <td>11000.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>39960.0</td>\n",
       "      <td>35862.0</td>\n",
       "      <td>0.897447</td>\n",
       "      <td>27381.0</td>\n",
       "      <td>9461.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Fuerzas Armadas</td>\n",
       "      <td>21840.0</td>\n",
       "      <td>3400.0</td>\n",
       "      <td>66100.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91340.0</td>\n",
       "      <td>79564.0</td>\n",
       "      <td>0.871075</td>\n",
       "      <td>68832.0</td>\n",
       "      <td>10732.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Totales</td>\n",
       "      <td>17950335.0</td>\n",
       "      <td>2709000.0</td>\n",
       "      <td>5975400.0</td>\n",
       "      <td>575825.0</td>\n",
       "      <td>27210560.0</td>\n",
       "      <td>25745178.0</td>\n",
       "      <td>0.946147</td>\n",
       "      <td>17487591.0</td>\n",
       "      <td>8614678.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             unnamed.1  Dosis entregadas Pfizer (1)  \\\n",
       "0            Andalucía                    2919240.0   \n",
       "1               Aragón                     567765.0   \n",
       "2            Asturias                      520385.0   \n",
       "3             Baleares                     340830.0   \n",
       "4             Canarias                     710160.0   \n",
       "5            Cantabria                     252285.0   \n",
       "6     Castilla y Leon                     1218855.0   \n",
       "7   Castilla La Mancha                     797805.0   \n",
       "8             Cataluña                    2853080.0   \n",
       "9        C. Valenciana                    1783270.0   \n",
       "10         Extremadura                     459305.0   \n",
       "11             Galicia                    1280095.0   \n",
       "12            La Rioja                     133445.0   \n",
       "13              Madrid                    2357475.0   \n",
       "14             Murcia                      504995.0   \n",
       "15             Navarra                     255795.0   \n",
       "16          País Vasco                     925290.0   \n",
       "17               Ceuta                      24210.0   \n",
       "18             Melilla                      24210.0   \n",
       "19     Fuerzas Armadas                      21840.0   \n",
       "20             Totales                   17950335.0   \n",
       "\n",
       "    Dosis entregadas Moderna (1)  Dosis entregadas AstraZeneca (1)  \\\n",
       "0                       447000.0                         1054200.0   \n",
       "1                        84500.0                          165600.0   \n",
       "2                        73600.0                          127000.0   \n",
       "3                        54800.0                          145800.0   \n",
       "4                       104800.0                          271000.0   \n",
       "5                        36900.0                           72500.0   \n",
       "6                       180200.0                          298300.0   \n",
       "7                       121100.0                          253800.0   \n",
       "8                       437200.0                          969100.0   \n",
       "9                       272700.0                          629800.0   \n",
       "10                       66700.0                          132400.0   \n",
       "11                      182600.0                          336600.0   \n",
       "12                       19500.0                           39600.0   \n",
       "13                      364200.0                          844700.0   \n",
       "14                       77300.0                          188100.0   \n",
       "15                       38800.0                           82300.0   \n",
       "16                      136200.0                          276500.0   \n",
       "17                        3800.0                           11000.0   \n",
       "18                        3700.0                           11000.0   \n",
       "19                        3400.0                           66100.0   \n",
       "20                     2709000.0                         5975400.0   \n",
       "\n",
       "    Dosis entregadas Janssen (1)  Total Dosis entregadas (1)  \\\n",
       "0                       102800.0                   4523240.0   \n",
       "1                        16000.0                    833865.0   \n",
       "2                        12400.0                    733385.0   \n",
       "3                        14200.0                    555630.0   \n",
       "4                        26400.0                   1112360.0   \n",
       "5                         6950.0                    368635.0   \n",
       "6                        29150.0                   1726505.0   \n",
       "7                        24675.0                   1197380.0   \n",
       "8                        94450.0                   4353830.0   \n",
       "9                        61400.0                   2747170.0   \n",
       "10                       12900.0                    671305.0   \n",
       "11                       32900.0                   1832195.0   \n",
       "12                        3900.0                    196445.0   \n",
       "13                       82300.0                   3648675.0   \n",
       "14                       18300.0                    788695.0   \n",
       "15                        8050.0                    384945.0   \n",
       "16                       26950.0                   1364940.0   \n",
       "17                        1050.0                     40060.0   \n",
       "18                        1050.0                     39960.0   \n",
       "19                           0.0                     91340.0   \n",
       "20                      575825.0                  27210560.0   \n",
       "\n",
       "    Dosis administradas (2)  % sobre entregadas  \\\n",
       "0                 4411991.0            0.975405   \n",
       "1                  800211.0            0.959641   \n",
       "2                  727195.0            0.991560   \n",
       "3                  518077.0            0.932414   \n",
       "4                  995872.0            0.895279   \n",
       "5                  346706.0            0.940513   \n",
       "6                 1598322.0            0.925756   \n",
       "7                 1146802.0            0.957759   \n",
       "8                 3995011.0            0.917585   \n",
       "9                 2632543.0            0.958275   \n",
       "10                 646531.0            0.963096   \n",
       "11                1786951.0            0.975306   \n",
       "12                 186704.0            0.950414   \n",
       "13                3410710.0            0.934780   \n",
       "14                 703427.0            0.891887   \n",
       "15                 379747.0            0.986497   \n",
       "16                1306191.0            0.956959   \n",
       "17                  36761.0            0.917649   \n",
       "18                  35862.0            0.897447   \n",
       "19                  79564.0            0.871075   \n",
       "20               25745178.0            0.946147   \n",
       "\n",
       "    Nº Personas con al menos 1 dosis  \\\n",
       "0                          3014242.0   \n",
       "1                           522723.0   \n",
       "2                           470971.0   \n",
       "3                           371487.0   \n",
       "4                           710238.0   \n",
       "5                           230025.0   \n",
       "6                          1005002.0   \n",
       "7                           774216.0   \n",
       "8                          2778155.0   \n",
       "9                          1797349.0   \n",
       "10                          427510.0   \n",
       "11                         1194630.0   \n",
       "12                          119865.0   \n",
       "13                         2319092.0   \n",
       "14                          462994.0   \n",
       "15                          256006.0   \n",
       "16                          908202.0   \n",
       "17                           28671.0   \n",
       "18                           27381.0   \n",
       "19                           68832.0   \n",
       "20                        17487591.0   \n",
       "\n",
       "    Nº Personas vacunadas\\n(pauta completada)  \\\n",
       "0                                   1446707.0   \n",
       "1                                    287048.0   \n",
       "2                                    264215.0   \n",
       "3                                    154356.0   \n",
       "4                                    309230.0   \n",
       "5                                    120945.0   \n",
       "6                                    615945.0   \n",
       "7                                    393256.0   \n",
       "8                                   1258088.0   \n",
       "9                                    881810.0   \n",
       "10                                   228317.0   \n",
       "11                                   613146.0   \n",
       "12                                    70135.0   \n",
       "13                                  1139171.0   \n",
       "14                                   250064.0   \n",
       "15                                   131982.0   \n",
       "16                                   421203.0   \n",
       "17                                     8867.0   \n",
       "18                                     9461.0   \n",
       "19                                    10732.0   \n",
       "20                                  8614678.0   \n",
       "\n",
       "   Fecha de la última vacuna registrada (2)  \n",
       "0                       2021-05-26T00:00:00  \n",
       "1                       2021-05-26T00:00:00  \n",
       "2                       2021-05-26T00:00:00  \n",
       "3                       2021-05-26T00:00:00  \n",
       "4                       2021-05-26T00:00:00  \n",
       "5                       2021-05-26T00:00:00  \n",
       "6                       2021-05-26T00:00:00  \n",
       "7                       2021-05-26T00:00:00  \n",
       "8                       2021-05-26T00:00:00  \n",
       "9                       2021-05-26T00:00:00  \n",
       "10                      2021-05-26T00:00:00  \n",
       "11                      2021-05-26T00:00:00  \n",
       "12                      2021-05-26T00:00:00  \n",
       "13                      2021-05-26T00:00:00  \n",
       "14                      2021-05-26T00:00:00  \n",
       "15                      2021-05-26T00:00:00  \n",
       "16                      2021-05-26T00:00:00  \n",
       "17                      2021-05-26T00:00:00  \n",
       "18                      2021-05-26T00:00:00  \n",
       "19                      2021-05-26T00:00:00  \n",
       "20                                     None  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "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>unnamed.1</th>\n",
       "      <th>Dosis entregadas Pfizer (1)</th>\n",
       "      <th>Dosis entregadas Moderna (1)</th>\n",
       "      <th>Dosis entregadas AstraZeneca (1)</th>\n",
       "      <th>Dosis entregadas Janssen (1)</th>\n",
       "      <th>Total Dosis entregadas (1)</th>\n",
       "      <th>Dosis administradas (2)</th>\n",
       "      <th>% sobre entregadas</th>\n",
       "      <th>Nº Personas con al menos 1 dosis</th>\n",
       "      <th>Nº Personas vacunadas\\n(pauta completada)</th>\n",
       "      <th>Fecha de la última vacuna registrada (2)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Baleares</td>\n",
       "      <td>340830.0</td>\n",
       "      <td>54800.0</td>\n",
       "      <td>145800.0</td>\n",
       "      <td>14200.0</td>\n",
       "      <td>555630.0</td>\n",
       "      <td>518077.0</td>\n",
       "      <td>0.932414</td>\n",
       "      <td>371487.0</td>\n",
       "      <td>154356.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Melilla</td>\n",
       "      <td>24210.0</td>\n",
       "      <td>3700.0</td>\n",
       "      <td>11000.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>39960.0</td>\n",
       "      <td>35862.0</td>\n",
       "      <td>0.897447</td>\n",
       "      <td>27381.0</td>\n",
       "      <td>9461.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>La Rioja</td>\n",
       "      <td>133445.0</td>\n",
       "      <td>19500.0</td>\n",
       "      <td>39600.0</td>\n",
       "      <td>3900.0</td>\n",
       "      <td>196445.0</td>\n",
       "      <td>186704.0</td>\n",
       "      <td>0.950414</td>\n",
       "      <td>119865.0</td>\n",
       "      <td>70135.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Cantabria</td>\n",
       "      <td>252285.0</td>\n",
       "      <td>36900.0</td>\n",
       "      <td>72500.0</td>\n",
       "      <td>6950.0</td>\n",
       "      <td>368635.0</td>\n",
       "      <td>346706.0</td>\n",
       "      <td>0.940513</td>\n",
       "      <td>230025.0</td>\n",
       "      <td>120945.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>C. Valenciana</td>\n",
       "      <td>1783270.0</td>\n",
       "      <td>272700.0</td>\n",
       "      <td>629800.0</td>\n",
       "      <td>61400.0</td>\n",
       "      <td>2747170.0</td>\n",
       "      <td>2632543.0</td>\n",
       "      <td>0.958275</td>\n",
       "      <td>1797349.0</td>\n",
       "      <td>881810.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Aragón</td>\n",
       "      <td>567765.0</td>\n",
       "      <td>84500.0</td>\n",
       "      <td>165600.0</td>\n",
       "      <td>16000.0</td>\n",
       "      <td>833865.0</td>\n",
       "      <td>800211.0</td>\n",
       "      <td>0.959641</td>\n",
       "      <td>522723.0</td>\n",
       "      <td>287048.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Castilla La Mancha</td>\n",
       "      <td>797805.0</td>\n",
       "      <td>121100.0</td>\n",
       "      <td>253800.0</td>\n",
       "      <td>24675.0</td>\n",
       "      <td>1197380.0</td>\n",
       "      <td>1146802.0</td>\n",
       "      <td>0.957759</td>\n",
       "      <td>774216.0</td>\n",
       "      <td>393256.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Castilla y Leon</td>\n",
       "      <td>1218855.0</td>\n",
       "      <td>180200.0</td>\n",
       "      <td>298300.0</td>\n",
       "      <td>29150.0</td>\n",
       "      <td>1726505.0</td>\n",
       "      <td>1598322.0</td>\n",
       "      <td>0.925756</td>\n",
       "      <td>1005002.0</td>\n",
       "      <td>615945.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ceuta</td>\n",
       "      <td>24210.0</td>\n",
       "      <td>3800.0</td>\n",
       "      <td>11000.0</td>\n",
       "      <td>1050.0</td>\n",
       "      <td>40060.0</td>\n",
       "      <td>36761.0</td>\n",
       "      <td>0.917649</td>\n",
       "      <td>28671.0</td>\n",
       "      <td>8867.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Galicia</td>\n",
       "      <td>1280095.0</td>\n",
       "      <td>182600.0</td>\n",
       "      <td>336600.0</td>\n",
       "      <td>32900.0</td>\n",
       "      <td>1832195.0</td>\n",
       "      <td>1786951.0</td>\n",
       "      <td>0.975306</td>\n",
       "      <td>1194630.0</td>\n",
       "      <td>613146.0</td>\n",
       "      <td>2021-05-26T00:00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             unnamed.1  Dosis entregadas Pfizer (1)  \\\n",
       "3             Baleares                     340830.0   \n",
       "18             Melilla                      24210.0   \n",
       "12            La Rioja                     133445.0   \n",
       "5            Cantabria                     252285.0   \n",
       "9        C. Valenciana                    1783270.0   \n",
       "1               Aragón                     567765.0   \n",
       "7   Castilla La Mancha                     797805.0   \n",
       "6     Castilla y Leon                     1218855.0   \n",
       "17               Ceuta                      24210.0   \n",
       "11             Galicia                    1280095.0   \n",
       "\n",
       "    Dosis entregadas Moderna (1)  Dosis entregadas AstraZeneca (1)  \\\n",
       "3                        54800.0                          145800.0   \n",
       "18                        3700.0                           11000.0   \n",
       "12                       19500.0                           39600.0   \n",
       "5                        36900.0                           72500.0   \n",
       "9                       272700.0                          629800.0   \n",
       "1                        84500.0                          165600.0   \n",
       "7                       121100.0                          253800.0   \n",
       "6                       180200.0                          298300.0   \n",
       "17                        3800.0                           11000.0   \n",
       "11                      182600.0                          336600.0   \n",
       "\n",
       "    Dosis entregadas Janssen (1)  Total Dosis entregadas (1)  \\\n",
       "3                        14200.0                    555630.0   \n",
       "18                        1050.0                     39960.0   \n",
       "12                        3900.0                    196445.0   \n",
       "5                         6950.0                    368635.0   \n",
       "9                        61400.0                   2747170.0   \n",
       "1                        16000.0                    833865.0   \n",
       "7                        24675.0                   1197380.0   \n",
       "6                        29150.0                   1726505.0   \n",
       "17                        1050.0                     40060.0   \n",
       "11                       32900.0                   1832195.0   \n",
       "\n",
       "    Dosis administradas (2)  % sobre entregadas  \\\n",
       "3                  518077.0            0.932414   \n",
       "18                  35862.0            0.897447   \n",
       "12                 186704.0            0.950414   \n",
       "5                  346706.0            0.940513   \n",
       "9                 2632543.0            0.958275   \n",
       "1                  800211.0            0.959641   \n",
       "7                 1146802.0            0.957759   \n",
       "6                 1598322.0            0.925756   \n",
       "17                  36761.0            0.917649   \n",
       "11                1786951.0            0.975306   \n",
       "\n",
       "    Nº Personas con al menos 1 dosis  \\\n",
       "3                           371487.0   \n",
       "18                           27381.0   \n",
       "12                          119865.0   \n",
       "5                           230025.0   \n",
       "9                          1797349.0   \n",
       "1                           522723.0   \n",
       "7                           774216.0   \n",
       "6                          1005002.0   \n",
       "17                           28671.0   \n",
       "11                         1194630.0   \n",
       "\n",
       "    Nº Personas vacunadas\\n(pauta completada)  \\\n",
       "3                                    154356.0   \n",
       "18                                     9461.0   \n",
       "12                                    70135.0   \n",
       "5                                    120945.0   \n",
       "9                                    881810.0   \n",
       "1                                    287048.0   \n",
       "7                                    393256.0   \n",
       "6                                    615945.0   \n",
       "17                                     8867.0   \n",
       "11                                   613146.0   \n",
       "\n",
       "   Fecha de la última vacuna registrada (2)  \n",
       "3                       2021-05-26T00:00:00  \n",
       "18                      2021-05-26T00:00:00  \n",
       "12                      2021-05-26T00:00:00  \n",
       "5                       2021-05-26T00:00:00  \n",
       "9                       2021-05-26T00:00:00  \n",
       "1                       2021-05-26T00:00:00  \n",
       "7                       2021-05-26T00:00:00  \n",
       "6                       2021-05-26T00:00:00  \n",
       "17                      2021-05-26T00:00:00  \n",
       "11                      2021-05-26T00:00:00  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sample(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}