Урок 17. Pandas-3.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Урок 17. Pandas, часть 3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd # импорт библиотеки Pandas"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 1. Объединение датафреймов методами merge и concat"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 264,
   "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>measure</th>\n",
       "      <th>location</th>\n",
       "      <th>sex</th>\n",
       "      <th>age</th>\n",
       "      <th>cause</th>\n",
       "      <th>metric</th>\n",
       "      <th>year</th>\n",
       "      <th>val</th>\n",
       "      <th>upper</th>\n",
       "      <th>lower</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Maternal and neonatal disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>7475.212700</td>\n",
       "      <td>9104.773541</td>\n",
       "      <td>6157.428603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Maternal and neonatal disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>7814.344518</td>\n",
       "      <td>9667.960848</td>\n",
       "      <td>6289.146375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Number</td>\n",
       "      <td>2012</td>\n",
       "      <td>1659.038707</td>\n",
       "      <td>2126.829521</td>\n",
       "      <td>1239.172699</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Number</td>\n",
       "      <td>2012</td>\n",
       "      <td>874.432466</td>\n",
       "      <td>1186.560596</td>\n",
       "      <td>618.271780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Number</td>\n",
       "      <td>2012</td>\n",
       "      <td>2533.471173</td>\n",
       "      <td>3231.220866</td>\n",
       "      <td>1868.204609</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Percent</td>\n",
       "      <td>2012</td>\n",
       "      <td>0.003799</td>\n",
       "      <td>0.004849</td>\n",
       "      <td>0.002863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Percent</td>\n",
       "      <td>2012</td>\n",
       "      <td>0.002202</td>\n",
       "      <td>0.002889</td>\n",
       "      <td>0.001585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Percent</td>\n",
       "      <td>2012</td>\n",
       "      <td>0.003038</td>\n",
       "      <td>0.003885</td>\n",
       "      <td>0.002298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>179.493660</td>\n",
       "      <td>230.104586</td>\n",
       "      <td>134.067784</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>91.400543</td>\n",
       "      <td>124.025911</td>\n",
       "      <td>64.625204</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  measure location     sex       age  \\\n",
       "0  DALYs (Disability-Adjusted Life Years)   Gambia  Female  All Ages   \n",
       "1  DALYs (Disability-Adjusted Life Years)   Gambia    Both  All Ages   \n",
       "2  DALYs (Disability-Adjusted Life Years)   Gambia    Male  All Ages   \n",
       "3  DALYs (Disability-Adjusted Life Years)   Gambia  Female  All Ages   \n",
       "4  DALYs (Disability-Adjusted Life Years)   Gambia    Both  All Ages   \n",
       "5  DALYs (Disability-Adjusted Life Years)   Gambia    Male  All Ages   \n",
       "6  DALYs (Disability-Adjusted Life Years)   Gambia  Female  All Ages   \n",
       "7  DALYs (Disability-Adjusted Life Years)   Gambia    Both  All Ages   \n",
       "8  DALYs (Disability-Adjusted Life Years)   Gambia    Male  All Ages   \n",
       "9  DALYs (Disability-Adjusted Life Years)   Gambia  Female  All Ages   \n",
       "\n",
       "                             cause   metric  year          val        upper  \\\n",
       "0  Maternal and neonatal disorders     Rate  2012  7475.212700  9104.773541   \n",
       "1  Maternal and neonatal disorders     Rate  2012  7814.344518  9667.960848   \n",
       "2          Substance use disorders   Number  2012  1659.038707  2126.829521   \n",
       "3          Substance use disorders   Number  2012   874.432466  1186.560596   \n",
       "4          Substance use disorders   Number  2012  2533.471173  3231.220866   \n",
       "5          Substance use disorders  Percent  2012     0.003799     0.004849   \n",
       "6          Substance use disorders  Percent  2012     0.002202     0.002889   \n",
       "7          Substance use disorders  Percent  2012     0.003038     0.003885   \n",
       "8          Substance use disorders     Rate  2012   179.493660   230.104586   \n",
       "9          Substance use disorders     Rate  2012    91.400543   124.025911   \n",
       "\n",
       "         lower  \n",
       "0  6157.428603  \n",
       "1  6289.146375  \n",
       "2  1239.172699  \n",
       "3   618.271780  \n",
       "4  1868.204609  \n",
       "5     0.002863  \n",
       "6     0.001585  \n",
       "7     0.002298  \n",
       "8   134.067784  \n",
       "9    64.625204  "
      ]
     },
     "execution_count": 264,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1 = pd.read_csv('/Users/sherlock/Downloads/IHME-GBD_2019_DATA-15798851-2/IHME-GBD_2019_DATA-15798851-2.csv')\n",
    "\n",
    "# загружем 1-ый файл, сохранненный на компьютере\n",
    "# ссылка на скачивание https://drive.google.com/file/d/1uK1edpdqVFJnFaGTWGpVOlaJHgoCBwli/view?usp=sharing \n",
    "# источник данных Global Burden of Disease Study 2019 (GBD 2019) Results.\n",
    "# Seattle, United States: Institute for Health Metrics and Evaluation (IHME), 2020.\n",
    "# Сайт http://ghdx.healthdata.org/gbd-results-tool\n",
    "# DALYs (Disability-Adjusted Life Years) — этот показатель означает, \n",
    "# сколько лет здоровой и продуктивной жизни люди теряют из-за нетрудоспособности и ранней смерти от разных болезней\n",
    "\n",
    "df1.head(10) # выводим первые 10 строк"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 265,
   "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>measure</th>\n",
       "      <th>location</th>\n",
       "      <th>sex</th>\n",
       "      <th>age</th>\n",
       "      <th>cause</th>\n",
       "      <th>metric</th>\n",
       "      <th>year</th>\n",
       "      <th>val</th>\n",
       "      <th>upper</th>\n",
       "      <th>lower</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Deaths</td>\n",
       "      <td>Samoa</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Chronic respiratory diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2000</td>\n",
       "      <td>64.470214</td>\n",
       "      <td>81.808307</td>\n",
       "      <td>53.476793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Deaths</td>\n",
       "      <td>Samoa</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Chronic respiratory diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2000</td>\n",
       "      <td>55.234399</td>\n",
       "      <td>77.883497</td>\n",
       "      <td>39.978647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Deaths</td>\n",
       "      <td>Samoa</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Chronic respiratory diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2000</td>\n",
       "      <td>60.039961</td>\n",
       "      <td>76.013089</td>\n",
       "      <td>49.941986</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Deaths</td>\n",
       "      <td>Samoa</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Skin and subcutaneous diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2000</td>\n",
       "      <td>2.246741</td>\n",
       "      <td>3.467454</td>\n",
       "      <td>1.438979</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Deaths</td>\n",
       "      <td>Samoa</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Skin and subcutaneous diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2000</td>\n",
       "      <td>1.368385</td>\n",
       "      <td>1.945448</td>\n",
       "      <td>0.866099</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Deaths</td>\n",
       "      <td>Samoa</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Skin and subcutaneous diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2000</td>\n",
       "      <td>1.825409</td>\n",
       "      <td>2.569260</td>\n",
       "      <td>1.259226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Deaths</td>\n",
       "      <td>Samoa</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Transport injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2000</td>\n",
       "      <td>25.920294</td>\n",
       "      <td>36.084587</td>\n",
       "      <td>18.130636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Deaths</td>\n",
       "      <td>Samoa</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Transport injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2000</td>\n",
       "      <td>10.099048</td>\n",
       "      <td>13.447738</td>\n",
       "      <td>7.330908</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Deaths</td>\n",
       "      <td>Samoa</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Transport injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2000</td>\n",
       "      <td>18.331128</td>\n",
       "      <td>25.000813</td>\n",
       "      <td>13.148053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Deaths</td>\n",
       "      <td>Samoa</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Unintentional injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2000</td>\n",
       "      <td>28.989384</td>\n",
       "      <td>39.579940</td>\n",
       "      <td>20.833239</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  measure location     sex       age                           cause metric  \\\n",
       "0  Deaths    Samoa    Male  All Ages    Chronic respiratory diseases   Rate   \n",
       "1  Deaths    Samoa  Female  All Ages    Chronic respiratory diseases   Rate   \n",
       "2  Deaths    Samoa    Both  All Ages    Chronic respiratory diseases   Rate   \n",
       "3  Deaths    Samoa    Male  All Ages  Skin and subcutaneous diseases   Rate   \n",
       "4  Deaths    Samoa  Female  All Ages  Skin and subcutaneous diseases   Rate   \n",
       "5  Deaths    Samoa    Both  All Ages  Skin and subcutaneous diseases   Rate   \n",
       "6  Deaths    Samoa    Male  All Ages              Transport injuries   Rate   \n",
       "7  Deaths    Samoa  Female  All Ages              Transport injuries   Rate   \n",
       "8  Deaths    Samoa    Both  All Ages              Transport injuries   Rate   \n",
       "9  Deaths    Samoa    Male  All Ages          Unintentional injuries   Rate   \n",
       "\n",
       "   year        val      upper      lower  \n",
       "0  2000  64.470214  81.808307  53.476793  \n",
       "1  2000  55.234399  77.883497  39.978647  \n",
       "2  2000  60.039961  76.013089  49.941986  \n",
       "3  2000   2.246741   3.467454   1.438979  \n",
       "4  2000   1.368385   1.945448   0.866099  \n",
       "5  2000   1.825409   2.569260   1.259226  \n",
       "6  2000  25.920294  36.084587  18.130636  \n",
       "7  2000  10.099048  13.447738   7.330908  \n",
       "8  2000  18.331128  25.000813  13.148053  \n",
       "9  2000  28.989384  39.579940  20.833239  "
      ]
     },
     "execution_count": 265,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = pd.read_csv(\"/Users/sherlock/Downloads/IHME-GBD_2019_DATA-ff08d9bc-1/IHME-GBD_2019_DATA-ff08d9bc-1.csv\")\n",
    "\n",
    "# загружем 1-ый файл, сохранненный на компьютере\n",
    "# ссылка на скачивание https://drive.google.com/file/d/16fM_JEC5GAkYEDaDgzROrBm8loi9RZRZ/view\n",
    "# источник данных Global Burden of Disease Study 2019 (GBD 2019) Results, сайт http://ghdx.healthdata.org/gbd-results-tool\n",
    "# в файле данные о смертности людей от разных причин по 204 странам с 2000 по 2019 гг\n",
    "\n",
    "df2.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 266,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1.rename(columns = {'val': 'daly_val', 'upper':'daly_upper', 'lower':'daly_lower'}, inplace = True)\n",
    "df2.rename(columns = {'val': 'deaths_val', 'upper': 'deaths_upper', 'lower':'deaths_lower'}, inplace = True)\n",
    "# меняем названия колонок в соответствии с показателями: число потерянных продуктивых лет для 1-го датафрейма (DALY)\n",
    "# и смертность для 2-го датафрейма ()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 267,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_all = pd.merge(df1, df2, on = ['location', 'sex', 'age', 'cause', 'metric', 'year'], how = 'inner') \n",
    "\n",
    "# inner: берем только совпадения из двух датафреймов \n",
    "# у нас указаны названия колонок, по которым мы объединяем датафреймы, но также можно объединять по индексу — \n",
    "# порядковому номеру, который слева по вертикали c помощью [df1.index] без кавывек"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 268,
   "metadata": {},
   "outputs": [],
   "source": [
    "# pd.merge(df1, df2, on = ['column name'], how='inner') # берем только строки, совпадающие в обоих датафреймах\n",
    "# pd.merge(df1, df2, on = ['column name'], how='outer') # все строки из всех датафреймов, не важно совпадающие или нет \n",
    "# pd.merge(df1, df2, on = ['column name'], how='left') # только совпадающие строки + все строки из левого датафрейма \n",
    "# pd.merge(df1, df2, on = ['column name'], how='right') только совпадающие строки + все строки из правого датафрейма "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 269,
   "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>measure_x</th>\n",
       "      <th>location</th>\n",
       "      <th>sex</th>\n",
       "      <th>age</th>\n",
       "      <th>cause</th>\n",
       "      <th>metric</th>\n",
       "      <th>year</th>\n",
       "      <th>daly_val</th>\n",
       "      <th>daly_upper</th>\n",
       "      <th>daly_lower</th>\n",
       "      <th>measure_y</th>\n",
       "      <th>deaths_val</th>\n",
       "      <th>deaths_upper</th>\n",
       "      <th>deaths_lower</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Maternal and neonatal disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>7475.212700</td>\n",
       "      <td>9104.773541</td>\n",
       "      <td>6157.428603</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>89.867238</td>\n",
       "      <td>110.176286</td>\n",
       "      <td>74.001324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Maternal and neonatal disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>7814.344518</td>\n",
       "      <td>9667.960848</td>\n",
       "      <td>6289.146375</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>89.365457</td>\n",
       "      <td>111.497307</td>\n",
       "      <td>71.539316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>179.493660</td>\n",
       "      <td>230.104586</td>\n",
       "      <td>134.067784</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>1.101136</td>\n",
       "      <td>1.545407</td>\n",
       "      <td>0.786638</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>91.400543</td>\n",
       "      <td>124.025911</td>\n",
       "      <td>64.625204</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>0.227136</td>\n",
       "      <td>0.296917</td>\n",
       "      <td>0.173921</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>134.688036</td>\n",
       "      <td>171.782808</td>\n",
       "      <td>99.320179</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>0.656605</td>\n",
       "      <td>0.896138</td>\n",
       "      <td>0.490594</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                measure_x location     sex       age  \\\n",
       "0  DALYs (Disability-Adjusted Life Years)   Gambia  Female  All Ages   \n",
       "1  DALYs (Disability-Adjusted Life Years)   Gambia    Both  All Ages   \n",
       "2  DALYs (Disability-Adjusted Life Years)   Gambia    Male  All Ages   \n",
       "3  DALYs (Disability-Adjusted Life Years)   Gambia  Female  All Ages   \n",
       "4  DALYs (Disability-Adjusted Life Years)   Gambia    Both  All Ages   \n",
       "\n",
       "                             cause metric  year     daly_val   daly_upper  \\\n",
       "0  Maternal and neonatal disorders   Rate  2012  7475.212700  9104.773541   \n",
       "1  Maternal and neonatal disorders   Rate  2012  7814.344518  9667.960848   \n",
       "2          Substance use disorders   Rate  2012   179.493660   230.104586   \n",
       "3          Substance use disorders   Rate  2012    91.400543   124.025911   \n",
       "4          Substance use disorders   Rate  2012   134.688036   171.782808   \n",
       "\n",
       "    daly_lower measure_y  deaths_val  deaths_upper  deaths_lower  \n",
       "0  6157.428603    Deaths   89.867238    110.176286     74.001324  \n",
       "1  6289.146375    Deaths   89.365457    111.497307     71.539316  \n",
       "2   134.067784    Deaths    1.101136      1.545407      0.786638  \n",
       "3    64.625204    Deaths    0.227136      0.296917      0.173921  \n",
       "4    99.320179    Deaths    0.656605      0.896138      0.490594  "
      ]
     },
     "execution_count": 269,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_all.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 295,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(97976, 15)"
      ]
     },
     "execution_count": 295,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_all.shape # сколько строк и колонок в датафрейме"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 296,
   "metadata": {},
   "outputs": [],
   "source": [
    " # делим датафрейм на два датафрейма: 1-ый со строками от первой до 50 000, 2-ой от 50000 до последней\n",
    "df_all_1 = df_all.iloc[:50000,:]\n",
    "df_all_2 = df_all.iloc[50000:,:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 297,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(97976, 15)"
      ]
     },
     "execution_count": 297,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_all_new = pd.concat([df_all_1, df_all_2], axis = 0) # объединяем датафреймы: если axis = 0, то по строкам, если \n",
    "# axis = 1, то по столбцам\n",
    "df_all_new.shape # в новом датафрейме снова столько же строк и столбцов, сколько было до разделения"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 2.1. Добавление новых столбцов с помощью математических операций"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 303,
   "metadata": {},
   "outputs": [],
   "source": [
    "# добавляем новый столбец, в котором будет округленное значение из другого столбца\n",
    "df_all[\"deaths_val_round\"] = df_all[\"deaths_val\"].round(decimals = 1) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 307,
   "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>measure_x</th>\n",
       "      <th>location</th>\n",
       "      <th>sex</th>\n",
       "      <th>age</th>\n",
       "      <th>cause</th>\n",
       "      <th>metric</th>\n",
       "      <th>year</th>\n",
       "      <th>daly_val</th>\n",
       "      <th>daly_upper</th>\n",
       "      <th>daly_lower</th>\n",
       "      <th>measure_y</th>\n",
       "      <th>deaths_val</th>\n",
       "      <th>deaths_upper</th>\n",
       "      <th>deaths_lower</th>\n",
       "      <th>deaths_val_round</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Maternal and neonatal disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>7475.212700</td>\n",
       "      <td>9104.773541</td>\n",
       "      <td>6157.428603</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>89.867238</td>\n",
       "      <td>110.176286</td>\n",
       "      <td>74.001324</td>\n",
       "      <td>89.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Maternal and neonatal disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>7814.344518</td>\n",
       "      <td>9667.960848</td>\n",
       "      <td>6289.146375</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>89.365457</td>\n",
       "      <td>111.497307</td>\n",
       "      <td>71.539316</td>\n",
       "      <td>89.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>179.493660</td>\n",
       "      <td>230.104586</td>\n",
       "      <td>134.067784</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>1.101136</td>\n",
       "      <td>1.545407</td>\n",
       "      <td>0.786638</td>\n",
       "      <td>1.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>91.400543</td>\n",
       "      <td>124.025911</td>\n",
       "      <td>64.625204</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>0.227136</td>\n",
       "      <td>0.296917</td>\n",
       "      <td>0.173921</td>\n",
       "      <td>0.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>134.688036</td>\n",
       "      <td>171.782808</td>\n",
       "      <td>99.320179</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>0.656605</td>\n",
       "      <td>0.896138</td>\n",
       "      <td>0.490594</td>\n",
       "      <td>0.7</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97971</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Chronic respiratory diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>602.342558</td>\n",
       "      <td>732.856075</td>\n",
       "      <td>491.019574</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>10.783192</td>\n",
       "      <td>13.484120</td>\n",
       "      <td>8.267941</td>\n",
       "      <td>10.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97972</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Chronic respiratory diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>635.274862</td>\n",
       "      <td>755.292643</td>\n",
       "      <td>530.146531</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>13.025678</td>\n",
       "      <td>15.412885</td>\n",
       "      <td>10.664151</td>\n",
       "      <td>13.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97973</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Unintentional injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1318.844977</td>\n",
       "      <td>1717.917036</td>\n",
       "      <td>1037.489279</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>20.824550</td>\n",
       "      <td>27.026330</td>\n",
       "      <td>16.310791</td>\n",
       "      <td>20.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97974</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Unintentional injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>813.052440</td>\n",
       "      <td>1042.011143</td>\n",
       "      <td>638.605025</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>11.865525</td>\n",
       "      <td>15.430914</td>\n",
       "      <td>9.199714</td>\n",
       "      <td>11.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97975</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Unintentional injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1059.021476</td>\n",
       "      <td>1334.453539</td>\n",
       "      <td>846.543870</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>16.222336</td>\n",
       "      <td>20.617369</td>\n",
       "      <td>12.836190</td>\n",
       "      <td>16.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>97976 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    measure_x location     sex       age  \\\n",
       "0      DALYs (Disability-Adjusted Life Years)   Gambia  Female  All Ages   \n",
       "1      DALYs (Disability-Adjusted Life Years)   Gambia    Both  All Ages   \n",
       "2      DALYs (Disability-Adjusted Life Years)   Gambia    Male  All Ages   \n",
       "3      DALYs (Disability-Adjusted Life Years)   Gambia  Female  All Ages   \n",
       "4      DALYs (Disability-Adjusted Life Years)   Gambia    Both  All Ages   \n",
       "...                                       ...      ...     ...       ...   \n",
       "97971  DALYs (Disability-Adjusted Life Years)   Malawi  Female  All Ages   \n",
       "97972  DALYs (Disability-Adjusted Life Years)   Malawi    Both  All Ages   \n",
       "97973  DALYs (Disability-Adjusted Life Years)   Malawi    Male  All Ages   \n",
       "97974  DALYs (Disability-Adjusted Life Years)   Malawi  Female  All Ages   \n",
       "97975  DALYs (Disability-Adjusted Life Years)   Malawi    Both  All Ages   \n",
       "\n",
       "                                 cause metric  year     daly_val   daly_upper  \\\n",
       "0      Maternal and neonatal disorders   Rate  2012  7475.212700  9104.773541   \n",
       "1      Maternal and neonatal disorders   Rate  2012  7814.344518  9667.960848   \n",
       "2              Substance use disorders   Rate  2012   179.493660   230.104586   \n",
       "3              Substance use disorders   Rate  2012    91.400543   124.025911   \n",
       "4              Substance use disorders   Rate  2012   134.688036   171.782808   \n",
       "...                                ...    ...   ...          ...          ...   \n",
       "97971     Chronic respiratory diseases   Rate  2019   602.342558   732.856075   \n",
       "97972     Chronic respiratory diseases   Rate  2019   635.274862   755.292643   \n",
       "97973           Unintentional injuries   Rate  2019  1318.844977  1717.917036   \n",
       "97974           Unintentional injuries   Rate  2019   813.052440  1042.011143   \n",
       "97975           Unintentional injuries   Rate  2019  1059.021476  1334.453539   \n",
       "\n",
       "        daly_lower measure_y  deaths_val  deaths_upper  deaths_lower  \\\n",
       "0      6157.428603    Deaths   89.867238    110.176286     74.001324   \n",
       "1      6289.146375    Deaths   89.365457    111.497307     71.539316   \n",
       "2       134.067784    Deaths    1.101136      1.545407      0.786638   \n",
       "3        64.625204    Deaths    0.227136      0.296917      0.173921   \n",
       "4        99.320179    Deaths    0.656605      0.896138      0.490594   \n",
       "...            ...       ...         ...           ...           ...   \n",
       "97971   491.019574    Deaths   10.783192     13.484120      8.267941   \n",
       "97972   530.146531    Deaths   13.025678     15.412885     10.664151   \n",
       "97973  1037.489279    Deaths   20.824550     27.026330     16.310791   \n",
       "97974   638.605025    Deaths   11.865525     15.430914      9.199714   \n",
       "97975   846.543870    Deaths   16.222336     20.617369     12.836190   \n",
       "\n",
       "       deaths_val_round  \n",
       "0                  89.9  \n",
       "1                  89.4  \n",
       "2                   1.1  \n",
       "3                   0.2  \n",
       "4                   0.7  \n",
       "...                 ...  \n",
       "97971              10.8  \n",
       "97972              13.0  \n",
       "97973              20.8  \n",
       "97974              11.9  \n",
       "97975              16.2  \n",
       "\n",
       "[97976 rows x 15 columns]"
      ]
     },
     "execution_count": 307,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_all"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 308,
   "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>measure_x</th>\n",
       "      <th>location</th>\n",
       "      <th>sex</th>\n",
       "      <th>age</th>\n",
       "      <th>cause</th>\n",
       "      <th>metric</th>\n",
       "      <th>year</th>\n",
       "      <th>daly_val</th>\n",
       "      <th>daly_upper</th>\n",
       "      <th>daly_lower</th>\n",
       "      <th>measure_y</th>\n",
       "      <th>deaths_val</th>\n",
       "      <th>deaths_upper</th>\n",
       "      <th>deaths_lower</th>\n",
       "      <th>deaths_val_round</th>\n",
       "      <th>deaths_total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Maternal and neonatal disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>7475.212700</td>\n",
       "      <td>9104.773541</td>\n",
       "      <td>6157.428603</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>89.867238</td>\n",
       "      <td>110.176286</td>\n",
       "      <td>74.001324</td>\n",
       "      <td>89.9</td>\n",
       "      <td>274.044849</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Maternal and neonatal disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>7814.344518</td>\n",
       "      <td>9667.960848</td>\n",
       "      <td>6289.146375</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>89.365457</td>\n",
       "      <td>111.497307</td>\n",
       "      <td>71.539316</td>\n",
       "      <td>89.4</td>\n",
       "      <td>272.402080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>179.493660</td>\n",
       "      <td>230.104586</td>\n",
       "      <td>134.067784</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>1.101136</td>\n",
       "      <td>1.545407</td>\n",
       "      <td>0.786638</td>\n",
       "      <td>1.1</td>\n",
       "      <td>3.433182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>91.400543</td>\n",
       "      <td>124.025911</td>\n",
       "      <td>64.625204</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>0.227136</td>\n",
       "      <td>0.296917</td>\n",
       "      <td>0.173921</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.697975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>134.688036</td>\n",
       "      <td>171.782808</td>\n",
       "      <td>99.320179</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>0.656605</td>\n",
       "      <td>0.896138</td>\n",
       "      <td>0.490594</td>\n",
       "      <td>0.7</td>\n",
       "      <td>2.043338</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97971</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Chronic respiratory diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>602.342558</td>\n",
       "      <td>732.856075</td>\n",
       "      <td>491.019574</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>10.783192</td>\n",
       "      <td>13.484120</td>\n",
       "      <td>8.267941</td>\n",
       "      <td>10.8</td>\n",
       "      <td>32.535253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97972</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Chronic respiratory diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>635.274862</td>\n",
       "      <td>755.292643</td>\n",
       "      <td>530.146531</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>13.025678</td>\n",
       "      <td>15.412885</td>\n",
       "      <td>10.664151</td>\n",
       "      <td>13.0</td>\n",
       "      <td>39.102714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97973</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Unintentional injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1318.844977</td>\n",
       "      <td>1717.917036</td>\n",
       "      <td>1037.489279</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>20.824550</td>\n",
       "      <td>27.026330</td>\n",
       "      <td>16.310791</td>\n",
       "      <td>20.8</td>\n",
       "      <td>64.161670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97974</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Unintentional injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>813.052440</td>\n",
       "      <td>1042.011143</td>\n",
       "      <td>638.605025</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>11.865525</td>\n",
       "      <td>15.430914</td>\n",
       "      <td>9.199714</td>\n",
       "      <td>11.9</td>\n",
       "      <td>36.496153</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97975</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Unintentional injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1059.021476</td>\n",
       "      <td>1334.453539</td>\n",
       "      <td>846.543870</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>16.222336</td>\n",
       "      <td>20.617369</td>\n",
       "      <td>12.836190</td>\n",
       "      <td>16.2</td>\n",
       "      <td>49.675896</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>97976 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    measure_x location     sex       age  \\\n",
       "0      DALYs (Disability-Adjusted Life Years)   Gambia  Female  All Ages   \n",
       "1      DALYs (Disability-Adjusted Life Years)   Gambia    Both  All Ages   \n",
       "2      DALYs (Disability-Adjusted Life Years)   Gambia    Male  All Ages   \n",
       "3      DALYs (Disability-Adjusted Life Years)   Gambia  Female  All Ages   \n",
       "4      DALYs (Disability-Adjusted Life Years)   Gambia    Both  All Ages   \n",
       "...                                       ...      ...     ...       ...   \n",
       "97971  DALYs (Disability-Adjusted Life Years)   Malawi  Female  All Ages   \n",
       "97972  DALYs (Disability-Adjusted Life Years)   Malawi    Both  All Ages   \n",
       "97973  DALYs (Disability-Adjusted Life Years)   Malawi    Male  All Ages   \n",
       "97974  DALYs (Disability-Adjusted Life Years)   Malawi  Female  All Ages   \n",
       "97975  DALYs (Disability-Adjusted Life Years)   Malawi    Both  All Ages   \n",
       "\n",
       "                                 cause metric  year     daly_val   daly_upper  \\\n",
       "0      Maternal and neonatal disorders   Rate  2012  7475.212700  9104.773541   \n",
       "1      Maternal and neonatal disorders   Rate  2012  7814.344518  9667.960848   \n",
       "2              Substance use disorders   Rate  2012   179.493660   230.104586   \n",
       "3              Substance use disorders   Rate  2012    91.400543   124.025911   \n",
       "4              Substance use disorders   Rate  2012   134.688036   171.782808   \n",
       "...                                ...    ...   ...          ...          ...   \n",
       "97971     Chronic respiratory diseases   Rate  2019   602.342558   732.856075   \n",
       "97972     Chronic respiratory diseases   Rate  2019   635.274862   755.292643   \n",
       "97973           Unintentional injuries   Rate  2019  1318.844977  1717.917036   \n",
       "97974           Unintentional injuries   Rate  2019   813.052440  1042.011143   \n",
       "97975           Unintentional injuries   Rate  2019  1059.021476  1334.453539   \n",
       "\n",
       "        daly_lower measure_y  deaths_val  deaths_upper  deaths_lower  \\\n",
       "0      6157.428603    Deaths   89.867238    110.176286     74.001324   \n",
       "1      6289.146375    Deaths   89.365457    111.497307     71.539316   \n",
       "2       134.067784    Deaths    1.101136      1.545407      0.786638   \n",
       "3        64.625204    Deaths    0.227136      0.296917      0.173921   \n",
       "4        99.320179    Deaths    0.656605      0.896138      0.490594   \n",
       "...            ...       ...         ...           ...           ...   \n",
       "97971   491.019574    Deaths   10.783192     13.484120      8.267941   \n",
       "97972   530.146531    Deaths   13.025678     15.412885     10.664151   \n",
       "97973  1037.489279    Deaths   20.824550     27.026330     16.310791   \n",
       "97974   638.605025    Deaths   11.865525     15.430914      9.199714   \n",
       "97975   846.543870    Deaths   16.222336     20.617369     12.836190   \n",
       "\n",
       "       deaths_val_round  deaths_total  \n",
       "0                  89.9    274.044849  \n",
       "1                  89.4    272.402080  \n",
       "2                   1.1      3.433182  \n",
       "3                   0.2      0.697975  \n",
       "4                   0.7      2.043338  \n",
       "...                 ...           ...  \n",
       "97971              10.8     32.535253  \n",
       "97972              13.0     39.102714  \n",
       "97973              20.8     64.161670  \n",
       "97974              11.9     36.496153  \n",
       "97975              16.2     49.675896  \n",
       "\n",
       "[97976 rows x 16 columns]"
      ]
     },
     "execution_count": 308,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# добавляем новый столбец, суммируя значения нескольких других\n",
    "df_all[\"deaths_total\"] = df_all[\"deaths_val\"] + df_all[\"deaths_upper\"] + df_all[\"deaths_lower\"]\n",
    "df_all"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 309,
   "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>measure_x</th>\n",
       "      <th>location</th>\n",
       "      <th>sex</th>\n",
       "      <th>age</th>\n",
       "      <th>cause</th>\n",
       "      <th>metric</th>\n",
       "      <th>year</th>\n",
       "      <th>daly_val</th>\n",
       "      <th>daly_upper</th>\n",
       "      <th>daly_lower</th>\n",
       "      <th>measure_y</th>\n",
       "      <th>deaths_val</th>\n",
       "      <th>deaths_upper</th>\n",
       "      <th>deaths_lower</th>\n",
       "      <th>deaths_val_round</th>\n",
       "      <th>deaths_total</th>\n",
       "      <th>total_loc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Maternal and neonatal disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>7475.212700</td>\n",
       "      <td>9104.773541</td>\n",
       "      <td>6157.428603</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>89.867238</td>\n",
       "      <td>110.176286</td>\n",
       "      <td>74.001324</td>\n",
       "      <td>89.9</td>\n",
       "      <td>274.044849</td>\n",
       "      <td>274.044849</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Maternal and neonatal disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>7814.344518</td>\n",
       "      <td>9667.960848</td>\n",
       "      <td>6289.146375</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>89.365457</td>\n",
       "      <td>111.497307</td>\n",
       "      <td>71.539316</td>\n",
       "      <td>89.4</td>\n",
       "      <td>272.402080</td>\n",
       "      <td>272.402080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>179.493660</td>\n",
       "      <td>230.104586</td>\n",
       "      <td>134.067784</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>1.101136</td>\n",
       "      <td>1.545407</td>\n",
       "      <td>0.786638</td>\n",
       "      <td>1.1</td>\n",
       "      <td>3.433182</td>\n",
       "      <td>3.433182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>91.400543</td>\n",
       "      <td>124.025911</td>\n",
       "      <td>64.625204</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>0.227136</td>\n",
       "      <td>0.296917</td>\n",
       "      <td>0.173921</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.697975</td>\n",
       "      <td>0.697975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>134.688036</td>\n",
       "      <td>171.782808</td>\n",
       "      <td>99.320179</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>0.656605</td>\n",
       "      <td>0.896138</td>\n",
       "      <td>0.490594</td>\n",
       "      <td>0.7</td>\n",
       "      <td>2.043338</td>\n",
       "      <td>2.043338</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97971</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Chronic respiratory diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>602.342558</td>\n",
       "      <td>732.856075</td>\n",
       "      <td>491.019574</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>10.783192</td>\n",
       "      <td>13.484120</td>\n",
       "      <td>8.267941</td>\n",
       "      <td>10.8</td>\n",
       "      <td>32.535253</td>\n",
       "      <td>32.535253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97972</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Chronic respiratory diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>635.274862</td>\n",
       "      <td>755.292643</td>\n",
       "      <td>530.146531</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>13.025678</td>\n",
       "      <td>15.412885</td>\n",
       "      <td>10.664151</td>\n",
       "      <td>13.0</td>\n",
       "      <td>39.102714</td>\n",
       "      <td>39.102714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97973</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Unintentional injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1318.844977</td>\n",
       "      <td>1717.917036</td>\n",
       "      <td>1037.489279</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>20.824550</td>\n",
       "      <td>27.026330</td>\n",
       "      <td>16.310791</td>\n",
       "      <td>20.8</td>\n",
       "      <td>64.161670</td>\n",
       "      <td>64.161670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97974</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Unintentional injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>813.052440</td>\n",
       "      <td>1042.011143</td>\n",
       "      <td>638.605025</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>11.865525</td>\n",
       "      <td>15.430914</td>\n",
       "      <td>9.199714</td>\n",
       "      <td>11.9</td>\n",
       "      <td>36.496153</td>\n",
       "      <td>36.496153</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97975</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Unintentional injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1059.021476</td>\n",
       "      <td>1334.453539</td>\n",
       "      <td>846.543870</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>16.222336</td>\n",
       "      <td>20.617369</td>\n",
       "      <td>12.836190</td>\n",
       "      <td>16.2</td>\n",
       "      <td>49.675896</td>\n",
       "      <td>49.675896</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>97976 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    measure_x location     sex       age  \\\n",
       "0      DALYs (Disability-Adjusted Life Years)   Gambia  Female  All Ages   \n",
       "1      DALYs (Disability-Adjusted Life Years)   Gambia    Both  All Ages   \n",
       "2      DALYs (Disability-Adjusted Life Years)   Gambia    Male  All Ages   \n",
       "3      DALYs (Disability-Adjusted Life Years)   Gambia  Female  All Ages   \n",
       "4      DALYs (Disability-Adjusted Life Years)   Gambia    Both  All Ages   \n",
       "...                                       ...      ...     ...       ...   \n",
       "97971  DALYs (Disability-Adjusted Life Years)   Malawi  Female  All Ages   \n",
       "97972  DALYs (Disability-Adjusted Life Years)   Malawi    Both  All Ages   \n",
       "97973  DALYs (Disability-Adjusted Life Years)   Malawi    Male  All Ages   \n",
       "97974  DALYs (Disability-Adjusted Life Years)   Malawi  Female  All Ages   \n",
       "97975  DALYs (Disability-Adjusted Life Years)   Malawi    Both  All Ages   \n",
       "\n",
       "                                 cause metric  year     daly_val   daly_upper  \\\n",
       "0      Maternal and neonatal disorders   Rate  2012  7475.212700  9104.773541   \n",
       "1      Maternal and neonatal disorders   Rate  2012  7814.344518  9667.960848   \n",
       "2              Substance use disorders   Rate  2012   179.493660   230.104586   \n",
       "3              Substance use disorders   Rate  2012    91.400543   124.025911   \n",
       "4              Substance use disorders   Rate  2012   134.688036   171.782808   \n",
       "...                                ...    ...   ...          ...          ...   \n",
       "97971     Chronic respiratory diseases   Rate  2019   602.342558   732.856075   \n",
       "97972     Chronic respiratory diseases   Rate  2019   635.274862   755.292643   \n",
       "97973           Unintentional injuries   Rate  2019  1318.844977  1717.917036   \n",
       "97974           Unintentional injuries   Rate  2019   813.052440  1042.011143   \n",
       "97975           Unintentional injuries   Rate  2019  1059.021476  1334.453539   \n",
       "\n",
       "        daly_lower measure_y  deaths_val  deaths_upper  deaths_lower  \\\n",
       "0      6157.428603    Deaths   89.867238    110.176286     74.001324   \n",
       "1      6289.146375    Deaths   89.365457    111.497307     71.539316   \n",
       "2       134.067784    Deaths    1.101136      1.545407      0.786638   \n",
       "3        64.625204    Deaths    0.227136      0.296917      0.173921   \n",
       "4        99.320179    Deaths    0.656605      0.896138      0.490594   \n",
       "...            ...       ...         ...           ...           ...   \n",
       "97971   491.019574    Deaths   10.783192     13.484120      8.267941   \n",
       "97972   530.146531    Deaths   13.025678     15.412885     10.664151   \n",
       "97973  1037.489279    Deaths   20.824550     27.026330     16.310791   \n",
       "97974   638.605025    Deaths   11.865525     15.430914      9.199714   \n",
       "97975   846.543870    Deaths   16.222336     20.617369     12.836190   \n",
       "\n",
       "       deaths_val_round  deaths_total   total_loc  \n",
       "0                  89.9    274.044849  274.044849  \n",
       "1                  89.4    272.402080  272.402080  \n",
       "2                   1.1      3.433182    3.433182  \n",
       "3                   0.2      0.697975    0.697975  \n",
       "4                   0.7      2.043338    2.043338  \n",
       "...                 ...           ...         ...  \n",
       "97971              10.8     32.535253   32.535253  \n",
       "97972              13.0     39.102714   39.102714  \n",
       "97973              20.8     64.161670   64.161670  \n",
       "97974              11.9     36.496153   36.496153  \n",
       "97975              16.2     49.675896   49.675896  \n",
       "\n",
       "[97976 rows x 17 columns]"
      ]
     },
     "execution_count": 309,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# добавляем новый столбец, суммируя значения нескольких других с помощью метода loc\n",
    "# помимо sum, можно считать mean (среднее), median (медиана), max, min, std (стандарт.отклонение) и пр.\n",
    "df_all[\"total_loc\"] = df_all.loc[:, \"deaths_val\":\"deaths_lower\"].sum(axis = 1)\n",
    "df_all"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 321,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "# добавляем новый столбец, суммируя значения нескольких других с помощью метода iloc\n",
    "# важно, что при использовании метода iloc правое значение (номер столбца) не включается, поэтому если нам нужны столбцы с номерами\n",
    "# 11, 12 и 13, указать нужно по с 11 по 14-й: df_all.iloc[:, 11:14] \n",
    "\n",
    "df_all[\"total_iloc\"] = df_all.iloc[:, 11:14].sum(axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 322,
   "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>measure_x</th>\n",
       "      <th>location</th>\n",
       "      <th>sex</th>\n",
       "      <th>age</th>\n",
       "      <th>cause</th>\n",
       "      <th>metric</th>\n",
       "      <th>year</th>\n",
       "      <th>daly_val</th>\n",
       "      <th>daly_upper</th>\n",
       "      <th>daly_lower</th>\n",
       "      <th>measure_y</th>\n",
       "      <th>deaths_val</th>\n",
       "      <th>deaths_upper</th>\n",
       "      <th>deaths_lower</th>\n",
       "      <th>deaths_val_round</th>\n",
       "      <th>deaths_total</th>\n",
       "      <th>total_loc</th>\n",
       "      <th>total_iloc</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Maternal and neonatal disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>7475.212700</td>\n",
       "      <td>9104.773541</td>\n",
       "      <td>6157.428603</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>89.867238</td>\n",
       "      <td>110.176286</td>\n",
       "      <td>74.001324</td>\n",
       "      <td>89.9</td>\n",
       "      <td>274.044849</td>\n",
       "      <td>274.044849</td>\n",
       "      <td>274.044849</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Maternal and neonatal disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>7814.344518</td>\n",
       "      <td>9667.960848</td>\n",
       "      <td>6289.146375</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>89.365457</td>\n",
       "      <td>111.497307</td>\n",
       "      <td>71.539316</td>\n",
       "      <td>89.4</td>\n",
       "      <td>272.402080</td>\n",
       "      <td>272.402080</td>\n",
       "      <td>272.402080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>179.493660</td>\n",
       "      <td>230.104586</td>\n",
       "      <td>134.067784</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>1.101136</td>\n",
       "      <td>1.545407</td>\n",
       "      <td>0.786638</td>\n",
       "      <td>1.1</td>\n",
       "      <td>3.433182</td>\n",
       "      <td>3.433182</td>\n",
       "      <td>3.433182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>91.400543</td>\n",
       "      <td>124.025911</td>\n",
       "      <td>64.625204</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>0.227136</td>\n",
       "      <td>0.296917</td>\n",
       "      <td>0.173921</td>\n",
       "      <td>0.2</td>\n",
       "      <td>0.697975</td>\n",
       "      <td>0.697975</td>\n",
       "      <td>0.697975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Gambia</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Substance use disorders</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2012</td>\n",
       "      <td>134.688036</td>\n",
       "      <td>171.782808</td>\n",
       "      <td>99.320179</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>0.656605</td>\n",
       "      <td>0.896138</td>\n",
       "      <td>0.490594</td>\n",
       "      <td>0.7</td>\n",
       "      <td>2.043338</td>\n",
       "      <td>2.043338</td>\n",
       "      <td>2.043338</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97971</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Chronic respiratory diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>602.342558</td>\n",
       "      <td>732.856075</td>\n",
       "      <td>491.019574</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>10.783192</td>\n",
       "      <td>13.484120</td>\n",
       "      <td>8.267941</td>\n",
       "      <td>10.8</td>\n",
       "      <td>32.535253</td>\n",
       "      <td>32.535253</td>\n",
       "      <td>32.535253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97972</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Chronic respiratory diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>635.274862</td>\n",
       "      <td>755.292643</td>\n",
       "      <td>530.146531</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>13.025678</td>\n",
       "      <td>15.412885</td>\n",
       "      <td>10.664151</td>\n",
       "      <td>13.0</td>\n",
       "      <td>39.102714</td>\n",
       "      <td>39.102714</td>\n",
       "      <td>39.102714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97973</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Unintentional injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1318.844977</td>\n",
       "      <td>1717.917036</td>\n",
       "      <td>1037.489279</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>20.824550</td>\n",
       "      <td>27.026330</td>\n",
       "      <td>16.310791</td>\n",
       "      <td>20.8</td>\n",
       "      <td>64.161670</td>\n",
       "      <td>64.161670</td>\n",
       "      <td>64.161670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97974</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Unintentional injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>813.052440</td>\n",
       "      <td>1042.011143</td>\n",
       "      <td>638.605025</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>11.865525</td>\n",
       "      <td>15.430914</td>\n",
       "      <td>9.199714</td>\n",
       "      <td>11.9</td>\n",
       "      <td>36.496153</td>\n",
       "      <td>36.496153</td>\n",
       "      <td>36.496153</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97975</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Malawi</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Unintentional injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1059.021476</td>\n",
       "      <td>1334.453539</td>\n",
       "      <td>846.543870</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>16.222336</td>\n",
       "      <td>20.617369</td>\n",
       "      <td>12.836190</td>\n",
       "      <td>16.2</td>\n",
       "      <td>49.675896</td>\n",
       "      <td>49.675896</td>\n",
       "      <td>49.675896</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>97976 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    measure_x location     sex       age  \\\n",
       "0      DALYs (Disability-Adjusted Life Years)   Gambia  Female  All Ages   \n",
       "1      DALYs (Disability-Adjusted Life Years)   Gambia    Both  All Ages   \n",
       "2      DALYs (Disability-Adjusted Life Years)   Gambia    Male  All Ages   \n",
       "3      DALYs (Disability-Adjusted Life Years)   Gambia  Female  All Ages   \n",
       "4      DALYs (Disability-Adjusted Life Years)   Gambia    Both  All Ages   \n",
       "...                                       ...      ...     ...       ...   \n",
       "97971  DALYs (Disability-Adjusted Life Years)   Malawi  Female  All Ages   \n",
       "97972  DALYs (Disability-Adjusted Life Years)   Malawi    Both  All Ages   \n",
       "97973  DALYs (Disability-Adjusted Life Years)   Malawi    Male  All Ages   \n",
       "97974  DALYs (Disability-Adjusted Life Years)   Malawi  Female  All Ages   \n",
       "97975  DALYs (Disability-Adjusted Life Years)   Malawi    Both  All Ages   \n",
       "\n",
       "                                 cause metric  year     daly_val   daly_upper  \\\n",
       "0      Maternal and neonatal disorders   Rate  2012  7475.212700  9104.773541   \n",
       "1      Maternal and neonatal disorders   Rate  2012  7814.344518  9667.960848   \n",
       "2              Substance use disorders   Rate  2012   179.493660   230.104586   \n",
       "3              Substance use disorders   Rate  2012    91.400543   124.025911   \n",
       "4              Substance use disorders   Rate  2012   134.688036   171.782808   \n",
       "...                                ...    ...   ...          ...          ...   \n",
       "97971     Chronic respiratory diseases   Rate  2019   602.342558   732.856075   \n",
       "97972     Chronic respiratory diseases   Rate  2019   635.274862   755.292643   \n",
       "97973           Unintentional injuries   Rate  2019  1318.844977  1717.917036   \n",
       "97974           Unintentional injuries   Rate  2019   813.052440  1042.011143   \n",
       "97975           Unintentional injuries   Rate  2019  1059.021476  1334.453539   \n",
       "\n",
       "        daly_lower measure_y  deaths_val  deaths_upper  deaths_lower  \\\n",
       "0      6157.428603    Deaths   89.867238    110.176286     74.001324   \n",
       "1      6289.146375    Deaths   89.365457    111.497307     71.539316   \n",
       "2       134.067784    Deaths    1.101136      1.545407      0.786638   \n",
       "3        64.625204    Deaths    0.227136      0.296917      0.173921   \n",
       "4        99.320179    Deaths    0.656605      0.896138      0.490594   \n",
       "...            ...       ...         ...           ...           ...   \n",
       "97971   491.019574    Deaths   10.783192     13.484120      8.267941   \n",
       "97972   530.146531    Deaths   13.025678     15.412885     10.664151   \n",
       "97973  1037.489279    Deaths   20.824550     27.026330     16.310791   \n",
       "97974   638.605025    Deaths   11.865525     15.430914      9.199714   \n",
       "97975   846.543870    Deaths   16.222336     20.617369     12.836190   \n",
       "\n",
       "       deaths_val_round  deaths_total   total_loc  total_iloc  \n",
       "0                  89.9    274.044849  274.044849  274.044849  \n",
       "1                  89.4    272.402080  272.402080  272.402080  \n",
       "2                   1.1      3.433182    3.433182    3.433182  \n",
       "3                   0.2      0.697975    0.697975    0.697975  \n",
       "4                   0.7      2.043338    2.043338    2.043338  \n",
       "...                 ...           ...         ...         ...  \n",
       "97971              10.8     32.535253   32.535253   32.535253  \n",
       "97972              13.0     39.102714   39.102714   39.102714  \n",
       "97973              20.8     64.161670   64.161670   64.161670  \n",
       "97974              11.9     36.496153   36.496153   36.496153  \n",
       "97975              16.2     49.675896   49.675896   49.675896  \n",
       "\n",
       "[97976 rows x 18 columns]"
      ]
     },
     "execution_count": 322,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_all"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# удалим ненужные столбцы, чтобы не мешали\n",
    "df_all.drop(['deaths_val_round','deaths_total', 'total_loc','total_iloc'], axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 2.2. Добавление новых столбцов с помощью lambda функций"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 327,
   "metadata": {},
   "outputs": [],
   "source": [
    "# создаем список стран, входивших в 2020 году в СНГ\n",
    "CIS_2020 = ['Azerbaijan', 'Armenia', 'Belarus', 'Kazakhstan', 'Kyrgyzstan', \n",
    "            'Moldova', 'Russian Federation', 'Tajikistan', 'Uzbekistan']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 328,
   "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>measure_x</th>\n",
       "      <th>location</th>\n",
       "      <th>sex</th>\n",
       "      <th>age</th>\n",
       "      <th>cause</th>\n",
       "      <th>metric</th>\n",
       "      <th>year</th>\n",
       "      <th>daly_val</th>\n",
       "      <th>daly_upper</th>\n",
       "      <th>daly_lower</th>\n",
       "      <th>measure_y</th>\n",
       "      <th>deaths_val</th>\n",
       "      <th>deaths_upper</th>\n",
       "      <th>deaths_lower</th>\n",
       "      <th>CIS_2020</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Transport injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2013</td>\n",
       "      <td>2311.203652</td>\n",
       "      <td>2557.790575</td>\n",
       "      <td>2102.970106</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>33.102775</td>\n",
       "      <td>33.670112</td>\n",
       "      <td>31.914774</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Transport injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2013</td>\n",
       "      <td>1003.703949</td>\n",
       "      <td>1204.231323</td>\n",
       "      <td>826.997768</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>10.021556</td>\n",
       "      <td>10.217613</td>\n",
       "      <td>9.439502</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Transport injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2013</td>\n",
       "      <td>1610.409759</td>\n",
       "      <td>1827.886031</td>\n",
       "      <td>1418.823756</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>20.731699</td>\n",
       "      <td>21.055609</td>\n",
       "      <td>19.955321</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Cardiovascular diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2013</td>\n",
       "      <td>16913.285219</td>\n",
       "      <td>17121.473215</td>\n",
       "      <td>16646.640694</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>689.563171</td>\n",
       "      <td>698.231847</td>\n",
       "      <td>671.841370</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Cardiovascular diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2013</td>\n",
       "      <td>12062.770301</td>\n",
       "      <td>12439.589972</td>\n",
       "      <td>11455.512603</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>730.915208</td>\n",
       "      <td>756.090049</td>\n",
       "      <td>678.546166</td>\n",
       "      <td>True</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95820</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Uzbekistan</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Unintentional injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>924.906883</td>\n",
       "      <td>1110.802656</td>\n",
       "      <td>764.324202</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>8.090781</td>\n",
       "      <td>9.449337</td>\n",
       "      <td>6.931106</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95821</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Uzbekistan</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Unintentional injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1489.541043</td>\n",
       "      <td>1751.864358</td>\n",
       "      <td>1263.197669</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>16.076524</td>\n",
       "      <td>18.680623</td>\n",
       "      <td>13.813033</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95873</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Armenia</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Digestive diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1890.952170</td>\n",
       "      <td>2175.781400</td>\n",
       "      <td>1600.627590</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>65.149955</td>\n",
       "      <td>76.413600</td>\n",
       "      <td>54.884648</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95874</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Armenia</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Digestive diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1134.309391</td>\n",
       "      <td>1299.771431</td>\n",
       "      <td>975.433185</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>49.340143</td>\n",
       "      <td>57.384637</td>\n",
       "      <td>41.791501</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95875</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Armenia</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Digestive diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1499.511198</td>\n",
       "      <td>1724.193941</td>\n",
       "      <td>1286.684471</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>56.970919</td>\n",
       "      <td>66.339240</td>\n",
       "      <td>48.503861</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3804 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    measure_x            location     sex  \\\n",
       "26     DALYs (Disability-Adjusted Life Years)  Russian Federation    Male   \n",
       "27     DALYs (Disability-Adjusted Life Years)  Russian Federation  Female   \n",
       "28     DALYs (Disability-Adjusted Life Years)  Russian Federation    Both   \n",
       "95     DALYs (Disability-Adjusted Life Years)  Russian Federation    Male   \n",
       "96     DALYs (Disability-Adjusted Life Years)  Russian Federation  Female   \n",
       "...                                       ...                 ...     ...   \n",
       "95820  DALYs (Disability-Adjusted Life Years)          Uzbekistan  Female   \n",
       "95821  DALYs (Disability-Adjusted Life Years)          Uzbekistan    Both   \n",
       "95873  DALYs (Disability-Adjusted Life Years)             Armenia    Male   \n",
       "95874  DALYs (Disability-Adjusted Life Years)             Armenia  Female   \n",
       "95875  DALYs (Disability-Adjusted Life Years)             Armenia    Both   \n",
       "\n",
       "            age                    cause metric  year      daly_val  \\\n",
       "26     All Ages       Transport injuries   Rate  2013   2311.203652   \n",
       "27     All Ages       Transport injuries   Rate  2013   1003.703949   \n",
       "28     All Ages       Transport injuries   Rate  2013   1610.409759   \n",
       "95     All Ages  Cardiovascular diseases   Rate  2013  16913.285219   \n",
       "96     All Ages  Cardiovascular diseases   Rate  2013  12062.770301   \n",
       "...         ...                      ...    ...   ...           ...   \n",
       "95820  All Ages   Unintentional injuries   Rate  2019    924.906883   \n",
       "95821  All Ages   Unintentional injuries   Rate  2019   1489.541043   \n",
       "95873  All Ages       Digestive diseases   Rate  2019   1890.952170   \n",
       "95874  All Ages       Digestive diseases   Rate  2019   1134.309391   \n",
       "95875  All Ages       Digestive diseases   Rate  2019   1499.511198   \n",
       "\n",
       "         daly_upper    daly_lower measure_y  deaths_val  deaths_upper  \\\n",
       "26      2557.790575   2102.970106    Deaths   33.102775     33.670112   \n",
       "27      1204.231323    826.997768    Deaths   10.021556     10.217613   \n",
       "28      1827.886031   1418.823756    Deaths   20.731699     21.055609   \n",
       "95     17121.473215  16646.640694    Deaths  689.563171    698.231847   \n",
       "96     12439.589972  11455.512603    Deaths  730.915208    756.090049   \n",
       "...             ...           ...       ...         ...           ...   \n",
       "95820   1110.802656    764.324202    Deaths    8.090781      9.449337   \n",
       "95821   1751.864358   1263.197669    Deaths   16.076524     18.680623   \n",
       "95873   2175.781400   1600.627590    Deaths   65.149955     76.413600   \n",
       "95874   1299.771431    975.433185    Deaths   49.340143     57.384637   \n",
       "95875   1724.193941   1286.684471    Deaths   56.970919     66.339240   \n",
       "\n",
       "       deaths_lower  CIS_2020  \n",
       "26        31.914774      True  \n",
       "27         9.439502      True  \n",
       "28        19.955321      True  \n",
       "95       671.841370      True  \n",
       "96       678.546166      True  \n",
       "...             ...       ...  \n",
       "95820      6.931106      True  \n",
       "95821     13.813033      True  \n",
       "95873     54.884648      True  \n",
       "95874     41.791501      True  \n",
       "95875     48.503861      True  \n",
       "\n",
       "[3804 rows x 15 columns]"
      ]
     },
     "execution_count": 328,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# с помощью lambda-функции прописываем, что если страна ('location') входит в СНГ, то пусть в новом столбце 'CIS_2020' \n",
    "# будет True, а если нет, то False\n",
    "df_all['CIS_2020'] = df_all['location'].apply(lambda x: True if x in CIS_2020 else False )\n",
    "df_all[df_all['CIS_2020'] == True]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 285,
   "metadata": {},
   "outputs": [],
   "source": [
    "# можно записать и короче, не прописывая полностью это условие\n",
    "df_all['CIS_2020'] = df_all['location'].apply(lambda x: x in CIS_2020)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 286,
   "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>measure_x</th>\n",
       "      <th>location</th>\n",
       "      <th>sex</th>\n",
       "      <th>age</th>\n",
       "      <th>cause</th>\n",
       "      <th>metric</th>\n",
       "      <th>year</th>\n",
       "      <th>daly_val</th>\n",
       "      <th>daly_upper</th>\n",
       "      <th>daly_lower</th>\n",
       "      <th>measure_y</th>\n",
       "      <th>deaths_val</th>\n",
       "      <th>deaths_upper</th>\n",
       "      <th>deaths_lower</th>\n",
       "      <th>CIS_2020</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Transport injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2013</td>\n",
       "      <td>2311.203652</td>\n",
       "      <td>2557.790575</td>\n",
       "      <td>2102.970106</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>33.102775</td>\n",
       "      <td>33.670112</td>\n",
       "      <td>31.914774</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Transport injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2013</td>\n",
       "      <td>1003.703949</td>\n",
       "      <td>1204.231323</td>\n",
       "      <td>826.997768</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>10.021556</td>\n",
       "      <td>10.217613</td>\n",
       "      <td>9.439502</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Transport injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2013</td>\n",
       "      <td>1610.409759</td>\n",
       "      <td>1827.886031</td>\n",
       "      <td>1418.823756</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>20.731699</td>\n",
       "      <td>21.055609</td>\n",
       "      <td>19.955321</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Cardiovascular diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2013</td>\n",
       "      <td>16913.285219</td>\n",
       "      <td>17121.473215</td>\n",
       "      <td>16646.640694</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>689.563171</td>\n",
       "      <td>698.231847</td>\n",
       "      <td>671.841370</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Cardiovascular diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2013</td>\n",
       "      <td>12062.770301</td>\n",
       "      <td>12439.589972</td>\n",
       "      <td>11455.512603</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>730.915208</td>\n",
       "      <td>756.090049</td>\n",
       "      <td>678.546166</td>\n",
       "      <td>True</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95820</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Uzbekistan</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Unintentional injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>924.906883</td>\n",
       "      <td>1110.802656</td>\n",
       "      <td>764.324202</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>8.090781</td>\n",
       "      <td>9.449337</td>\n",
       "      <td>6.931106</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95821</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Uzbekistan</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Unintentional injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1489.541043</td>\n",
       "      <td>1751.864358</td>\n",
       "      <td>1263.197669</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>16.076524</td>\n",
       "      <td>18.680623</td>\n",
       "      <td>13.813033</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95873</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Armenia</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Digestive diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1890.952170</td>\n",
       "      <td>2175.781400</td>\n",
       "      <td>1600.627590</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>65.149955</td>\n",
       "      <td>76.413600</td>\n",
       "      <td>54.884648</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95874</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Armenia</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Digestive diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1134.309391</td>\n",
       "      <td>1299.771431</td>\n",
       "      <td>975.433185</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>49.340143</td>\n",
       "      <td>57.384637</td>\n",
       "      <td>41.791501</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95875</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Armenia</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Digestive diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1499.511198</td>\n",
       "      <td>1724.193941</td>\n",
       "      <td>1286.684471</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>56.970919</td>\n",
       "      <td>66.339240</td>\n",
       "      <td>48.503861</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3804 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    measure_x            location     sex  \\\n",
       "26     DALYs (Disability-Adjusted Life Years)  Russian Federation    Male   \n",
       "27     DALYs (Disability-Adjusted Life Years)  Russian Federation  Female   \n",
       "28     DALYs (Disability-Adjusted Life Years)  Russian Federation    Both   \n",
       "95     DALYs (Disability-Adjusted Life Years)  Russian Federation    Male   \n",
       "96     DALYs (Disability-Adjusted Life Years)  Russian Federation  Female   \n",
       "...                                       ...                 ...     ...   \n",
       "95820  DALYs (Disability-Adjusted Life Years)          Uzbekistan  Female   \n",
       "95821  DALYs (Disability-Adjusted Life Years)          Uzbekistan    Both   \n",
       "95873  DALYs (Disability-Adjusted Life Years)             Armenia    Male   \n",
       "95874  DALYs (Disability-Adjusted Life Years)             Armenia  Female   \n",
       "95875  DALYs (Disability-Adjusted Life Years)             Armenia    Both   \n",
       "\n",
       "            age                    cause metric  year      daly_val  \\\n",
       "26     All Ages       Transport injuries   Rate  2013   2311.203652   \n",
       "27     All Ages       Transport injuries   Rate  2013   1003.703949   \n",
       "28     All Ages       Transport injuries   Rate  2013   1610.409759   \n",
       "95     All Ages  Cardiovascular diseases   Rate  2013  16913.285219   \n",
       "96     All Ages  Cardiovascular diseases   Rate  2013  12062.770301   \n",
       "...         ...                      ...    ...   ...           ...   \n",
       "95820  All Ages   Unintentional injuries   Rate  2019    924.906883   \n",
       "95821  All Ages   Unintentional injuries   Rate  2019   1489.541043   \n",
       "95873  All Ages       Digestive diseases   Rate  2019   1890.952170   \n",
       "95874  All Ages       Digestive diseases   Rate  2019   1134.309391   \n",
       "95875  All Ages       Digestive diseases   Rate  2019   1499.511198   \n",
       "\n",
       "         daly_upper    daly_lower measure_y  deaths_val  deaths_upper  \\\n",
       "26      2557.790575   2102.970106    Deaths   33.102775     33.670112   \n",
       "27      1204.231323    826.997768    Deaths   10.021556     10.217613   \n",
       "28      1827.886031   1418.823756    Deaths   20.731699     21.055609   \n",
       "95     17121.473215  16646.640694    Deaths  689.563171    698.231847   \n",
       "96     12439.589972  11455.512603    Deaths  730.915208    756.090049   \n",
       "...             ...           ...       ...         ...           ...   \n",
       "95820   1110.802656    764.324202    Deaths    8.090781      9.449337   \n",
       "95821   1751.864358   1263.197669    Deaths   16.076524     18.680623   \n",
       "95873   2175.781400   1600.627590    Deaths   65.149955     76.413600   \n",
       "95874   1299.771431    975.433185    Deaths   49.340143     57.384637   \n",
       "95875   1724.193941   1286.684471    Deaths   56.970919     66.339240   \n",
       "\n",
       "       deaths_lower  CIS_2020  \n",
       "26        31.914774      True  \n",
       "27         9.439502      True  \n",
       "28        19.955321      True  \n",
       "95       671.841370      True  \n",
       "96       678.546166      True  \n",
       "...             ...       ...  \n",
       "95820      6.931106      True  \n",
       "95821     13.813033      True  \n",
       "95873     54.884648      True  \n",
       "95874     41.791501      True  \n",
       "95875     48.503861      True  \n",
       "\n",
       "[3804 rows x 15 columns]"
      ]
     },
     "execution_count": 286,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# выберем строки, которые соответствуют новому условию и проверим, удалось ли их добавить \n",
    "df_all[df_all['CIS_2020'] == True]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 287,
   "metadata": {},
   "outputs": [],
   "source": [
    "# точно так же можно прописать любое сложное условие отдельной функцией, а затем применить к нужному столбцу\n",
    "def if_cis(x):\n",
    "    if x in CIS_2020:\n",
    "        return True\n",
    "    else:\n",
    "        False"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 288,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_all['CIS_2020'] = df_all['location'].apply(if_cis)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 289,
   "metadata": {
    "scrolled": true
   },
   "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>measure_x</th>\n",
       "      <th>location</th>\n",
       "      <th>sex</th>\n",
       "      <th>age</th>\n",
       "      <th>cause</th>\n",
       "      <th>metric</th>\n",
       "      <th>year</th>\n",
       "      <th>daly_val</th>\n",
       "      <th>daly_upper</th>\n",
       "      <th>daly_lower</th>\n",
       "      <th>measure_y</th>\n",
       "      <th>deaths_val</th>\n",
       "      <th>deaths_upper</th>\n",
       "      <th>deaths_lower</th>\n",
       "      <th>CIS_2020</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Transport injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2013</td>\n",
       "      <td>2311.203652</td>\n",
       "      <td>2557.790575</td>\n",
       "      <td>2102.970106</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>33.102775</td>\n",
       "      <td>33.670112</td>\n",
       "      <td>31.914774</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Transport injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2013</td>\n",
       "      <td>1003.703949</td>\n",
       "      <td>1204.231323</td>\n",
       "      <td>826.997768</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>10.021556</td>\n",
       "      <td>10.217613</td>\n",
       "      <td>9.439502</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Transport injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2013</td>\n",
       "      <td>1610.409759</td>\n",
       "      <td>1827.886031</td>\n",
       "      <td>1418.823756</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>20.731699</td>\n",
       "      <td>21.055609</td>\n",
       "      <td>19.955321</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Cardiovascular diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2013</td>\n",
       "      <td>16913.285219</td>\n",
       "      <td>17121.473215</td>\n",
       "      <td>16646.640694</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>689.563171</td>\n",
       "      <td>698.231847</td>\n",
       "      <td>671.841370</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Cardiovascular diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2013</td>\n",
       "      <td>12062.770301</td>\n",
       "      <td>12439.589972</td>\n",
       "      <td>11455.512603</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>730.915208</td>\n",
       "      <td>756.090049</td>\n",
       "      <td>678.546166</td>\n",
       "      <td>True</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95820</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Uzbekistan</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Unintentional injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>924.906883</td>\n",
       "      <td>1110.802656</td>\n",
       "      <td>764.324202</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>8.090781</td>\n",
       "      <td>9.449337</td>\n",
       "      <td>6.931106</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95821</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Uzbekistan</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Unintentional injuries</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1489.541043</td>\n",
       "      <td>1751.864358</td>\n",
       "      <td>1263.197669</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>16.076524</td>\n",
       "      <td>18.680623</td>\n",
       "      <td>13.813033</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95873</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Armenia</td>\n",
       "      <td>Male</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Digestive diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1890.952170</td>\n",
       "      <td>2175.781400</td>\n",
       "      <td>1600.627590</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>65.149955</td>\n",
       "      <td>76.413600</td>\n",
       "      <td>54.884648</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95874</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Armenia</td>\n",
       "      <td>Female</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Digestive diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1134.309391</td>\n",
       "      <td>1299.771431</td>\n",
       "      <td>975.433185</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>49.340143</td>\n",
       "      <td>57.384637</td>\n",
       "      <td>41.791501</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95875</th>\n",
       "      <td>DALYs (Disability-Adjusted Life Years)</td>\n",
       "      <td>Armenia</td>\n",
       "      <td>Both</td>\n",
       "      <td>All Ages</td>\n",
       "      <td>Digestive diseases</td>\n",
       "      <td>Rate</td>\n",
       "      <td>2019</td>\n",
       "      <td>1499.511198</td>\n",
       "      <td>1724.193941</td>\n",
       "      <td>1286.684471</td>\n",
       "      <td>Deaths</td>\n",
       "      <td>56.970919</td>\n",
       "      <td>66.339240</td>\n",
       "      <td>48.503861</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3804 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    measure_x            location     sex  \\\n",
       "26     DALYs (Disability-Adjusted Life Years)  Russian Federation    Male   \n",
       "27     DALYs (Disability-Adjusted Life Years)  Russian Federation  Female   \n",
       "28     DALYs (Disability-Adjusted Life Years)  Russian Federation    Both   \n",
       "95     DALYs (Disability-Adjusted Life Years)  Russian Federation    Male   \n",
       "96     DALYs (Disability-Adjusted Life Years)  Russian Federation  Female   \n",
       "...                                       ...                 ...     ...   \n",
       "95820  DALYs (Disability-Adjusted Life Years)          Uzbekistan  Female   \n",
       "95821  DALYs (Disability-Adjusted Life Years)          Uzbekistan    Both   \n",
       "95873  DALYs (Disability-Adjusted Life Years)             Armenia    Male   \n",
       "95874  DALYs (Disability-Adjusted Life Years)             Armenia  Female   \n",
       "95875  DALYs (Disability-Adjusted Life Years)             Armenia    Both   \n",
       "\n",
       "            age                    cause metric  year      daly_val  \\\n",
       "26     All Ages       Transport injuries   Rate  2013   2311.203652   \n",
       "27     All Ages       Transport injuries   Rate  2013   1003.703949   \n",
       "28     All Ages       Transport injuries   Rate  2013   1610.409759   \n",
       "95     All Ages  Cardiovascular diseases   Rate  2013  16913.285219   \n",
       "96     All Ages  Cardiovascular diseases   Rate  2013  12062.770301   \n",
       "...         ...                      ...    ...   ...           ...   \n",
       "95820  All Ages   Unintentional injuries   Rate  2019    924.906883   \n",
       "95821  All Ages   Unintentional injuries   Rate  2019   1489.541043   \n",
       "95873  All Ages       Digestive diseases   Rate  2019   1890.952170   \n",
       "95874  All Ages       Digestive diseases   Rate  2019   1134.309391   \n",
       "95875  All Ages       Digestive diseases   Rate  2019   1499.511198   \n",
       "\n",
       "         daly_upper    daly_lower measure_y  deaths_val  deaths_upper  \\\n",
       "26      2557.790575   2102.970106    Deaths   33.102775     33.670112   \n",
       "27      1204.231323    826.997768    Deaths   10.021556     10.217613   \n",
       "28      1827.886031   1418.823756    Deaths   20.731699     21.055609   \n",
       "95     17121.473215  16646.640694    Deaths  689.563171    698.231847   \n",
       "96     12439.589972  11455.512603    Deaths  730.915208    756.090049   \n",
       "...             ...           ...       ...         ...           ...   \n",
       "95820   1110.802656    764.324202    Deaths    8.090781      9.449337   \n",
       "95821   1751.864358   1263.197669    Deaths   16.076524     18.680623   \n",
       "95873   2175.781400   1600.627590    Deaths   65.149955     76.413600   \n",
       "95874   1299.771431    975.433185    Deaths   49.340143     57.384637   \n",
       "95875   1724.193941   1286.684471    Deaths   56.970919     66.339240   \n",
       "\n",
       "       deaths_lower CIS_2020  \n",
       "26        31.914774     True  \n",
       "27         9.439502     True  \n",
       "28        19.955321     True  \n",
       "95       671.841370     True  \n",
       "96       678.546166     True  \n",
       "...             ...      ...  \n",
       "95820      6.931106     True  \n",
       "95821     13.813033     True  \n",
       "95873     54.884648     True  \n",
       "95874     41.791501     True  \n",
       "95875     48.503861     True  \n",
       "\n",
       "[3804 rows x 15 columns]"
      ]
     },
     "execution_count": 289,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_all[df_all['CIS_2020'] == True]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 290,
   "metadata": {},
   "outputs": [],
   "source": [
    "# сохраняем датафрейм в csv\n",
    "df_all.to_csv('df_all.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 3. Работа с большими файлами с помощью аргумента chunksize"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 233,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CHUNK DF\n",
      "   Unnamed: 0                               measure_x location     sex  \\\n",
      "0           0  DALYs (Disability-Adjusted Life Years)   Gambia  Female   \n",
      "1           1  DALYs (Disability-Adjusted Life Years)   Gambia    Both   \n",
      "2           2  DALYs (Disability-Adjusted Life Years)   Gambia    Male   \n",
      "3           3  DALYs (Disability-Adjusted Life Years)   Gambia  Female   \n",
      "4           4  DALYs (Disability-Adjusted Life Years)   Gambia    Both   \n",
      "\n",
      "        age                            cause metric  year     daly_val  \\\n",
      "0  All Ages  Maternal and neonatal disorders   Rate  2012  7475.212700   \n",
      "1  All Ages  Maternal and neonatal disorders   Rate  2012  7814.344518   \n",
      "2  All Ages          Substance use disorders   Rate  2012   179.493660   \n",
      "3  All Ages          Substance use disorders   Rate  2012    91.400543   \n",
      "4  All Ages          Substance use disorders   Rate  2012   134.688036   \n",
      "\n",
      "    daly_upper   daly_lower measure_y  deaths_val  deaths_upper  deaths_lower  \\\n",
      "0  9104.773541  6157.428603    Deaths   89.867238    110.176286     74.001324   \n",
      "1  9667.960848  6289.146375    Deaths   89.365457    111.497307     71.539316   \n",
      "2   230.104586   134.067784    Deaths    1.101136      1.545407      0.786638   \n",
      "3   124.025911    64.625204    Deaths    0.227136      0.296917      0.173921   \n",
      "4   171.782808    99.320179    Deaths    0.656605      0.896138      0.490594   \n",
      "\n",
      "  CIS_2020  \n",
      "0      NaN  \n",
      "1      NaN  \n",
      "2      NaN  \n",
      "3      NaN  \n",
      "4      NaN  \n",
      "CHUNK DF\n",
      "       Unnamed: 0                               measure_x location     sex  \\\n",
      "50000       50000  DALYs (Disability-Adjusted Life Years)    India    Both   \n",
      "50001       50001  DALYs (Disability-Adjusted Life Years)    India    Male   \n",
      "50002       50002  DALYs (Disability-Adjusted Life Years)    India  Female   \n",
      "50003       50003  DALYs (Disability-Adjusted Life Years)    India    Both   \n",
      "50004       50004  DALYs (Disability-Adjusted Life Years)   Turkey    Male   \n",
      "\n",
      "            age                            cause metric  year     daly_val  \\\n",
      "50000  All Ages        Other infectious diseases   Rate  2016   958.958618   \n",
      "50001  All Ages  Maternal and neonatal disorders   Rate  2016  3857.092523   \n",
      "50002  All Ages  Maternal and neonatal disorders   Rate  2016  3936.244203   \n",
      "50003  All Ages  Maternal and neonatal disorders   Rate  2016  3895.617080   \n",
      "50004  All Ages               Transport injuries   Rate  2016   906.078397   \n",
      "\n",
      "        daly_upper   daly_lower measure_y  deaths_val  deaths_upper  \\\n",
      "50000  1253.212194   758.548648    Deaths   14.064804     17.711690   \n",
      "50001  4559.365099  3248.746140    Deaths   39.804065     47.428130   \n",
      "50002  4575.786077  3357.759508    Deaths   42.591026     49.826017   \n",
      "50003  4578.291899  3318.975051    Deaths   41.160530     48.311924   \n",
      "50004  1044.082153   685.161081    Deaths   16.515202     19.376146   \n",
      "\n",
      "       deaths_lower CIS_2020  \n",
      "50000     11.444635      NaN  \n",
      "50001     33.085022      NaN  \n",
      "50002     36.112185      NaN  \n",
      "50003     34.780916      NaN  \n",
      "50004     11.913822      NaN  \n"
     ]
    }
   ],
   "source": [
    "# разобьем большой файл на части с помощью аргумента chunksize, в котором прописывается сколько строк должно быть в каждой части\n",
    "# выведем по 5 строк каждой получившейся части\n",
    "\n",
    "for chunk_df in pd.read_csv('df_all.csv', \n",
    "                      chunksize = 50000):\n",
    "    print(\"CHUNK DF\")\n",
    "    print(chunk_df.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 244,
   "metadata": {},
   "outputs": [],
   "source": [
    "# применим метод groupby отдельно к каждой части и затем объединим результат в новый датафрейм\n",
    "new_df = pd.DataFrame() # пустой датафрейм\n",
    "for chunk_df in pd.read_csv('df_all.csv', \n",
    "                      chunksize = 50000):\n",
    "    result = chunk_df.groupby(['cause', 'year']).agg({'deaths_val': 'mean',\n",
    "                                                    'daly_val': 'mean'})\n",
    "    new_df = pd.concat([new_df,result])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 248,
   "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></th>\n",
       "      <th>deaths_val</th>\n",
       "      <th>daly_val</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cause</th>\n",
       "      <th>year</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Cardiovascular diseases</th>\n",
       "      <th>2011</th>\n",
       "      <td>112.889873</td>\n",
       "      <td>2945.949359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012</th>\n",
       "      <td>238.128059</td>\n",
       "      <td>5118.690134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>236.486609</td>\n",
       "      <td>5005.051157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014</th>\n",
       "      <td>242.057921</td>\n",
       "      <td>5088.816632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015</th>\n",
       "      <td>253.292782</td>\n",
       "      <td>5250.955897</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Unintentional injuries</th>\n",
       "      <th>2015</th>\n",
       "      <td>24.622137</td>\n",
       "      <td>1575.325187</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016</th>\n",
       "      <td>21.095357</td>\n",
       "      <td>1389.698018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017</th>\n",
       "      <td>22.527506</td>\n",
       "      <td>1467.601676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018</th>\n",
       "      <td>21.578766</td>\n",
       "      <td>1428.203221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2019</th>\n",
       "      <td>21.508796</td>\n",
       "      <td>1417.611000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>236 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                              deaths_val     daly_val\n",
       "cause                   year                         \n",
       "Cardiovascular diseases 2011  112.889873  2945.949359\n",
       "                        2012  238.128059  5118.690134\n",
       "                        2013  236.486609  5005.051157\n",
       "                        2014  242.057921  5088.816632\n",
       "                        2015  253.292782  5250.955897\n",
       "...                                  ...          ...\n",
       "Unintentional injuries  2015   24.622137  1575.325187\n",
       "                        2016   21.095357  1389.698018\n",
       "                        2017   22.527506  1467.601676\n",
       "                        2018   21.578766  1428.203221\n",
       "                        2019   21.508796  1417.611000\n",
       "\n",
       "[236 rows x 2 columns]"
      ]
     },
     "execution_count": 248,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 291,
   "metadata": {},
   "outputs": [],
   "source": [
    "# сохраним результат в файл\n",
    "new_df.to_csv('deaths_daly_groupby.csv', encoding = 'utf-8')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Вот и всё, вы молодцы!"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}