3.DataFrame Indexing Filtering.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "79d57604-f357-4e24-8199-47256c6d1fd6",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "32cec588-c7c7-4575-b33b-588f6c66c1ad",
   "metadata": {},
   "outputs": [],
   "source": [
    "csv_data_path = 'https://raw.githubusercontent.com/turingplanet/pandas-intro/main/public-datasets/country.csv'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "885768dc-7bf4-4adf-bb5b-3d2201f324a6",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(csv_data_path)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "0927eb6a-4a72-4612-9834-d6e58b6b5e9d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Country', 'Region', 'Population', 'Area (sq. mi.)',\n",
       "       'Pop. Density (per sq. mi.)', 'Coastline (coast/area ratio)',\n",
       "       'Net migration', 'Infant mortality (per 1000 births)',\n",
       "       'GDP ($ per capita)', 'Literacy (%)', 'Phones (per 1000)', 'Arable (%)',\n",
       "       'Crops (%)', 'Other (%)', 'Climate', 'Birthrate', 'Deathrate',\n",
       "       'Agriculture', 'Industry', 'Service'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns #列出列名"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "e2422877-ccb7-4c15-8387-f7a17f4311da",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RangeIndex(start=0, stop=227, step=1)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "dd7b2fb5-ece5-4635-90b2-d8d51deb931a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(227, 20)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "23d37ceb-cec1-41e5-9a7a-68b59ca705db",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0         Afghanistan\n",
       "1             Albania\n",
       "2             Algeria\n",
       "3      American Samoa\n",
       "4             Andorra\n",
       "            ...      \n",
       "222         West Bank\n",
       "223    Western Sahara\n",
       "224             Yemen\n",
       "225            Zambia\n",
       "226          Zimbabwe\n",
       "Name: Country, Length: 227, dtype: object"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Country'] #获取特定列的数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "f4423a81-00a1-4f03-a898-c051e1c1b631",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Afghanistan'"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Country'].iloc[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "2d8aa509-15cb-4d28-b2aa-5a54444c5147",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Country                                                    American Samoa\n",
       "Region                                OCEANIA                            \n",
       "Population                                                          57794\n",
       "Area (sq. mi.)                                                        199\n",
       "Pop. Density (per sq. mi.)                                          290,4\n",
       "Coastline (coast/area ratio)                                        58,29\n",
       "Net migration                                                      -20,71\n",
       "Infant mortality (per 1000 births)                                   9,27\n",
       "GDP ($ per capita)                                                 8000.0\n",
       "Literacy (%)                                                         97,0\n",
       "Phones (per 1000)                                                   259,5\n",
       "Arable (%)                                                             10\n",
       "Crops (%)                                                              15\n",
       "Other (%)                                                              75\n",
       "Climate                                                                 2\n",
       "Birthrate                                                           22,46\n",
       "Deathrate                                                            3,27\n",
       "Agriculture                                                           NaN\n",
       "Industry                                                              NaN\n",
       "Service                                                               NaN\n",
       "Name: 3, dtype: object"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "707c78d9-f093-48da-a810-3fe8e88e4460",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": 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>Country</th>\n",
       "      <th>Region</th>\n",
       "      <th>Population</th>\n",
       "      <th>Area (sq. mi.)</th>\n",
       "      <th>Pop. Density (per sq. mi.)</th>\n",
       "      <th>Coastline (coast/area ratio)</th>\n",
       "      <th>Net migration</th>\n",
       "      <th>Infant mortality (per 1000 births)</th>\n",
       "      <th>GDP ($ per capita)</th>\n",
       "      <th>Literacy (%)</th>\n",
       "      <th>Phones (per 1000)</th>\n",
       "      <th>Arable (%)</th>\n",
       "      <th>Crops (%)</th>\n",
       "      <th>Other (%)</th>\n",
       "      <th>Climate</th>\n",
       "      <th>Birthrate</th>\n",
       "      <th>Deathrate</th>\n",
       "      <th>Agriculture</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Service</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Australia</td>\n",
       "      <td>OCEANIA</td>\n",
       "      <td>20264082</td>\n",
       "      <td>7686850</td>\n",
       "      <td>2,6</td>\n",
       "      <td>0,34</td>\n",
       "      <td>3,98</td>\n",
       "      <td>4,69</td>\n",
       "      <td>29000.0</td>\n",
       "      <td>100,0</td>\n",
       "      <td>565,5</td>\n",
       "      <td>6,55</td>\n",
       "      <td>0,04</td>\n",
       "      <td>93,41</td>\n",
       "      <td>1</td>\n",
       "      <td>12,14</td>\n",
       "      <td>7,51</td>\n",
       "      <td>0,038</td>\n",
       "      <td>0,262</td>\n",
       "      <td>0,7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Austria</td>\n",
       "      <td>WESTERN EUROPE</td>\n",
       "      <td>8192880</td>\n",
       "      <td>83870</td>\n",
       "      <td>97,7</td>\n",
       "      <td>0,00</td>\n",
       "      <td>2</td>\n",
       "      <td>4,66</td>\n",
       "      <td>30000.0</td>\n",
       "      <td>98,0</td>\n",
       "      <td>452,2</td>\n",
       "      <td>16,91</td>\n",
       "      <td>0,86</td>\n",
       "      <td>82,23</td>\n",
       "      <td>3</td>\n",
       "      <td>8,74</td>\n",
       "      <td>9,76</td>\n",
       "      <td>0,018</td>\n",
       "      <td>0,304</td>\n",
       "      <td>0,678</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Azerbaijan</td>\n",
       "      <td>C.W. OF IND. STATES</td>\n",
       "      <td>7961619</td>\n",
       "      <td>86600</td>\n",
       "      <td>91,9</td>\n",
       "      <td>0,00</td>\n",
       "      <td>-4,9</td>\n",
       "      <td>81,74</td>\n",
       "      <td>3400.0</td>\n",
       "      <td>97,0</td>\n",
       "      <td>137,1</td>\n",
       "      <td>19,63</td>\n",
       "      <td>2,71</td>\n",
       "      <td>77,66</td>\n",
       "      <td>1</td>\n",
       "      <td>20,74</td>\n",
       "      <td>9,75</td>\n",
       "      <td>0,141</td>\n",
       "      <td>0,457</td>\n",
       "      <td>0,402</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Bahamas, The</td>\n",
       "      <td>LATIN AMER. &amp; CARIB</td>\n",
       "      <td>303770</td>\n",
       "      <td>13940</td>\n",
       "      <td>21,8</td>\n",
       "      <td>25,41</td>\n",
       "      <td>-2,2</td>\n",
       "      <td>25,21</td>\n",
       "      <td>16700.0</td>\n",
       "      <td>95,6</td>\n",
       "      <td>460,6</td>\n",
       "      <td>0,8</td>\n",
       "      <td>0,4</td>\n",
       "      <td>98,8</td>\n",
       "      <td>2</td>\n",
       "      <td>17,57</td>\n",
       "      <td>9,05</td>\n",
       "      <td>0,03</td>\n",
       "      <td>0,07</td>\n",
       "      <td>0,9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Bahrain</td>\n",
       "      <td>NEAR EAST</td>\n",
       "      <td>698585</td>\n",
       "      <td>665</td>\n",
       "      <td>1050,5</td>\n",
       "      <td>24,21</td>\n",
       "      <td>1,05</td>\n",
       "      <td>17,27</td>\n",
       "      <td>16900.0</td>\n",
       "      <td>89,1</td>\n",
       "      <td>281,3</td>\n",
       "      <td>2,82</td>\n",
       "      <td>5,63</td>\n",
       "      <td>91,55</td>\n",
       "      <td>1</td>\n",
       "      <td>17,8</td>\n",
       "      <td>4,14</td>\n",
       "      <td>0,005</td>\n",
       "      <td>0,387</td>\n",
       "      <td>0,608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>147365352</td>\n",
       "      <td>144000</td>\n",
       "      <td>1023,4</td>\n",
       "      <td>0,40</td>\n",
       "      <td>-0,71</td>\n",
       "      <td>62,6</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>43,1</td>\n",
       "      <td>7,3</td>\n",
       "      <td>62,11</td>\n",
       "      <td>3,07</td>\n",
       "      <td>34,82</td>\n",
       "      <td>2</td>\n",
       "      <td>29,8</td>\n",
       "      <td>8,27</td>\n",
       "      <td>0,199</td>\n",
       "      <td>0,198</td>\n",
       "      <td>0,603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Barbados</td>\n",
       "      <td>LATIN AMER. &amp; CARIB</td>\n",
       "      <td>279912</td>\n",
       "      <td>431</td>\n",
       "      <td>649,5</td>\n",
       "      <td>22,51</td>\n",
       "      <td>-0,31</td>\n",
       "      <td>12,5</td>\n",
       "      <td>15700.0</td>\n",
       "      <td>97,4</td>\n",
       "      <td>481,9</td>\n",
       "      <td>37,21</td>\n",
       "      <td>2,33</td>\n",
       "      <td>60,46</td>\n",
       "      <td>2</td>\n",
       "      <td>12,71</td>\n",
       "      <td>8,67</td>\n",
       "      <td>0,06</td>\n",
       "      <td>0,16</td>\n",
       "      <td>0,78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Belarus</td>\n",
       "      <td>C.W. OF IND. STATES</td>\n",
       "      <td>10293011</td>\n",
       "      <td>207600</td>\n",
       "      <td>49,6</td>\n",
       "      <td>0,00</td>\n",
       "      <td>2,54</td>\n",
       "      <td>13,37</td>\n",
       "      <td>6100.0</td>\n",
       "      <td>99,6</td>\n",
       "      <td>319,1</td>\n",
       "      <td>29,55</td>\n",
       "      <td>0,6</td>\n",
       "      <td>69,85</td>\n",
       "      <td>4</td>\n",
       "      <td>11,16</td>\n",
       "      <td>14,02</td>\n",
       "      <td>0,093</td>\n",
       "      <td>0,316</td>\n",
       "      <td>0,591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Belgium</td>\n",
       "      <td>WESTERN EUROPE</td>\n",
       "      <td>10379067</td>\n",
       "      <td>30528</td>\n",
       "      <td>340,0</td>\n",
       "      <td>0,22</td>\n",
       "      <td>1,23</td>\n",
       "      <td>4,68</td>\n",
       "      <td>29100.0</td>\n",
       "      <td>98,0</td>\n",
       "      <td>462,6</td>\n",
       "      <td>23,28</td>\n",
       "      <td>0,4</td>\n",
       "      <td>76,32</td>\n",
       "      <td>3</td>\n",
       "      <td>10,38</td>\n",
       "      <td>10,27</td>\n",
       "      <td>0,01</td>\n",
       "      <td>0,24</td>\n",
       "      <td>0,749</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Country                               Region  Population  \\\n",
       "11     Australia  OCEANIA                                20264082   \n",
       "12       Austria  WESTERN EUROPE                          8192880   \n",
       "13    Azerbaijan                 C.W. OF IND. STATES      7961619   \n",
       "14  Bahamas, The              LATIN AMER. & CARIB          303770   \n",
       "15       Bahrain  NEAR EAST                                698585   \n",
       "16    Bangladesh        ASIA (EX. NEAR EAST)            147365352   \n",
       "17      Barbados              LATIN AMER. & CARIB          279912   \n",
       "18       Belarus                 C.W. OF IND. STATES     10293011   \n",
       "19       Belgium  WESTERN EUROPE                         10379067   \n",
       "\n",
       "    Area (sq. mi.) Pop. Density (per sq. mi.) Coastline (coast/area ratio)  \\\n",
       "11         7686850                        2,6                         0,34   \n",
       "12           83870                       97,7                         0,00   \n",
       "13           86600                       91,9                         0,00   \n",
       "14           13940                       21,8                        25,41   \n",
       "15             665                     1050,5                        24,21   \n",
       "16          144000                     1023,4                         0,40   \n",
       "17             431                      649,5                        22,51   \n",
       "18          207600                       49,6                         0,00   \n",
       "19           30528                      340,0                         0,22   \n",
       "\n",
       "   Net migration Infant mortality (per 1000 births)  GDP ($ per capita)  \\\n",
       "11          3,98                               4,69             29000.0   \n",
       "12             2                               4,66             30000.0   \n",
       "13          -4,9                              81,74              3400.0   \n",
       "14          -2,2                              25,21             16700.0   \n",
       "15          1,05                              17,27             16900.0   \n",
       "16         -0,71                               62,6              1900.0   \n",
       "17         -0,31                               12,5             15700.0   \n",
       "18          2,54                              13,37              6100.0   \n",
       "19          1,23                               4,68             29100.0   \n",
       "\n",
       "   Literacy (%) Phones (per 1000) Arable (%) Crops (%) Other (%) Climate  \\\n",
       "11        100,0             565,5       6,55      0,04     93,41       1   \n",
       "12         98,0             452,2      16,91      0,86     82,23       3   \n",
       "13         97,0             137,1      19,63      2,71     77,66       1   \n",
       "14         95,6             460,6        0,8       0,4      98,8       2   \n",
       "15         89,1             281,3       2,82      5,63     91,55       1   \n",
       "16         43,1               7,3      62,11      3,07     34,82       2   \n",
       "17         97,4             481,9      37,21      2,33     60,46       2   \n",
       "18         99,6             319,1      29,55       0,6     69,85       4   \n",
       "19         98,0             462,6      23,28       0,4     76,32       3   \n",
       "\n",
       "   Birthrate Deathrate Agriculture Industry Service  \n",
       "11     12,14      7,51       0,038    0,262     0,7  \n",
       "12      8,74      9,76       0,018    0,304   0,678  \n",
       "13     20,74      9,75       0,141    0,457   0,402  \n",
       "14     17,57      9,05        0,03     0,07     0,9  \n",
       "15      17,8      4,14       0,005    0,387   0,608  \n",
       "16      29,8      8,27       0,199    0,198   0,603  \n",
       "17     12,71      8,67        0,06     0,16    0,78  \n",
       "18     11,16     14,02       0,093    0,316   0,591  \n",
       "19     10,38     10,27        0,01     0,24   0,749  "
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[11:20]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "26ae3393-abbf-49ca-85c0-65c0ab658138",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Country                                                    American Samoa\n",
       "Region                                OCEANIA                            \n",
       "Population                                                          57794\n",
       "Area (sq. mi.)                                                        199\n",
       "Pop. Density (per sq. mi.)                                          290,4\n",
       "Coastline (coast/area ratio)                                        58,29\n",
       "Net migration                                                      -20,71\n",
       "Infant mortality (per 1000 births)                                   9,27\n",
       "GDP ($ per capita)                                                 8000.0\n",
       "Literacy (%)                                                         97,0\n",
       "Phones (per 1000)                                                   259,5\n",
       "Arable (%)                                                             10\n",
       "Crops (%)                                                              15\n",
       "Other (%)                                                              75\n",
       "Climate                                                                 2\n",
       "Birthrate                                                           22,46\n",
       "Deathrate                                                            3,27\n",
       "Agriculture                                                           NaN\n",
       "Industry                                                              NaN\n",
       "Service                                                               NaN\n",
       "Name: 3, dtype: object"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "a7fa15de-2082-48a8-91c8-1597c870c19a",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": 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>Country</th>\n",
       "      <th>Region</th>\n",
       "      <th>Population</th>\n",
       "      <th>Area (sq. mi.)</th>\n",
       "      <th>Pop. Density (per sq. mi.)</th>\n",
       "      <th>Coastline (coast/area ratio)</th>\n",
       "      <th>Net migration</th>\n",
       "      <th>Infant mortality (per 1000 births)</th>\n",
       "      <th>GDP ($ per capita)</th>\n",
       "      <th>Literacy (%)</th>\n",
       "      <th>Phones (per 1000)</th>\n",
       "      <th>Arable (%)</th>\n",
       "      <th>Crops (%)</th>\n",
       "      <th>Other (%)</th>\n",
       "      <th>Climate</th>\n",
       "      <th>Birthrate</th>\n",
       "      <th>Deathrate</th>\n",
       "      <th>Agriculture</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Service</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>31056997</td>\n",
       "      <td>647500</td>\n",
       "      <td>48,0</td>\n",
       "      <td>0,00</td>\n",
       "      <td>23,06</td>\n",
       "      <td>163,07</td>\n",
       "      <td>700.0</td>\n",
       "      <td>36,0</td>\n",
       "      <td>3,2</td>\n",
       "      <td>12,13</td>\n",
       "      <td>0,22</td>\n",
       "      <td>87,65</td>\n",
       "      <td>1</td>\n",
       "      <td>46,6</td>\n",
       "      <td>20,34</td>\n",
       "      <td>0,38</td>\n",
       "      <td>0,24</td>\n",
       "      <td>0,38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Albania</td>\n",
       "      <td>EASTERN EUROPE</td>\n",
       "      <td>3581655</td>\n",
       "      <td>28748</td>\n",
       "      <td>124,6</td>\n",
       "      <td>1,26</td>\n",
       "      <td>-4,93</td>\n",
       "      <td>21,52</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>86,5</td>\n",
       "      <td>71,2</td>\n",
       "      <td>21,09</td>\n",
       "      <td>4,42</td>\n",
       "      <td>74,49</td>\n",
       "      <td>3</td>\n",
       "      <td>15,11</td>\n",
       "      <td>5,22</td>\n",
       "      <td>0,232</td>\n",
       "      <td>0,188</td>\n",
       "      <td>0,579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Algeria</td>\n",
       "      <td>NORTHERN AFRICA</td>\n",
       "      <td>32930091</td>\n",
       "      <td>2381740</td>\n",
       "      <td>13,8</td>\n",
       "      <td>0,04</td>\n",
       "      <td>-0,39</td>\n",
       "      <td>31</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>70,0</td>\n",
       "      <td>78,1</td>\n",
       "      <td>3,22</td>\n",
       "      <td>0,25</td>\n",
       "      <td>96,53</td>\n",
       "      <td>1</td>\n",
       "      <td>17,14</td>\n",
       "      <td>4,61</td>\n",
       "      <td>0,101</td>\n",
       "      <td>0,6</td>\n",
       "      <td>0,298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>American Samoa</td>\n",
       "      <td>OCEANIA</td>\n",
       "      <td>57794</td>\n",
       "      <td>199</td>\n",
       "      <td>290,4</td>\n",
       "      <td>58,29</td>\n",
       "      <td>-20,71</td>\n",
       "      <td>9,27</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>97,0</td>\n",
       "      <td>259,5</td>\n",
       "      <td>10</td>\n",
       "      <td>15</td>\n",
       "      <td>75</td>\n",
       "      <td>2</td>\n",
       "      <td>22,46</td>\n",
       "      <td>3,27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Country                               Region  Population  \\\n",
       "0     Afghanistan        ASIA (EX. NEAR EAST)             31056997   \n",
       "1         Albania  EASTERN EUROPE                          3581655   \n",
       "2         Algeria  NORTHERN AFRICA                        32930091   \n",
       "3  American Samoa  OCEANIA                                   57794   \n",
       "\n",
       "   Area (sq. mi.) Pop. Density (per sq. mi.) Coastline (coast/area ratio)  \\\n",
       "0          647500                       48,0                         0,00   \n",
       "1           28748                      124,6                         1,26   \n",
       "2         2381740                       13,8                         0,04   \n",
       "3             199                      290,4                        58,29   \n",
       "\n",
       "  Net migration Infant mortality (per 1000 births)  GDP ($ per capita)  \\\n",
       "0         23,06                             163,07               700.0   \n",
       "1         -4,93                              21,52              4500.0   \n",
       "2         -0,39                                 31              6000.0   \n",
       "3        -20,71                               9,27              8000.0   \n",
       "\n",
       "  Literacy (%) Phones (per 1000) Arable (%) Crops (%) Other (%) Climate  \\\n",
       "0         36,0               3,2      12,13      0,22     87,65       1   \n",
       "1         86,5              71,2      21,09      4,42     74,49       3   \n",
       "2         70,0              78,1       3,22      0,25     96,53       1   \n",
       "3         97,0             259,5         10        15        75       2   \n",
       "\n",
       "  Birthrate Deathrate Agriculture Industry Service  \n",
       "0      46,6     20,34        0,38     0,24    0,38  \n",
       "1     15,11      5,22       0,232    0,188   0,579  \n",
       "2     17,14      4,61       0,101      0,6   0,298  \n",
       "3     22,46      3,27         NaN      NaN     NaN  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[0:3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "3330e07c-7569-4440-a435-fe4da5661ba3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3581655"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iat[1,2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "ad6844f1-c288-41f6-9e48-55c0ae4d31cb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3581655"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.at[1, 'Population']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "f7ca6954-458f-4d72-858d-046f7b0b589c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3581655"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iat[1, 2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "94e4f57e-2cd6-4a7c-9ff4-75f62c03e43a",
   "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>Region</th>\n",
       "      <th>Population</th>\n",
       "      <th>Area (sq. mi.)</th>\n",
       "      <th>Pop. Density (per sq. mi.)</th>\n",
       "      <th>Coastline (coast/area ratio)</th>\n",
       "      <th>Net migration</th>\n",
       "      <th>Infant mortality (per 1000 births)</th>\n",
       "      <th>GDP ($ per capita)</th>\n",
       "      <th>Literacy (%)</th>\n",
       "      <th>Phones (per 1000)</th>\n",
       "      <th>Arable (%)</th>\n",
       "      <th>Crops (%)</th>\n",
       "      <th>Other (%)</th>\n",
       "      <th>Climate</th>\n",
       "      <th>Birthrate</th>\n",
       "      <th>Deathrate</th>\n",
       "      <th>Agriculture</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Service</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>31056997</td>\n",
       "      <td>647500</td>\n",
       "      <td>48,0</td>\n",
       "      <td>0,00</td>\n",
       "      <td>23,06</td>\n",
       "      <td>163,07</td>\n",
       "      <td>700.0</td>\n",
       "      <td>36,0</td>\n",
       "      <td>3,2</td>\n",
       "      <td>12,13</td>\n",
       "      <td>0,22</td>\n",
       "      <td>87,65</td>\n",
       "      <td>1</td>\n",
       "      <td>46,6</td>\n",
       "      <td>20,34</td>\n",
       "      <td>0,38</td>\n",
       "      <td>0,24</td>\n",
       "      <td>0,38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Albania</th>\n",
       "      <td>EASTERN EUROPE</td>\n",
       "      <td>3581655</td>\n",
       "      <td>28748</td>\n",
       "      <td>124,6</td>\n",
       "      <td>1,26</td>\n",
       "      <td>-4,93</td>\n",
       "      <td>21,52</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>86,5</td>\n",
       "      <td>71,2</td>\n",
       "      <td>21,09</td>\n",
       "      <td>4,42</td>\n",
       "      <td>74,49</td>\n",
       "      <td>3</td>\n",
       "      <td>15,11</td>\n",
       "      <td>5,22</td>\n",
       "      <td>0,232</td>\n",
       "      <td>0,188</td>\n",
       "      <td>0,579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>NORTHERN AFRICA</td>\n",
       "      <td>32930091</td>\n",
       "      <td>2381740</td>\n",
       "      <td>13,8</td>\n",
       "      <td>0,04</td>\n",
       "      <td>-0,39</td>\n",
       "      <td>31</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>70,0</td>\n",
       "      <td>78,1</td>\n",
       "      <td>3,22</td>\n",
       "      <td>0,25</td>\n",
       "      <td>96,53</td>\n",
       "      <td>1</td>\n",
       "      <td>17,14</td>\n",
       "      <td>4,61</td>\n",
       "      <td>0,101</td>\n",
       "      <td>0,6</td>\n",
       "      <td>0,298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>American Samoa</th>\n",
       "      <td>OCEANIA</td>\n",
       "      <td>57794</td>\n",
       "      <td>199</td>\n",
       "      <td>290,4</td>\n",
       "      <td>58,29</td>\n",
       "      <td>-20,71</td>\n",
       "      <td>9,27</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>97,0</td>\n",
       "      <td>259,5</td>\n",
       "      <td>10</td>\n",
       "      <td>15</td>\n",
       "      <td>75</td>\n",
       "      <td>2</td>\n",
       "      <td>22,46</td>\n",
       "      <td>3,27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Andorra</th>\n",
       "      <td>WESTERN EUROPE</td>\n",
       "      <td>71201</td>\n",
       "      <td>468</td>\n",
       "      <td>152,1</td>\n",
       "      <td>0,00</td>\n",
       "      <td>6,6</td>\n",
       "      <td>4,05</td>\n",
       "      <td>19000.0</td>\n",
       "      <td>100,0</td>\n",
       "      <td>497,2</td>\n",
       "      <td>2,22</td>\n",
       "      <td>0</td>\n",
       "      <td>97,78</td>\n",
       "      <td>3</td>\n",
       "      <td>8,71</td>\n",
       "      <td>6,25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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>West Bank</th>\n",
       "      <td>NEAR EAST</td>\n",
       "      <td>2460492</td>\n",
       "      <td>5860</td>\n",
       "      <td>419,9</td>\n",
       "      <td>0,00</td>\n",
       "      <td>2,98</td>\n",
       "      <td>19,62</td>\n",
       "      <td>800.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>145,2</td>\n",
       "      <td>16,9</td>\n",
       "      <td>18,97</td>\n",
       "      <td>64,13</td>\n",
       "      <td>3</td>\n",
       "      <td>31,67</td>\n",
       "      <td>3,92</td>\n",
       "      <td>0,09</td>\n",
       "      <td>0,28</td>\n",
       "      <td>0,63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Western Sahara</th>\n",
       "      <td>NORTHERN AFRICA</td>\n",
       "      <td>273008</td>\n",
       "      <td>266000</td>\n",
       "      <td>1,0</td>\n",
       "      <td>0,42</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0,02</td>\n",
       "      <td>0</td>\n",
       "      <td>99,98</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0,4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yemen</th>\n",
       "      <td>NEAR EAST</td>\n",
       "      <td>21456188</td>\n",
       "      <td>527970</td>\n",
       "      <td>40,6</td>\n",
       "      <td>0,36</td>\n",
       "      <td>0</td>\n",
       "      <td>61,5</td>\n",
       "      <td>800.0</td>\n",
       "      <td>50,2</td>\n",
       "      <td>37,2</td>\n",
       "      <td>2,78</td>\n",
       "      <td>0,24</td>\n",
       "      <td>96,98</td>\n",
       "      <td>1</td>\n",
       "      <td>42,89</td>\n",
       "      <td>8,3</td>\n",
       "      <td>0,135</td>\n",
       "      <td>0,472</td>\n",
       "      <td>0,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zambia</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>11502010</td>\n",
       "      <td>752614</td>\n",
       "      <td>15,3</td>\n",
       "      <td>0,00</td>\n",
       "      <td>0</td>\n",
       "      <td>88,29</td>\n",
       "      <td>800.0</td>\n",
       "      <td>80,6</td>\n",
       "      <td>8,2</td>\n",
       "      <td>7,08</td>\n",
       "      <td>0,03</td>\n",
       "      <td>92,9</td>\n",
       "      <td>2</td>\n",
       "      <td>41</td>\n",
       "      <td>19,93</td>\n",
       "      <td>0,22</td>\n",
       "      <td>0,29</td>\n",
       "      <td>0,489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zimbabwe</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>12236805</td>\n",
       "      <td>390580</td>\n",
       "      <td>31,3</td>\n",
       "      <td>0,00</td>\n",
       "      <td>0</td>\n",
       "      <td>67,69</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>90,7</td>\n",
       "      <td>26,8</td>\n",
       "      <td>8,32</td>\n",
       "      <td>0,34</td>\n",
       "      <td>91,34</td>\n",
       "      <td>2</td>\n",
       "      <td>28,01</td>\n",
       "      <td>21,84</td>\n",
       "      <td>0,179</td>\n",
       "      <td>0,243</td>\n",
       "      <td>0,579</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>227 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Region  Population  \\\n",
       "Country                                                           \n",
       "Afghanistan           ASIA (EX. NEAR EAST)             31056997   \n",
       "Albania         EASTERN EUROPE                          3581655   \n",
       "Algeria         NORTHERN AFRICA                        32930091   \n",
       "American Samoa  OCEANIA                                   57794   \n",
       "Andorra         WESTERN EUROPE                            71201   \n",
       "...                                             ...         ...   \n",
       "West Bank       NEAR EAST                               2460492   \n",
       "Western Sahara  NORTHERN AFRICA                          273008   \n",
       "Yemen           NEAR EAST                              21456188   \n",
       "Zambia          SUB-SAHARAN AFRICA                     11502010   \n",
       "Zimbabwe        SUB-SAHARAN AFRICA                     12236805   \n",
       "\n",
       "                Area (sq. mi.) Pop. Density (per sq. mi.)  \\\n",
       "Country                                                     \n",
       "Afghanistan             647500                       48,0   \n",
       "Albania                  28748                      124,6   \n",
       "Algeria                2381740                       13,8   \n",
       "American Samoa             199                      290,4   \n",
       "Andorra                    468                      152,1   \n",
       "...                        ...                        ...   \n",
       "West Bank                 5860                      419,9   \n",
       "Western Sahara          266000                        1,0   \n",
       "Yemen                   527970                       40,6   \n",
       "Zambia                  752614                       15,3   \n",
       "Zimbabwe                390580                       31,3   \n",
       "\n",
       "               Coastline (coast/area ratio) Net migration  \\\n",
       "Country                                                     \n",
       "Afghanistan                            0,00         23,06   \n",
       "Albania                                1,26         -4,93   \n",
       "Algeria                                0,04         -0,39   \n",
       "American Samoa                        58,29        -20,71   \n",
       "Andorra                                0,00           6,6   \n",
       "...                                     ...           ...   \n",
       "West Bank                              0,00          2,98   \n",
       "Western Sahara                         0,42           NaN   \n",
       "Yemen                                  0,36             0   \n",
       "Zambia                                 0,00             0   \n",
       "Zimbabwe                               0,00             0   \n",
       "\n",
       "               Infant mortality (per 1000 births)  GDP ($ per capita)  \\\n",
       "Country                                                                 \n",
       "Afghanistan                                163,07               700.0   \n",
       "Albania                                     21,52              4500.0   \n",
       "Algeria                                        31              6000.0   \n",
       "American Samoa                               9,27              8000.0   \n",
       "Andorra                                      4,05             19000.0   \n",
       "...                                           ...                 ...   \n",
       "West Bank                                   19,62               800.0   \n",
       "Western Sahara                                NaN                 NaN   \n",
       "Yemen                                        61,5               800.0   \n",
       "Zambia                                      88,29               800.0   \n",
       "Zimbabwe                                    67,69              1900.0   \n",
       "\n",
       "               Literacy (%) Phones (per 1000) Arable (%) Crops (%) Other (%)  \\\n",
       "Country                                                                        \n",
       "Afghanistan            36,0               3,2      12,13      0,22     87,65   \n",
       "Albania                86,5              71,2      21,09      4,42     74,49   \n",
       "Algeria                70,0              78,1       3,22      0,25     96,53   \n",
       "American Samoa         97,0             259,5         10        15        75   \n",
       "Andorra               100,0             497,2       2,22         0     97,78   \n",
       "...                     ...               ...        ...       ...       ...   \n",
       "West Bank               NaN             145,2       16,9     18,97     64,13   \n",
       "Western Sahara          NaN               NaN       0,02         0     99,98   \n",
       "Yemen                  50,2              37,2       2,78      0,24     96,98   \n",
       "Zambia                 80,6               8,2       7,08      0,03      92,9   \n",
       "Zimbabwe               90,7              26,8       8,32      0,34     91,34   \n",
       "\n",
       "               Climate Birthrate Deathrate Agriculture Industry Service  \n",
       "Country                                                                  \n",
       "Afghanistan          1      46,6     20,34        0,38     0,24    0,38  \n",
       "Albania              3     15,11      5,22       0,232    0,188   0,579  \n",
       "Algeria              1     17,14      4,61       0,101      0,6   0,298  \n",
       "American Samoa       2     22,46      3,27         NaN      NaN     NaN  \n",
       "Andorra              3      8,71      6,25         NaN      NaN     NaN  \n",
       "...                ...       ...       ...         ...      ...     ...  \n",
       "West Bank            3     31,67      3,92        0,09     0,28    0,63  \n",
       "Western Sahara       1       NaN       NaN         NaN      NaN     0,4  \n",
       "Yemen                1     42,89       8,3       0,135    0,472   0,393  \n",
       "Zambia               2        41     19,93        0,22     0,29   0,489  \n",
       "Zimbabwe             2     28,01     21,84       0,179    0,243   0,579  \n",
       "\n",
       "[227 rows x 19 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.set_index('Country') #将Country列为index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "159c95f3-abd3-4814-be40-1b80a1f2256f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RangeIndex(start=0, stop=227, step=1)"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "ad5665ec-f447-456e-8ed3-c8b25666a645",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.set_index('Country', inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "82aea197-c7e1-4940-b875-921a05ad5aab",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Afghanistan', 'Albania', 'Algeria', 'American Samoa', 'Andorra',\n",
       "       'Angola', 'Anguilla', 'Antigua & Barbuda', 'Argentina', 'Armenia',\n",
       "       ...\n",
       "       'Vanuatu', 'Venezuela', 'Vietnam', 'Virgin Islands',\n",
       "       'Wallis and Futuna', 'West Bank', 'Western Sahara', 'Yemen', 'Zambia',\n",
       "       'Zimbabwe'],\n",
       "      dtype='object', name='Country', length=227)"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "c065db71-c14f-4908-beb7-2e5996a12733",
   "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>Region</th>\n",
       "      <th>Population</th>\n",
       "      <th>Area (sq. mi.)</th>\n",
       "      <th>Pop. Density (per sq. mi.)</th>\n",
       "      <th>Coastline (coast/area ratio)</th>\n",
       "      <th>Net migration</th>\n",
       "      <th>Infant mortality (per 1000 births)</th>\n",
       "      <th>GDP ($ per capita)</th>\n",
       "      <th>Literacy (%)</th>\n",
       "      <th>Phones (per 1000)</th>\n",
       "      <th>Arable (%)</th>\n",
       "      <th>Crops (%)</th>\n",
       "      <th>Other (%)</th>\n",
       "      <th>Climate</th>\n",
       "      <th>Birthrate</th>\n",
       "      <th>Deathrate</th>\n",
       "      <th>Agriculture</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Service</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>China</th>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>1313973713</td>\n",
       "      <td>9596960</td>\n",
       "      <td>136,9</td>\n",
       "      <td>0,15</td>\n",
       "      <td>-0,4</td>\n",
       "      <td>24,18</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>90,9</td>\n",
       "      <td>266,7</td>\n",
       "      <td>15,4</td>\n",
       "      <td>1,25</td>\n",
       "      <td>83,35</td>\n",
       "      <td>1,5</td>\n",
       "      <td>13,25</td>\n",
       "      <td>6,97</td>\n",
       "      <td>0,125</td>\n",
       "      <td>0,473</td>\n",
       "      <td>0,403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vietnam</th>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>84402966</td>\n",
       "      <td>329560</td>\n",
       "      <td>256,1</td>\n",
       "      <td>1,05</td>\n",
       "      <td>-0,45</td>\n",
       "      <td>25,95</td>\n",
       "      <td>2500.0</td>\n",
       "      <td>90,3</td>\n",
       "      <td>187,7</td>\n",
       "      <td>19,97</td>\n",
       "      <td>5,95</td>\n",
       "      <td>74,08</td>\n",
       "      <td>2</td>\n",
       "      <td>16,86</td>\n",
       "      <td>6,22</td>\n",
       "      <td>0,209</td>\n",
       "      <td>0,41</td>\n",
       "      <td>0,381</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                Region  Population  Area (sq. mi.)  \\\n",
       "Country                                                              \n",
       "China    ASIA (EX. NEAR EAST)           1313973713         9596960   \n",
       "Vietnam  ASIA (EX. NEAR EAST)             84402966          329560   \n",
       "\n",
       "        Pop. Density (per sq. mi.) Coastline (coast/area ratio) Net migration  \\\n",
       "Country                                                                         \n",
       "China                        136,9                         0,15          -0,4   \n",
       "Vietnam                      256,1                         1,05         -0,45   \n",
       "\n",
       "        Infant mortality (per 1000 births)  GDP ($ per capita) Literacy (%)  \\\n",
       "Country                                                                       \n",
       "China                                24,18              5000.0         90,9   \n",
       "Vietnam                              25,95              2500.0         90,3   \n",
       "\n",
       "        Phones (per 1000) Arable (%) Crops (%) Other (%) Climate Birthrate  \\\n",
       "Country                                                                      \n",
       "China               266,7       15,4      1,25     83,35     1,5     13,25   \n",
       "Vietnam             187,7      19,97      5,95     74,08       2     16,86   \n",
       "\n",
       "        Deathrate Agriculture Industry Service  \n",
       "Country                                         \n",
       "China        6,97       0,125    0,473   0,403  \n",
       "Vietnam      6,22       0,209     0,41   0,381  "
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[['China','Vietnam']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "455daefe-e01e-4900-8002-58f7f414be97",
   "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>Region</th>\n",
       "      <th>Net migration</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>China</th>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>-0,4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vietnam</th>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>-0,45</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                Region Net migration\n",
       "Country                                             \n",
       "China    ASIA (EX. NEAR EAST)                   -0,4\n",
       "Vietnam  ASIA (EX. NEAR EAST)                  -0,45"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[['China', 'Vietnam'], ['Region', 'Net migration']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "1dabc644-76e4-48c4-8493-f40a65f5bd35",
   "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>Region</th>\n",
       "      <th>Population</th>\n",
       "      <th>Area (sq. mi.)</th>\n",
       "      <th>Pop. Density (per sq. mi.)</th>\n",
       "      <th>Coastline (coast/area ratio)</th>\n",
       "      <th>Net migration</th>\n",
       "      <th>Infant mortality (per 1000 births)</th>\n",
       "      <th>GDP ($ per capita)</th>\n",
       "      <th>Literacy (%)</th>\n",
       "      <th>Phones (per 1000)</th>\n",
       "      <th>Arable (%)</th>\n",
       "      <th>Crops (%)</th>\n",
       "      <th>Other (%)</th>\n",
       "      <th>Climate</th>\n",
       "      <th>Birthrate</th>\n",
       "      <th>Deathrate</th>\n",
       "      <th>Agriculture</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Service</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>31056997</td>\n",
       "      <td>647500</td>\n",
       "      <td>48,0</td>\n",
       "      <td>0,00</td>\n",
       "      <td>23,06</td>\n",
       "      <td>163,07</td>\n",
       "      <td>700.0</td>\n",
       "      <td>36,0</td>\n",
       "      <td>3,2</td>\n",
       "      <td>12,13</td>\n",
       "      <td>0,22</td>\n",
       "      <td>87,65</td>\n",
       "      <td>1</td>\n",
       "      <td>46,6</td>\n",
       "      <td>20,34</td>\n",
       "      <td>0,38</td>\n",
       "      <td>0,24</td>\n",
       "      <td>0,38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Albania</th>\n",
       "      <td>EASTERN EUROPE</td>\n",
       "      <td>3581655</td>\n",
       "      <td>28748</td>\n",
       "      <td>124,6</td>\n",
       "      <td>1,26</td>\n",
       "      <td>-4,93</td>\n",
       "      <td>21,52</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>86,5</td>\n",
       "      <td>71,2</td>\n",
       "      <td>21,09</td>\n",
       "      <td>4,42</td>\n",
       "      <td>74,49</td>\n",
       "      <td>3</td>\n",
       "      <td>15,11</td>\n",
       "      <td>5,22</td>\n",
       "      <td>0,232</td>\n",
       "      <td>0,188</td>\n",
       "      <td>0,579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>NORTHERN AFRICA</td>\n",
       "      <td>32930091</td>\n",
       "      <td>2381740</td>\n",
       "      <td>13,8</td>\n",
       "      <td>0,04</td>\n",
       "      <td>-0,39</td>\n",
       "      <td>31</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>70,0</td>\n",
       "      <td>78,1</td>\n",
       "      <td>3,22</td>\n",
       "      <td>0,25</td>\n",
       "      <td>96,53</td>\n",
       "      <td>1</td>\n",
       "      <td>17,14</td>\n",
       "      <td>4,61</td>\n",
       "      <td>0,101</td>\n",
       "      <td>0,6</td>\n",
       "      <td>0,298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>American Samoa</th>\n",
       "      <td>OCEANIA</td>\n",
       "      <td>57794</td>\n",
       "      <td>199</td>\n",
       "      <td>290,4</td>\n",
       "      <td>58,29</td>\n",
       "      <td>-20,71</td>\n",
       "      <td>9,27</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>97,0</td>\n",
       "      <td>259,5</td>\n",
       "      <td>10</td>\n",
       "      <td>15</td>\n",
       "      <td>75</td>\n",
       "      <td>2</td>\n",
       "      <td>22,46</td>\n",
       "      <td>3,27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Andorra</th>\n",
       "      <td>WESTERN EUROPE</td>\n",
       "      <td>71201</td>\n",
       "      <td>468</td>\n",
       "      <td>152,1</td>\n",
       "      <td>0,00</td>\n",
       "      <td>6,6</td>\n",
       "      <td>4,05</td>\n",
       "      <td>19000.0</td>\n",
       "      <td>100,0</td>\n",
       "      <td>497,2</td>\n",
       "      <td>2,22</td>\n",
       "      <td>0</td>\n",
       "      <td>97,78</td>\n",
       "      <td>3</td>\n",
       "      <td>8,71</td>\n",
       "      <td>6,25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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>West Bank</th>\n",
       "      <td>NEAR EAST</td>\n",
       "      <td>2460492</td>\n",
       "      <td>5860</td>\n",
       "      <td>419,9</td>\n",
       "      <td>0,00</td>\n",
       "      <td>2,98</td>\n",
       "      <td>19,62</td>\n",
       "      <td>800.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>145,2</td>\n",
       "      <td>16,9</td>\n",
       "      <td>18,97</td>\n",
       "      <td>64,13</td>\n",
       "      <td>3</td>\n",
       "      <td>31,67</td>\n",
       "      <td>3,92</td>\n",
       "      <td>0,09</td>\n",
       "      <td>0,28</td>\n",
       "      <td>0,63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Western Sahara</th>\n",
       "      <td>NORTHERN AFRICA</td>\n",
       "      <td>273008</td>\n",
       "      <td>266000</td>\n",
       "      <td>1,0</td>\n",
       "      <td>0,42</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0,02</td>\n",
       "      <td>0</td>\n",
       "      <td>99,98</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0,4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yemen</th>\n",
       "      <td>NEAR EAST</td>\n",
       "      <td>21456188</td>\n",
       "      <td>527970</td>\n",
       "      <td>40,6</td>\n",
       "      <td>0,36</td>\n",
       "      <td>0</td>\n",
       "      <td>61,5</td>\n",
       "      <td>800.0</td>\n",
       "      <td>50,2</td>\n",
       "      <td>37,2</td>\n",
       "      <td>2,78</td>\n",
       "      <td>0,24</td>\n",
       "      <td>96,98</td>\n",
       "      <td>1</td>\n",
       "      <td>42,89</td>\n",
       "      <td>8,3</td>\n",
       "      <td>0,135</td>\n",
       "      <td>0,472</td>\n",
       "      <td>0,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zambia</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>11502010</td>\n",
       "      <td>752614</td>\n",
       "      <td>15,3</td>\n",
       "      <td>0,00</td>\n",
       "      <td>0</td>\n",
       "      <td>88,29</td>\n",
       "      <td>800.0</td>\n",
       "      <td>80,6</td>\n",
       "      <td>8,2</td>\n",
       "      <td>7,08</td>\n",
       "      <td>0,03</td>\n",
       "      <td>92,9</td>\n",
       "      <td>2</td>\n",
       "      <td>41</td>\n",
       "      <td>19,93</td>\n",
       "      <td>0,22</td>\n",
       "      <td>0,29</td>\n",
       "      <td>0,489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zimbabwe</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>12236805</td>\n",
       "      <td>390580</td>\n",
       "      <td>31,3</td>\n",
       "      <td>0,00</td>\n",
       "      <td>0</td>\n",
       "      <td>67,69</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>90,7</td>\n",
       "      <td>26,8</td>\n",
       "      <td>8,32</td>\n",
       "      <td>0,34</td>\n",
       "      <td>91,34</td>\n",
       "      <td>2</td>\n",
       "      <td>28,01</td>\n",
       "      <td>21,84</td>\n",
       "      <td>0,179</td>\n",
       "      <td>0,243</td>\n",
       "      <td>0,579</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>227 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Region  Population  \\\n",
       "Country                                                           \n",
       "Afghanistan           ASIA (EX. NEAR EAST)             31056997   \n",
       "Albania         EASTERN EUROPE                          3581655   \n",
       "Algeria         NORTHERN AFRICA                        32930091   \n",
       "American Samoa  OCEANIA                                   57794   \n",
       "Andorra         WESTERN EUROPE                            71201   \n",
       "...                                             ...         ...   \n",
       "West Bank       NEAR EAST                               2460492   \n",
       "Western Sahara  NORTHERN AFRICA                          273008   \n",
       "Yemen           NEAR EAST                              21456188   \n",
       "Zambia          SUB-SAHARAN AFRICA                     11502010   \n",
       "Zimbabwe        SUB-SAHARAN AFRICA                     12236805   \n",
       "\n",
       "                Area (sq. mi.) Pop. Density (per sq. mi.)  \\\n",
       "Country                                                     \n",
       "Afghanistan             647500                       48,0   \n",
       "Albania                  28748                      124,6   \n",
       "Algeria                2381740                       13,8   \n",
       "American Samoa             199                      290,4   \n",
       "Andorra                    468                      152,1   \n",
       "...                        ...                        ...   \n",
       "West Bank                 5860                      419,9   \n",
       "Western Sahara          266000                        1,0   \n",
       "Yemen                   527970                       40,6   \n",
       "Zambia                  752614                       15,3   \n",
       "Zimbabwe                390580                       31,3   \n",
       "\n",
       "               Coastline (coast/area ratio) Net migration  \\\n",
       "Country                                                     \n",
       "Afghanistan                            0,00         23,06   \n",
       "Albania                                1,26         -4,93   \n",
       "Algeria                                0,04         -0,39   \n",
       "American Samoa                        58,29        -20,71   \n",
       "Andorra                                0,00           6,6   \n",
       "...                                     ...           ...   \n",
       "West Bank                              0,00          2,98   \n",
       "Western Sahara                         0,42           NaN   \n",
       "Yemen                                  0,36             0   \n",
       "Zambia                                 0,00             0   \n",
       "Zimbabwe                               0,00             0   \n",
       "\n",
       "               Infant mortality (per 1000 births)  GDP ($ per capita)  \\\n",
       "Country                                                                 \n",
       "Afghanistan                                163,07               700.0   \n",
       "Albania                                     21,52              4500.0   \n",
       "Algeria                                        31              6000.0   \n",
       "American Samoa                               9,27              8000.0   \n",
       "Andorra                                      4,05             19000.0   \n",
       "...                                           ...                 ...   \n",
       "West Bank                                   19,62               800.0   \n",
       "Western Sahara                                NaN                 NaN   \n",
       "Yemen                                        61,5               800.0   \n",
       "Zambia                                      88,29               800.0   \n",
       "Zimbabwe                                    67,69              1900.0   \n",
       "\n",
       "               Literacy (%) Phones (per 1000) Arable (%) Crops (%) Other (%)  \\\n",
       "Country                                                                        \n",
       "Afghanistan            36,0               3,2      12,13      0,22     87,65   \n",
       "Albania                86,5              71,2      21,09      4,42     74,49   \n",
       "Algeria                70,0              78,1       3,22      0,25     96,53   \n",
       "American Samoa         97,0             259,5         10        15        75   \n",
       "Andorra               100,0             497,2       2,22         0     97,78   \n",
       "...                     ...               ...        ...       ...       ...   \n",
       "West Bank               NaN             145,2       16,9     18,97     64,13   \n",
       "Western Sahara          NaN               NaN       0,02         0     99,98   \n",
       "Yemen                  50,2              37,2       2,78      0,24     96,98   \n",
       "Zambia                 80,6               8,2       7,08      0,03      92,9   \n",
       "Zimbabwe               90,7              26,8       8,32      0,34     91,34   \n",
       "\n",
       "               Climate Birthrate Deathrate Agriculture Industry Service  \n",
       "Country                                                                  \n",
       "Afghanistan          1      46,6     20,34        0,38     0,24    0,38  \n",
       "Albania              3     15,11      5,22       0,232    0,188   0,579  \n",
       "Algeria              1     17,14      4,61       0,101      0,6   0,298  \n",
       "American Samoa       2     22,46      3,27         NaN      NaN     NaN  \n",
       "Andorra              3      8,71      6,25         NaN      NaN     NaN  \n",
       "...                ...       ...       ...         ...      ...     ...  \n",
       "West Bank            3     31,67      3,92        0,09     0,28    0,63  \n",
       "Western Sahara       1       NaN       NaN         NaN      NaN     0,4  \n",
       "Yemen                1     42,89       8,3       0,135    0,472   0,393  \n",
       "Zambia               2        41     19,93        0,22     0,29   0,489  \n",
       "Zimbabwe             2     28,01     21,84       0,179    0,243   0,579  \n",
       "\n",
       "[227 rows x 19 columns]"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "dcabec2f-e199-4b3e-ac38-52d62089e031",
   "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>Region</th>\n",
       "      <th>Population</th>\n",
       "      <th>Area (sq. mi.)</th>\n",
       "      <th>Pop. Density (per sq. mi.)</th>\n",
       "      <th>Coastline (coast/area ratio)</th>\n",
       "      <th>Net migration</th>\n",
       "      <th>Infant mortality (per 1000 births)</th>\n",
       "      <th>GDP ($ per capita)</th>\n",
       "      <th>Literacy (%)</th>\n",
       "      <th>Phones (per 1000)</th>\n",
       "      <th>Arable (%)</th>\n",
       "      <th>Crops (%)</th>\n",
       "      <th>Other (%)</th>\n",
       "      <th>Climate</th>\n",
       "      <th>Birthrate</th>\n",
       "      <th>Deathrate</th>\n",
       "      <th>Agriculture</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Service</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Zimbabwe</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>12236805</td>\n",
       "      <td>390580</td>\n",
       "      <td>31,3</td>\n",
       "      <td>0,00</td>\n",
       "      <td>0</td>\n",
       "      <td>67,69</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>90,7</td>\n",
       "      <td>26,8</td>\n",
       "      <td>8,32</td>\n",
       "      <td>0,34</td>\n",
       "      <td>91,34</td>\n",
       "      <td>2</td>\n",
       "      <td>28,01</td>\n",
       "      <td>21,84</td>\n",
       "      <td>0,179</td>\n",
       "      <td>0,243</td>\n",
       "      <td>0,579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zambia</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>11502010</td>\n",
       "      <td>752614</td>\n",
       "      <td>15,3</td>\n",
       "      <td>0,00</td>\n",
       "      <td>0</td>\n",
       "      <td>88,29</td>\n",
       "      <td>800.0</td>\n",
       "      <td>80,6</td>\n",
       "      <td>8,2</td>\n",
       "      <td>7,08</td>\n",
       "      <td>0,03</td>\n",
       "      <td>92,9</td>\n",
       "      <td>2</td>\n",
       "      <td>41</td>\n",
       "      <td>19,93</td>\n",
       "      <td>0,22</td>\n",
       "      <td>0,29</td>\n",
       "      <td>0,489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yemen</th>\n",
       "      <td>NEAR EAST</td>\n",
       "      <td>21456188</td>\n",
       "      <td>527970</td>\n",
       "      <td>40,6</td>\n",
       "      <td>0,36</td>\n",
       "      <td>0</td>\n",
       "      <td>61,5</td>\n",
       "      <td>800.0</td>\n",
       "      <td>50,2</td>\n",
       "      <td>37,2</td>\n",
       "      <td>2,78</td>\n",
       "      <td>0,24</td>\n",
       "      <td>96,98</td>\n",
       "      <td>1</td>\n",
       "      <td>42,89</td>\n",
       "      <td>8,3</td>\n",
       "      <td>0,135</td>\n",
       "      <td>0,472</td>\n",
       "      <td>0,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Western Sahara</th>\n",
       "      <td>NORTHERN AFRICA</td>\n",
       "      <td>273008</td>\n",
       "      <td>266000</td>\n",
       "      <td>1,0</td>\n",
       "      <td>0,42</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0,02</td>\n",
       "      <td>0</td>\n",
       "      <td>99,98</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0,4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>West Bank</th>\n",
       "      <td>NEAR EAST</td>\n",
       "      <td>2460492</td>\n",
       "      <td>5860</td>\n",
       "      <td>419,9</td>\n",
       "      <td>0,00</td>\n",
       "      <td>2,98</td>\n",
       "      <td>19,62</td>\n",
       "      <td>800.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>145,2</td>\n",
       "      <td>16,9</td>\n",
       "      <td>18,97</td>\n",
       "      <td>64,13</td>\n",
       "      <td>3</td>\n",
       "      <td>31,67</td>\n",
       "      <td>3,92</td>\n",
       "      <td>0,09</td>\n",
       "      <td>0,28</td>\n",
       "      <td>0,63</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Andorra</th>\n",
       "      <td>WESTERN EUROPE</td>\n",
       "      <td>71201</td>\n",
       "      <td>468</td>\n",
       "      <td>152,1</td>\n",
       "      <td>0,00</td>\n",
       "      <td>6,6</td>\n",
       "      <td>4,05</td>\n",
       "      <td>19000.0</td>\n",
       "      <td>100,0</td>\n",
       "      <td>497,2</td>\n",
       "      <td>2,22</td>\n",
       "      <td>0</td>\n",
       "      <td>97,78</td>\n",
       "      <td>3</td>\n",
       "      <td>8,71</td>\n",
       "      <td>6,25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>American Samoa</th>\n",
       "      <td>OCEANIA</td>\n",
       "      <td>57794</td>\n",
       "      <td>199</td>\n",
       "      <td>290,4</td>\n",
       "      <td>58,29</td>\n",
       "      <td>-20,71</td>\n",
       "      <td>9,27</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>97,0</td>\n",
       "      <td>259,5</td>\n",
       "      <td>10</td>\n",
       "      <td>15</td>\n",
       "      <td>75</td>\n",
       "      <td>2</td>\n",
       "      <td>22,46</td>\n",
       "      <td>3,27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>NORTHERN AFRICA</td>\n",
       "      <td>32930091</td>\n",
       "      <td>2381740</td>\n",
       "      <td>13,8</td>\n",
       "      <td>0,04</td>\n",
       "      <td>-0,39</td>\n",
       "      <td>31</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>70,0</td>\n",
       "      <td>78,1</td>\n",
       "      <td>3,22</td>\n",
       "      <td>0,25</td>\n",
       "      <td>96,53</td>\n",
       "      <td>1</td>\n",
       "      <td>17,14</td>\n",
       "      <td>4,61</td>\n",
       "      <td>0,101</td>\n",
       "      <td>0,6</td>\n",
       "      <td>0,298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Albania</th>\n",
       "      <td>EASTERN EUROPE</td>\n",
       "      <td>3581655</td>\n",
       "      <td>28748</td>\n",
       "      <td>124,6</td>\n",
       "      <td>1,26</td>\n",
       "      <td>-4,93</td>\n",
       "      <td>21,52</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>86,5</td>\n",
       "      <td>71,2</td>\n",
       "      <td>21,09</td>\n",
       "      <td>4,42</td>\n",
       "      <td>74,49</td>\n",
       "      <td>3</td>\n",
       "      <td>15,11</td>\n",
       "      <td>5,22</td>\n",
       "      <td>0,232</td>\n",
       "      <td>0,188</td>\n",
       "      <td>0,579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>31056997</td>\n",
       "      <td>647500</td>\n",
       "      <td>48,0</td>\n",
       "      <td>0,00</td>\n",
       "      <td>23,06</td>\n",
       "      <td>163,07</td>\n",
       "      <td>700.0</td>\n",
       "      <td>36,0</td>\n",
       "      <td>3,2</td>\n",
       "      <td>12,13</td>\n",
       "      <td>0,22</td>\n",
       "      <td>87,65</td>\n",
       "      <td>1</td>\n",
       "      <td>46,6</td>\n",
       "      <td>20,34</td>\n",
       "      <td>0,38</td>\n",
       "      <td>0,24</td>\n",
       "      <td>0,38</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>227 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Region  Population  \\\n",
       "Country                                                           \n",
       "Zimbabwe        SUB-SAHARAN AFRICA                     12236805   \n",
       "Zambia          SUB-SAHARAN AFRICA                     11502010   \n",
       "Yemen           NEAR EAST                              21456188   \n",
       "Western Sahara  NORTHERN AFRICA                          273008   \n",
       "West Bank       NEAR EAST                               2460492   \n",
       "...                                             ...         ...   \n",
       "Andorra         WESTERN EUROPE                            71201   \n",
       "American Samoa  OCEANIA                                   57794   \n",
       "Algeria         NORTHERN AFRICA                        32930091   \n",
       "Albania         EASTERN EUROPE                          3581655   \n",
       "Afghanistan           ASIA (EX. NEAR EAST)             31056997   \n",
       "\n",
       "                Area (sq. mi.) Pop. Density (per sq. mi.)  \\\n",
       "Country                                                     \n",
       "Zimbabwe                390580                       31,3   \n",
       "Zambia                  752614                       15,3   \n",
       "Yemen                   527970                       40,6   \n",
       "Western Sahara          266000                        1,0   \n",
       "West Bank                 5860                      419,9   \n",
       "...                        ...                        ...   \n",
       "Andorra                    468                      152,1   \n",
       "American Samoa             199                      290,4   \n",
       "Algeria                2381740                       13,8   \n",
       "Albania                  28748                      124,6   \n",
       "Afghanistan             647500                       48,0   \n",
       "\n",
       "               Coastline (coast/area ratio) Net migration  \\\n",
       "Country                                                     \n",
       "Zimbabwe                               0,00             0   \n",
       "Zambia                                 0,00             0   \n",
       "Yemen                                  0,36             0   \n",
       "Western Sahara                         0,42           NaN   \n",
       "West Bank                              0,00          2,98   \n",
       "...                                     ...           ...   \n",
       "Andorra                                0,00           6,6   \n",
       "American Samoa                        58,29        -20,71   \n",
       "Algeria                                0,04         -0,39   \n",
       "Albania                                1,26         -4,93   \n",
       "Afghanistan                            0,00         23,06   \n",
       "\n",
       "               Infant mortality (per 1000 births)  GDP ($ per capita)  \\\n",
       "Country                                                                 \n",
       "Zimbabwe                                    67,69              1900.0   \n",
       "Zambia                                      88,29               800.0   \n",
       "Yemen                                        61,5               800.0   \n",
       "Western Sahara                                NaN                 NaN   \n",
       "West Bank                                   19,62               800.0   \n",
       "...                                           ...                 ...   \n",
       "Andorra                                      4,05             19000.0   \n",
       "American Samoa                               9,27              8000.0   \n",
       "Algeria                                        31              6000.0   \n",
       "Albania                                     21,52              4500.0   \n",
       "Afghanistan                                163,07               700.0   \n",
       "\n",
       "               Literacy (%) Phones (per 1000) Arable (%) Crops (%) Other (%)  \\\n",
       "Country                                                                        \n",
       "Zimbabwe               90,7              26,8       8,32      0,34     91,34   \n",
       "Zambia                 80,6               8,2       7,08      0,03      92,9   \n",
       "Yemen                  50,2              37,2       2,78      0,24     96,98   \n",
       "Western Sahara          NaN               NaN       0,02         0     99,98   \n",
       "West Bank               NaN             145,2       16,9     18,97     64,13   \n",
       "...                     ...               ...        ...       ...       ...   \n",
       "Andorra               100,0             497,2       2,22         0     97,78   \n",
       "American Samoa         97,0             259,5         10        15        75   \n",
       "Algeria                70,0              78,1       3,22      0,25     96,53   \n",
       "Albania                86,5              71,2      21,09      4,42     74,49   \n",
       "Afghanistan            36,0               3,2      12,13      0,22     87,65   \n",
       "\n",
       "               Climate Birthrate Deathrate Agriculture Industry Service  \n",
       "Country                                                                  \n",
       "Zimbabwe             2     28,01     21,84       0,179    0,243   0,579  \n",
       "Zambia               2        41     19,93        0,22     0,29   0,489  \n",
       "Yemen                1     42,89       8,3       0,135    0,472   0,393  \n",
       "Western Sahara       1       NaN       NaN         NaN      NaN     0,4  \n",
       "West Bank            3     31,67      3,92        0,09     0,28    0,63  \n",
       "...                ...       ...       ...         ...      ...     ...  \n",
       "Andorra              3      8,71      6,25         NaN      NaN     NaN  \n",
       "American Samoa       2     22,46      3,27         NaN      NaN     NaN  \n",
       "Algeria              1     17,14      4,61       0,101      0,6   0,298  \n",
       "Albania              3     15,11      5,22       0,232    0,188   0,579  \n",
       "Afghanistan          1      46,6     20,34        0,38     0,24    0,38  \n",
       "\n",
       "[227 rows x 19 columns]"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_index(ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "1f442287-4109-46e9-92e4-e1e06dad449b",
   "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>Region</th>\n",
       "      <th>Population</th>\n",
       "      <th>Area (sq. mi.)</th>\n",
       "      <th>Pop. Density (per sq. mi.)</th>\n",
       "      <th>Coastline (coast/area ratio)</th>\n",
       "      <th>Net migration</th>\n",
       "      <th>Infant mortality (per 1000 births)</th>\n",
       "      <th>GDP ($ per capita)</th>\n",
       "      <th>Literacy (%)</th>\n",
       "      <th>Phones (per 1000)</th>\n",
       "      <th>Arable (%)</th>\n",
       "      <th>Crops (%)</th>\n",
       "      <th>Other (%)</th>\n",
       "      <th>Climate</th>\n",
       "      <th>Birthrate</th>\n",
       "      <th>Deathrate</th>\n",
       "      <th>Agriculture</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Service</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Zambia</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>11502010</td>\n",
       "      <td>752614</td>\n",
       "      <td>15,3</td>\n",
       "      <td>0,00</td>\n",
       "      <td>0</td>\n",
       "      <td>88,29</td>\n",
       "      <td>800.0</td>\n",
       "      <td>80,6</td>\n",
       "      <td>8,2</td>\n",
       "      <td>7,08</td>\n",
       "      <td>0,03</td>\n",
       "      <td>92,9</td>\n",
       "      <td>2</td>\n",
       "      <td>41</td>\n",
       "      <td>19,93</td>\n",
       "      <td>0,22</td>\n",
       "      <td>0,29</td>\n",
       "      <td>0,489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Western Sahara</th>\n",
       "      <td>NORTHERN AFRICA</td>\n",
       "      <td>273008</td>\n",
       "      <td>266000</td>\n",
       "      <td>1,0</td>\n",
       "      <td>0,42</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0,02</td>\n",
       "      <td>0</td>\n",
       "      <td>99,98</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0,4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>West Bank</th>\n",
       "      <td>NEAR EAST</td>\n",
       "      <td>2460492</td>\n",
       "      <td>5860</td>\n",
       "      <td>419,9</td>\n",
       "      <td>0,00</td>\n",
       "      <td>2,98</td>\n",
       "      <td>19,62</td>\n",
       "      <td>800.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>145,2</td>\n",
       "      <td>16,9</td>\n",
       "      <td>18,97</td>\n",
       "      <td>64,13</td>\n",
       "      <td>3</td>\n",
       "      <td>31,67</td>\n",
       "      <td>3,92</td>\n",
       "      <td>0,09</td>\n",
       "      <td>0,28</td>\n",
       "      <td>0,63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wallis and Futuna</th>\n",
       "      <td>OCEANIA</td>\n",
       "      <td>16025</td>\n",
       "      <td>274</td>\n",
       "      <td>58,5</td>\n",
       "      <td>47,08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3700.0</td>\n",
       "      <td>50,0</td>\n",
       "      <td>118,6</td>\n",
       "      <td>5</td>\n",
       "      <td>25</td>\n",
       "      <td>70</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Virgin Islands</th>\n",
       "      <td>LATIN AMER. &amp; CARIB</td>\n",
       "      <td>108605</td>\n",
       "      <td>1910</td>\n",
       "      <td>56,9</td>\n",
       "      <td>9,84</td>\n",
       "      <td>-8,94</td>\n",
       "      <td>8,03</td>\n",
       "      <td>17200.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>652,8</td>\n",
       "      <td>11,76</td>\n",
       "      <td>2,94</td>\n",
       "      <td>85,3</td>\n",
       "      <td>2</td>\n",
       "      <td>13,96</td>\n",
       "      <td>6,43</td>\n",
       "      <td>0,01</td>\n",
       "      <td>0,19</td>\n",
       "      <td>0,8</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Andorra</th>\n",
       "      <td>WESTERN EUROPE</td>\n",
       "      <td>71201</td>\n",
       "      <td>468</td>\n",
       "      <td>152,1</td>\n",
       "      <td>0,00</td>\n",
       "      <td>6,6</td>\n",
       "      <td>4,05</td>\n",
       "      <td>19000.0</td>\n",
       "      <td>100,0</td>\n",
       "      <td>497,2</td>\n",
       "      <td>2,22</td>\n",
       "      <td>0</td>\n",
       "      <td>97,78</td>\n",
       "      <td>3</td>\n",
       "      <td>8,71</td>\n",
       "      <td>6,25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>American Samoa</th>\n",
       "      <td>OCEANIA</td>\n",
       "      <td>57794</td>\n",
       "      <td>199</td>\n",
       "      <td>290,4</td>\n",
       "      <td>58,29</td>\n",
       "      <td>-20,71</td>\n",
       "      <td>9,27</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>97,0</td>\n",
       "      <td>259,5</td>\n",
       "      <td>10</td>\n",
       "      <td>15</td>\n",
       "      <td>75</td>\n",
       "      <td>2</td>\n",
       "      <td>22,46</td>\n",
       "      <td>3,27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>NORTHERN AFRICA</td>\n",
       "      <td>32930091</td>\n",
       "      <td>2381740</td>\n",
       "      <td>13,8</td>\n",
       "      <td>0,04</td>\n",
       "      <td>-0,39</td>\n",
       "      <td>31</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>70,0</td>\n",
       "      <td>78,1</td>\n",
       "      <td>3,22</td>\n",
       "      <td>0,25</td>\n",
       "      <td>96,53</td>\n",
       "      <td>1</td>\n",
       "      <td>17,14</td>\n",
       "      <td>4,61</td>\n",
       "      <td>0,101</td>\n",
       "      <td>0,6</td>\n",
       "      <td>0,298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Albania</th>\n",
       "      <td>EASTERN EUROPE</td>\n",
       "      <td>3581655</td>\n",
       "      <td>28748</td>\n",
       "      <td>124,6</td>\n",
       "      <td>1,26</td>\n",
       "      <td>-4,93</td>\n",
       "      <td>21,52</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>86,5</td>\n",
       "      <td>71,2</td>\n",
       "      <td>21,09</td>\n",
       "      <td>4,42</td>\n",
       "      <td>74,49</td>\n",
       "      <td>3</td>\n",
       "      <td>15,11</td>\n",
       "      <td>5,22</td>\n",
       "      <td>0,232</td>\n",
       "      <td>0,188</td>\n",
       "      <td>0,579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>31056997</td>\n",
       "      <td>647500</td>\n",
       "      <td>48,0</td>\n",
       "      <td>0,00</td>\n",
       "      <td>23,06</td>\n",
       "      <td>163,07</td>\n",
       "      <td>700.0</td>\n",
       "      <td>36,0</td>\n",
       "      <td>3,2</td>\n",
       "      <td>12,13</td>\n",
       "      <td>0,22</td>\n",
       "      <td>87,65</td>\n",
       "      <td>1</td>\n",
       "      <td>46,6</td>\n",
       "      <td>20,34</td>\n",
       "      <td>0,38</td>\n",
       "      <td>0,24</td>\n",
       "      <td>0,38</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>225 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                Region  Population  \\\n",
       "Country                                                              \n",
       "Zambia             SUB-SAHARAN AFRICA                     11502010   \n",
       "Western Sahara     NORTHERN AFRICA                          273008   \n",
       "West Bank          NEAR EAST                               2460492   \n",
       "Wallis and Futuna  OCEANIA                                   16025   \n",
       "Virgin Islands                 LATIN AMER. & CARIB          108605   \n",
       "...                                                ...         ...   \n",
       "Andorra            WESTERN EUROPE                            71201   \n",
       "American Samoa     OCEANIA                                   57794   \n",
       "Algeria            NORTHERN AFRICA                        32930091   \n",
       "Albania            EASTERN EUROPE                          3581655   \n",
       "Afghanistan              ASIA (EX. NEAR EAST)             31056997   \n",
       "\n",
       "                   Area (sq. mi.) Pop. Density (per sq. mi.)  \\\n",
       "Country                                                        \n",
       "Zambia                     752614                       15,3   \n",
       "Western Sahara             266000                        1,0   \n",
       "West Bank                    5860                      419,9   \n",
       "Wallis and Futuna             274                       58,5   \n",
       "Virgin Islands               1910                       56,9   \n",
       "...                           ...                        ...   \n",
       "Andorra                       468                      152,1   \n",
       "American Samoa                199                      290,4   \n",
       "Algeria                   2381740                       13,8   \n",
       "Albania                     28748                      124,6   \n",
       "Afghanistan                647500                       48,0   \n",
       "\n",
       "                  Coastline (coast/area ratio) Net migration  \\\n",
       "Country                                                        \n",
       "Zambia                                    0,00             0   \n",
       "Western Sahara                            0,42           NaN   \n",
       "West Bank                                 0,00          2,98   \n",
       "Wallis and Futuna                        47,08           NaN   \n",
       "Virgin Islands                            9,84         -8,94   \n",
       "...                                        ...           ...   \n",
       "Andorra                                   0,00           6,6   \n",
       "American Samoa                           58,29        -20,71   \n",
       "Algeria                                   0,04         -0,39   \n",
       "Albania                                   1,26         -4,93   \n",
       "Afghanistan                               0,00         23,06   \n",
       "\n",
       "                  Infant mortality (per 1000 births)  GDP ($ per capita)  \\\n",
       "Country                                                                    \n",
       "Zambia                                         88,29               800.0   \n",
       "Western Sahara                                   NaN                 NaN   \n",
       "West Bank                                      19,62               800.0   \n",
       "Wallis and Futuna                                NaN              3700.0   \n",
       "Virgin Islands                                  8,03             17200.0   \n",
       "...                                              ...                 ...   \n",
       "Andorra                                         4,05             19000.0   \n",
       "American Samoa                                  9,27              8000.0   \n",
       "Algeria                                           31              6000.0   \n",
       "Albania                                        21,52              4500.0   \n",
       "Afghanistan                                   163,07               700.0   \n",
       "\n",
       "                  Literacy (%) Phones (per 1000) Arable (%) Crops (%)  \\\n",
       "Country                                                                 \n",
       "Zambia                    80,6               8,2       7,08      0,03   \n",
       "Western Sahara             NaN               NaN       0,02         0   \n",
       "West Bank                  NaN             145,2       16,9     18,97   \n",
       "Wallis and Futuna         50,0             118,6          5        25   \n",
       "Virgin Islands             NaN             652,8      11,76      2,94   \n",
       "...                        ...               ...        ...       ...   \n",
       "Andorra                  100,0             497,2       2,22         0   \n",
       "American Samoa            97,0             259,5         10        15   \n",
       "Algeria                   70,0              78,1       3,22      0,25   \n",
       "Albania                   86,5              71,2      21,09      4,42   \n",
       "Afghanistan               36,0               3,2      12,13      0,22   \n",
       "\n",
       "                  Other (%) Climate Birthrate Deathrate Agriculture Industry  \\\n",
       "Country                                                                        \n",
       "Zambia                 92,9       2        41     19,93        0,22     0,29   \n",
       "Western Sahara        99,98       1       NaN       NaN         NaN      NaN   \n",
       "West Bank             64,13       3     31,67      3,92        0,09     0,28   \n",
       "Wallis and Futuna        70       2       NaN       NaN         NaN      NaN   \n",
       "Virgin Islands         85,3       2     13,96      6,43        0,01     0,19   \n",
       "...                     ...     ...       ...       ...         ...      ...   \n",
       "Andorra               97,78       3      8,71      6,25         NaN      NaN   \n",
       "American Samoa           75       2     22,46      3,27         NaN      NaN   \n",
       "Algeria               96,53       1     17,14      4,61       0,101      0,6   \n",
       "Albania               74,49       3     15,11      5,22       0,232    0,188   \n",
       "Afghanistan           87,65       1      46,6     20,34        0,38     0,24   \n",
       "\n",
       "                  Service  \n",
       "Country                    \n",
       "Zambia              0,489  \n",
       "Western Sahara        0,4  \n",
       "West Bank            0,63  \n",
       "Wallis and Futuna     NaN  \n",
       "Virgin Islands        0,8  \n",
       "...                   ...  \n",
       "Andorra               NaN  \n",
       "American Samoa        NaN  \n",
       "Algeria             0,298  \n",
       "Albania             0,579  \n",
       "Afghanistan          0,38  \n",
       "\n",
       "[225 rows x 19 columns]"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.drop(['Zimbabwe','Yemen']).sort_index(ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "4911a7ba-9bb1-4f66-87ad-8da2fc036a9b",
   "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>Area (sq. mi.)</th>\n",
       "      <th>Pop. Density (per sq. mi.)</th>\n",
       "      <th>Coastline (coast/area ratio)</th>\n",
       "      <th>Net migration</th>\n",
       "      <th>Infant mortality (per 1000 births)</th>\n",
       "      <th>GDP ($ per capita)</th>\n",
       "      <th>Literacy (%)</th>\n",
       "      <th>Phones (per 1000)</th>\n",
       "      <th>Arable (%)</th>\n",
       "      <th>Crops (%)</th>\n",
       "      <th>Other (%)</th>\n",
       "      <th>Climate</th>\n",
       "      <th>Birthrate</th>\n",
       "      <th>Deathrate</th>\n",
       "      <th>Agriculture</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Service</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Zimbabwe</th>\n",
       "      <td>390580</td>\n",
       "      <td>31,3</td>\n",
       "      <td>0,00</td>\n",
       "      <td>0</td>\n",
       "      <td>67,69</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>90,7</td>\n",
       "      <td>26,8</td>\n",
       "      <td>8,32</td>\n",
       "      <td>0,34</td>\n",
       "      <td>91,34</td>\n",
       "      <td>2</td>\n",
       "      <td>28,01</td>\n",
       "      <td>21,84</td>\n",
       "      <td>0,179</td>\n",
       "      <td>0,243</td>\n",
       "      <td>0,579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zambia</th>\n",
       "      <td>752614</td>\n",
       "      <td>15,3</td>\n",
       "      <td>0,00</td>\n",
       "      <td>0</td>\n",
       "      <td>88,29</td>\n",
       "      <td>800.0</td>\n",
       "      <td>80,6</td>\n",
       "      <td>8,2</td>\n",
       "      <td>7,08</td>\n",
       "      <td>0,03</td>\n",
       "      <td>92,9</td>\n",
       "      <td>2</td>\n",
       "      <td>41</td>\n",
       "      <td>19,93</td>\n",
       "      <td>0,22</td>\n",
       "      <td>0,29</td>\n",
       "      <td>0,489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yemen</th>\n",
       "      <td>527970</td>\n",
       "      <td>40,6</td>\n",
       "      <td>0,36</td>\n",
       "      <td>0</td>\n",
       "      <td>61,5</td>\n",
       "      <td>800.0</td>\n",
       "      <td>50,2</td>\n",
       "      <td>37,2</td>\n",
       "      <td>2,78</td>\n",
       "      <td>0,24</td>\n",
       "      <td>96,98</td>\n",
       "      <td>1</td>\n",
       "      <td>42,89</td>\n",
       "      <td>8,3</td>\n",
       "      <td>0,135</td>\n",
       "      <td>0,472</td>\n",
       "      <td>0,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Western Sahara</th>\n",
       "      <td>266000</td>\n",
       "      <td>1,0</td>\n",
       "      <td>0,42</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0,02</td>\n",
       "      <td>0</td>\n",
       "      <td>99,98</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0,4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>West Bank</th>\n",
       "      <td>5860</td>\n",
       "      <td>419,9</td>\n",
       "      <td>0,00</td>\n",
       "      <td>2,98</td>\n",
       "      <td>19,62</td>\n",
       "      <td>800.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>145,2</td>\n",
       "      <td>16,9</td>\n",
       "      <td>18,97</td>\n",
       "      <td>64,13</td>\n",
       "      <td>3</td>\n",
       "      <td>31,67</td>\n",
       "      <td>3,92</td>\n",
       "      <td>0,09</td>\n",
       "      <td>0,28</td>\n",
       "      <td>0,63</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>Andorra</th>\n",
       "      <td>468</td>\n",
       "      <td>152,1</td>\n",
       "      <td>0,00</td>\n",
       "      <td>6,6</td>\n",
       "      <td>4,05</td>\n",
       "      <td>19000.0</td>\n",
       "      <td>100,0</td>\n",
       "      <td>497,2</td>\n",
       "      <td>2,22</td>\n",
       "      <td>0</td>\n",
       "      <td>97,78</td>\n",
       "      <td>3</td>\n",
       "      <td>8,71</td>\n",
       "      <td>6,25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>American Samoa</th>\n",
       "      <td>199</td>\n",
       "      <td>290,4</td>\n",
       "      <td>58,29</td>\n",
       "      <td>-20,71</td>\n",
       "      <td>9,27</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>97,0</td>\n",
       "      <td>259,5</td>\n",
       "      <td>10</td>\n",
       "      <td>15</td>\n",
       "      <td>75</td>\n",
       "      <td>2</td>\n",
       "      <td>22,46</td>\n",
       "      <td>3,27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>2381740</td>\n",
       "      <td>13,8</td>\n",
       "      <td>0,04</td>\n",
       "      <td>-0,39</td>\n",
       "      <td>31</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>70,0</td>\n",
       "      <td>78,1</td>\n",
       "      <td>3,22</td>\n",
       "      <td>0,25</td>\n",
       "      <td>96,53</td>\n",
       "      <td>1</td>\n",
       "      <td>17,14</td>\n",
       "      <td>4,61</td>\n",
       "      <td>0,101</td>\n",
       "      <td>0,6</td>\n",
       "      <td>0,298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Albania</th>\n",
       "      <td>28748</td>\n",
       "      <td>124,6</td>\n",
       "      <td>1,26</td>\n",
       "      <td>-4,93</td>\n",
       "      <td>21,52</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>86,5</td>\n",
       "      <td>71,2</td>\n",
       "      <td>21,09</td>\n",
       "      <td>4,42</td>\n",
       "      <td>74,49</td>\n",
       "      <td>3</td>\n",
       "      <td>15,11</td>\n",
       "      <td>5,22</td>\n",
       "      <td>0,232</td>\n",
       "      <td>0,188</td>\n",
       "      <td>0,579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>647500</td>\n",
       "      <td>48,0</td>\n",
       "      <td>0,00</td>\n",
       "      <td>23,06</td>\n",
       "      <td>163,07</td>\n",
       "      <td>700.0</td>\n",
       "      <td>36,0</td>\n",
       "      <td>3,2</td>\n",
       "      <td>12,13</td>\n",
       "      <td>0,22</td>\n",
       "      <td>87,65</td>\n",
       "      <td>1</td>\n",
       "      <td>46,6</td>\n",
       "      <td>20,34</td>\n",
       "      <td>0,38</td>\n",
       "      <td>0,24</td>\n",
       "      <td>0,38</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>227 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Area (sq. mi.) Pop. Density (per sq. mi.)  \\\n",
       "Country                                                     \n",
       "Zimbabwe                390580                       31,3   \n",
       "Zambia                  752614                       15,3   \n",
       "Yemen                   527970                       40,6   \n",
       "Western Sahara          266000                        1,0   \n",
       "West Bank                 5860                      419,9   \n",
       "...                        ...                        ...   \n",
       "Andorra                    468                      152,1   \n",
       "American Samoa             199                      290,4   \n",
       "Algeria                2381740                       13,8   \n",
       "Albania                  28748                      124,6   \n",
       "Afghanistan             647500                       48,0   \n",
       "\n",
       "               Coastline (coast/area ratio) Net migration  \\\n",
       "Country                                                     \n",
       "Zimbabwe                               0,00             0   \n",
       "Zambia                                 0,00             0   \n",
       "Yemen                                  0,36             0   \n",
       "Western Sahara                         0,42           NaN   \n",
       "West Bank                              0,00          2,98   \n",
       "...                                     ...           ...   \n",
       "Andorra                                0,00           6,6   \n",
       "American Samoa                        58,29        -20,71   \n",
       "Algeria                                0,04         -0,39   \n",
       "Albania                                1,26         -4,93   \n",
       "Afghanistan                            0,00         23,06   \n",
       "\n",
       "               Infant mortality (per 1000 births)  GDP ($ per capita)  \\\n",
       "Country                                                                 \n",
       "Zimbabwe                                    67,69              1900.0   \n",
       "Zambia                                      88,29               800.0   \n",
       "Yemen                                        61,5               800.0   \n",
       "Western Sahara                                NaN                 NaN   \n",
       "West Bank                                   19,62               800.0   \n",
       "...                                           ...                 ...   \n",
       "Andorra                                      4,05             19000.0   \n",
       "American Samoa                               9,27              8000.0   \n",
       "Algeria                                        31              6000.0   \n",
       "Albania                                     21,52              4500.0   \n",
       "Afghanistan                                163,07               700.0   \n",
       "\n",
       "               Literacy (%) Phones (per 1000) Arable (%) Crops (%) Other (%)  \\\n",
       "Country                                                                        \n",
       "Zimbabwe               90,7              26,8       8,32      0,34     91,34   \n",
       "Zambia                 80,6               8,2       7,08      0,03      92,9   \n",
       "Yemen                  50,2              37,2       2,78      0,24     96,98   \n",
       "Western Sahara          NaN               NaN       0,02         0     99,98   \n",
       "West Bank               NaN             145,2       16,9     18,97     64,13   \n",
       "...                     ...               ...        ...       ...       ...   \n",
       "Andorra               100,0             497,2       2,22         0     97,78   \n",
       "American Samoa         97,0             259,5         10        15        75   \n",
       "Algeria                70,0              78,1       3,22      0,25     96,53   \n",
       "Albania                86,5              71,2      21,09      4,42     74,49   \n",
       "Afghanistan            36,0               3,2      12,13      0,22     87,65   \n",
       "\n",
       "               Climate Birthrate Deathrate Agriculture Industry Service  \n",
       "Country                                                                  \n",
       "Zimbabwe             2     28,01     21,84       0,179    0,243   0,579  \n",
       "Zambia               2        41     19,93        0,22     0,29   0,489  \n",
       "Yemen                1     42,89       8,3       0,135    0,472   0,393  \n",
       "Western Sahara       1       NaN       NaN         NaN      NaN     0,4  \n",
       "West Bank            3     31,67      3,92        0,09     0,28    0,63  \n",
       "...                ...       ...       ...         ...      ...     ...  \n",
       "Andorra              3      8,71      6,25         NaN      NaN     NaN  \n",
       "American Samoa       2     22,46      3,27         NaN      NaN     NaN  \n",
       "Algeria              1     17,14      4,61       0,101      0,6   0,298  \n",
       "Albania              3     15,11      5,22       0,232    0,188   0,579  \n",
       "Afghanistan          1      46,6     20,34        0,38     0,24    0,38  \n",
       "\n",
       "[227 rows x 17 columns]"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.drop(['Region','Population'], axis = 1).sort_index(ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "5711df8c-8a27-4b07-92da-9c3b79117987",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country</th>\n",
       "      <th>Region</th>\n",
       "      <th>Population</th>\n",
       "      <th>Area (sq. mi.)</th>\n",
       "      <th>Pop. Density (per sq. mi.)</th>\n",
       "      <th>Coastline (coast/area ratio)</th>\n",
       "      <th>Net migration</th>\n",
       "      <th>Infant mortality (per 1000 births)</th>\n",
       "      <th>GDP ($ per capita)</th>\n",
       "      <th>Literacy (%)</th>\n",
       "      <th>Phones (per 1000)</th>\n",
       "      <th>Arable (%)</th>\n",
       "      <th>Crops (%)</th>\n",
       "      <th>Other (%)</th>\n",
       "      <th>Climate</th>\n",
       "      <th>Birthrate</th>\n",
       "      <th>Deathrate</th>\n",
       "      <th>Agriculture</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Service</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>31056997</td>\n",
       "      <td>647500</td>\n",
       "      <td>48,0</td>\n",
       "      <td>0,00</td>\n",
       "      <td>23,06</td>\n",
       "      <td>163,07</td>\n",
       "      <td>700.0</td>\n",
       "      <td>36,0</td>\n",
       "      <td>3,2</td>\n",
       "      <td>12,13</td>\n",
       "      <td>0,22</td>\n",
       "      <td>87,65</td>\n",
       "      <td>1</td>\n",
       "      <td>46,6</td>\n",
       "      <td>20,34</td>\n",
       "      <td>0,38</td>\n",
       "      <td>0,24</td>\n",
       "      <td>0,38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Albania</td>\n",
       "      <td>EASTERN EUROPE</td>\n",
       "      <td>3581655</td>\n",
       "      <td>28748</td>\n",
       "      <td>124,6</td>\n",
       "      <td>1,26</td>\n",
       "      <td>-4,93</td>\n",
       "      <td>21,52</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>86,5</td>\n",
       "      <td>71,2</td>\n",
       "      <td>21,09</td>\n",
       "      <td>4,42</td>\n",
       "      <td>74,49</td>\n",
       "      <td>3</td>\n",
       "      <td>15,11</td>\n",
       "      <td>5,22</td>\n",
       "      <td>0,232</td>\n",
       "      <td>0,188</td>\n",
       "      <td>0,579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Algeria</td>\n",
       "      <td>NORTHERN AFRICA</td>\n",
       "      <td>32930091</td>\n",
       "      <td>2381740</td>\n",
       "      <td>13,8</td>\n",
       "      <td>0,04</td>\n",
       "      <td>-0,39</td>\n",
       "      <td>31</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>70,0</td>\n",
       "      <td>78,1</td>\n",
       "      <td>3,22</td>\n",
       "      <td>0,25</td>\n",
       "      <td>96,53</td>\n",
       "      <td>1</td>\n",
       "      <td>17,14</td>\n",
       "      <td>4,61</td>\n",
       "      <td>0,101</td>\n",
       "      <td>0,6</td>\n",
       "      <td>0,298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>American Samoa</td>\n",
       "      <td>OCEANIA</td>\n",
       "      <td>57794</td>\n",
       "      <td>199</td>\n",
       "      <td>290,4</td>\n",
       "      <td>58,29</td>\n",
       "      <td>-20,71</td>\n",
       "      <td>9,27</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>97,0</td>\n",
       "      <td>259,5</td>\n",
       "      <td>10</td>\n",
       "      <td>15</td>\n",
       "      <td>75</td>\n",
       "      <td>2</td>\n",
       "      <td>22,46</td>\n",
       "      <td>3,27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Andorra</td>\n",
       "      <td>WESTERN EUROPE</td>\n",
       "      <td>71201</td>\n",
       "      <td>468</td>\n",
       "      <td>152,1</td>\n",
       "      <td>0,00</td>\n",
       "      <td>6,6</td>\n",
       "      <td>4,05</td>\n",
       "      <td>19000.0</td>\n",
       "      <td>100,0</td>\n",
       "      <td>497,2</td>\n",
       "      <td>2,22</td>\n",
       "      <td>0</td>\n",
       "      <td>97,78</td>\n",
       "      <td>3</td>\n",
       "      <td>8,71</td>\n",
       "      <td>6,25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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>222</th>\n",
       "      <td>West Bank</td>\n",
       "      <td>NEAR EAST</td>\n",
       "      <td>2460492</td>\n",
       "      <td>5860</td>\n",
       "      <td>419,9</td>\n",
       "      <td>0,00</td>\n",
       "      <td>2,98</td>\n",
       "      <td>19,62</td>\n",
       "      <td>800.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>145,2</td>\n",
       "      <td>16,9</td>\n",
       "      <td>18,97</td>\n",
       "      <td>64,13</td>\n",
       "      <td>3</td>\n",
       "      <td>31,67</td>\n",
       "      <td>3,92</td>\n",
       "      <td>0,09</td>\n",
       "      <td>0,28</td>\n",
       "      <td>0,63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>Western Sahara</td>\n",
       "      <td>NORTHERN AFRICA</td>\n",
       "      <td>273008</td>\n",
       "      <td>266000</td>\n",
       "      <td>1,0</td>\n",
       "      <td>0,42</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0,02</td>\n",
       "      <td>0</td>\n",
       "      <td>99,98</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0,4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>Yemen</td>\n",
       "      <td>NEAR EAST</td>\n",
       "      <td>21456188</td>\n",
       "      <td>527970</td>\n",
       "      <td>40,6</td>\n",
       "      <td>0,36</td>\n",
       "      <td>0</td>\n",
       "      <td>61,5</td>\n",
       "      <td>800.0</td>\n",
       "      <td>50,2</td>\n",
       "      <td>37,2</td>\n",
       "      <td>2,78</td>\n",
       "      <td>0,24</td>\n",
       "      <td>96,98</td>\n",
       "      <td>1</td>\n",
       "      <td>42,89</td>\n",
       "      <td>8,3</td>\n",
       "      <td>0,135</td>\n",
       "      <td>0,472</td>\n",
       "      <td>0,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>Zambia</td>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>11502010</td>\n",
       "      <td>752614</td>\n",
       "      <td>15,3</td>\n",
       "      <td>0,00</td>\n",
       "      <td>0</td>\n",
       "      <td>88,29</td>\n",
       "      <td>800.0</td>\n",
       "      <td>80,6</td>\n",
       "      <td>8,2</td>\n",
       "      <td>7,08</td>\n",
       "      <td>0,03</td>\n",
       "      <td>92,9</td>\n",
       "      <td>2</td>\n",
       "      <td>41</td>\n",
       "      <td>19,93</td>\n",
       "      <td>0,22</td>\n",
       "      <td>0,29</td>\n",
       "      <td>0,489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>12236805</td>\n",
       "      <td>390580</td>\n",
       "      <td>31,3</td>\n",
       "      <td>0,00</td>\n",
       "      <td>0</td>\n",
       "      <td>67,69</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>90,7</td>\n",
       "      <td>26,8</td>\n",
       "      <td>8,32</td>\n",
       "      <td>0,34</td>\n",
       "      <td>91,34</td>\n",
       "      <td>2</td>\n",
       "      <td>28,01</td>\n",
       "      <td>21,84</td>\n",
       "      <td>0,179</td>\n",
       "      <td>0,243</td>\n",
       "      <td>0,579</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>227 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Country                               Region  Population  \\\n",
       "0       Afghanistan        ASIA (EX. NEAR EAST)             31056997   \n",
       "1           Albania  EASTERN EUROPE                          3581655   \n",
       "2           Algeria  NORTHERN AFRICA                        32930091   \n",
       "3    American Samoa  OCEANIA                                   57794   \n",
       "4           Andorra  WESTERN EUROPE                            71201   \n",
       "..              ...                                  ...         ...   \n",
       "222       West Bank  NEAR EAST                               2460492   \n",
       "223  Western Sahara  NORTHERN AFRICA                          273008   \n",
       "224           Yemen  NEAR EAST                              21456188   \n",
       "225          Zambia  SUB-SAHARAN AFRICA                     11502010   \n",
       "226        Zimbabwe  SUB-SAHARAN AFRICA                     12236805   \n",
       "\n",
       "     Area (sq. mi.) Pop. Density (per sq. mi.) Coastline (coast/area ratio)  \\\n",
       "0            647500                       48,0                         0,00   \n",
       "1             28748                      124,6                         1,26   \n",
       "2           2381740                       13,8                         0,04   \n",
       "3               199                      290,4                        58,29   \n",
       "4               468                      152,1                         0,00   \n",
       "..              ...                        ...                          ...   \n",
       "222            5860                      419,9                         0,00   \n",
       "223          266000                        1,0                         0,42   \n",
       "224          527970                       40,6                         0,36   \n",
       "225          752614                       15,3                         0,00   \n",
       "226          390580                       31,3                         0,00   \n",
       "\n",
       "    Net migration Infant mortality (per 1000 births)  GDP ($ per capita)  \\\n",
       "0           23,06                             163,07               700.0   \n",
       "1           -4,93                              21,52              4500.0   \n",
       "2           -0,39                                 31              6000.0   \n",
       "3          -20,71                               9,27              8000.0   \n",
       "4             6,6                               4,05             19000.0   \n",
       "..            ...                                ...                 ...   \n",
       "222          2,98                              19,62               800.0   \n",
       "223           NaN                                NaN                 NaN   \n",
       "224             0                               61,5               800.0   \n",
       "225             0                              88,29               800.0   \n",
       "226             0                              67,69              1900.0   \n",
       "\n",
       "    Literacy (%) Phones (per 1000) Arable (%) Crops (%) Other (%) Climate  \\\n",
       "0           36,0               3,2      12,13      0,22     87,65       1   \n",
       "1           86,5              71,2      21,09      4,42     74,49       3   \n",
       "2           70,0              78,1       3,22      0,25     96,53       1   \n",
       "3           97,0             259,5         10        15        75       2   \n",
       "4          100,0             497,2       2,22         0     97,78       3   \n",
       "..           ...               ...        ...       ...       ...     ...   \n",
       "222          NaN             145,2       16,9     18,97     64,13       3   \n",
       "223          NaN               NaN       0,02         0     99,98       1   \n",
       "224         50,2              37,2       2,78      0,24     96,98       1   \n",
       "225         80,6               8,2       7,08      0,03      92,9       2   \n",
       "226         90,7              26,8       8,32      0,34     91,34       2   \n",
       "\n",
       "    Birthrate Deathrate Agriculture Industry Service  \n",
       "0        46,6     20,34        0,38     0,24    0,38  \n",
       "1       15,11      5,22       0,232    0,188   0,579  \n",
       "2       17,14      4,61       0,101      0,6   0,298  \n",
       "3       22,46      3,27         NaN      NaN     NaN  \n",
       "4        8,71      6,25         NaN      NaN     NaN  \n",
       "..        ...       ...         ...      ...     ...  \n",
       "222     31,67      3,92        0,09     0,28    0,63  \n",
       "223       NaN       NaN         NaN      NaN     0,4  \n",
       "224     42,89       8,3       0,135    0,472   0,393  \n",
       "225        41     19,93        0,22     0,29   0,489  \n",
       "226     28,01     21,84       0,179    0,243   0,579  \n",
       "\n",
       "[227 rows x 20 columns]"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "1317586c-c1ed-4ad0-b9a0-c3f9f75dd410",
   "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>Region</th>\n",
       "      <th>Net migration</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>China</th>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>-0,4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>India</th>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>-0,07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United States</th>\n",
       "      <td>NORTHERN AMERICA</td>\n",
       "      <td>3,41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Indonesia</th>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Brazil</th>\n",
       "      <td>LATIN AMER. &amp; CARIB</td>\n",
       "      <td>-0,03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pakistan</th>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>-2,77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bangladesh</th>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>-0,71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Russia</th>\n",
       "      <td>C.W. OF IND. STATES</td>\n",
       "      <td>1,02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nigeria</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>0,26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Japan</th>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            Region Net migration\n",
       "Country                                                         \n",
       "China                ASIA (EX. NEAR EAST)                   -0,4\n",
       "India                ASIA (EX. NEAR EAST)                  -0,07\n",
       "United States  NORTHERN AMERICA                             3,41\n",
       "Indonesia            ASIA (EX. NEAR EAST)                      0\n",
       "Brazil                     LATIN AMER. & CARIB             -0,03\n",
       "Pakistan             ASIA (EX. NEAR EAST)                  -2,77\n",
       "Bangladesh           ASIA (EX. NEAR EAST)                  -0,71\n",
       "Russia                        C.W. OF IND. STATES           1,02\n",
       "Nigeria        SUB-SAHARAN AFRICA                           0,26\n",
       "Japan                ASIA (EX. NEAR EAST)                      0"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_values('Population', ascending=False).iloc[:10][['Region','Net migration']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "id": "11f20ae0-d522-4216-8b59-fbcd7b11c944",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Region', 'Population', 'Area (sq. mi.)', 'Pop. Density (per sq. mi.)',\n",
       "       'Coastline (coast/area ratio)', 'Net migration',\n",
       "       'Infant mortality (per 1000 births)', 'GDP ($ per capita)',\n",
       "       'Literacy (%)', 'Phones (per 1000)', 'Arable (%)', 'Crops (%)',\n",
       "       'Other (%)', 'Climate', 'Birthrate', 'Deathrate', 'Agriculture',\n",
       "       'Industry', 'Service'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "b24ab62b-6f6e-4995-bae8-6b15c033591f",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.rename(columns = {'Net migration':'Nm', 'Pop. Density (per sq. mi.)':'Pop'}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "a19694fd-5769-4349-818f-b8a90dd075e7",
   "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>Region</th>\n",
       "      <th>Population</th>\n",
       "      <th>Area (sq. mi.)</th>\n",
       "      <th>Pop</th>\n",
       "      <th>Coastline (coast/area ratio)</th>\n",
       "      <th>Nm</th>\n",
       "      <th>Infant mortality (per 1000 births)</th>\n",
       "      <th>GDP ($ per capita)</th>\n",
       "      <th>Literacy (%)</th>\n",
       "      <th>Phones (per 1000)</th>\n",
       "      <th>Arable (%)</th>\n",
       "      <th>Crops (%)</th>\n",
       "      <th>Other (%)</th>\n",
       "      <th>Climate</th>\n",
       "      <th>Birthrate</th>\n",
       "      <th>Deathrate</th>\n",
       "      <th>Agriculture</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Service</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>31056997</td>\n",
       "      <td>647500</td>\n",
       "      <td>48,0</td>\n",
       "      <td>0,00</td>\n",
       "      <td>23,06</td>\n",
       "      <td>163,07</td>\n",
       "      <td>700.0</td>\n",
       "      <td>36,0</td>\n",
       "      <td>3,2</td>\n",
       "      <td>12,13</td>\n",
       "      <td>0,22</td>\n",
       "      <td>87,65</td>\n",
       "      <td>1</td>\n",
       "      <td>46,6</td>\n",
       "      <td>20,34</td>\n",
       "      <td>0,38</td>\n",
       "      <td>0,24</td>\n",
       "      <td>0,38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Albania</th>\n",
       "      <td>EASTERN EUROPE</td>\n",
       "      <td>3581655</td>\n",
       "      <td>28748</td>\n",
       "      <td>124,6</td>\n",
       "      <td>1,26</td>\n",
       "      <td>-4,93</td>\n",
       "      <td>21,52</td>\n",
       "      <td>4500.0</td>\n",
       "      <td>86,5</td>\n",
       "      <td>71,2</td>\n",
       "      <td>21,09</td>\n",
       "      <td>4,42</td>\n",
       "      <td>74,49</td>\n",
       "      <td>3</td>\n",
       "      <td>15,11</td>\n",
       "      <td>5,22</td>\n",
       "      <td>0,232</td>\n",
       "      <td>0,188</td>\n",
       "      <td>0,579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>NORTHERN AFRICA</td>\n",
       "      <td>32930091</td>\n",
       "      <td>2381740</td>\n",
       "      <td>13,8</td>\n",
       "      <td>0,04</td>\n",
       "      <td>-0,39</td>\n",
       "      <td>31</td>\n",
       "      <td>6000.0</td>\n",
       "      <td>70,0</td>\n",
       "      <td>78,1</td>\n",
       "      <td>3,22</td>\n",
       "      <td>0,25</td>\n",
       "      <td>96,53</td>\n",
       "      <td>1</td>\n",
       "      <td>17,14</td>\n",
       "      <td>4,61</td>\n",
       "      <td>0,101</td>\n",
       "      <td>0,6</td>\n",
       "      <td>0,298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>American Samoa</th>\n",
       "      <td>OCEANIA</td>\n",
       "      <td>57794</td>\n",
       "      <td>199</td>\n",
       "      <td>290,4</td>\n",
       "      <td>58,29</td>\n",
       "      <td>-20,71</td>\n",
       "      <td>9,27</td>\n",
       "      <td>8000.0</td>\n",
       "      <td>97,0</td>\n",
       "      <td>259,5</td>\n",
       "      <td>10</td>\n",
       "      <td>15</td>\n",
       "      <td>75</td>\n",
       "      <td>2</td>\n",
       "      <td>22,46</td>\n",
       "      <td>3,27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Andorra</th>\n",
       "      <td>WESTERN EUROPE</td>\n",
       "      <td>71201</td>\n",
       "      <td>468</td>\n",
       "      <td>152,1</td>\n",
       "      <td>0,00</td>\n",
       "      <td>6,6</td>\n",
       "      <td>4,05</td>\n",
       "      <td>19000.0</td>\n",
       "      <td>100,0</td>\n",
       "      <td>497,2</td>\n",
       "      <td>2,22</td>\n",
       "      <td>0</td>\n",
       "      <td>97,78</td>\n",
       "      <td>3</td>\n",
       "      <td>8,71</td>\n",
       "      <td>6,25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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>West Bank</th>\n",
       "      <td>NEAR EAST</td>\n",
       "      <td>2460492</td>\n",
       "      <td>5860</td>\n",
       "      <td>419,9</td>\n",
       "      <td>0,00</td>\n",
       "      <td>2,98</td>\n",
       "      <td>19,62</td>\n",
       "      <td>800.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>145,2</td>\n",
       "      <td>16,9</td>\n",
       "      <td>18,97</td>\n",
       "      <td>64,13</td>\n",
       "      <td>3</td>\n",
       "      <td>31,67</td>\n",
       "      <td>3,92</td>\n",
       "      <td>0,09</td>\n",
       "      <td>0,28</td>\n",
       "      <td>0,63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Western Sahara</th>\n",
       "      <td>NORTHERN AFRICA</td>\n",
       "      <td>273008</td>\n",
       "      <td>266000</td>\n",
       "      <td>1,0</td>\n",
       "      <td>0,42</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0,02</td>\n",
       "      <td>0</td>\n",
       "      <td>99,98</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0,4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yemen</th>\n",
       "      <td>NEAR EAST</td>\n",
       "      <td>21456188</td>\n",
       "      <td>527970</td>\n",
       "      <td>40,6</td>\n",
       "      <td>0,36</td>\n",
       "      <td>0</td>\n",
       "      <td>61,5</td>\n",
       "      <td>800.0</td>\n",
       "      <td>50,2</td>\n",
       "      <td>37,2</td>\n",
       "      <td>2,78</td>\n",
       "      <td>0,24</td>\n",
       "      <td>96,98</td>\n",
       "      <td>1</td>\n",
       "      <td>42,89</td>\n",
       "      <td>8,3</td>\n",
       "      <td>0,135</td>\n",
       "      <td>0,472</td>\n",
       "      <td>0,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zambia</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>11502010</td>\n",
       "      <td>752614</td>\n",
       "      <td>15,3</td>\n",
       "      <td>0,00</td>\n",
       "      <td>0</td>\n",
       "      <td>88,29</td>\n",
       "      <td>800.0</td>\n",
       "      <td>80,6</td>\n",
       "      <td>8,2</td>\n",
       "      <td>7,08</td>\n",
       "      <td>0,03</td>\n",
       "      <td>92,9</td>\n",
       "      <td>2</td>\n",
       "      <td>41</td>\n",
       "      <td>19,93</td>\n",
       "      <td>0,22</td>\n",
       "      <td>0,29</td>\n",
       "      <td>0,489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zimbabwe</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>12236805</td>\n",
       "      <td>390580</td>\n",
       "      <td>31,3</td>\n",
       "      <td>0,00</td>\n",
       "      <td>0</td>\n",
       "      <td>67,69</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>90,7</td>\n",
       "      <td>26,8</td>\n",
       "      <td>8,32</td>\n",
       "      <td>0,34</td>\n",
       "      <td>91,34</td>\n",
       "      <td>2</td>\n",
       "      <td>28,01</td>\n",
       "      <td>21,84</td>\n",
       "      <td>0,179</td>\n",
       "      <td>0,243</td>\n",
       "      <td>0,579</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>227 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Region  Population  \\\n",
       "Country                                                           \n",
       "Afghanistan           ASIA (EX. NEAR EAST)             31056997   \n",
       "Albania         EASTERN EUROPE                          3581655   \n",
       "Algeria         NORTHERN AFRICA                        32930091   \n",
       "American Samoa  OCEANIA                                   57794   \n",
       "Andorra         WESTERN EUROPE                            71201   \n",
       "...                                             ...         ...   \n",
       "West Bank       NEAR EAST                               2460492   \n",
       "Western Sahara  NORTHERN AFRICA                          273008   \n",
       "Yemen           NEAR EAST                              21456188   \n",
       "Zambia          SUB-SAHARAN AFRICA                     11502010   \n",
       "Zimbabwe        SUB-SAHARAN AFRICA                     12236805   \n",
       "\n",
       "                Area (sq. mi.)    Pop Coastline (coast/area ratio)      Nm  \\\n",
       "Country                                                                      \n",
       "Afghanistan             647500   48,0                         0,00   23,06   \n",
       "Albania                  28748  124,6                         1,26   -4,93   \n",
       "Algeria                2381740   13,8                         0,04   -0,39   \n",
       "American Samoa             199  290,4                        58,29  -20,71   \n",
       "Andorra                    468  152,1                         0,00     6,6   \n",
       "...                        ...    ...                          ...     ...   \n",
       "West Bank                 5860  419,9                         0,00    2,98   \n",
       "Western Sahara          266000    1,0                         0,42     NaN   \n",
       "Yemen                   527970   40,6                         0,36       0   \n",
       "Zambia                  752614   15,3                         0,00       0   \n",
       "Zimbabwe                390580   31,3                         0,00       0   \n",
       "\n",
       "               Infant mortality (per 1000 births)  GDP ($ per capita)  \\\n",
       "Country                                                                 \n",
       "Afghanistan                                163,07               700.0   \n",
       "Albania                                     21,52              4500.0   \n",
       "Algeria                                        31              6000.0   \n",
       "American Samoa                               9,27              8000.0   \n",
       "Andorra                                      4,05             19000.0   \n",
       "...                                           ...                 ...   \n",
       "West Bank                                   19,62               800.0   \n",
       "Western Sahara                                NaN                 NaN   \n",
       "Yemen                                        61,5               800.0   \n",
       "Zambia                                      88,29               800.0   \n",
       "Zimbabwe                                    67,69              1900.0   \n",
       "\n",
       "               Literacy (%) Phones (per 1000) Arable (%) Crops (%) Other (%)  \\\n",
       "Country                                                                        \n",
       "Afghanistan            36,0               3,2      12,13      0,22     87,65   \n",
       "Albania                86,5              71,2      21,09      4,42     74,49   \n",
       "Algeria                70,0              78,1       3,22      0,25     96,53   \n",
       "American Samoa         97,0             259,5         10        15        75   \n",
       "Andorra               100,0             497,2       2,22         0     97,78   \n",
       "...                     ...               ...        ...       ...       ...   \n",
       "West Bank               NaN             145,2       16,9     18,97     64,13   \n",
       "Western Sahara          NaN               NaN       0,02         0     99,98   \n",
       "Yemen                  50,2              37,2       2,78      0,24     96,98   \n",
       "Zambia                 80,6               8,2       7,08      0,03      92,9   \n",
       "Zimbabwe               90,7              26,8       8,32      0,34     91,34   \n",
       "\n",
       "               Climate Birthrate Deathrate Agriculture Industry Service  \n",
       "Country                                                                  \n",
       "Afghanistan          1      46,6     20,34        0,38     0,24    0,38  \n",
       "Albania              3     15,11      5,22       0,232    0,188   0,579  \n",
       "Algeria              1     17,14      4,61       0,101      0,6   0,298  \n",
       "American Samoa       2     22,46      3,27         NaN      NaN     NaN  \n",
       "Andorra              3      8,71      6,25         NaN      NaN     NaN  \n",
       "...                ...       ...       ...         ...      ...     ...  \n",
       "West Bank            3     31,67      3,92        0,09     0,28    0,63  \n",
       "Western Sahara       1       NaN       NaN         NaN      NaN     0,4  \n",
       "Yemen                1     42,89       8,3       0,135    0,472   0,393  \n",
       "Zambia               2        41     19,93        0,22     0,29   0,489  \n",
       "Zimbabwe             2     28,01     21,84       0,179    0,243   0,579  \n",
       "\n",
       "[227 rows x 19 columns]"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "id": "c9c5d86e-ea2b-425c-bb6d-e6d7e317867e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Country\n",
       "Afghanistan       False\n",
       "Albania           False\n",
       "Algeria           False\n",
       "American Samoa    False\n",
       "Andorra           False\n",
       "                  ...  \n",
       "West Bank         False\n",
       "Western Sahara    False\n",
       "Yemen              True\n",
       "Zambia             True\n",
       "Zimbabwe           True\n",
       "Name: Nm, Length: 227, dtype: bool"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Nm'] == '0'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "cbcc2f89-2c5d-462a-80f7-f0bc6d92aa38",
   "metadata": {},
   "outputs": [],
   "source": [
    "zero_migration_filter = df['Nm'] == '0'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "id": "66a735d2-67af-4ef3-b8ae-79792d36ec06",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": 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>Region</th>\n",
       "      <th>Population</th>\n",
       "      <th>Area (sq. mi.)</th>\n",
       "      <th>Pop</th>\n",
       "      <th>Coastline (coast/area ratio)</th>\n",
       "      <th>Nm</th>\n",
       "      <th>Infant mortality (per 1000 births)</th>\n",
       "      <th>GDP ($ per capita)</th>\n",
       "      <th>Literacy (%)</th>\n",
       "      <th>Phones (per 1000)</th>\n",
       "      <th>Arable (%)</th>\n",
       "      <th>Crops (%)</th>\n",
       "      <th>Other (%)</th>\n",
       "      <th>Climate</th>\n",
       "      <th>Birthrate</th>\n",
       "      <th>Deathrate</th>\n",
       "      <th>Agriculture</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Service</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Angola</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>12127071</td>\n",
       "      <td>1246700</td>\n",
       "      <td>9,7</td>\n",
       "      <td>0,13</td>\n",
       "      <td>0</td>\n",
       "      <td>191,19</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>42,0</td>\n",
       "      <td>7,8</td>\n",
       "      <td>2,41</td>\n",
       "      <td>0,24</td>\n",
       "      <td>97,35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45,11</td>\n",
       "      <td>24,2</td>\n",
       "      <td>0,096</td>\n",
       "      <td>0,658</td>\n",
       "      <td>0,246</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aruba</th>\n",
       "      <td>LATIN AMER. &amp; CARIB</td>\n",
       "      <td>71891</td>\n",
       "      <td>193</td>\n",
       "      <td>372,5</td>\n",
       "      <td>35,49</td>\n",
       "      <td>0</td>\n",
       "      <td>5,89</td>\n",
       "      <td>28000.0</td>\n",
       "      <td>97,0</td>\n",
       "      <td>516,1</td>\n",
       "      <td>10,53</td>\n",
       "      <td>0</td>\n",
       "      <td>89,47</td>\n",
       "      <td>2</td>\n",
       "      <td>11,03</td>\n",
       "      <td>6,68</td>\n",
       "      <td>0,004</td>\n",
       "      <td>0,333</td>\n",
       "      <td>0,663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Belize</th>\n",
       "      <td>LATIN AMER. &amp; CARIB</td>\n",
       "      <td>287730</td>\n",
       "      <td>22966</td>\n",
       "      <td>12,5</td>\n",
       "      <td>1,68</td>\n",
       "      <td>0</td>\n",
       "      <td>25,69</td>\n",
       "      <td>4900.0</td>\n",
       "      <td>94,1</td>\n",
       "      <td>115,7</td>\n",
       "      <td>2,85</td>\n",
       "      <td>1,71</td>\n",
       "      <td>95,44</td>\n",
       "      <td>2</td>\n",
       "      <td>28,84</td>\n",
       "      <td>5,72</td>\n",
       "      <td>0,142</td>\n",
       "      <td>0,152</td>\n",
       "      <td>0,612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Benin</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>7862944</td>\n",
       "      <td>112620</td>\n",
       "      <td>69,8</td>\n",
       "      <td>0,11</td>\n",
       "      <td>0</td>\n",
       "      <td>85</td>\n",
       "      <td>1100.0</td>\n",
       "      <td>40,9</td>\n",
       "      <td>9,7</td>\n",
       "      <td>18,08</td>\n",
       "      <td>2,4</td>\n",
       "      <td>79,52</td>\n",
       "      <td>2</td>\n",
       "      <td>38,85</td>\n",
       "      <td>12,22</td>\n",
       "      <td>0,316</td>\n",
       "      <td>0,138</td>\n",
       "      <td>0,546</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bhutan</th>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>2279723</td>\n",
       "      <td>47000</td>\n",
       "      <td>48,5</td>\n",
       "      <td>0,00</td>\n",
       "      <td>0</td>\n",
       "      <td>100,44</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>42,2</td>\n",
       "      <td>14,3</td>\n",
       "      <td>3,09</td>\n",
       "      <td>0,43</td>\n",
       "      <td>96,48</td>\n",
       "      <td>2</td>\n",
       "      <td>33,65</td>\n",
       "      <td>12,7</td>\n",
       "      <td>0,258</td>\n",
       "      <td>0,379</td>\n",
       "      <td>0,363</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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Uganda</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>28195754</td>\n",
       "      <td>236040</td>\n",
       "      <td>119,5</td>\n",
       "      <td>0,00</td>\n",
       "      <td>0</td>\n",
       "      <td>67,83</td>\n",
       "      <td>1400.0</td>\n",
       "      <td>69,9</td>\n",
       "      <td>3,6</td>\n",
       "      <td>25,88</td>\n",
       "      <td>10,65</td>\n",
       "      <td>63,47</td>\n",
       "      <td>2</td>\n",
       "      <td>47,35</td>\n",
       "      <td>12,24</td>\n",
       "      <td>0,311</td>\n",
       "      <td>0,222</td>\n",
       "      <td>0,469</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vanuatu</th>\n",
       "      <td>OCEANIA</td>\n",
       "      <td>208869</td>\n",
       "      <td>12200</td>\n",
       "      <td>17,1</td>\n",
       "      <td>20,72</td>\n",
       "      <td>0</td>\n",
       "      <td>55,16</td>\n",
       "      <td>2900.0</td>\n",
       "      <td>53,0</td>\n",
       "      <td>32,6</td>\n",
       "      <td>2,46</td>\n",
       "      <td>7,38</td>\n",
       "      <td>90,16</td>\n",
       "      <td>2</td>\n",
       "      <td>22,72</td>\n",
       "      <td>7,82</td>\n",
       "      <td>0,26</td>\n",
       "      <td>0,12</td>\n",
       "      <td>0,62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yemen</th>\n",
       "      <td>NEAR EAST</td>\n",
       "      <td>21456188</td>\n",
       "      <td>527970</td>\n",
       "      <td>40,6</td>\n",
       "      <td>0,36</td>\n",
       "      <td>0</td>\n",
       "      <td>61,5</td>\n",
       "      <td>800.0</td>\n",
       "      <td>50,2</td>\n",
       "      <td>37,2</td>\n",
       "      <td>2,78</td>\n",
       "      <td>0,24</td>\n",
       "      <td>96,98</td>\n",
       "      <td>1</td>\n",
       "      <td>42,89</td>\n",
       "      <td>8,3</td>\n",
       "      <td>0,135</td>\n",
       "      <td>0,472</td>\n",
       "      <td>0,393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zambia</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>11502010</td>\n",
       "      <td>752614</td>\n",
       "      <td>15,3</td>\n",
       "      <td>0,00</td>\n",
       "      <td>0</td>\n",
       "      <td>88,29</td>\n",
       "      <td>800.0</td>\n",
       "      <td>80,6</td>\n",
       "      <td>8,2</td>\n",
       "      <td>7,08</td>\n",
       "      <td>0,03</td>\n",
       "      <td>92,9</td>\n",
       "      <td>2</td>\n",
       "      <td>41</td>\n",
       "      <td>19,93</td>\n",
       "      <td>0,22</td>\n",
       "      <td>0,29</td>\n",
       "      <td>0,489</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zimbabwe</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>12236805</td>\n",
       "      <td>390580</td>\n",
       "      <td>31,3</td>\n",
       "      <td>0,00</td>\n",
       "      <td>0</td>\n",
       "      <td>67,69</td>\n",
       "      <td>1900.0</td>\n",
       "      <td>90,7</td>\n",
       "      <td>26,8</td>\n",
       "      <td>8,32</td>\n",
       "      <td>0,34</td>\n",
       "      <td>91,34</td>\n",
       "      <td>2</td>\n",
       "      <td>28,01</td>\n",
       "      <td>21,84</td>\n",
       "      <td>0,179</td>\n",
       "      <td>0,243</td>\n",
       "      <td>0,579</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>62 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       Region  Population  Area (sq. mi.)  \\\n",
       "Country                                                                     \n",
       "Angola    SUB-SAHARAN AFRICA                     12127071         1246700   \n",
       "Aruba                 LATIN AMER. & CARIB           71891             193   \n",
       "Belize                LATIN AMER. & CARIB          287730           22966   \n",
       "Benin     SUB-SAHARAN AFRICA                      7862944          112620   \n",
       "Bhutan          ASIA (EX. NEAR EAST)              2279723           47000   \n",
       "...                                       ...         ...             ...   \n",
       "Uganda    SUB-SAHARAN AFRICA                     28195754          236040   \n",
       "Vanuatu   OCEANIA                                  208869           12200   \n",
       "Yemen     NEAR EAST                              21456188          527970   \n",
       "Zambia    SUB-SAHARAN AFRICA                     11502010          752614   \n",
       "Zimbabwe  SUB-SAHARAN AFRICA                     12236805          390580   \n",
       "\n",
       "            Pop Coastline (coast/area ratio) Nm  \\\n",
       "Country                                           \n",
       "Angola      9,7                         0,13  0   \n",
       "Aruba     372,5                        35,49  0   \n",
       "Belize     12,5                         1,68  0   \n",
       "Benin      69,8                         0,11  0   \n",
       "Bhutan     48,5                         0,00  0   \n",
       "...         ...                          ... ..   \n",
       "Uganda    119,5                         0,00  0   \n",
       "Vanuatu    17,1                        20,72  0   \n",
       "Yemen      40,6                         0,36  0   \n",
       "Zambia     15,3                         0,00  0   \n",
       "Zimbabwe   31,3                         0,00  0   \n",
       "\n",
       "         Infant mortality (per 1000 births)  GDP ($ per capita) Literacy (%)  \\\n",
       "Country                                                                        \n",
       "Angola                               191,19              1900.0         42,0   \n",
       "Aruba                                  5,89             28000.0         97,0   \n",
       "Belize                                25,69              4900.0         94,1   \n",
       "Benin                                    85              1100.0         40,9   \n",
       "Bhutan                               100,44              1300.0         42,2   \n",
       "...                                     ...                 ...          ...   \n",
       "Uganda                                67,83              1400.0         69,9   \n",
       "Vanuatu                               55,16              2900.0         53,0   \n",
       "Yemen                                  61,5               800.0         50,2   \n",
       "Zambia                                88,29               800.0         80,6   \n",
       "Zimbabwe                              67,69              1900.0         90,7   \n",
       "\n",
       "         Phones (per 1000) Arable (%) Crops (%) Other (%) Climate Birthrate  \\\n",
       "Country                                                                       \n",
       "Angola                 7,8       2,41      0,24     97,35     NaN     45,11   \n",
       "Aruba                516,1      10,53         0     89,47       2     11,03   \n",
       "Belize               115,7       2,85      1,71     95,44       2     28,84   \n",
       "Benin                  9,7      18,08       2,4     79,52       2     38,85   \n",
       "Bhutan                14,3       3,09      0,43     96,48       2     33,65   \n",
       "...                    ...        ...       ...       ...     ...       ...   \n",
       "Uganda                 3,6      25,88     10,65     63,47       2     47,35   \n",
       "Vanuatu               32,6       2,46      7,38     90,16       2     22,72   \n",
       "Yemen                 37,2       2,78      0,24     96,98       1     42,89   \n",
       "Zambia                 8,2       7,08      0,03      92,9       2        41   \n",
       "Zimbabwe              26,8       8,32      0,34     91,34       2     28,01   \n",
       "\n",
       "         Deathrate Agriculture Industry Service  \n",
       "Country                                          \n",
       "Angola        24,2       0,096    0,658   0,246  \n",
       "Aruba         6,68       0,004    0,333   0,663  \n",
       "Belize        5,72       0,142    0,152   0,612  \n",
       "Benin        12,22       0,316    0,138   0,546  \n",
       "Bhutan        12,7       0,258    0,379   0,363  \n",
       "...            ...         ...      ...     ...  \n",
       "Uganda       12,24       0,311    0,222   0,469  \n",
       "Vanuatu       7,82        0,26     0,12    0,62  \n",
       "Yemen          8,3       0,135    0,472   0,393  \n",
       "Zambia       19,93        0,22     0,29   0,489  \n",
       "Zimbabwe     21,84       0,179    0,243   0,579  \n",
       "\n",
       "[62 rows x 19 columns]"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[zero_migration_filter]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "id": "3ff6c242-7ce4-4d5a-bdec-2179326ea8e6",
   "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>Region</th>\n",
       "      <th>Pop</th>\n",
       "      <th>Nm</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Angola</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>9,7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Aruba</th>\n",
       "      <td>LATIN AMER. &amp; CARIB</td>\n",
       "      <td>372,5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Belize</th>\n",
       "      <td>LATIN AMER. &amp; CARIB</td>\n",
       "      <td>12,5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Benin</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>69,8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bhutan</th>\n",
       "      <td>ASIA (EX. NEAR EAST)</td>\n",
       "      <td>48,5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Uganda</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>119,5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Vanuatu</th>\n",
       "      <td>OCEANIA</td>\n",
       "      <td>17,1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yemen</th>\n",
       "      <td>NEAR EAST</td>\n",
       "      <td>40,6</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zambia</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>15,3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zimbabwe</th>\n",
       "      <td>SUB-SAHARAN AFRICA</td>\n",
       "      <td>31,3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>62 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       Region    Pop Nm\n",
       "Country                                                \n",
       "Angola    SUB-SAHARAN AFRICA                     9,7  0\n",
       "Aruba                 LATIN AMER. & CARIB      372,5  0\n",
       "Belize                LATIN AMER. & CARIB       12,5  0\n",
       "Benin     SUB-SAHARAN AFRICA                    69,8  0\n",
       "Bhutan          ASIA (EX. NEAR EAST)            48,5  0\n",
       "...                                       ...    ... ..\n",
       "Uganda    SUB-SAHARAN AFRICA                   119,5  0\n",
       "Vanuatu   OCEANIA                               17,1  0\n",
       "Yemen     NEAR EAST                             40,6  0\n",
       "Zambia    SUB-SAHARAN AFRICA                    15,3  0\n",
       "Zimbabwe  SUB-SAHARAN AFRICA                    31,3  0\n",
       "\n",
       "[62 rows x 3 columns]"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[zero_migration_filter, ['Region','Pop','Nm']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b92245e6-f6d6-4ebf-bd52-7f4073ac36ea",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.12.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}