smoking_exploration.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "53aa021f",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import os\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4cdea173",
   "metadata": {},
   "source": [
    "# Acquire\n",
    "Data can be retrieved from the [World Health Organization (WHO)](https://www.who.int//)\n",
    "* [Age-standardized estimates of current tobacco use, tobacco smoking and cigarette smoking\n",
    "Data by country](https://apps.who.int/gho/data/view.main.TOBAGESTDCURRv)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "1043c134",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Relative to current location\n",
    "#  /1.   /2.   /3.       /4.       /5.    /6.      /7. \n",
    "# /Users/qmcbt/Documents/Education/Codeup/Projects/Smoking/ **(file is here)**\n",
    "# /1.    /2    /3.                 /4.       \n",
    "# /Users/qmcbt/codeup-data-science/my_notes/ **(I am here)**\n",
    "#          ../                 ../\n",
    "# I must go up 2 levels to reach first shared parent folder\n",
    "\n",
    "df = pd.read_csv('../../Documents/Education/Codeup/Projects/Smoking/M_Est_tob_curr_std,M_Est_smk_curr_std,M_Est_cig_curr_std.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "5b70a1ae",
   "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: 0</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Estimate of current tobacco use prevalence (%) (age-standardized rate)</th>\n",
       "      <th>Estimate of current tobacco use prevalence (%) (age-standardized rate).1</th>\n",
       "      <th>Estimate of current tobacco use prevalence (%) (age-standardized rate).2</th>\n",
       "      <th>Estimate of current tobacco smoking prevalence (%) (age-standardized rate)</th>\n",
       "      <th>Estimate of current tobacco smoking prevalence (%) (age-standardized rate).1</th>\n",
       "      <th>Estimate of current tobacco smoking prevalence (%) (age-standardized rate).2</th>\n",
       "      <th>Estimate of current cigarette smoking prevalence (%) (age-standardized rate)</th>\n",
       "      <th>Estimate of current cigarette smoking prevalence (%) (age-standardized rate).1</th>\n",
       "      <th>Estimate of current cigarette smoking prevalence (%) (age-standardized rate).2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Country</td>\n",
       "      <td>Year</td>\n",
       "      <td>Both sexes</td>\n",
       "      <td>Male</td>\n",
       "      <td>Female</td>\n",
       "      <td>Both sexes</td>\n",
       "      <td>Male</td>\n",
       "      <td>Female</td>\n",
       "      <td>Both sexes</td>\n",
       "      <td>Male</td>\n",
       "      <td>Female</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2025</td>\n",
       "      <td>21</td>\n",
       "      <td>36.3</td>\n",
       "      <td>5.7</td>\n",
       "      <td>7.8</td>\n",
       "      <td>14</td>\n",
       "      <td>1.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2023</td>\n",
       "      <td>8.4</td>\n",
       "      <td>37.4</td>\n",
       "      <td>6.2</td>\n",
       "      <td>8.4</td>\n",
       "      <td>15</td>\n",
       "      <td>1.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2020</td>\n",
       "      <td>23.3</td>\n",
       "      <td>39.4</td>\n",
       "      <td>7.2</td>\n",
       "      <td>9.5</td>\n",
       "      <td>16.7</td>\n",
       "      <td>2.2</td>\n",
       "      <td>7.7</td>\n",
       "      <td>14.5</td>\n",
       "      <td>0.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>2019</td>\n",
       "      <td>23.8</td>\n",
       "      <td>40.1</td>\n",
       "      <td>7.5</td>\n",
       "      <td>9.9</td>\n",
       "      <td>17.3</td>\n",
       "      <td>2.4</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1473</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>2018</td>\n",
       "      <td>12.1</td>\n",
       "      <td>23</td>\n",
       "      <td>1.7</td>\n",
       "      <td>11.4</td>\n",
       "      <td>21.7</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1474</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>2015</td>\n",
       "      <td>13.6</td>\n",
       "      <td>25.1</td>\n",
       "      <td>2</td>\n",
       "      <td>12.4</td>\n",
       "      <td>23.6</td>\n",
       "      <td>1.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1475</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>2010</td>\n",
       "      <td>15.6</td>\n",
       "      <td>28.6</td>\n",
       "      <td>2.6</td>\n",
       "      <td>14.5</td>\n",
       "      <td>27.4</td>\n",
       "      <td>1.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1476</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>2005</td>\n",
       "      <td>18.1</td>\n",
       "      <td>32.7</td>\n",
       "      <td>3.5</td>\n",
       "      <td>16.7</td>\n",
       "      <td>31.3</td>\n",
       "      <td>2.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1477</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>2000</td>\n",
       "      <td>21</td>\n",
       "      <td>37.3</td>\n",
       "      <td>4.6</td>\n",
       "      <td>19.5</td>\n",
       "      <td>36.1</td>\n",
       "      <td>2.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1478 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0 Unnamed: 1  \\\n",
       "0         Country       Year   \n",
       "1     Afghanistan       2025   \n",
       "2     Afghanistan       2023   \n",
       "3     Afghanistan       2020   \n",
       "4     Afghanistan       2019   \n",
       "...           ...        ...   \n",
       "1473     Zimbabwe       2018   \n",
       "1474     Zimbabwe       2015   \n",
       "1475     Zimbabwe       2010   \n",
       "1476     Zimbabwe       2005   \n",
       "1477     Zimbabwe       2000   \n",
       "\n",
       "     Estimate of current tobacco use prevalence (%) (age-standardized rate)  \\\n",
       "0                                            Both sexes                       \n",
       "1                                                    21                       \n",
       "2                                                   8.4                       \n",
       "3                                                  23.3                       \n",
       "4                                                  23.8                       \n",
       "...                                                 ...                       \n",
       "1473                                               12.1                       \n",
       "1474                                               13.6                       \n",
       "1475                                               15.6                       \n",
       "1476                                               18.1                       \n",
       "1477                                                 21                       \n",
       "\n",
       "     Estimate of current tobacco use prevalence (%) (age-standardized rate).1  \\\n",
       "0                                                  Male                         \n",
       "1                                                  36.3                         \n",
       "2                                                  37.4                         \n",
       "3                                                  39.4                         \n",
       "4                                                  40.1                         \n",
       "...                                                 ...                         \n",
       "1473                                                 23                         \n",
       "1474                                               25.1                         \n",
       "1475                                               28.6                         \n",
       "1476                                               32.7                         \n",
       "1477                                               37.3                         \n",
       "\n",
       "     Estimate of current tobacco use prevalence (%) (age-standardized rate).2  \\\n",
       "0                                                Female                         \n",
       "1                                                   5.7                         \n",
       "2                                                   6.2                         \n",
       "3                                                   7.2                         \n",
       "4                                                   7.5                         \n",
       "...                                                 ...                         \n",
       "1473                                                1.7                         \n",
       "1474                                                  2                         \n",
       "1475                                                2.6                         \n",
       "1476                                                3.5                         \n",
       "1477                                                4.6                         \n",
       "\n",
       "     Estimate of current tobacco smoking prevalence (%) (age-standardized rate)  \\\n",
       "0                                            Both sexes                           \n",
       "1                                                   7.8                           \n",
       "2                                                   8.4                           \n",
       "3                                                   9.5                           \n",
       "4                                                   9.9                           \n",
       "...                                                 ...                           \n",
       "1473                                               11.4                           \n",
       "1474                                               12.4                           \n",
       "1475                                               14.5                           \n",
       "1476                                               16.7                           \n",
       "1477                                               19.5                           \n",
       "\n",
       "     Estimate of current tobacco smoking prevalence (%) (age-standardized rate).1  \\\n",
       "0                                                  Male                             \n",
       "1                                                    14                             \n",
       "2                                                    15                             \n",
       "3                                                  16.7                             \n",
       "4                                                  17.3                             \n",
       "...                                                 ...                             \n",
       "1473                                               21.7                             \n",
       "1474                                               23.6                             \n",
       "1475                                               27.4                             \n",
       "1476                                               31.3                             \n",
       "1477                                               36.1                             \n",
       "\n",
       "     Estimate of current tobacco smoking prevalence (%) (age-standardized rate).2  \\\n",
       "0                                                Female                             \n",
       "1                                                   1.5                             \n",
       "2                                                   1.8                             \n",
       "3                                                   2.2                             \n",
       "4                                                   2.4                             \n",
       "...                                                 ...                             \n",
       "1473                                                  1                             \n",
       "1474                                                1.2                             \n",
       "1475                                                1.6                             \n",
       "1476                                                2.1                             \n",
       "1477                                                2.9                             \n",
       "\n",
       "     Estimate of current cigarette smoking prevalence (%) (age-standardized rate)  \\\n",
       "0                                            Both sexes                             \n",
       "1                                                   NaN                             \n",
       "2                                                   NaN                             \n",
       "3                                                   7.7                             \n",
       "4                                                   NaN                             \n",
       "...                                                 ...                             \n",
       "1473                                                NaN                             \n",
       "1474                                                NaN                             \n",
       "1475                                                NaN                             \n",
       "1476                                                NaN                             \n",
       "1477                                                NaN                             \n",
       "\n",
       "     Estimate of current cigarette smoking prevalence (%) (age-standardized rate).1  \\\n",
       "0                                                  Male                               \n",
       "1                                                   NaN                               \n",
       "2                                                   NaN                               \n",
       "3                                                  14.5                               \n",
       "4                                                   NaN                               \n",
       "...                                                 ...                               \n",
       "1473                                                NaN                               \n",
       "1474                                                NaN                               \n",
       "1475                                                NaN                               \n",
       "1476                                                NaN                               \n",
       "1477                                                NaN                               \n",
       "\n",
       "     Estimate of current cigarette smoking prevalence (%) (age-standardized rate).2  \n",
       "0                                                Female                              \n",
       "1                                                   NaN                              \n",
       "2                                                   NaN                              \n",
       "3                                                   0.9                              \n",
       "4                                                   NaN                              \n",
       "...                                                 ...                              \n",
       "1473                                                NaN                              \n",
       "1474                                                NaN                              \n",
       "1475                                                NaN                              \n",
       "1476                                                NaN                              \n",
       "1477                                                NaN                              \n",
       "\n",
       "[1478 rows x 11 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "3bc6ff94",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1478, 11)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "a6cb6907",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1478 entries, 0 to 1477\n",
      "Data columns (total 11 columns):\n",
      " #   Column                                                                          Non-Null Count  Dtype \n",
      "---  ------                                                                          --------------  ----- \n",
      " 0   Unnamed: 0                                                                      1478 non-null   object\n",
      " 1   Unnamed: 1                                                                      1478 non-null   object\n",
      " 2   Estimate of current tobacco use prevalence (%) (age-standardized rate)          1477 non-null   object\n",
      " 3   Estimate of current tobacco use prevalence (%) (age-standardized rate).1        1477 non-null   object\n",
      " 4   Estimate of current tobacco use prevalence (%) (age-standardized rate).2        1477 non-null   object\n",
      " 5   Estimate of current tobacco smoking prevalence (%) (age-standardized rate)      1477 non-null   object\n",
      " 6   Estimate of current tobacco smoking prevalence (%) (age-standardized rate).1    1477 non-null   object\n",
      " 7   Estimate of current tobacco smoking prevalence (%) (age-standardized rate).2    1477 non-null   object\n",
      " 8   Estimate of current cigarette smoking prevalence (%) (age-standardized rate)    166 non-null    object\n",
      " 9   Estimate of current cigarette smoking prevalence (%) (age-standardized rate).1  166 non-null    object\n",
      " 10  Estimate of current cigarette smoking prevalence (%) (age-standardized rate).2  166 non-null    object\n",
      "dtypes: object(11)\n",
      "memory usage: 127.1+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "50d25bf6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "166"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Number of Unique Countries\n",
    "df['Unnamed: 0'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "1bf9d29e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Country', 'Afghanistan', 'Albania', 'Algeria', 'Andorra',\n",
       "       'Argentina', 'Armenia', 'Australia', 'Austria', 'Azerbaijan',\n",
       "       'Bahamas', 'Bahrain', 'Bangladesh', 'Barbados', 'Belarus',\n",
       "       'Belgium', 'Belize', 'Benin', 'Bolivia (Plurinational State of)',\n",
       "       'Bosnia and Herzegovina', 'Botswana', 'Brazil',\n",
       "       'Brunei Darussalam', 'Bulgaria', 'Burkina Faso', 'Burundi',\n",
       "       'Cabo Verde', 'Cambodia', 'Cameroon', 'Canada', 'Chad', 'Chile',\n",
       "       'China', 'Colombia', 'Comoros', 'Congo', 'Cook Islands',\n",
       "       'Costa Rica', \"Côte d'Ivoire\", 'Croatia', 'Cuba', 'Cyprus',\n",
       "       'Czechia', \"Democratic People's Republic of Korea\",\n",
       "       'Democratic Republic of the Congo', 'Denmark',\n",
       "       'Dominican Republic', 'Ecuador', 'Egypt', 'El Salvador', 'Eritrea',\n",
       "       'Estonia', 'Eswatini', 'Ethiopia', 'Fiji', 'Finland', 'France',\n",
       "       'Gambia', 'Georgia', 'Germany', 'Ghana', 'Greece', 'Guatemala',\n",
       "       'Guinea-Bissau', 'Guyana', 'Haiti', 'Hungary', 'Iceland', 'India',\n",
       "       'Indonesia', 'Iran (Islamic Republic of)', 'Iraq', 'Ireland',\n",
       "       'Israel', 'Italy', 'Jamaica', 'Japan', 'Jordan', 'Kazakhstan',\n",
       "       'Kenya', 'Kiribati', 'Kuwait', 'Kyrgyzstan',\n",
       "       \"Lao People's Democratic Republic\", 'Latvia', 'Lebanon', 'Lesotho',\n",
       "       'Liberia', 'Lithuania', 'Luxembourg', 'Madagascar', 'Malawi',\n",
       "       'Malaysia', 'Maldives', 'Mali', 'Malta', 'Marshall Islands',\n",
       "       'Mauritania', 'Mauritius', 'Mexico', 'Mongolia', 'Montenegro',\n",
       "       'Morocco', 'Mozambique', 'Myanmar', 'Namibia', 'Nauru', 'Nepal',\n",
       "       'Netherlands', 'New Zealand', 'Niger', 'Nigeria', 'Norway', 'Oman',\n",
       "       'Pakistan', 'Palau', 'Panama', 'Papua New Guinea', 'Paraguay',\n",
       "       'Peru', 'Philippines', 'Poland', 'Portugal', 'Qatar',\n",
       "       'Republic of Korea', 'Republic of Moldova', 'Romania',\n",
       "       'Russian Federation', 'Rwanda', 'Samoa', 'Sao Tome and Principe',\n",
       "       'Saudi Arabia', 'Senegal', 'Serbia', 'Seychelles', 'Sierra Leone',\n",
       "       'Singapore', 'Slovakia', 'Slovenia', 'Solomon Islands',\n",
       "       'South Africa', 'Spain', 'Sri Lanka', 'Sweden', 'Switzerland',\n",
       "       'Thailand', 'Timor-Leste', 'Togo', 'Tonga', 'Tunisia', 'Türkiye',\n",
       "       'Turkmenistan', 'Tuvalu', 'Uganda', 'Ukraine',\n",
       "       'United Arab Emirates',\n",
       "       'United Kingdom of Great Britain and Northern Ireland',\n",
       "       'United Republic of Tanzania', 'United States of America',\n",
       "       'Uruguay', 'Uzbekistan', 'Vanuatu', 'Viet Nam', 'Yemen', 'Zambia',\n",
       "       'Zimbabwe'], dtype=object)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# List of Unique Countries\n",
    "df['Unnamed: 0'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "6bde251a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "10"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Number of Unique Years\n",
    "df['Unnamed: 1'].nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "42ddb5b7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Year', ' 2025', ' 2023', ' 2020', ' 2019', ' 2018', ' 2015',\n",
       "       ' 2010', ' 2005', ' 2000'], dtype=object)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# List of Unique Years\n",
    "df['Unnamed: 1'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "c80fff81",
   "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: 0</th>\n",
       "      <th>Unnamed: 1</th>\n",
       "      <th>Estimate of current tobacco use prevalence (%) (age-standardized rate)</th>\n",
       "      <th>Estimate of current tobacco use prevalence (%) (age-standardized rate).1</th>\n",
       "      <th>Estimate of current tobacco use prevalence (%) (age-standardized rate).2</th>\n",
       "      <th>Estimate of current tobacco smoking prevalence (%) (age-standardized rate)</th>\n",
       "      <th>Estimate of current tobacco smoking prevalence (%) (age-standardized rate).1</th>\n",
       "      <th>Estimate of current tobacco smoking prevalence (%) (age-standardized rate).2</th>\n",
       "      <th>Estimate of current cigarette smoking prevalence (%) (age-standardized rate)</th>\n",
       "      <th>Estimate of current cigarette smoking prevalence (%) (age-standardized rate).1</th>\n",
       "      <th>Estimate of current cigarette smoking prevalence (%) (age-standardized rate).2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>1478</td>\n",
       "      <td>1478</td>\n",
       "      <td>1477</td>\n",
       "      <td>1477</td>\n",
       "      <td>1477</td>\n",
       "      <td>1477</td>\n",
       "      <td>1477</td>\n",
       "      <td>1477</td>\n",
       "      <td>166</td>\n",
       "      <td>166</td>\n",
       "      <td>166</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique</th>\n",
       "      <td>166</td>\n",
       "      <td>10</td>\n",
       "      <td>417</td>\n",
       "      <td>529</td>\n",
       "      <td>359</td>\n",
       "      <td>406</td>\n",
       "      <td>508</td>\n",
       "      <td>335</td>\n",
       "      <td>145</td>\n",
       "      <td>141</td>\n",
       "      <td>93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>top</th>\n",
       "      <td>Lao People's Democratic Republic</td>\n",
       "      <td>2020</td>\n",
       "      <td>28.4</td>\n",
       "      <td>36.3</td>\n",
       "      <td>2</td>\n",
       "      <td>22</td>\n",
       "      <td>18.4</td>\n",
       "      <td>0.6</td>\n",
       "      <td>16.55</td>\n",
       "      <td>16.4</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>freq</th>\n",
       "      <td>9</td>\n",
       "      <td>165</td>\n",
       "      <td>13</td>\n",
       "      <td>9</td>\n",
       "      <td>18</td>\n",
       "      <td>13</td>\n",
       "      <td>10</td>\n",
       "      <td>30</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              Unnamed: 0 Unnamed: 1  \\\n",
       "count                               1478       1478   \n",
       "unique                               166         10   \n",
       "top     Lao People's Democratic Republic       2020   \n",
       "freq                                   9        165   \n",
       "\n",
       "       Estimate of current tobacco use prevalence (%) (age-standardized rate)  \\\n",
       "count                                                1477                       \n",
       "unique                                                417                       \n",
       "top                                                  28.4                       \n",
       "freq                                                   13                       \n",
       "\n",
       "       Estimate of current tobacco use prevalence (%) (age-standardized rate).1  \\\n",
       "count                                                1477                         \n",
       "unique                                                529                         \n",
       "top                                                  36.3                         \n",
       "freq                                                    9                         \n",
       "\n",
       "       Estimate of current tobacco use prevalence (%) (age-standardized rate).2  \\\n",
       "count                                                1477                         \n",
       "unique                                                359                         \n",
       "top                                                     2                         \n",
       "freq                                                   18                         \n",
       "\n",
       "       Estimate of current tobacco smoking prevalence (%) (age-standardized rate)  \\\n",
       "count                                                1477                           \n",
       "unique                                                406                           \n",
       "top                                                    22                           \n",
       "freq                                                   13                           \n",
       "\n",
       "       Estimate of current tobacco smoking prevalence (%) (age-standardized rate).1  \\\n",
       "count                                                1477                             \n",
       "unique                                                508                             \n",
       "top                                                  18.4                             \n",
       "freq                                                   10                             \n",
       "\n",
       "       Estimate of current tobacco smoking prevalence (%) (age-standardized rate).2  \\\n",
       "count                                                1477                             \n",
       "unique                                                335                             \n",
       "top                                                   0.6                             \n",
       "freq                                                   30                             \n",
       "\n",
       "       Estimate of current cigarette smoking prevalence (%) (age-standardized rate)  \\\n",
       "count                                                 166                             \n",
       "unique                                                145                             \n",
       "top                                                 16.55                             \n",
       "freq                                                    4                             \n",
       "\n",
       "       Estimate of current cigarette smoking prevalence (%) (age-standardized rate).1  \\\n",
       "count                                                 166                               \n",
       "unique                                                141                               \n",
       "top                                                  16.4                               \n",
       "freq                                                    3                               \n",
       "\n",
       "       Estimate of current cigarette smoking prevalence (%) (age-standardized rate).2  \n",
       "count                                                 166                              \n",
       "unique                                                 93                              \n",
       "top                                                   0.1                              \n",
       "freq                                                    8                              "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe(include='all')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "f929bd2d",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Unnamed: 0                                                                           0\n",
       "Unnamed: 1                                                                           0\n",
       "Estimate of current tobacco use prevalence (%) (age-standardized rate)               1\n",
       "Estimate of current tobacco use prevalence (%) (age-standardized rate).1             1\n",
       "Estimate of current tobacco use prevalence (%) (age-standardized rate).2             1\n",
       "Estimate of current tobacco smoking prevalence (%) (age-standardized rate)           1\n",
       "Estimate of current tobacco smoking prevalence (%) (age-standardized rate).1         1\n",
       "Estimate of current tobacco smoking prevalence (%) (age-standardized rate).2         1\n",
       "Estimate of current cigarette smoking prevalence (%) (age-standardized rate)      1312\n",
       "Estimate of current cigarette smoking prevalence (%) (age-standardized rate).1    1312\n",
       "Estimate of current cigarette smoking prevalence (%) (age-standardized rate).2    1312\n",
       "dtype: int64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9be53d48",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}