Untitled.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "4ae49693",
   "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>geografia</th>\n",
       "      <th>giorno</th>\n",
       "      <th>data</th>\n",
       "      <th>totale_casi_positivi</th>\n",
       "      <th>deceduti</th>\n",
       "      <th>deceduti_inc</th>\n",
       "      <th>totale_ricoveri</th>\n",
       "      <th>totale_ricoveri_inc</th>\n",
       "      <th>attualmente_positivi</th>\n",
       "      <th>dimessi</th>\n",
       "      <th>tamponi</th>\n",
       "      <th>tamponi_inc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AR</td>\n",
       "      <td>0</td>\n",
       "      <td>24/2/2020</td>\n",
       "      <td>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>1</th>\n",
       "      <td>FI</td>\n",
       "      <td>0</td>\n",
       "      <td>24/2/2020</td>\n",
       "      <td>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>2</th>\n",
       "      <td>GR</td>\n",
       "      <td>0</td>\n",
       "      <td>24/2/2020</td>\n",
       "      <td>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>3</th>\n",
       "      <td>LI</td>\n",
       "      <td>0</td>\n",
       "      <td>24/2/2020</td>\n",
       "      <td>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>4</th>\n",
       "      <td>LU</td>\n",
       "      <td>0</td>\n",
       "      <td>24/2/2020</td>\n",
       "      <td>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>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11797</th>\n",
       "      <td>SI</td>\n",
       "      <td>842</td>\n",
       "      <td>15/6/2022</td>\n",
       "      <td>82487</td>\n",
       "      <td>537.0</td>\n",
       "      <td>0.186567</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>11798</th>\n",
       "      <td>Toscana</td>\n",
       "      <td>842</td>\n",
       "      <td>15/6/2022</td>\n",
       "      <td>1167901</td>\n",
       "      <td>10134.0</td>\n",
       "      <td>0.039487</td>\n",
       "      <td>228.0</td>\n",
       "      <td>-0.436681</td>\n",
       "      <td>26052.0</td>\n",
       "      <td>1131715.0</td>\n",
       "      <td>6815858.0</td>\n",
       "      <td>0.024713</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11799</th>\n",
       "      <td>aslCENTRO</td>\n",
       "      <td>842</td>\n",
       "      <td>15/6/2022</td>\n",
       "      <td>497422</td>\n",
       "      <td>4936.0</td>\n",
       "      <td>0.000000</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>11800</th>\n",
       "      <td>aslNO</td>\n",
       "      <td>842</td>\n",
       "      <td>15/6/2022</td>\n",
       "      <td>418719</td>\n",
       "      <td>3474.0</td>\n",
       "      <td>0.057604</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>11801</th>\n",
       "      <td>aslSE</td>\n",
       "      <td>842</td>\n",
       "      <td>15/6/2022</td>\n",
       "      <td>251205</td>\n",
       "      <td>1585.0</td>\n",
       "      <td>0.126342</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",
       "  </tbody>\n",
       "</table>\n",
       "<p>11802 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       geografia  giorno       data  totale_casi_positivi  deceduti  \\\n",
       "0             AR       0  24/2/2020                     0       NaN   \n",
       "1             FI       0  24/2/2020                     0       NaN   \n",
       "2             GR       0  24/2/2020                     0       NaN   \n",
       "3             LI       0  24/2/2020                     0       NaN   \n",
       "4             LU       0  24/2/2020                     0       NaN   \n",
       "...          ...     ...        ...                   ...       ...   \n",
       "11797         SI     842  15/6/2022                 82487     537.0   \n",
       "11798    Toscana     842  15/6/2022               1167901   10134.0   \n",
       "11799  aslCENTRO     842  15/6/2022                497422    4936.0   \n",
       "11800      aslNO     842  15/6/2022                418719    3474.0   \n",
       "11801      aslSE     842  15/6/2022                251205    1585.0   \n",
       "\n",
       "       deceduti_inc  totale_ricoveri  totale_ricoveri_inc  \\\n",
       "0               NaN              NaN                  NaN   \n",
       "1               NaN              NaN                  NaN   \n",
       "2               NaN              NaN                  NaN   \n",
       "3               NaN              NaN                  NaN   \n",
       "4               NaN              NaN                  NaN   \n",
       "...             ...              ...                  ...   \n",
       "11797      0.186567              NaN                  NaN   \n",
       "11798      0.039487            228.0            -0.436681   \n",
       "11799      0.000000              NaN                  NaN   \n",
       "11800      0.057604              NaN                  NaN   \n",
       "11801      0.126342              NaN                  NaN   \n",
       "\n",
       "       attualmente_positivi    dimessi    tamponi  tamponi_inc  \n",
       "0                       NaN        NaN        NaN          NaN  \n",
       "1                       NaN        NaN        NaN          NaN  \n",
       "2                       NaN        NaN        NaN          NaN  \n",
       "3                       NaN        NaN        NaN          NaN  \n",
       "4                       NaN        NaN        NaN          NaN  \n",
       "...                     ...        ...        ...          ...  \n",
       "11797                   NaN        NaN        NaN          NaN  \n",
       "11798               26052.0  1131715.0  6815858.0     0.024713  \n",
       "11799                   NaN        NaN        NaN          NaN  \n",
       "11800                   NaN        NaN        NaN          NaN  \n",
       "11801                   NaN        NaN        NaN          NaN  \n",
       "\n",
       "[11802 rows x 12 columns]"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import datetime\n",
    "import warnings\n",
    "import pandas as pd\n",
    "DATA=pd.read_csv(r\"C:\\Users\\diego\\OneDrive\\Desktop\\DS\\kaggle_datasets\\covid_Tuscany\\covidars20220615.csv\",sep='|')\n",
    "DATA.drop(['totale_casi_positivi_ab','letalita'],axis=1,inplace=True)\n",
    "#\n",
    "DATA"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "f5dfa5b5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "geografia                   0\n",
       "giorno                      0\n",
       "data                        0\n",
       "totale_casi_positivi        0\n",
       "deceduti                  182\n",
       "deceduti_inc              285\n",
       "totale_ricoveri         10959\n",
       "totale_ricoveri_inc     10961\n",
       "attualmente_positivi    10959\n",
       "dimessi                 10959\n",
       "tamponi                 10959\n",
       "tamponi_inc             10960\n",
       "dtype: int64"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "DATA.isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "388fa8ad",
   "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>geografia</th>\n",
       "      <th>giorno</th>\n",
       "      <th>data</th>\n",
       "      <th>totale_casi_positivi</th>\n",
       "      <th>deceduti</th>\n",
       "      <th>deceduti_inc</th>\n",
       "      <th>totale_ricoveri</th>\n",
       "      <th>totale_ricoveri_inc</th>\n",
       "      <th>attualmente_positivi</th>\n",
       "      <th>dimessi</th>\n",
       "      <th>tamponi</th>\n",
       "      <th>tamponi_inc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Toscana</td>\n",
       "      <td>0</td>\n",
       "      <td>24/2/2020</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Toscana</td>\n",
       "      <td>1</td>\n",
       "      <td>25/2/2020</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>296.0</td>\n",
       "      <td>111.428570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Toscana</td>\n",
       "      <td>2</td>\n",
       "      <td>26/2/2020</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>363.0</td>\n",
       "      <td>22.635136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Toscana</td>\n",
       "      <td>3</td>\n",
       "      <td>27/2/2020</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>410.0</td>\n",
       "      <td>12.947659</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>Toscana</td>\n",
       "      <td>4</td>\n",
       "      <td>28/2/2020</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.0</td>\n",
       "      <td>150.000000</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>437.0</td>\n",
       "      <td>6.585366</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11742</th>\n",
       "      <td>Toscana</td>\n",
       "      <td>838</td>\n",
       "      <td>11/6/2022</td>\n",
       "      <td>1162512.0</td>\n",
       "      <td>10126.0</td>\n",
       "      <td>0.009877</td>\n",
       "      <td>200.0</td>\n",
       "      <td>-6.976744</td>\n",
       "      <td>24658.0</td>\n",
       "      <td>1127728.0</td>\n",
       "      <td>6810723.0</td>\n",
       "      <td>0.016491</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11756</th>\n",
       "      <td>Toscana</td>\n",
       "      <td>839</td>\n",
       "      <td>12/6/2022</td>\n",
       "      <td>1163547.0</td>\n",
       "      <td>10126.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>197.0</td>\n",
       "      <td>-1.500000</td>\n",
       "      <td>24684.0</td>\n",
       "      <td>1128737.0</td>\n",
       "      <td>6812155.0</td>\n",
       "      <td>0.021026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11770</th>\n",
       "      <td>Toscana</td>\n",
       "      <td>840</td>\n",
       "      <td>13/6/2022</td>\n",
       "      <td>1163981.0</td>\n",
       "      <td>10128.0</td>\n",
       "      <td>0.019751</td>\n",
       "      <td>219.0</td>\n",
       "      <td>11.167513</td>\n",
       "      <td>24395.0</td>\n",
       "      <td>1129458.0</td>\n",
       "      <td>6812587.0</td>\n",
       "      <td>0.006342</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11784</th>\n",
       "      <td>Toscana</td>\n",
       "      <td>841</td>\n",
       "      <td>14/6/2022</td>\n",
       "      <td>1166162.0</td>\n",
       "      <td>10130.0</td>\n",
       "      <td>0.019747</td>\n",
       "      <td>229.0</td>\n",
       "      <td>4.566210</td>\n",
       "      <td>24947.0</td>\n",
       "      <td>1131085.0</td>\n",
       "      <td>6814174.0</td>\n",
       "      <td>0.023295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11798</th>\n",
       "      <td>Toscana</td>\n",
       "      <td>842</td>\n",
       "      <td>15/6/2022</td>\n",
       "      <td>1167901.0</td>\n",
       "      <td>10134.0</td>\n",
       "      <td>0.039487</td>\n",
       "      <td>228.0</td>\n",
       "      <td>-0.436681</td>\n",
       "      <td>26052.0</td>\n",
       "      <td>1131715.0</td>\n",
       "      <td>6815858.0</td>\n",
       "      <td>0.024713</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>843 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      geografia  giorno       data  totale_casi_positivi  deceduti  \\\n",
       "10      Toscana       0  24/2/2020                   0.0       0.0   \n",
       "24      Toscana       1  25/2/2020                   2.0       0.0   \n",
       "38      Toscana       2  26/2/2020                   2.0       0.0   \n",
       "52      Toscana       3  27/2/2020                   2.0       0.0   \n",
       "66      Toscana       4  28/2/2020                   8.0       0.0   \n",
       "...         ...     ...        ...                   ...       ...   \n",
       "11742   Toscana     838  11/6/2022             1162512.0   10126.0   \n",
       "11756   Toscana     839  12/6/2022             1163547.0   10126.0   \n",
       "11770   Toscana     840  13/6/2022             1163981.0   10128.0   \n",
       "11784   Toscana     841  14/6/2022             1166162.0   10130.0   \n",
       "11798   Toscana     842  15/6/2022             1167901.0   10134.0   \n",
       "\n",
       "       deceduti_inc  totale_ricoveri  totale_ricoveri_inc  \\\n",
       "10         0.000000              0.0             0.000000   \n",
       "24         0.000000              2.0             0.000000   \n",
       "38         0.000000              2.0             0.000000   \n",
       "52         0.000000              2.0             0.000000   \n",
       "66         0.000000              5.0           150.000000   \n",
       "...             ...              ...                  ...   \n",
       "11742      0.009877            200.0            -6.976744   \n",
       "11756      0.000000            197.0            -1.500000   \n",
       "11770      0.019751            219.0            11.167513   \n",
       "11784      0.019747            229.0             4.566210   \n",
       "11798      0.039487            228.0            -0.436681   \n",
       "\n",
       "       attualmente_positivi    dimessi    tamponi  tamponi_inc  \n",
       "10                      0.0        0.0      140.0     0.000000  \n",
       "24                      2.0        0.0      296.0   111.428570  \n",
       "38                      2.0        0.0      363.0    22.635136  \n",
       "52                      2.0        0.0      410.0    12.947659  \n",
       "66                      7.0        1.0      437.0     6.585366  \n",
       "...                     ...        ...        ...          ...  \n",
       "11742               24658.0  1127728.0  6810723.0     0.016491  \n",
       "11756               24684.0  1128737.0  6812155.0     0.021026  \n",
       "11770               24395.0  1129458.0  6812587.0     0.006342  \n",
       "11784               24947.0  1131085.0  6814174.0     0.023295  \n",
       "11798               26052.0  1131715.0  6815858.0     0.024713  \n",
       "\n",
       "[843 rows x 12 columns]"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "regione=DATA.where(DATA['geografia']=='Toscana')\n",
    "regione.dropna(axis=0,how='all',inplace=True)\n",
    "regione['giorno']=regione['giorno'].astype('int64')\n",
    "regione.loc[:,['deceduti_inc','totale_ricoveri_inc','tamponi_inc']]=regione.loc[:,['deceduti_inc',\n",
    "        'totale_ricoveri_inc','tamponi_inc']].fillna(0)\n",
    "regione"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "89c65e54",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "geografia               0\n",
       "giorno                  0\n",
       "data                    0\n",
       "totale_casi_positivi    0\n",
       "deceduti                0\n",
       "deceduti_inc            0\n",
       "totale_ricoveri         0\n",
       "totale_ricoveri_inc     0\n",
       "attualmente_positivi    0\n",
       "dimessi                 0\n",
       "tamponi                 0\n",
       "tamponi_inc             0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "regione.isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "2c1c52f9",
   "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>geografia</th>\n",
       "      <th>giorno</th>\n",
       "      <th>data</th>\n",
       "      <th>totale_casi_positivi</th>\n",
       "      <th>deceduti</th>\n",
       "      <th>deceduti_inc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AR</td>\n",
       "      <td>0</td>\n",
       "      <td>24/2/2020</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>FI</td>\n",
       "      <td>0</td>\n",
       "      <td>24/2/2020</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>GR</td>\n",
       "      <td>0</td>\n",
       "      <td>24/2/2020</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>LI</td>\n",
       "      <td>0</td>\n",
       "      <td>24/2/2020</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>LU</td>\n",
       "      <td>0</td>\n",
       "      <td>24/2/2020</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</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>11796</th>\n",
       "      <td>PT</td>\n",
       "      <td>842</td>\n",
       "      <td>15/6/2022</td>\n",
       "      <td>93378.0</td>\n",
       "      <td>910.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11797</th>\n",
       "      <td>SI</td>\n",
       "      <td>842</td>\n",
       "      <td>15/6/2022</td>\n",
       "      <td>82487.0</td>\n",
       "      <td>537.0</td>\n",
       "      <td>0.186567</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11799</th>\n",
       "      <td>aslCENTRO</td>\n",
       "      <td>842</td>\n",
       "      <td>15/6/2022</td>\n",
       "      <td>497422.0</td>\n",
       "      <td>4936.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11800</th>\n",
       "      <td>aslNO</td>\n",
       "      <td>842</td>\n",
       "      <td>15/6/2022</td>\n",
       "      <td>418719.0</td>\n",
       "      <td>3474.0</td>\n",
       "      <td>0.057604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11801</th>\n",
       "      <td>aslSE</td>\n",
       "      <td>842</td>\n",
       "      <td>15/6/2022</td>\n",
       "      <td>251205.0</td>\n",
       "      <td>1585.0</td>\n",
       "      <td>0.126342</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10959 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       geografia  giorno       data  totale_casi_positivi  deceduti  \\\n",
       "0             AR       0  24/2/2020                   0.0       0.0   \n",
       "1             FI       0  24/2/2020                   0.0       0.0   \n",
       "2             GR       0  24/2/2020                   0.0       0.0   \n",
       "3             LI       0  24/2/2020                   0.0       0.0   \n",
       "4             LU       0  24/2/2020                   0.0       0.0   \n",
       "...          ...     ...        ...                   ...       ...   \n",
       "11796         PT     842  15/6/2022               93378.0     910.0   \n",
       "11797         SI     842  15/6/2022               82487.0     537.0   \n",
       "11799  aslCENTRO     842  15/6/2022              497422.0    4936.0   \n",
       "11800      aslNO     842  15/6/2022              418719.0    3474.0   \n",
       "11801      aslSE     842  15/6/2022              251205.0    1585.0   \n",
       "\n",
       "       deceduti_inc  \n",
       "0          0.000000  \n",
       "1          0.000000  \n",
       "2          0.000000  \n",
       "3          0.000000  \n",
       "4          0.000000  \n",
       "...             ...  \n",
       "11796      0.000000  \n",
       "11797      0.186567  \n",
       "11799      0.000000  \n",
       "11800      0.057604  \n",
       "11801      0.126342  \n",
       "\n",
       "[10959 rows x 6 columns]"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "DATA_province=DATA.where(DATA['geografia'] != 'Toscana')\n",
    "DATA_province.dropna(axis=0,how='all',inplace=True)\n",
    "\n",
    "\n",
    "DATA_province.drop(['totale_ricoveri',\n",
    "                        'totale_ricoveri_inc','attualmente_positivi',\n",
    "                   'dimessi','tamponi','tamponi_inc'],axis=1,inplace=True)\n",
    "DATA_province['giorno']=DATA_province['giorno'].astype('int64')\n",
    "DATA_province.loc[:,['deceduti','deceduti_inc']]=DATA_province.loc[:,['deceduti','deceduti_inc']].fillna(0)\n",
    "DATA_province"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "id": "8d4e6a8a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "geografia               0\n",
       "giorno                  0\n",
       "data                    0\n",
       "totale_casi_positivi    0\n",
       "deceduti                0\n",
       "deceduti_inc            0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "DATA_province.isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "id": "282a688c",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['AR' 'FI' 'GR' 'LI' 'LU' 'MS' 'PI' 'PO' 'PT' 'SI' 'aslCENTRO' 'aslNO'\n",
      " 'aslSE']\n"
     ]
    }
   ],
   "source": [
    "print(pd.unique(DATA_province['geografia']))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "id": "76426f78",
   "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>Location</th>\n",
       "      <th>day</th>\n",
       "      <th>date</th>\n",
       "      <th>total_number_positive_people</th>\n",
       "      <th>deaths</th>\n",
       "      <th>death_increment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AR</td>\n",
       "      <td>0</td>\n",
       "      <td>24/2/2020</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>FI</td>\n",
       "      <td>0</td>\n",
       "      <td>24/2/2020</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>GR</td>\n",
       "      <td>0</td>\n",
       "      <td>24/2/2020</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>LI</td>\n",
       "      <td>0</td>\n",
       "      <td>24/2/2020</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>LU</td>\n",
       "      <td>0</td>\n",
       "      <td>24/2/2020</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</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>11796</th>\n",
       "      <td>PT</td>\n",
       "      <td>842</td>\n",
       "      <td>15/6/2022</td>\n",
       "      <td>93378.0</td>\n",
       "      <td>910.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11797</th>\n",
       "      <td>SI</td>\n",
       "      <td>842</td>\n",
       "      <td>15/6/2022</td>\n",
       "      <td>82487.0</td>\n",
       "      <td>537.0</td>\n",
       "      <td>0.186567</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11799</th>\n",
       "      <td>aslCENTRO</td>\n",
       "      <td>842</td>\n",
       "      <td>15/6/2022</td>\n",
       "      <td>497422.0</td>\n",
       "      <td>4936.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11800</th>\n",
       "      <td>aslNO</td>\n",
       "      <td>842</td>\n",
       "      <td>15/6/2022</td>\n",
       "      <td>418719.0</td>\n",
       "      <td>3474.0</td>\n",
       "      <td>0.057604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11801</th>\n",
       "      <td>aslSE</td>\n",
       "      <td>842</td>\n",
       "      <td>15/6/2022</td>\n",
       "      <td>251205.0</td>\n",
       "      <td>1585.0</td>\n",
       "      <td>0.126342</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10959 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Location  day       date  total_number_positive_people  deaths  \\\n",
       "0             AR    0  24/2/2020                           0.0     0.0   \n",
       "1             FI    0  24/2/2020                           0.0     0.0   \n",
       "2             GR    0  24/2/2020                           0.0     0.0   \n",
       "3             LI    0  24/2/2020                           0.0     0.0   \n",
       "4             LU    0  24/2/2020                           0.0     0.0   \n",
       "...          ...  ...        ...                           ...     ...   \n",
       "11796         PT  842  15/6/2022                       93378.0   910.0   \n",
       "11797         SI  842  15/6/2022                       82487.0   537.0   \n",
       "11799  aslCENTRO  842  15/6/2022                      497422.0  4936.0   \n",
       "11800      aslNO  842  15/6/2022                      418719.0  3474.0   \n",
       "11801      aslSE  842  15/6/2022                      251205.0  1585.0   \n",
       "\n",
       "       death_increment  \n",
       "0             0.000000  \n",
       "1             0.000000  \n",
       "2             0.000000  \n",
       "3             0.000000  \n",
       "4             0.000000  \n",
       "...                ...  \n",
       "11796         0.000000  \n",
       "11797         0.186567  \n",
       "11799         0.000000  \n",
       "11800         0.057604  \n",
       "11801         0.126342  \n",
       "\n",
       "[10959 rows x 6 columns]"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "DATA_province.columns = ['Location', 'day', 'date', 'total_number_positive_people','deaths','deaths_increase']\n",
    "DATA_province"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b26730e6",
   "metadata": {},
   "outputs": [],
   "source": [
    "totale_ricoveri\ttotale_ricoveri_inc\tattualmente_positivi\tdimessi\ttamponi\ttamponi_inc\n",
    "\n",
    "regione.columns = ['Location', 'day', 'date', 'total_number_positive_people','deaths','deaths_increase','total_recoveries'\n",
    "                ,'total_recoveries_increase','currently_positive','']"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}