data_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 141,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import ast\n",
    "import json\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "metadata": {},
   "outputs": [],
   "source": [
    "paid = pd.read_csv('Данные/paid_all_period.csv')\n",
    "affected = pd.read_csv('Данные/sectors_cluster_affected_total_all_period.csv')\n",
    "targeted = pd.read_csv('Данные/sectors_cluster_targeted_total_all_period.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Year</th>\n",
       "      <th>Donor Name</th>\n",
       "      <th>CBPF Name</th>\n",
       "      <th>Paid Amount</th>\n",
       "      <th>Pledged Amount</th>\n",
       "      <th>Total Contributions</th>\n",
       "      <th>Local Curency</th>\n",
       "      <th>Exchange Rate</th>\n",
       "      <th>Paid Amount (Local Currency)</th>\n",
       "      <th>Pledged Amount (Local Currency)</th>\n",
       "      <th>Total Contributions (Local Currency)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>2006</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>5012000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5012000.0</td>\n",
       "      <td>USD</td>\n",
       "      <td>1.00</td>\n",
       "      <td>5012000.00</td>\n",
       "      <td>0</td>\n",
       "      <td>5012000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2006</td>\n",
       "      <td>Norway</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>1553277.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1553277.0</td>\n",
       "      <td>USD</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1553277.00</td>\n",
       "      <td>0</td>\n",
       "      <td>1553277.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2006</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>247934.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>247934.0</td>\n",
       "      <td>CHF</td>\n",
       "      <td>1.21</td>\n",
       "      <td>300000.14</td>\n",
       "      <td>0</td>\n",
       "      <td>300000.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>2006</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>8861284.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>8861284.0</td>\n",
       "      <td>GBP</td>\n",
       "      <td>0.56</td>\n",
       "      <td>5000000.20</td>\n",
       "      <td>0</td>\n",
       "      <td>5000000.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>2007</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>3395940.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3395940.0</td>\n",
       "      <td>USD</td>\n",
       "      <td>1.00</td>\n",
       "      <td>3395940.00</td>\n",
       "      <td>0</td>\n",
       "      <td>3395940.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0  Year      Donor Name CBPF Name  Paid Amount  Pledged Amount  \\\n",
       "0           0  2006     Netherlands  Ethiopia    5012000.0             0.0   \n",
       "1           1  2006          Norway  Ethiopia    1553277.0             0.0   \n",
       "2           2  2006     Switzerland  Ethiopia     247934.0             0.0   \n",
       "3           3  2006  United Kingdom  Ethiopia    8861284.0             0.0   \n",
       "4           0  2007     Netherlands  Ethiopia    3395940.0             0.0   \n",
       "\n",
       "   Total Contributions Local Curency  Exchange Rate  \\\n",
       "0            5012000.0           USD           1.00   \n",
       "1            1553277.0           USD           1.00   \n",
       "2             247934.0           CHF           1.21   \n",
       "3            8861284.0           GBP           0.56   \n",
       "4            3395940.0           USD           1.00   \n",
       "\n",
       "   Paid Amount (Local Currency)  Pledged Amount (Local Currency)  \\\n",
       "0                    5012000.00                                0   \n",
       "1                    1553277.00                                0   \n",
       "2                     300000.14                                0   \n",
       "3                    5000000.20                                0   \n",
       "4                    3395940.00                                0   \n",
       "\n",
       "   Total Contributions (Local Currency)  \n",
       "0                            5012000.00  \n",
       "1                            1553277.00  \n",
       "2                             300000.14  \n",
       "3                            5000000.20  \n",
       "4                            3395940.00  "
      ]
     },
     "execution_count": 143,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "paid.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "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>CBPF Name</th>\n",
       "      <th>total_contributions</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Niger (RhPF)</th>\n",
       "      <td>6</td>\n",
       "      <td>8.764908e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Burkina Faso (RhPF)</th>\n",
       "      <td>6</td>\n",
       "      <td>1.228212e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Colombia</th>\n",
       "      <td>24</td>\n",
       "      <td>1.270318e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Venezuela</th>\n",
       "      <td>11</td>\n",
       "      <td>1.276383e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jordan</th>\n",
       "      <td>35</td>\n",
       "      <td>6.183625e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Myanmar</th>\n",
       "      <td>65</td>\n",
       "      <td>9.210216e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Haiti</th>\n",
       "      <td>47</td>\n",
       "      <td>9.386667e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pakistan</th>\n",
       "      <td>33</td>\n",
       "      <td>1.033629e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Lebanon</th>\n",
       "      <td>60</td>\n",
       "      <td>1.105090e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nigeria</th>\n",
       "      <td>61</td>\n",
       "      <td>1.512291e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oPt</th>\n",
       "      <td>99</td>\n",
       "      <td>1.673497e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ukraine</th>\n",
       "      <td>48</td>\n",
       "      <td>2.316317e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CAR</th>\n",
       "      <td>92</td>\n",
       "      <td>2.640590e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Syria</th>\n",
       "      <td>107</td>\n",
       "      <td>3.193841e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Iraq</th>\n",
       "      <td>66</td>\n",
       "      <td>3.530478e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Somalia</th>\n",
       "      <td>115</td>\n",
       "      <td>5.283192e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>79</td>\n",
       "      <td>5.913914e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ethiopia</th>\n",
       "      <td>120</td>\n",
       "      <td>6.808559e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Syria Cross border</th>\n",
       "      <td>94</td>\n",
       "      <td>7.185451e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sudan</th>\n",
       "      <td>93</td>\n",
       "      <td>7.320387e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DRC</th>\n",
       "      <td>98</td>\n",
       "      <td>8.338781e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>South Sudan</th>\n",
       "      <td>116</td>\n",
       "      <td>8.678893e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yemen</th>\n",
       "      <td>157</td>\n",
       "      <td>9.248935e+08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     CBPF Name  total_contributions\n",
       "Niger (RhPF)                 6         8.764908e+06\n",
       "Burkina Faso (RhPF)          6         1.228212e+07\n",
       "Colombia                    24         1.270318e+07\n",
       "Venezuela                   11         1.276383e+07\n",
       "Jordan                      35         6.183625e+07\n",
       "Myanmar                     65         9.210216e+07\n",
       "Haiti                       47         9.386667e+07\n",
       "Pakistan                    33         1.033629e+08\n",
       "Lebanon                     60         1.105090e+08\n",
       "Nigeria                     61         1.512291e+08\n",
       "oPt                         99         1.673497e+08\n",
       "Ukraine                     48         2.316317e+08\n",
       "CAR                         92         2.640590e+08\n",
       "Syria                      107         3.193841e+08\n",
       "Iraq                        66         3.530478e+08\n",
       "Somalia                    115         5.283192e+08\n",
       "Afghanistan                 79         5.913914e+08\n",
       "Ethiopia                   120         6.808559e+08\n",
       "Syria Cross border          94         7.185451e+08\n",
       "Sudan                       93         7.320387e+08\n",
       "DRC                         98         8.338781e+08\n",
       "South Sudan                116         8.678893e+08\n",
       "Yemen                      157         9.248935e+08"
      ]
     },
     "execution_count": 144,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "paid_money_by_country = pd.DataFrame(paid['CBPF Name'].value_counts())\n",
    "paid_money_by_country['total_contributions'] = paid.groupby(by=['CBPF Name']).sum()['Total Contributions']\n",
    "paid_money_by_country.sort_values(by='total_contributions')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "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>Donor Name</th>\n",
       "      <th>total_contributions</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Kenya</th>\n",
       "      <td>1</td>\n",
       "      <td>1.987330e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Madagascar</th>\n",
       "      <td>1</td>\n",
       "      <td>5.000000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sri Lanka</th>\n",
       "      <td>4</td>\n",
       "      <td>5.000000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chile</th>\n",
       "      <td>1</td>\n",
       "      <td>5.000000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Montenegro</th>\n",
       "      <td>1</td>\n",
       "      <td>1.234568e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Norway</th>\n",
       "      <td>115</td>\n",
       "      <td>4.384337e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Netherlands</th>\n",
       "      <td>97</td>\n",
       "      <td>7.962476e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sweden</th>\n",
       "      <td>177</td>\n",
       "      <td>9.000405e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Germany</th>\n",
       "      <td>111</td>\n",
       "      <td>1.073204e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United Kingdom</th>\n",
       "      <td>136</td>\n",
       "      <td>2.442082e+09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>84 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Donor Name  total_contributions\n",
       "Kenya                    1         1.987330e+03\n",
       "Madagascar               1         5.000000e+03\n",
       "Sri Lanka                4         5.000000e+03\n",
       "Chile                    1         5.000000e+03\n",
       "Montenegro               1         1.234568e+04\n",
       "...                    ...                  ...\n",
       "Norway                 115         4.384337e+08\n",
       "Netherlands             97         7.962476e+08\n",
       "Sweden                 177         9.000405e+08\n",
       "Germany                111         1.073204e+09\n",
       "United Kingdom         136         2.442082e+09\n",
       "\n",
       "[84 rows x 2 columns]"
      ]
     },
     "execution_count": 145,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "paid_money_by_donor = pd.DataFrame(paid['Donor Name'].value_counts())\n",
    "paid_money_by_donor['total_contributions'] = paid.groupby(by=['Donor Name']).sum()['Total Contributions']\n",
    "paid_money_by_donor.sort_values(by='total_contributions')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "metadata": {},
   "outputs": [],
   "source": [
    "def count_degree_paid(data, \n",
    "                      affected,\n",
    "                      targeted,\n",
    "                      year_begin=2020, \n",
    "                      year_finish=2021, \n",
    "                      count_type='unique_country'):\n",
    "    \n",
    "\n",
    "    data_period = data[(data.Year >= year_begin) & (data.Year <= year_finish)]\n",
    "    affected = affected[(affected.Year >= year_begin) & (affected.Year <= year_finish)]\n",
    "    targeted = targeted[(targeted.Year >= year_begin) & (targeted.Year <= year_finish)]\n",
    "    \n",
    "    if count_type == 'unique_country':\n",
    "        data_country = data_period[['Donor Name', 'CBPF Name']].drop_duplicates()\n",
    "        donor_weight = pd.DataFrame(data_country.groupby(by=['Donor Name']).count()['CBPF Name'])\n",
    "        donor_weight['transaction_sum'] = data_period.groupby(by='Donor Name').sum()['Total Contributions']\n",
    "        donor_weight['transaction_number'] = data_period.groupby(by='Donor Name').count()['Total Contributions']\n",
    "        donor_weight = donor_weight.reset_index()\n",
    "        donor_weight['help_countries'] = ''\n",
    "\n",
    "        poor_weight = pd.DataFrame(data_country.groupby(by=['CBPF Name']).count()['Donor Name'])\n",
    "        poor_weight['transaction_sum'] = data_period.groupby(by='CBPF Name').sum()['Total Contributions']\n",
    "        poor_weight['transaction_number'] = data_period.groupby(by='CBPF Name').count()['Total Contributions']\n",
    "        poor_weight[['Total Allocations target', 'Targeted People target', 'Reached People target']] = targeted.groupby(by=['CBPF Name']).sum()[['Total Allocations', 'Targeted People', 'Reached People']]\n",
    "        poor_weight[['Total Allocations affected', 'Targeted People affected', 'Reached People affected']] = targeted.groupby(by=['CBPF Name']).sum()[['Total Allocations', 'Targeted People', 'Reached People']]\n",
    "        poor_weight = poor_weight.reset_index()\n",
    "        poor_weight['help_countries'] = ''\n",
    "\n",
    "        for donor in data_country['Donor Name'].unique():\n",
    "            help_countries = data_country[data_country['Donor Name'] == donor]['CBPF Name'].values\n",
    "            help_countries = \",\".join(help_countries)\n",
    "            donor_weight.loc[donor_weight['Donor Name'] == donor, 'help_countries'] = help_countries\n",
    "\n",
    "        for poor in data_country['CBPF Name'].unique():\n",
    "            help_countries = data_country[data_country['CBPF Name'] == poor]['Donor Name'].values\n",
    "            help_countries = \",\".join(help_countries)\n",
    "            poor_weight.loc[poor_weight['CBPF Name'] == poor, 'help_countries'] = help_countries\n",
    "        \n",
    "        donor_weight['help_countries'] = donor_weight['help_countries'].apply(lambda x: x.split(','))\n",
    "        poor_weight['help_countries'] = poor_weight['help_countries'].apply(lambda x: x.split(','))\n",
    "\n",
    "        donor_weight = donor_weight.rename(columns={'CBPF Name': 'cbpf_number'})\n",
    "        poor_weight = poor_weight.rename(columns={'Donor Name': 'donor_number'})\n",
    "\n",
    "        return donor_weight, poor_weight\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "metadata": {},
   "outputs": [],
   "source": [
    "donor_weight, poor_weight = count_degree_paid(paid, affected, targeted, year_begin=2016, year_finish=2021)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 150,
   "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>CBPF Name</th>\n",
       "      <th>donor_number</th>\n",
       "      <th>transaction_sum</th>\n",
       "      <th>transaction_number</th>\n",
       "      <th>Total Allocations target</th>\n",
       "      <th>Targeted People target</th>\n",
       "      <th>Reached People target</th>\n",
       "      <th>Total Allocations affected</th>\n",
       "      <th>Targeted People affected</th>\n",
       "      <th>Reached People affected</th>\n",
       "      <th>help_countries</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>16</td>\n",
       "      <td>3.004483e+08</td>\n",
       "      <td>48</td>\n",
       "      <td>4.506843e+08</td>\n",
       "      <td>48719165</td>\n",
       "      <td>28118344</td>\n",
       "      <td>4.506843e+08</td>\n",
       "      <td>48719165</td>\n",
       "      <td>28118344</td>\n",
       "      <td>[Australia, Denmark, Germany, Netherlands, Nor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CAR</td>\n",
       "      <td>15</td>\n",
       "      <td>1.433469e+08</td>\n",
       "      <td>54</td>\n",
       "      <td>1.663312e+08</td>\n",
       "      <td>16536435</td>\n",
       "      <td>15665310</td>\n",
       "      <td>1.663312e+08</td>\n",
       "      <td>16536435</td>\n",
       "      <td>15665310</td>\n",
       "      <td>[Belgium, Canada, Denmark, Germany, Ireland, L...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Colombia</td>\n",
       "      <td>4</td>\n",
       "      <td>2.706420e+06</td>\n",
       "      <td>7</td>\n",
       "      <td>3.290924e+06</td>\n",
       "      <td>28639</td>\n",
       "      <td>35994</td>\n",
       "      <td>3.290924e+06</td>\n",
       "      <td>28639</td>\n",
       "      <td>35994</td>\n",
       "      <td>[Spain, Sweden, Switzerland, PRIVATE SECTOR]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>DRC</td>\n",
       "      <td>11</td>\n",
       "      <td>3.391533e+08</td>\n",
       "      <td>45</td>\n",
       "      <td>3.807995e+08</td>\n",
       "      <td>20252836</td>\n",
       "      <td>21783839</td>\n",
       "      <td>3.807995e+08</td>\n",
       "      <td>20252836</td>\n",
       "      <td>21783839</td>\n",
       "      <td>[Belgium, Ireland, Luxembourg, Netherlands, Sw...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>17</td>\n",
       "      <td>3.427118e+08</td>\n",
       "      <td>52</td>\n",
       "      <td>4.545566e+08</td>\n",
       "      <td>95239407</td>\n",
       "      <td>84193027</td>\n",
       "      <td>4.545566e+08</td>\n",
       "      <td>95239407</td>\n",
       "      <td>84193027</td>\n",
       "      <td>[Australia, Denmark, Germany, Ireland, Korea, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Iraq</td>\n",
       "      <td>19</td>\n",
       "      <td>2.923819e+08</td>\n",
       "      <td>55</td>\n",
       "      <td>3.367464e+08</td>\n",
       "      <td>29431129</td>\n",
       "      <td>29649774</td>\n",
       "      <td>3.367464e+08</td>\n",
       "      <td>29431129</td>\n",
       "      <td>29649774</td>\n",
       "      <td>[Australia, Belgium, Canada, Cyprus, Denmark, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Jordan</td>\n",
       "      <td>11</td>\n",
       "      <td>4.880278e+07</td>\n",
       "      <td>28</td>\n",
       "      <td>4.979649e+07</td>\n",
       "      <td>2002846</td>\n",
       "      <td>1822529</td>\n",
       "      <td>4.979649e+07</td>\n",
       "      <td>2002846</td>\n",
       "      <td>1822529</td>\n",
       "      <td>[Belgium, Ireland, Netherlands, Sweden, United...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Lebanon</td>\n",
       "      <td>15</td>\n",
       "      <td>7.127652e+07</td>\n",
       "      <td>42</td>\n",
       "      <td>1.003306e+08</td>\n",
       "      <td>1843283</td>\n",
       "      <td>1675849</td>\n",
       "      <td>1.003306e+08</td>\n",
       "      <td>1843283</td>\n",
       "      <td>1675849</td>\n",
       "      <td>[Belgium, Germany, Ireland, Netherlands, Swede...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Myanmar</td>\n",
       "      <td>15</td>\n",
       "      <td>6.360746e+07</td>\n",
       "      <td>43</td>\n",
       "      <td>7.866459e+07</td>\n",
       "      <td>4464966</td>\n",
       "      <td>4065797</td>\n",
       "      <td>7.866459e+07</td>\n",
       "      <td>4464966</td>\n",
       "      <td>4065797</td>\n",
       "      <td>[Australia, Denmark, Sweden, Switzerland, Unit...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Nigeria</td>\n",
       "      <td>21</td>\n",
       "      <td>1.313785e+08</td>\n",
       "      <td>52</td>\n",
       "      <td>1.425113e+08</td>\n",
       "      <td>21893692</td>\n",
       "      <td>22822675</td>\n",
       "      <td>1.425113e+08</td>\n",
       "      <td>21893692</td>\n",
       "      <td>22822675</td>\n",
       "      <td>[Azerbaijan, Belgium, Canada, Denmark, Germany...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Pakistan</td>\n",
       "      <td>5</td>\n",
       "      <td>3.710265e+07</td>\n",
       "      <td>14</td>\n",
       "      <td>3.755265e+07</td>\n",
       "      <td>6751274</td>\n",
       "      <td>5793640</td>\n",
       "      <td>3.755265e+07</td>\n",
       "      <td>6751274</td>\n",
       "      <td>5793640</td>\n",
       "      <td>[Sweden, United Kingdom, PRIVATE SECTOR, Canad...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Somalia</td>\n",
       "      <td>15</td>\n",
       "      <td>2.436826e+08</td>\n",
       "      <td>59</td>\n",
       "      <td>2.779365e+08</td>\n",
       "      <td>28254147</td>\n",
       "      <td>29632204</td>\n",
       "      <td>2.779365e+08</td>\n",
       "      <td>28254147</td>\n",
       "      <td>29632204</td>\n",
       "      <td>[Australia, Denmark, Germany, Ireland, Netherl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>South Sudan</td>\n",
       "      <td>18</td>\n",
       "      <td>3.604884e+08</td>\n",
       "      <td>70</td>\n",
       "      <td>4.104549e+08</td>\n",
       "      <td>44634631</td>\n",
       "      <td>48870515</td>\n",
       "      <td>4.104549e+08</td>\n",
       "      <td>44634631</td>\n",
       "      <td>48870515</td>\n",
       "      <td>[Australia, Belgium, Canada, Denmark, Germany,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Sudan</td>\n",
       "      <td>14</td>\n",
       "      <td>2.600087e+08</td>\n",
       "      <td>45</td>\n",
       "      <td>3.039283e+08</td>\n",
       "      <td>82280823</td>\n",
       "      <td>74453364</td>\n",
       "      <td>3.039283e+08</td>\n",
       "      <td>82280823</td>\n",
       "      <td>74453364</td>\n",
       "      <td>[Denmark, Germany, Ireland, Netherlands, Norwa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Syria</td>\n",
       "      <td>22</td>\n",
       "      <td>2.432172e+08</td>\n",
       "      <td>75</td>\n",
       "      <td>3.084226e+08</td>\n",
       "      <td>34695584</td>\n",
       "      <td>33958998</td>\n",
       "      <td>3.084226e+08</td>\n",
       "      <td>34695584</td>\n",
       "      <td>33958998</td>\n",
       "      <td>[Belgium, Denmark, Germany, Iceland, Jersey, K...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Syria Cross border</td>\n",
       "      <td>17</td>\n",
       "      <td>5.332880e+08</td>\n",
       "      <td>63</td>\n",
       "      <td>6.738566e+08</td>\n",
       "      <td>57534139</td>\n",
       "      <td>55074856</td>\n",
       "      <td>6.738566e+08</td>\n",
       "      <td>57534139</td>\n",
       "      <td>55074856</td>\n",
       "      <td>[Belgium, Denmark, France, Germany, Ireland, N...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Ukraine</td>\n",
       "      <td>14</td>\n",
       "      <td>1.650802e+07</td>\n",
       "      <td>20</td>\n",
       "      <td>2.739508e+07</td>\n",
       "      <td>1471816</td>\n",
       "      <td>553018</td>\n",
       "      <td>2.739508e+07</td>\n",
       "      <td>1471816</td>\n",
       "      <td>553018</td>\n",
       "      <td>[Estonia, Germany, Korea,  Republic of, Lithua...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Venezuela</td>\n",
       "      <td>6</td>\n",
       "      <td>5.442107e+06</td>\n",
       "      <td>6</td>\n",
       "      <td>1.145604e+07</td>\n",
       "      <td>173795</td>\n",
       "      <td>112740</td>\n",
       "      <td>1.145604e+07</td>\n",
       "      <td>173795</td>\n",
       "      <td>112740</td>\n",
       "      <td>[Canada, Ireland, Korea,  Republic of, Spain, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Yemen</td>\n",
       "      <td>38</td>\n",
       "      <td>7.582367e+08</td>\n",
       "      <td>105</td>\n",
       "      <td>8.575105e+08</td>\n",
       "      <td>51597134</td>\n",
       "      <td>49037954</td>\n",
       "      <td>8.575105e+08</td>\n",
       "      <td>51597134</td>\n",
       "      <td>49037954</td>\n",
       "      <td>[Canada, Denmark, Germany, Ireland, Korea,  Re...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>oPt</td>\n",
       "      <td>18</td>\n",
       "      <td>1.072515e+08</td>\n",
       "      <td>50</td>\n",
       "      <td>1.327950e+08</td>\n",
       "      <td>28907459</td>\n",
       "      <td>30813856</td>\n",
       "      <td>1.327950e+08</td>\n",
       "      <td>28907459</td>\n",
       "      <td>30813856</td>\n",
       "      <td>[Belgium, Germany, Ireland, Norway, Spain, Swe...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             CBPF Name  donor_number  transaction_sum  transaction_number  \\\n",
       "0          Afghanistan            16     3.004483e+08                  48   \n",
       "1                  CAR            15     1.433469e+08                  54   \n",
       "2             Colombia             4     2.706420e+06                   7   \n",
       "3                  DRC            11     3.391533e+08                  45   \n",
       "4             Ethiopia            17     3.427118e+08                  52   \n",
       "5                 Iraq            19     2.923819e+08                  55   \n",
       "6               Jordan            11     4.880278e+07                  28   \n",
       "7              Lebanon            15     7.127652e+07                  42   \n",
       "8              Myanmar            15     6.360746e+07                  43   \n",
       "9              Nigeria            21     1.313785e+08                  52   \n",
       "10            Pakistan             5     3.710265e+07                  14   \n",
       "11             Somalia            15     2.436826e+08                  59   \n",
       "12         South Sudan            18     3.604884e+08                  70   \n",
       "13               Sudan            14     2.600087e+08                  45   \n",
       "14               Syria            22     2.432172e+08                  75   \n",
       "15  Syria Cross border            17     5.332880e+08                  63   \n",
       "16             Ukraine            14     1.650802e+07                  20   \n",
       "17           Venezuela             6     5.442107e+06                   6   \n",
       "18               Yemen            38     7.582367e+08                 105   \n",
       "19                 oPt            18     1.072515e+08                  50   \n",
       "\n",
       "    Total Allocations target  Targeted People target  Reached People target  \\\n",
       "0               4.506843e+08                48719165               28118344   \n",
       "1               1.663312e+08                16536435               15665310   \n",
       "2               3.290924e+06                   28639                  35994   \n",
       "3               3.807995e+08                20252836               21783839   \n",
       "4               4.545566e+08                95239407               84193027   \n",
       "5               3.367464e+08                29431129               29649774   \n",
       "6               4.979649e+07                 2002846                1822529   \n",
       "7               1.003306e+08                 1843283                1675849   \n",
       "8               7.866459e+07                 4464966                4065797   \n",
       "9               1.425113e+08                21893692               22822675   \n",
       "10              3.755265e+07                 6751274                5793640   \n",
       "11              2.779365e+08                28254147               29632204   \n",
       "12              4.104549e+08                44634631               48870515   \n",
       "13              3.039283e+08                82280823               74453364   \n",
       "14              3.084226e+08                34695584               33958998   \n",
       "15              6.738566e+08                57534139               55074856   \n",
       "16              2.739508e+07                 1471816                 553018   \n",
       "17              1.145604e+07                  173795                 112740   \n",
       "18              8.575105e+08                51597134               49037954   \n",
       "19              1.327950e+08                28907459               30813856   \n",
       "\n",
       "    Total Allocations affected  Targeted People affected  \\\n",
       "0                 4.506843e+08                  48719165   \n",
       "1                 1.663312e+08                  16536435   \n",
       "2                 3.290924e+06                     28639   \n",
       "3                 3.807995e+08                  20252836   \n",
       "4                 4.545566e+08                  95239407   \n",
       "5                 3.367464e+08                  29431129   \n",
       "6                 4.979649e+07                   2002846   \n",
       "7                 1.003306e+08                   1843283   \n",
       "8                 7.866459e+07                   4464966   \n",
       "9                 1.425113e+08                  21893692   \n",
       "10                3.755265e+07                   6751274   \n",
       "11                2.779365e+08                  28254147   \n",
       "12                4.104549e+08                  44634631   \n",
       "13                3.039283e+08                  82280823   \n",
       "14                3.084226e+08                  34695584   \n",
       "15                6.738566e+08                  57534139   \n",
       "16                2.739508e+07                   1471816   \n",
       "17                1.145604e+07                    173795   \n",
       "18                8.575105e+08                  51597134   \n",
       "19                1.327950e+08                  28907459   \n",
       "\n",
       "    Reached People affected                                     help_countries  \n",
       "0                  28118344  [Australia, Denmark, Germany, Netherlands, Nor...  \n",
       "1                  15665310  [Belgium, Canada, Denmark, Germany, Ireland, L...  \n",
       "2                     35994       [Spain, Sweden, Switzerland, PRIVATE SECTOR]  \n",
       "3                  21783839  [Belgium, Ireland, Luxembourg, Netherlands, Sw...  \n",
       "4                  84193027  [Australia, Denmark, Germany, Ireland, Korea, ...  \n",
       "5                  29649774  [Australia, Belgium, Canada, Cyprus, Denmark, ...  \n",
       "6                   1822529  [Belgium, Ireland, Netherlands, Sweden, United...  \n",
       "7                   1675849  [Belgium, Germany, Ireland, Netherlands, Swede...  \n",
       "8                   4065797  [Australia, Denmark, Sweden, Switzerland, Unit...  \n",
       "9                  22822675  [Azerbaijan, Belgium, Canada, Denmark, Germany...  \n",
       "10                  5793640  [Sweden, United Kingdom, PRIVATE SECTOR, Canad...  \n",
       "11                 29632204  [Australia, Denmark, Germany, Ireland, Netherl...  \n",
       "12                 48870515  [Australia, Belgium, Canada, Denmark, Germany,...  \n",
       "13                 74453364  [Denmark, Germany, Ireland, Netherlands, Norwa...  \n",
       "14                 33958998  [Belgium, Denmark, Germany, Iceland, Jersey, K...  \n",
       "15                 55074856  [Belgium, Denmark, France, Germany, Ireland, N...  \n",
       "16                   553018  [Estonia, Germany, Korea,  Republic of, Lithua...  \n",
       "17                   112740  [Canada, Ireland, Korea,  Republic of, Spain, ...  \n",
       "18                 49037954  [Canada, Denmark, Germany, Ireland, Korea,  Re...  \n",
       "19                 30813856  [Belgium, Germany, Ireland, Norway, Spain, Swe...  "
      ]
     },
     "execution_count": 150,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "poor_weight"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.9.13 64-bit",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.13"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "b0fa6594d8f4cbf19f97940f81e996739fb7646882a419484c72d19e05852a7e"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}