bmi_clean.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "3bd5a848",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Imports \n",
    "%matplotlib inline\n",
    "\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import math\n",
    "import seaborn as sns\n",
    "sns.set()\n",
    "sns.set_context('talk')\n",
    "\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')\n",
    "pd.set_option(\"display.max_columns\", 104)\n",
    "import patsy\n",
    "import statsmodels.api as sm\n",
    "import scipy.stats as stats\n",
    "from scipy.stats import ttest_ind, chisquare, normaltest\n",
    "# Note: the statsmodels import may print out a 'FutureWarning'. Thats fine."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "74b240a0",
   "metadata": {},
   "source": [
    "This file should be used to collect and scrape our code and stuff. thanks!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "84a3cb06",
   "metadata": {},
   "outputs": [],
   "source": [
    "# for BMI csv, region/world\n",
    "bmi = pd.read_csv(\"./datasets/bmi_country.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "fd01244e",
   "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>Country/Region/World</th>\n",
       "      <th>ISO</th>\n",
       "      <th>Sex</th>\n",
       "      <th>Year</th>\n",
       "      <th>Mean BMI</th>\n",
       "      <th>Mean BMI lower 95% uncertainty interval</th>\n",
       "      <th>Mean BMI upper 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI&gt;=30 kg/m² (obesity)</th>\n",
       "      <th>Prevalence of BMI&gt;=30 kg/m² lower 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI&gt;=30 kg/m² upper 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI&gt;=35 kg/m² (severe obesity)</th>\n",
       "      <th>Prevalence of BMI&gt;=35 kg/m² lower 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI&gt;=35 kg/m² upper 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI&lt;18.5 kg/m² (underweight)</th>\n",
       "      <th>Prevalence of BMI&lt;18.5 kg/m² lower 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI&lt;18.5 kg/m² upper 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 18.5 kg/m² to &lt;20 kg/m²</th>\n",
       "      <th>Prevalence of BMI 18.5 kg/m² to &lt;20 kg/m² lower 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 18.5 kg/m² to &lt;20 kg/m² upper 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 20 kg/m² to &lt;25 kg/m²</th>\n",
       "      <th>Prevalence of BMI 20 kg/m² to &lt;25 kg/m² lower 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 20 kg/m² to &lt;25 kg/m² upper 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 25 kg/m² to &lt;30 kg/m²</th>\n",
       "      <th>Prevalence of BMI 25 kg/m² to &lt;30 kg/m² lower 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 25 kg/m² to &lt;30 kg/m² upper 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 30 kg/m² to &lt;35 kg/m²</th>\n",
       "      <th>Prevalence of BMI 30 kg/m² to &lt;35 kg/m² lower 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 30 kg/m² to &lt;35 kg/m² upper 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 35 kg/m² to &lt;40 kg/m²</th>\n",
       "      <th>Prevalence of BMI 35 kg/m² to &lt;40 kg/m² lower 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 35 kg/m² to &lt;40 kg/m² upper 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI &gt;=40 kg/m²(morbid obesity)</th>\n",
       "      <th>Prevalence of BMI &gt;=40 kg/m² lower 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI &gt;=40 kg/m² upper 95% uncertainty interval</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>Men</td>\n",
       "      <td>1975</td>\n",
       "      <td>18.999440</td>\n",
       "      <td>16.331119</td>\n",
       "      <td>21.763077</td>\n",
       "      <td>0.002078</td>\n",
       "      <td>0.000384</td>\n",
       "      <td>0.006515</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000002</td>\n",
       "      <td>0.000158</td>\n",
       "      <td>0.284239</td>\n",
       "      <td>0.147565</td>\n",
       "      <td>0.421922</td>\n",
       "      <td>0.234271</td>\n",
       "      <td>0.134912</td>\n",
       "      <td>0.347236</td>\n",
       "      <td>0.428146</td>\n",
       "      <td>0.312880</td>\n",
       "      <td>0.551022</td>\n",
       "      <td>0.051266</td>\n",
       "      <td>0.021452</td>\n",
       "      <td>0.096419</td>\n",
       "      <td>0.002043</td>\n",
       "      <td>0.000351</td>\n",
       "      <td>0.006493</td>\n",
       "      <td>0.000027</td>\n",
       "      <td>6.663263e-07</td>\n",
       "      <td>0.000138</td>\n",
       "      <td>0.000008</td>\n",
       "      <td>5.054664e-08</td>\n",
       "      <td>0.000047</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>Men</td>\n",
       "      <td>1976</td>\n",
       "      <td>19.105518</td>\n",
       "      <td>16.500077</td>\n",
       "      <td>21.801109</td>\n",
       "      <td>0.002237</td>\n",
       "      <td>0.000437</td>\n",
       "      <td>0.006820</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000002</td>\n",
       "      <td>0.000168</td>\n",
       "      <td>0.281990</td>\n",
       "      <td>0.148634</td>\n",
       "      <td>0.417047</td>\n",
       "      <td>0.232208</td>\n",
       "      <td>0.136020</td>\n",
       "      <td>0.340563</td>\n",
       "      <td>0.430523</td>\n",
       "      <td>0.317865</td>\n",
       "      <td>0.549570</td>\n",
       "      <td>0.053042</td>\n",
       "      <td>0.022928</td>\n",
       "      <td>0.097881</td>\n",
       "      <td>0.002199</td>\n",
       "      <td>0.000403</td>\n",
       "      <td>0.006779</td>\n",
       "      <td>0.000030</td>\n",
       "      <td>8.525116e-07</td>\n",
       "      <td>0.000149</td>\n",
       "      <td>0.000009</td>\n",
       "      <td>6.816061e-08</td>\n",
       "      <td>0.000049</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>Men</td>\n",
       "      <td>1977</td>\n",
       "      <td>19.212080</td>\n",
       "      <td>16.646507</td>\n",
       "      <td>21.842021</td>\n",
       "      <td>0.002410</td>\n",
       "      <td>0.000497</td>\n",
       "      <td>0.007179</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>0.000185</td>\n",
       "      <td>0.279694</td>\n",
       "      <td>0.149224</td>\n",
       "      <td>0.412887</td>\n",
       "      <td>0.230125</td>\n",
       "      <td>0.136671</td>\n",
       "      <td>0.335139</td>\n",
       "      <td>0.432881</td>\n",
       "      <td>0.322810</td>\n",
       "      <td>0.549225</td>\n",
       "      <td>0.054890</td>\n",
       "      <td>0.024613</td>\n",
       "      <td>0.098869</td>\n",
       "      <td>0.002368</td>\n",
       "      <td>0.000454</td>\n",
       "      <td>0.007144</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1.080451e-06</td>\n",
       "      <td>0.000163</td>\n",
       "      <td>0.000009</td>\n",
       "      <td>9.255251e-08</td>\n",
       "      <td>0.000053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>Men</td>\n",
       "      <td>1978</td>\n",
       "      <td>19.319053</td>\n",
       "      <td>16.786899</td>\n",
       "      <td>21.876516</td>\n",
       "      <td>0.002599</td>\n",
       "      <td>0.000559</td>\n",
       "      <td>0.007567</td>\n",
       "      <td>0.000047</td>\n",
       "      <td>0.000003</td>\n",
       "      <td>0.000202</td>\n",
       "      <td>0.277336</td>\n",
       "      <td>0.150410</td>\n",
       "      <td>0.407314</td>\n",
       "      <td>0.228031</td>\n",
       "      <td>0.137231</td>\n",
       "      <td>0.330865</td>\n",
       "      <td>0.435219</td>\n",
       "      <td>0.327795</td>\n",
       "      <td>0.548325</td>\n",
       "      <td>0.056815</td>\n",
       "      <td>0.026318</td>\n",
       "      <td>0.100453</td>\n",
       "      <td>0.002551</td>\n",
       "      <td>0.000519</td>\n",
       "      <td>0.007540</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>1.364412e-06</td>\n",
       "      <td>0.000178</td>\n",
       "      <td>0.000010</td>\n",
       "      <td>1.262377e-07</td>\n",
       "      <td>0.000057</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>AFG</td>\n",
       "      <td>Men</td>\n",
       "      <td>1979</td>\n",
       "      <td>19.425952</td>\n",
       "      <td>16.950002</td>\n",
       "      <td>21.930634</td>\n",
       "      <td>0.002804</td>\n",
       "      <td>0.000636</td>\n",
       "      <td>0.008026</td>\n",
       "      <td>0.000053</td>\n",
       "      <td>0.000004</td>\n",
       "      <td>0.000220</td>\n",
       "      <td>0.274931</td>\n",
       "      <td>0.151589</td>\n",
       "      <td>0.403758</td>\n",
       "      <td>0.225927</td>\n",
       "      <td>0.137064</td>\n",
       "      <td>0.327193</td>\n",
       "      <td>0.437522</td>\n",
       "      <td>0.332613</td>\n",
       "      <td>0.547925</td>\n",
       "      <td>0.058816</td>\n",
       "      <td>0.028116</td>\n",
       "      <td>0.102426</td>\n",
       "      <td>0.002751</td>\n",
       "      <td>0.000581</td>\n",
       "      <td>0.007971</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>1.698723e-06</td>\n",
       "      <td>0.000193</td>\n",
       "      <td>0.000011</td>\n",
       "      <td>1.576738e-07</td>\n",
       "      <td>0.000062</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Country/Region/World  ISO  Sex  Year   Mean BMI  \\\n",
       "0          Afghanistan  AFG  Men  1975  18.999440   \n",
       "1          Afghanistan  AFG  Men  1976  19.105518   \n",
       "2          Afghanistan  AFG  Men  1977  19.212080   \n",
       "3          Afghanistan  AFG  Men  1978  19.319053   \n",
       "4          Afghanistan  AFG  Men  1979  19.425952   \n",
       "\n",
       "   Mean BMI lower 95% uncertainty interval  \\\n",
       "0                                16.331119   \n",
       "1                                16.500077   \n",
       "2                                16.646507   \n",
       "3                                16.786899   \n",
       "4                                16.950002   \n",
       "\n",
       "   Mean BMI upper 95% uncertainty interval  \\\n",
       "0                                21.763077   \n",
       "1                                21.801109   \n",
       "2                                21.842021   \n",
       "3                                21.876516   \n",
       "4                                21.930634   \n",
       "\n",
       "   Prevalence of BMI>=30 kg/m² (obesity)  \\\n",
       "0                               0.002078   \n",
       "1                               0.002237   \n",
       "2                               0.002410   \n",
       "3                               0.002599   \n",
       "4                               0.002804   \n",
       "\n",
       "   Prevalence of BMI>=30 kg/m² lower 95% uncertainty interval  \\\n",
       "0                                           0.000384            \n",
       "1                                           0.000437            \n",
       "2                                           0.000497            \n",
       "3                                           0.000559            \n",
       "4                                           0.000636            \n",
       "\n",
       "   Prevalence of BMI>=30 kg/m² upper 95% uncertainty interval  \\\n",
       "0                                           0.006515            \n",
       "1                                           0.006820            \n",
       "2                                           0.007179            \n",
       "3                                           0.007567            \n",
       "4                                           0.008026            \n",
       "\n",
       "   Prevalence of BMI>=35 kg/m² (severe obesity)  \\\n",
       "0                                      0.000034   \n",
       "1                                      0.000038   \n",
       "2                                      0.000042   \n",
       "3                                      0.000047   \n",
       "4                                      0.000053   \n",
       "\n",
       "   Prevalence of BMI>=35 kg/m² lower 95% uncertainty interval  \\\n",
       "0                                           0.000002            \n",
       "1                                           0.000002            \n",
       "2                                           0.000003            \n",
       "3                                           0.000003            \n",
       "4                                           0.000004            \n",
       "\n",
       "   Prevalence of BMI>=35 kg/m² upper 95% uncertainty interval  \\\n",
       "0                                           0.000158            \n",
       "1                                           0.000168            \n",
       "2                                           0.000185            \n",
       "3                                           0.000202            \n",
       "4                                           0.000220            \n",
       "\n",
       "   Prevalence of BMI<18.5 kg/m² (underweight)  \\\n",
       "0                                    0.284239   \n",
       "1                                    0.281990   \n",
       "2                                    0.279694   \n",
       "3                                    0.277336   \n",
       "4                                    0.274931   \n",
       "\n",
       "   Prevalence of BMI<18.5 kg/m² lower 95% uncertainty interval  \\\n",
       "0                                           0.147565             \n",
       "1                                           0.148634             \n",
       "2                                           0.149224             \n",
       "3                                           0.150410             \n",
       "4                                           0.151589             \n",
       "\n",
       "   Prevalence of BMI<18.5 kg/m² upper 95% uncertainty interval  \\\n",
       "0                                           0.421922             \n",
       "1                                           0.417047             \n",
       "2                                           0.412887             \n",
       "3                                           0.407314             \n",
       "4                                           0.403758             \n",
       "\n",
       "   Prevalence of BMI 18.5 kg/m² to <20 kg/m²  \\\n",
       "0                                   0.234271   \n",
       "1                                   0.232208   \n",
       "2                                   0.230125   \n",
       "3                                   0.228031   \n",
       "4                                   0.225927   \n",
       "\n",
       "   Prevalence of BMI 18.5 kg/m² to <20 kg/m² lower 95% uncertainty interval  \\\n",
       "0                                           0.134912                          \n",
       "1                                           0.136020                          \n",
       "2                                           0.136671                          \n",
       "3                                           0.137231                          \n",
       "4                                           0.137064                          \n",
       "\n",
       "   Prevalence of BMI 18.5 kg/m² to <20 kg/m² upper 95% uncertainty interval  \\\n",
       "0                                           0.347236                          \n",
       "1                                           0.340563                          \n",
       "2                                           0.335139                          \n",
       "3                                           0.330865                          \n",
       "4                                           0.327193                          \n",
       "\n",
       "   Prevalence of BMI 20 kg/m² to <25 kg/m²  \\\n",
       "0                                 0.428146   \n",
       "1                                 0.430523   \n",
       "2                                 0.432881   \n",
       "3                                 0.435219   \n",
       "4                                 0.437522   \n",
       "\n",
       "   Prevalence of BMI 20 kg/m² to <25 kg/m² lower 95% uncertainty interval  \\\n",
       "0                                           0.312880                        \n",
       "1                                           0.317865                        \n",
       "2                                           0.322810                        \n",
       "3                                           0.327795                        \n",
       "4                                           0.332613                        \n",
       "\n",
       "   Prevalence of BMI 20 kg/m² to <25 kg/m² upper 95% uncertainty interval  \\\n",
       "0                                           0.551022                        \n",
       "1                                           0.549570                        \n",
       "2                                           0.549225                        \n",
       "3                                           0.548325                        \n",
       "4                                           0.547925                        \n",
       "\n",
       "   Prevalence of BMI 25 kg/m² to <30 kg/m²  \\\n",
       "0                                 0.051266   \n",
       "1                                 0.053042   \n",
       "2                                 0.054890   \n",
       "3                                 0.056815   \n",
       "4                                 0.058816   \n",
       "\n",
       "   Prevalence of BMI 25 kg/m² to <30 kg/m² lower 95% uncertainty interval  \\\n",
       "0                                           0.021452                        \n",
       "1                                           0.022928                        \n",
       "2                                           0.024613                        \n",
       "3                                           0.026318                        \n",
       "4                                           0.028116                        \n",
       "\n",
       "   Prevalence of BMI 25 kg/m² to <30 kg/m² upper 95% uncertainty interval  \\\n",
       "0                                           0.096419                        \n",
       "1                                           0.097881                        \n",
       "2                                           0.098869                        \n",
       "3                                           0.100453                        \n",
       "4                                           0.102426                        \n",
       "\n",
       "   Prevalence of BMI 30 kg/m² to <35 kg/m²  \\\n",
       "0                                 0.002043   \n",
       "1                                 0.002199   \n",
       "2                                 0.002368   \n",
       "3                                 0.002551   \n",
       "4                                 0.002751   \n",
       "\n",
       "   Prevalence of BMI 30 kg/m² to <35 kg/m² lower 95% uncertainty interval  \\\n",
       "0                                           0.000351                        \n",
       "1                                           0.000403                        \n",
       "2                                           0.000454                        \n",
       "3                                           0.000519                        \n",
       "4                                           0.000581                        \n",
       "\n",
       "   Prevalence of BMI 30 kg/m² to <35 kg/m² upper 95% uncertainty interval  \\\n",
       "0                                           0.006493                        \n",
       "1                                           0.006779                        \n",
       "2                                           0.007144                        \n",
       "3                                           0.007540                        \n",
       "4                                           0.007971                        \n",
       "\n",
       "   Prevalence of BMI 35 kg/m² to <40 kg/m²  \\\n",
       "0                                 0.000027   \n",
       "1                                 0.000030   \n",
       "2                                 0.000033   \n",
       "3                                 0.000037   \n",
       "4                                 0.000041   \n",
       "\n",
       "   Prevalence of BMI 35 kg/m² to <40 kg/m² lower 95% uncertainty interval  \\\n",
       "0                                       6.663263e-07                        \n",
       "1                                       8.525116e-07                        \n",
       "2                                       1.080451e-06                        \n",
       "3                                       1.364412e-06                        \n",
       "4                                       1.698723e-06                        \n",
       "\n",
       "   Prevalence of BMI 35 kg/m² to <40 kg/m² upper 95% uncertainty interval  \\\n",
       "0                                           0.000138                        \n",
       "1                                           0.000149                        \n",
       "2                                           0.000163                        \n",
       "3                                           0.000178                        \n",
       "4                                           0.000193                        \n",
       "\n",
       "   Prevalence of BMI >=40 kg/m²(morbid obesity)  \\\n",
       "0                                      0.000008   \n",
       "1                                      0.000009   \n",
       "2                                      0.000009   \n",
       "3                                      0.000010   \n",
       "4                                      0.000011   \n",
       "\n",
       "   Prevalence of BMI >=40 kg/m² lower 95% uncertainty interval  \\\n",
       "0                                       5.054664e-08             \n",
       "1                                       6.816061e-08             \n",
       "2                                       9.255251e-08             \n",
       "3                                       1.262377e-07             \n",
       "4                                       1.576738e-07             \n",
       "\n",
       "   Prevalence of BMI >=40 kg/m² upper 95% uncertainty interval  \n",
       "0                                           0.000047            \n",
       "1                                           0.000049            \n",
       "2                                           0.000053            \n",
       "3                                           0.000057            \n",
       "4                                           0.000062            "
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bmi.head() # basically just checking if it is properly uploaded and works"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "a0a65704",
   "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>Country/Region/World</th>\n",
       "      <th>Sex</th>\n",
       "      <th>Year</th>\n",
       "      <th>Mean BMI</th>\n",
       "      <th>Mean BMI lower 95% uncertainty interval</th>\n",
       "      <th>Mean BMI upper 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI&gt;=30 kg/m² (obesity)</th>\n",
       "      <th>Prevalence of BMI&gt;=30 kg/m² lower 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI&gt;=30 kg/m² upper 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI&gt;=35 kg/m² (severe obesity)</th>\n",
       "      <th>Prevalence of BMI&gt;=35 kg/m² lower 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI&gt;=35 kg/m² upper 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI&lt;18.5 kg/m² (underweight)</th>\n",
       "      <th>Prevalence of BMI&lt;18.5 kg/m² lower 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI&lt;18.5 kg/m² upper 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 18.5 kg/m² to &lt;20 kg/m²</th>\n",
       "      <th>Prevalence of BMI 18.5 kg/m² to &lt;20 kg/m² lower 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 18.5 kg/m² to &lt;20 kg/m² upper 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 20 kg/m² to &lt;25 kg/m²</th>\n",
       "      <th>Prevalence of BMI 20 kg/m² to &lt;25 kg/m² lower 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 20 kg/m² to &lt;25 kg/m² upper 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 25 kg/m² to &lt;30 kg/m²</th>\n",
       "      <th>Prevalence of BMI 25 kg/m² to &lt;30 kg/m² lower 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 25 kg/m² to &lt;30 kg/m² upper 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 30 kg/m² to &lt;35 kg/m²</th>\n",
       "      <th>Prevalence of BMI 30 kg/m² to &lt;35 kg/m² lower 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 30 kg/m² to &lt;35 kg/m² upper 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 35 kg/m² to &lt;40 kg/m²</th>\n",
       "      <th>Prevalence of BMI 35 kg/m² to &lt;40 kg/m² lower 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI 35 kg/m² to &lt;40 kg/m² upper 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI &gt;=40 kg/m²(morbid obesity)</th>\n",
       "      <th>Prevalence of BMI &gt;=40 kg/m² lower 95% uncertainty interval</th>\n",
       "      <th>Prevalence of BMI &gt;=40 kg/m² upper 95% uncertainty interval</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Men</td>\n",
       "      <td>2000</td>\n",
       "      <td>21.369506</td>\n",
       "      <td>19.153423</td>\n",
       "      <td>23.559675</td>\n",
       "      <td>0.012297</td>\n",
       "      <td>0.004712</td>\n",
       "      <td>0.026176</td>\n",
       "      <td>0.000582</td>\n",
       "      <td>0.000112</td>\n",
       "      <td>0.001755</td>\n",
       "      <td>0.218857</td>\n",
       "      <td>0.116488</td>\n",
       "      <td>0.329003</td>\n",
       "      <td>0.181228</td>\n",
       "      <td>0.115501</td>\n",
       "      <td>0.257605</td>\n",
       "      <td>0.474904</td>\n",
       "      <td>0.392218</td>\n",
       "      <td>0.562829</td>\n",
       "      <td>0.112715</td>\n",
       "      <td>0.074823</td>\n",
       "      <td>0.161792</td>\n",
       "      <td>0.011715</td>\n",
       "      <td>0.004119</td>\n",
       "      <td>0.025631</td>\n",
       "      <td>0.000440</td>\n",
       "      <td>0.000053</td>\n",
       "      <td>0.001507</td>\n",
       "      <td>0.000142</td>\n",
       "      <td>0.000008</td>\n",
       "      <td>0.000623</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Men</td>\n",
       "      <td>2001</td>\n",
       "      <td>21.456846</td>\n",
       "      <td>19.226323</td>\n",
       "      <td>23.641168</td>\n",
       "      <td>0.013129</td>\n",
       "      <td>0.005102</td>\n",
       "      <td>0.027750</td>\n",
       "      <td>0.000649</td>\n",
       "      <td>0.000128</td>\n",
       "      <td>0.001936</td>\n",
       "      <td>0.215744</td>\n",
       "      <td>0.114774</td>\n",
       "      <td>0.325905</td>\n",
       "      <td>0.178977</td>\n",
       "      <td>0.113907</td>\n",
       "      <td>0.254904</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.394457</td>\n",
       "      <td>0.562832</td>\n",
       "      <td>0.115959</td>\n",
       "      <td>0.077215</td>\n",
       "      <td>0.165228</td>\n",
       "      <td>0.012479</td>\n",
       "      <td>0.004480</td>\n",
       "      <td>0.027253</td>\n",
       "      <td>0.000489</td>\n",
       "      <td>0.000060</td>\n",
       "      <td>0.001679</td>\n",
       "      <td>0.000160</td>\n",
       "      <td>0.000010</td>\n",
       "      <td>0.000694</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Men</td>\n",
       "      <td>2002</td>\n",
       "      <td>21.543463</td>\n",
       "      <td>19.301239</td>\n",
       "      <td>23.727827</td>\n",
       "      <td>0.014011</td>\n",
       "      <td>0.005522</td>\n",
       "      <td>0.029456</td>\n",
       "      <td>0.000724</td>\n",
       "      <td>0.000145</td>\n",
       "      <td>0.002104</td>\n",
       "      <td>0.212595</td>\n",
       "      <td>0.112654</td>\n",
       "      <td>0.322228</td>\n",
       "      <td>0.176702</td>\n",
       "      <td>0.112743</td>\n",
       "      <td>0.251709</td>\n",
       "      <td>0.477428</td>\n",
       "      <td>0.396318</td>\n",
       "      <td>0.563393</td>\n",
       "      <td>0.119263</td>\n",
       "      <td>0.080114</td>\n",
       "      <td>0.168613</td>\n",
       "      <td>0.013287</td>\n",
       "      <td>0.004841</td>\n",
       "      <td>0.028726</td>\n",
       "      <td>0.000544</td>\n",
       "      <td>0.000070</td>\n",
       "      <td>0.001836</td>\n",
       "      <td>0.000181</td>\n",
       "      <td>0.000011</td>\n",
       "      <td>0.000769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Men</td>\n",
       "      <td>2003</td>\n",
       "      <td>21.628227</td>\n",
       "      <td>19.394877</td>\n",
       "      <td>23.830242</td>\n",
       "      <td>0.014947</td>\n",
       "      <td>0.006002</td>\n",
       "      <td>0.031181</td>\n",
       "      <td>0.000807</td>\n",
       "      <td>0.000167</td>\n",
       "      <td>0.002341</td>\n",
       "      <td>0.209419</td>\n",
       "      <td>0.110636</td>\n",
       "      <td>0.318674</td>\n",
       "      <td>0.174411</td>\n",
       "      <td>0.110997</td>\n",
       "      <td>0.248713</td>\n",
       "      <td>0.478601</td>\n",
       "      <td>0.397541</td>\n",
       "      <td>0.564361</td>\n",
       "      <td>0.122622</td>\n",
       "      <td>0.082665</td>\n",
       "      <td>0.173029</td>\n",
       "      <td>0.014140</td>\n",
       "      <td>0.005196</td>\n",
       "      <td>0.030535</td>\n",
       "      <td>0.000604</td>\n",
       "      <td>0.000080</td>\n",
       "      <td>0.002018</td>\n",
       "      <td>0.000204</td>\n",
       "      <td>0.000013</td>\n",
       "      <td>0.000860</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Men</td>\n",
       "      <td>2004</td>\n",
       "      <td>21.710447</td>\n",
       "      <td>19.476779</td>\n",
       "      <td>23.912341</td>\n",
       "      <td>0.015937</td>\n",
       "      <td>0.006489</td>\n",
       "      <td>0.032795</td>\n",
       "      <td>0.000900</td>\n",
       "      <td>0.000187</td>\n",
       "      <td>0.002584</td>\n",
       "      <td>0.206212</td>\n",
       "      <td>0.108702</td>\n",
       "      <td>0.315840</td>\n",
       "      <td>0.172098</td>\n",
       "      <td>0.109884</td>\n",
       "      <td>0.246124</td>\n",
       "      <td>0.479721</td>\n",
       "      <td>0.399063</td>\n",
       "      <td>0.564695</td>\n",
       "      <td>0.126031</td>\n",
       "      <td>0.085312</td>\n",
       "      <td>0.177013</td>\n",
       "      <td>0.015038</td>\n",
       "      <td>0.005581</td>\n",
       "      <td>0.032024</td>\n",
       "      <td>0.000670</td>\n",
       "      <td>0.000092</td>\n",
       "      <td>0.002221</td>\n",
       "      <td>0.000230</td>\n",
       "      <td>0.000015</td>\n",
       "      <td>0.000959</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Country/Region/World  Sex  Year   Mean BMI  \\\n",
       "25          Afghanistan  Men  2000  21.369506   \n",
       "26          Afghanistan  Men  2001  21.456846   \n",
       "27          Afghanistan  Men  2002  21.543463   \n",
       "28          Afghanistan  Men  2003  21.628227   \n",
       "29          Afghanistan  Men  2004  21.710447   \n",
       "\n",
       "    Mean BMI lower 95% uncertainty interval  \\\n",
       "25                                19.153423   \n",
       "26                                19.226323   \n",
       "27                                19.301239   \n",
       "28                                19.394877   \n",
       "29                                19.476779   \n",
       "\n",
       "    Mean BMI upper 95% uncertainty interval  \\\n",
       "25                                23.559675   \n",
       "26                                23.641168   \n",
       "27                                23.727827   \n",
       "28                                23.830242   \n",
       "29                                23.912341   \n",
       "\n",
       "    Prevalence of BMI>=30 kg/m² (obesity)  \\\n",
       "25                               0.012297   \n",
       "26                               0.013129   \n",
       "27                               0.014011   \n",
       "28                               0.014947   \n",
       "29                               0.015937   \n",
       "\n",
       "    Prevalence of BMI>=30 kg/m² lower 95% uncertainty interval  \\\n",
       "25                                           0.004712            \n",
       "26                                           0.005102            \n",
       "27                                           0.005522            \n",
       "28                                           0.006002            \n",
       "29                                           0.006489            \n",
       "\n",
       "    Prevalence of BMI>=30 kg/m² upper 95% uncertainty interval  \\\n",
       "25                                           0.026176            \n",
       "26                                           0.027750            \n",
       "27                                           0.029456            \n",
       "28                                           0.031181            \n",
       "29                                           0.032795            \n",
       "\n",
       "    Prevalence of BMI>=35 kg/m² (severe obesity)  \\\n",
       "25                                      0.000582   \n",
       "26                                      0.000649   \n",
       "27                                      0.000724   \n",
       "28                                      0.000807   \n",
       "29                                      0.000900   \n",
       "\n",
       "    Prevalence of BMI>=35 kg/m² lower 95% uncertainty interval  \\\n",
       "25                                           0.000112            \n",
       "26                                           0.000128            \n",
       "27                                           0.000145            \n",
       "28                                           0.000167            \n",
       "29                                           0.000187            \n",
       "\n",
       "    Prevalence of BMI>=35 kg/m² upper 95% uncertainty interval  \\\n",
       "25                                           0.001755            \n",
       "26                                           0.001936            \n",
       "27                                           0.002104            \n",
       "28                                           0.002341            \n",
       "29                                           0.002584            \n",
       "\n",
       "    Prevalence of BMI<18.5 kg/m² (underweight)  \\\n",
       "25                                    0.218857   \n",
       "26                                    0.215744   \n",
       "27                                    0.212595   \n",
       "28                                    0.209419   \n",
       "29                                    0.206212   \n",
       "\n",
       "    Prevalence of BMI<18.5 kg/m² lower 95% uncertainty interval  \\\n",
       "25                                           0.116488             \n",
       "26                                           0.114774             \n",
       "27                                           0.112654             \n",
       "28                                           0.110636             \n",
       "29                                           0.108702             \n",
       "\n",
       "    Prevalence of BMI<18.5 kg/m² upper 95% uncertainty interval  \\\n",
       "25                                           0.329003             \n",
       "26                                           0.325905             \n",
       "27                                           0.322228             \n",
       "28                                           0.318674             \n",
       "29                                           0.315840             \n",
       "\n",
       "    Prevalence of BMI 18.5 kg/m² to <20 kg/m²  \\\n",
       "25                                   0.181228   \n",
       "26                                   0.178977   \n",
       "27                                   0.176702   \n",
       "28                                   0.174411   \n",
       "29                                   0.172098   \n",
       "\n",
       "    Prevalence of BMI 18.5 kg/m² to <20 kg/m² lower 95% uncertainty interval  \\\n",
       "25                                           0.115501                          \n",
       "26                                           0.113907                          \n",
       "27                                           0.112743                          \n",
       "28                                           0.110997                          \n",
       "29                                           0.109884                          \n",
       "\n",
       "    Prevalence of BMI 18.5 kg/m² to <20 kg/m² upper 95% uncertainty interval  \\\n",
       "25                                           0.257605                          \n",
       "26                                           0.254904                          \n",
       "27                                           0.251709                          \n",
       "28                                           0.248713                          \n",
       "29                                           0.246124                          \n",
       "\n",
       "    Prevalence of BMI 20 kg/m² to <25 kg/m²  \\\n",
       "25                                 0.474904   \n",
       "26                                 0.476190   \n",
       "27                                 0.477428   \n",
       "28                                 0.478601   \n",
       "29                                 0.479721   \n",
       "\n",
       "    Prevalence of BMI 20 kg/m² to <25 kg/m² lower 95% uncertainty interval  \\\n",
       "25                                           0.392218                        \n",
       "26                                           0.394457                        \n",
       "27                                           0.396318                        \n",
       "28                                           0.397541                        \n",
       "29                                           0.399063                        \n",
       "\n",
       "    Prevalence of BMI 20 kg/m² to <25 kg/m² upper 95% uncertainty interval  \\\n",
       "25                                           0.562829                        \n",
       "26                                           0.562832                        \n",
       "27                                           0.563393                        \n",
       "28                                           0.564361                        \n",
       "29                                           0.564695                        \n",
       "\n",
       "    Prevalence of BMI 25 kg/m² to <30 kg/m²  \\\n",
       "25                                 0.112715   \n",
       "26                                 0.115959   \n",
       "27                                 0.119263   \n",
       "28                                 0.122622   \n",
       "29                                 0.126031   \n",
       "\n",
       "    Prevalence of BMI 25 kg/m² to <30 kg/m² lower 95% uncertainty interval  \\\n",
       "25                                           0.074823                        \n",
       "26                                           0.077215                        \n",
       "27                                           0.080114                        \n",
       "28                                           0.082665                        \n",
       "29                                           0.085312                        \n",
       "\n",
       "    Prevalence of BMI 25 kg/m² to <30 kg/m² upper 95% uncertainty interval  \\\n",
       "25                                           0.161792                        \n",
       "26                                           0.165228                        \n",
       "27                                           0.168613                        \n",
       "28                                           0.173029                        \n",
       "29                                           0.177013                        \n",
       "\n",
       "    Prevalence of BMI 30 kg/m² to <35 kg/m²  \\\n",
       "25                                 0.011715   \n",
       "26                                 0.012479   \n",
       "27                                 0.013287   \n",
       "28                                 0.014140   \n",
       "29                                 0.015038   \n",
       "\n",
       "    Prevalence of BMI 30 kg/m² to <35 kg/m² lower 95% uncertainty interval  \\\n",
       "25                                           0.004119                        \n",
       "26                                           0.004480                        \n",
       "27                                           0.004841                        \n",
       "28                                           0.005196                        \n",
       "29                                           0.005581                        \n",
       "\n",
       "    Prevalence of BMI 30 kg/m² to <35 kg/m² upper 95% uncertainty interval  \\\n",
       "25                                           0.025631                        \n",
       "26                                           0.027253                        \n",
       "27                                           0.028726                        \n",
       "28                                           0.030535                        \n",
       "29                                           0.032024                        \n",
       "\n",
       "    Prevalence of BMI 35 kg/m² to <40 kg/m²  \\\n",
       "25                                 0.000440   \n",
       "26                                 0.000489   \n",
       "27                                 0.000544   \n",
       "28                                 0.000604   \n",
       "29                                 0.000670   \n",
       "\n",
       "    Prevalence of BMI 35 kg/m² to <40 kg/m² lower 95% uncertainty interval  \\\n",
       "25                                           0.000053                        \n",
       "26                                           0.000060                        \n",
       "27                                           0.000070                        \n",
       "28                                           0.000080                        \n",
       "29                                           0.000092                        \n",
       "\n",
       "    Prevalence of BMI 35 kg/m² to <40 kg/m² upper 95% uncertainty interval  \\\n",
       "25                                           0.001507                        \n",
       "26                                           0.001679                        \n",
       "27                                           0.001836                        \n",
       "28                                           0.002018                        \n",
       "29                                           0.002221                        \n",
       "\n",
       "    Prevalence of BMI >=40 kg/m²(morbid obesity)  \\\n",
       "25                                      0.000142   \n",
       "26                                      0.000160   \n",
       "27                                      0.000181   \n",
       "28                                      0.000204   \n",
       "29                                      0.000230   \n",
       "\n",
       "    Prevalence of BMI >=40 kg/m² lower 95% uncertainty interval  \\\n",
       "25                                           0.000008             \n",
       "26                                           0.000010             \n",
       "27                                           0.000011             \n",
       "28                                           0.000013             \n",
       "29                                           0.000015             \n",
       "\n",
       "    Prevalence of BMI >=40 kg/m² upper 95% uncertainty interval  \n",
       "25                                           0.000623            \n",
       "26                                           0.000694            \n",
       "27                                           0.000769            \n",
       "28                                           0.000860            \n",
       "29                                           0.000959            "
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# CLEANING UP TABLE\n",
    "bmi = bmi[bmi['Year'] >= 2000] # updating it so that it is only in 21st century\n",
    "if 'ISO' in bmi.columns: # deletes NaN column that wasn't used\n",
    "    del bmi['ISO']\n",
    "bmi.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1ba3782b",
   "metadata": {},
   "source": [
    "Next up, standardizing the table, with sex and relevant BMI information"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "3272844e",
   "metadata": {},
   "outputs": [],
   "source": [
    "def standardize_gender(str_in): \n",
    "    try:\n",
    "        if pd.notna(str_in):\n",
    "            str_in = str_in.lower().strip()\n",
    "\n",
    "            \n",
    "            if 'women' in str_in:\n",
    "                return str_in.replace('women', 'F')\n",
    "            elif 'men' in str_in:\n",
    "                return str_in.replace('men', 'M')\n",
    "            else:\n",
    "                return np.nan\n",
    "        else:\n",
    "            return np.nan\n",
    "    except Exception as e:\n",
    "        print(f\"An error occurred: {e}\")\n",
    "        return np.nan"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "29e90874",
   "metadata": {},
   "outputs": [],
   "source": [
    "bmi['Sex'] = bmi['Sex'].apply(standardize_gender)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "e7a0e7a8",
   "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>Country/Region/World</th>\n",
       "      <th>Sex</th>\n",
       "      <th>Year</th>\n",
       "      <th>Mean BMI</th>\n",
       "      <th>Prevalence of BMI&gt;=30 kg/m² (obesity)</th>\n",
       "      <th>Prevalence of BMI&gt;=35 kg/m² (severe obesity)</th>\n",
       "      <th>Prevalence of BMI&lt;18.5 kg/m² (underweight)</th>\n",
       "      <th>Prevalence of BMI 18.5 kg/m² to &lt;20 kg/m²</th>\n",
       "      <th>Prevalence of BMI 20 kg/m² to &lt;25 kg/m²</th>\n",
       "      <th>Prevalence of BMI 25 kg/m² to &lt;30 kg/m²</th>\n",
       "      <th>Prevalence of BMI 30 kg/m² to &lt;35 kg/m²</th>\n",
       "      <th>Prevalence of BMI 35 kg/m² to &lt;40 kg/m²</th>\n",
       "      <th>Prevalence of BMI &gt;=40 kg/m²(morbid obesity)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>M</td>\n",
       "      <td>2000</td>\n",
       "      <td>21.369506</td>\n",
       "      <td>0.012297</td>\n",
       "      <td>0.000582</td>\n",
       "      <td>0.218857</td>\n",
       "      <td>0.181228</td>\n",
       "      <td>0.474904</td>\n",
       "      <td>0.112715</td>\n",
       "      <td>0.011715</td>\n",
       "      <td>0.000440</td>\n",
       "      <td>0.000142</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>M</td>\n",
       "      <td>2001</td>\n",
       "      <td>21.456846</td>\n",
       "      <td>0.013129</td>\n",
       "      <td>0.000649</td>\n",
       "      <td>0.215744</td>\n",
       "      <td>0.178977</td>\n",
       "      <td>0.476190</td>\n",
       "      <td>0.115959</td>\n",
       "      <td>0.012479</td>\n",
       "      <td>0.000489</td>\n",
       "      <td>0.000160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>M</td>\n",
       "      <td>2002</td>\n",
       "      <td>21.543463</td>\n",
       "      <td>0.014011</td>\n",
       "      <td>0.000724</td>\n",
       "      <td>0.212595</td>\n",
       "      <td>0.176702</td>\n",
       "      <td>0.477428</td>\n",
       "      <td>0.119263</td>\n",
       "      <td>0.013287</td>\n",
       "      <td>0.000544</td>\n",
       "      <td>0.000181</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>M</td>\n",
       "      <td>2003</td>\n",
       "      <td>21.628227</td>\n",
       "      <td>0.014947</td>\n",
       "      <td>0.000807</td>\n",
       "      <td>0.209419</td>\n",
       "      <td>0.174411</td>\n",
       "      <td>0.478601</td>\n",
       "      <td>0.122622</td>\n",
       "      <td>0.014140</td>\n",
       "      <td>0.000604</td>\n",
       "      <td>0.000204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>M</td>\n",
       "      <td>2004</td>\n",
       "      <td>21.710447</td>\n",
       "      <td>0.015937</td>\n",
       "      <td>0.000900</td>\n",
       "      <td>0.206212</td>\n",
       "      <td>0.172098</td>\n",
       "      <td>0.479721</td>\n",
       "      <td>0.126031</td>\n",
       "      <td>0.015038</td>\n",
       "      <td>0.000670</td>\n",
       "      <td>0.000230</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16795</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>F</td>\n",
       "      <td>2012</td>\n",
       "      <td>25.284840</td>\n",
       "      <td>0.244698</td>\n",
       "      <td>0.084217</td>\n",
       "      <td>0.049484</td>\n",
       "      <td>0.072888</td>\n",
       "      <td>0.355026</td>\n",
       "      <td>0.277904</td>\n",
       "      <td>0.160482</td>\n",
       "      <td>0.055707</td>\n",
       "      <td>0.028509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16796</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>F</td>\n",
       "      <td>2013</td>\n",
       "      <td>25.319948</td>\n",
       "      <td>0.249242</td>\n",
       "      <td>0.086849</td>\n",
       "      <td>0.048700</td>\n",
       "      <td>0.071592</td>\n",
       "      <td>0.351572</td>\n",
       "      <td>0.278894</td>\n",
       "      <td>0.162394</td>\n",
       "      <td>0.057094</td>\n",
       "      <td>0.029754</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16797</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>F</td>\n",
       "      <td>2014</td>\n",
       "      <td>25.356222</td>\n",
       "      <td>0.253836</td>\n",
       "      <td>0.089553</td>\n",
       "      <td>0.047933</td>\n",
       "      <td>0.070315</td>\n",
       "      <td>0.348091</td>\n",
       "      <td>0.279826</td>\n",
       "      <td>0.164283</td>\n",
       "      <td>0.058500</td>\n",
       "      <td>0.031054</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16798</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>F</td>\n",
       "      <td>2015</td>\n",
       "      <td>25.393409</td>\n",
       "      <td>0.258485</td>\n",
       "      <td>0.092343</td>\n",
       "      <td>0.047186</td>\n",
       "      <td>0.069068</td>\n",
       "      <td>0.344566</td>\n",
       "      <td>0.280695</td>\n",
       "      <td>0.166141</td>\n",
       "      <td>0.059935</td>\n",
       "      <td>0.032408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16799</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>F</td>\n",
       "      <td>2016</td>\n",
       "      <td>25.431487</td>\n",
       "      <td>0.263240</td>\n",
       "      <td>0.095246</td>\n",
       "      <td>0.046450</td>\n",
       "      <td>0.067832</td>\n",
       "      <td>0.340970</td>\n",
       "      <td>0.281509</td>\n",
       "      <td>0.167994</td>\n",
       "      <td>0.061414</td>\n",
       "      <td>0.033832</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6800 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Country/Region/World Sex  Year   Mean BMI  \\\n",
       "25             Afghanistan   M  2000  21.369506   \n",
       "26             Afghanistan   M  2001  21.456846   \n",
       "27             Afghanistan   M  2002  21.543463   \n",
       "28             Afghanistan   M  2003  21.628227   \n",
       "29             Afghanistan   M  2004  21.710447   \n",
       "...                    ...  ..   ...        ...   \n",
       "16795             Zimbabwe   F  2012  25.284840   \n",
       "16796             Zimbabwe   F  2013  25.319948   \n",
       "16797             Zimbabwe   F  2014  25.356222   \n",
       "16798             Zimbabwe   F  2015  25.393409   \n",
       "16799             Zimbabwe   F  2016  25.431487   \n",
       "\n",
       "       Prevalence of BMI>=30 kg/m² (obesity)  \\\n",
       "25                                  0.012297   \n",
       "26                                  0.013129   \n",
       "27                                  0.014011   \n",
       "28                                  0.014947   \n",
       "29                                  0.015937   \n",
       "...                                      ...   \n",
       "16795                               0.244698   \n",
       "16796                               0.249242   \n",
       "16797                               0.253836   \n",
       "16798                               0.258485   \n",
       "16799                               0.263240   \n",
       "\n",
       "       Prevalence of BMI>=35 kg/m² (severe obesity)  \\\n",
       "25                                         0.000582   \n",
       "26                                         0.000649   \n",
       "27                                         0.000724   \n",
       "28                                         0.000807   \n",
       "29                                         0.000900   \n",
       "...                                             ...   \n",
       "16795                                      0.084217   \n",
       "16796                                      0.086849   \n",
       "16797                                      0.089553   \n",
       "16798                                      0.092343   \n",
       "16799                                      0.095246   \n",
       "\n",
       "       Prevalence of BMI<18.5 kg/m² (underweight)  \\\n",
       "25                                       0.218857   \n",
       "26                                       0.215744   \n",
       "27                                       0.212595   \n",
       "28                                       0.209419   \n",
       "29                                       0.206212   \n",
       "...                                           ...   \n",
       "16795                                    0.049484   \n",
       "16796                                    0.048700   \n",
       "16797                                    0.047933   \n",
       "16798                                    0.047186   \n",
       "16799                                    0.046450   \n",
       "\n",
       "       Prevalence of BMI 18.5 kg/m² to <20 kg/m²  \\\n",
       "25                                      0.181228   \n",
       "26                                      0.178977   \n",
       "27                                      0.176702   \n",
       "28                                      0.174411   \n",
       "29                                      0.172098   \n",
       "...                                          ...   \n",
       "16795                                   0.072888   \n",
       "16796                                   0.071592   \n",
       "16797                                   0.070315   \n",
       "16798                                   0.069068   \n",
       "16799                                   0.067832   \n",
       "\n",
       "       Prevalence of BMI 20 kg/m² to <25 kg/m²  \\\n",
       "25                                    0.474904   \n",
       "26                                    0.476190   \n",
       "27                                    0.477428   \n",
       "28                                    0.478601   \n",
       "29                                    0.479721   \n",
       "...                                        ...   \n",
       "16795                                 0.355026   \n",
       "16796                                 0.351572   \n",
       "16797                                 0.348091   \n",
       "16798                                 0.344566   \n",
       "16799                                 0.340970   \n",
       "\n",
       "       Prevalence of BMI 25 kg/m² to <30 kg/m²  \\\n",
       "25                                    0.112715   \n",
       "26                                    0.115959   \n",
       "27                                    0.119263   \n",
       "28                                    0.122622   \n",
       "29                                    0.126031   \n",
       "...                                        ...   \n",
       "16795                                 0.277904   \n",
       "16796                                 0.278894   \n",
       "16797                                 0.279826   \n",
       "16798                                 0.280695   \n",
       "16799                                 0.281509   \n",
       "\n",
       "       Prevalence of BMI 30 kg/m² to <35 kg/m²  \\\n",
       "25                                    0.011715   \n",
       "26                                    0.012479   \n",
       "27                                    0.013287   \n",
       "28                                    0.014140   \n",
       "29                                    0.015038   \n",
       "...                                        ...   \n",
       "16795                                 0.160482   \n",
       "16796                                 0.162394   \n",
       "16797                                 0.164283   \n",
       "16798                                 0.166141   \n",
       "16799                                 0.167994   \n",
       "\n",
       "       Prevalence of BMI 35 kg/m² to <40 kg/m²  \\\n",
       "25                                    0.000440   \n",
       "26                                    0.000489   \n",
       "27                                    0.000544   \n",
       "28                                    0.000604   \n",
       "29                                    0.000670   \n",
       "...                                        ...   \n",
       "16795                                 0.055707   \n",
       "16796                                 0.057094   \n",
       "16797                                 0.058500   \n",
       "16798                                 0.059935   \n",
       "16799                                 0.061414   \n",
       "\n",
       "       Prevalence of BMI >=40 kg/m²(morbid obesity)  \n",
       "25                                         0.000142  \n",
       "26                                         0.000160  \n",
       "27                                         0.000181  \n",
       "28                                         0.000204  \n",
       "29                                         0.000230  \n",
       "...                                             ...  \n",
       "16795                                      0.028509  \n",
       "16796                                      0.029754  \n",
       "16797                                      0.031054  \n",
       "16798                                      0.032408  \n",
       "16799                                      0.033832  \n",
       "\n",
       "[6800 rows x 13 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# cleans up uncertainty interval, we can add back if needed for EDA but not sure\n",
    "for col in bmi.columns:\n",
    "    if 'uncertainty interval' in col:\n",
    "        del bmi[col]\n",
    "bmi"
   ]
  }
 ],
 "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.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}