gdpBarRacedata.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Untitled3.ipynb",
      "provenance": [],
      "collapsed_sections": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "LlG7ZR1Cc13p",
        "outputId": "3d034542-3865-4edf-8f98-c1574c4eb767"
      },
      "source": [
        "import seaborn as sns\n",
        "import numpy as np\n",
        "import matplotlib.pyplot as plt\n",
        "from mpl_toolkits.axes_grid.inset_locator import (inset_axes, InsetPosition,\n",
        "                                                  mark_inset)\n",
        "import pandas as pd"
      ],
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:4: MatplotlibDeprecationWarning: \n",
            "The mpl_toolkits.axes_grid module was deprecated in Matplotlib 2.1 and will be removed two minor releases later. Use mpl_toolkits.axes_grid1 and mpl_toolkits.axisartist, which provide the same functionality instead.\n",
            "  after removing the cwd from sys.path.\n"
          ],
          "name": "stderr"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "LSNqJOC3dbuv"
      },
      "source": [
        "data = pd.read_csv(\"GDP_billions2.csv\")\n"
      ],
      "execution_count": 68,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 304
        },
        "id": "UxJzFZdAd2ws",
        "outputId": "91a4ef4a-273a-478a-eeba-97668d1cb6c9"
      },
      "source": [
        "data.head()\n",
        "data.drop('South Asia', inplace=True, axis=1)\n",
        "data.head()"
      ],
      "execution_count": 69,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>date</th>\n",
              "      <th>United States</th>\n",
              "      <th>China</th>\n",
              "      <th>Japan</th>\n",
              "      <th>Germany</th>\n",
              "      <th>France</th>\n",
              "      <th>India</th>\n",
              "      <th>United Kingdom</th>\n",
              "      <th>Brazil</th>\n",
              "      <th>Italy</th>\n",
              "      <th>Canada</th>\n",
              "      <th>Russian Federation</th>\n",
              "      <th>Spain</th>\n",
              "      <th>Korea, Rep.</th>\n",
              "      <th>Australia</th>\n",
              "      <th>Mexico</th>\n",
              "      <th>Turkey</th>\n",
              "      <th>Indonesia</th>\n",
              "      <th>Netherlands</th>\n",
              "      <th>Saudi Arabia</th>\n",
              "      <th>Switzerland</th>\n",
              "      <th>Poland</th>\n",
              "      <th>Sweden</th>\n",
              "      <th>Belgium</th>\n",
              "      <th>Norway</th>\n",
              "      <th>Iran, Islamic Rep.</th>\n",
              "      <th>Nigeria</th>\n",
              "      <th>Thailand</th>\n",
              "      <th>Austria</th>\n",
              "      <th>Argentina</th>\n",
              "      <th>South Africa</th>\n",
              "      <th>United Arab Emirates</th>\n",
              "      <th>Malaysia</th>\n",
              "      <th>Colombia</th>\n",
              "      <th>Ireland</th>\n",
              "      <th>Denmark</th>\n",
              "      <th>Philippines</th>\n",
              "      <th>Singapore</th>\n",
              "      <th>Israel</th>\n",
              "      <th>Egypt, Arab Rep.</th>\n",
              "      <th>...</th>\n",
              "      <th>Mauritania</th>\n",
              "      <th>Kyrgyz Republic</th>\n",
              "      <th>Bermuda</th>\n",
              "      <th>Togo</th>\n",
              "      <th>Eswatini</th>\n",
              "      <th>Montenegro</th>\n",
              "      <th>Guyana</th>\n",
              "      <th>Suriname</th>\n",
              "      <th>Barbados</th>\n",
              "      <th>Maldives</th>\n",
              "      <th>Fiji</th>\n",
              "      <th>Sierra Leone</th>\n",
              "      <th>Andorra</th>\n",
              "      <th>Lesotho</th>\n",
              "      <th>Bhutan</th>\n",
              "      <th>Liberia</th>\n",
              "      <th>Burundi</th>\n",
              "      <th>Cabo Verde</th>\n",
              "      <th>Gambia, The</th>\n",
              "      <th>Central African Republic</th>\n",
              "      <th>St. Lucia</th>\n",
              "      <th>Belize</th>\n",
              "      <th>Antigua and Barbuda</th>\n",
              "      <th>Seychelles</th>\n",
              "      <th>Timor-Leste</th>\n",
              "      <th>Comoros</th>\n",
              "      <th>Guinea-Bissau</th>\n",
              "      <th>Solomon Islands</th>\n",
              "      <th>Grenada</th>\n",
              "      <th>St. Kitts and Nevis</th>\n",
              "      <th>Vanuatu</th>\n",
              "      <th>St. Vincent and the Grenadines</th>\n",
              "      <th>Samoa</th>\n",
              "      <th>Dominica</th>\n",
              "      <th>Tonga</th>\n",
              "      <th>Sao Tome and Principe</th>\n",
              "      <th>Kiribati</th>\n",
              "      <th>Palau</th>\n",
              "      <th>Nauru</th>\n",
              "      <th>Tuvalu</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1960</td>\n",
              "      <td>3170</td>\n",
              "      <td>128.0</td>\n",
              "      <td>796</td>\n",
              "      <td>0</td>\n",
              "      <td>594</td>\n",
              "      <td>149</td>\n",
              "      <td>730</td>\n",
              "      <td>247</td>\n",
              "      <td>546</td>\n",
              "      <td>294</td>\n",
              "      <td>0</td>\n",
              "      <td>225</td>\n",
              "      <td>23.3</td>\n",
              "      <td>199</td>\n",
              "      <td>148</td>\n",
              "      <td>87.2</td>\n",
              "      <td>60.6</td>\n",
              "      <td>188</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>135</td>\n",
              "      <td>119</td>\n",
              "      <td>83.0</td>\n",
              "      <td>65.3</td>\n",
              "      <td>61.4</td>\n",
              "      <td>15.6</td>\n",
              "      <td>91.8</td>\n",
              "      <td>116</td>\n",
              "      <td>79.1</td>\n",
              "      <td>0.0</td>\n",
              "      <td>11.0</td>\n",
              "      <td>37.6</td>\n",
              "      <td>0.0</td>\n",
              "      <td>94.1</td>\n",
              "      <td>28.9</td>\n",
              "      <td>5.8</td>\n",
              "      <td>18.6</td>\n",
              "      <td>15.4</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.5</td>\n",
              "      <td>0.6</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.5</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.7</td>\n",
              "      <td>0.9</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.2</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.6</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.9</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1961</td>\n",
              "      <td>3250</td>\n",
              "      <td>93.1</td>\n",
              "      <td>892</td>\n",
              "      <td>0</td>\n",
              "      <td>624</td>\n",
              "      <td>154</td>\n",
              "      <td>750</td>\n",
              "      <td>272</td>\n",
              "      <td>591</td>\n",
              "      <td>303</td>\n",
              "      <td>0</td>\n",
              "      <td>251</td>\n",
              "      <td>24.9</td>\n",
              "      <td>204</td>\n",
              "      <td>155</td>\n",
              "      <td>88.2</td>\n",
              "      <td>64.1</td>\n",
              "      <td>189</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>143</td>\n",
              "      <td>125</td>\n",
              "      <td>88.2</td>\n",
              "      <td>72.8</td>\n",
              "      <td>61.5</td>\n",
              "      <td>16.5</td>\n",
              "      <td>96.9</td>\n",
              "      <td>122</td>\n",
              "      <td>82.1</td>\n",
              "      <td>0.0</td>\n",
              "      <td>11.9</td>\n",
              "      <td>39.5</td>\n",
              "      <td>0.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>30.5</td>\n",
              "      <td>6.2</td>\n",
              "      <td>20.7</td>\n",
              "      <td>16.2</td>\n",
              "      <td>...</td>\n",
              "      <td>1.2</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.6</td>\n",
              "      <td>0.7</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.5</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.7</td>\n",
              "      <td>0.9</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.2</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.5</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.9</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1962</td>\n",
              "      <td>3440</td>\n",
              "      <td>87.9</td>\n",
              "      <td>972</td>\n",
              "      <td>0</td>\n",
              "      <td>666</td>\n",
              "      <td>159</td>\n",
              "      <td>758</td>\n",
              "      <td>286</td>\n",
              "      <td>628</td>\n",
              "      <td>326</td>\n",
              "      <td>0</td>\n",
              "      <td>276</td>\n",
              "      <td>25.9</td>\n",
              "      <td>207</td>\n",
              "      <td>162</td>\n",
              "      <td>93.1</td>\n",
              "      <td>65.2</td>\n",
              "      <td>202</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>149</td>\n",
              "      <td>132</td>\n",
              "      <td>90.7</td>\n",
              "      <td>79.0</td>\n",
              "      <td>64.0</td>\n",
              "      <td>17.7</td>\n",
              "      <td>99.5</td>\n",
              "      <td>121</td>\n",
              "      <td>87.2</td>\n",
              "      <td>0.0</td>\n",
              "      <td>12.6</td>\n",
              "      <td>41.6</td>\n",
              "      <td>0.0</td>\n",
              "      <td>106.0</td>\n",
              "      <td>32.0</td>\n",
              "      <td>6.7</td>\n",
              "      <td>22.8</td>\n",
              "      <td>16.8</td>\n",
              "      <td>...</td>\n",
              "      <td>1.2</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.6</td>\n",
              "      <td>0.7</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.6</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.7</td>\n",
              "      <td>0.9</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.3</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.6</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.9</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.2</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1963</td>\n",
              "      <td>3600</td>\n",
              "      <td>97.0</td>\n",
              "      <td>1050</td>\n",
              "      <td>0</td>\n",
              "      <td>708</td>\n",
              "      <td>168</td>\n",
              "      <td>795</td>\n",
              "      <td>289</td>\n",
              "      <td>663</td>\n",
              "      <td>343</td>\n",
              "      <td>0</td>\n",
              "      <td>303</td>\n",
              "      <td>28.2</td>\n",
              "      <td>220</td>\n",
              "      <td>175</td>\n",
              "      <td>102.0</td>\n",
              "      <td>63.8</td>\n",
              "      <td>209</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>157</td>\n",
              "      <td>137</td>\n",
              "      <td>94.1</td>\n",
              "      <td>84.7</td>\n",
              "      <td>69.5</td>\n",
              "      <td>19.1</td>\n",
              "      <td>104.0</td>\n",
              "      <td>114</td>\n",
              "      <td>93.6</td>\n",
              "      <td>0.0</td>\n",
              "      <td>13.6</td>\n",
              "      <td>43.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>106.0</td>\n",
              "      <td>34.2</td>\n",
              "      <td>7.4</td>\n",
              "      <td>25.2</td>\n",
              "      <td>18.6</td>\n",
              "      <td>...</td>\n",
              "      <td>1.2</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.6</td>\n",
              "      <td>0.7</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.4</td>\n",
              "      <td>1.1</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.8</td>\n",
              "      <td>0.9</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.3</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.6</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.9</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1964</td>\n",
              "      <td>3800</td>\n",
              "      <td>115.0</td>\n",
              "      <td>1180</td>\n",
              "      <td>0</td>\n",
              "      <td>755</td>\n",
              "      <td>181</td>\n",
              "      <td>839</td>\n",
              "      <td>299</td>\n",
              "      <td>681</td>\n",
              "      <td>366</td>\n",
              "      <td>0</td>\n",
              "      <td>319</td>\n",
              "      <td>30.9</td>\n",
              "      <td>235</td>\n",
              "      <td>196</td>\n",
              "      <td>107.0</td>\n",
              "      <td>66.0</td>\n",
              "      <td>226</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>168</td>\n",
              "      <td>147</td>\n",
              "      <td>98.8</td>\n",
              "      <td>92.5</td>\n",
              "      <td>73.0</td>\n",
              "      <td>20.4</td>\n",
              "      <td>110.0</td>\n",
              "      <td>126</td>\n",
              "      <td>101.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>14.3</td>\n",
              "      <td>45.6</td>\n",
              "      <td>0.0</td>\n",
              "      <td>116.0</td>\n",
              "      <td>35.4</td>\n",
              "      <td>7.2</td>\n",
              "      <td>27.2</td>\n",
              "      <td>20.7</td>\n",
              "      <td>...</td>\n",
              "      <td>1.5</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>0.8</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.5</td>\n",
              "      <td>1.2</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.8</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.3</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.6</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.9</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 186 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "   date  United States  China  Japan  ...  Kiribati  Palau  Nauru  Tuvalu\n",
              "0  1960           3170  128.0    796  ...       0.0    0.0    0.0       0\n",
              "1  1961           3250   93.1    892  ...       0.0    0.0    0.0       0\n",
              "2  1962           3440   87.9    972  ...       0.0    0.0    0.0       0\n",
              "3  1963           3600   97.0   1050  ...       0.0    0.0    0.0       0\n",
              "4  1964           3800  115.0   1180  ...       0.0    0.0    0.0       0\n",
              "\n",
              "[5 rows x 186 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 69
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "j1RrGdBed6cx"
      },
      "source": [
        "# usonly = data.iloc[:,:2]\n",
        "# usonly.head()"
      ],
      "execution_count": 70,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ArveJmzFgJz9"
      },
      "source": [
        ""
      ],
      "execution_count": 70,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "TUpbdovngwA3"
      },
      "source": [
        "rearranged = data.melt(id_vars=[\"date\"], \n",
        "        var_name=\"Country\", \n",
        "        value_name=\"Value\")"
      ],
      "execution_count": 71,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "id": "y7djfaWMhU6n",
        "outputId": "f5c40175-7217-44d1-815a-e1bce5c60f0e"
      },
      "source": [
        "rearranged"
      ],
      "execution_count": 72,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>date</th>\n",
              "      <th>Country</th>\n",
              "      <th>Value</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1960</td>\n",
              "      <td>United States</td>\n",
              "      <td>3170.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1961</td>\n",
              "      <td>United States</td>\n",
              "      <td>3250.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1962</td>\n",
              "      <td>United States</td>\n",
              "      <td>3440.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1963</td>\n",
              "      <td>United States</td>\n",
              "      <td>3600.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1964</td>\n",
              "      <td>United States</td>\n",
              "      <td>3800.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11095</th>\n",
              "      <td>2015</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11096</th>\n",
              "      <td>2016</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11097</th>\n",
              "      <td>2017</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11098</th>\n",
              "      <td>2018</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11099</th>\n",
              "      <td>2019</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>11100 rows × 3 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       date        Country   Value\n",
              "0      1960  United States  3170.0\n",
              "1      1961  United States  3250.0\n",
              "2      1962  United States  3440.0\n",
              "3      1963  United States  3600.0\n",
              "4      1964  United States  3800.0\n",
              "...     ...            ...     ...\n",
              "11095  2015         Tuvalu     0.0\n",
              "11096  2016         Tuvalu     0.0\n",
              "11097  2017         Tuvalu     0.0\n",
              "11098  2018         Tuvalu     0.0\n",
              "11099  2019         Tuvalu     0.0\n",
              "\n",
              "[11100 rows x 3 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 72
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "HSuQRJUBv8U9"
      },
      "source": [
        "rearranged['lastValue'] = rearranged['Value'].shift(1)"
      ],
      "execution_count": 75,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "I0QffWMQwOTe"
      },
      "source": [
        "rearranged.loc[rearranged.date == 1960, \"lastValue\"] = 0\n",
        "# rearranged[rearranged['Country'] == \"China\"]\n",
        "# rearranged"
      ],
      "execution_count": 89,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "id": "5Yk5qmZtxfUi",
        "outputId": "8e77906d-1c1a-44a2-fdde-5fca25de327e"
      },
      "source": [
        "rearranged"
      ],
      "execution_count": 90,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>date</th>\n",
              "      <th>Country</th>\n",
              "      <th>Value</th>\n",
              "      <th>lastValue</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1960</td>\n",
              "      <td>United States</td>\n",
              "      <td>3170.0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1961</td>\n",
              "      <td>United States</td>\n",
              "      <td>3250.0</td>\n",
              "      <td>3170</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1962</td>\n",
              "      <td>United States</td>\n",
              "      <td>3440.0</td>\n",
              "      <td>3250</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1963</td>\n",
              "      <td>United States</td>\n",
              "      <td>3600.0</td>\n",
              "      <td>3440</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1964</td>\n",
              "      <td>United States</td>\n",
              "      <td>3800.0</td>\n",
              "      <td>3600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11095</th>\n",
              "      <td>2015</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11096</th>\n",
              "      <td>2016</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11097</th>\n",
              "      <td>2017</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11098</th>\n",
              "      <td>2018</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11099</th>\n",
              "      <td>2019</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>11100 rows × 4 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       date        Country   Value lastValue\n",
              "0      1960  United States  3170.0         0\n",
              "1      1961  United States  3250.0      3170\n",
              "2      1962  United States  3440.0      3250\n",
              "3      1963  United States  3600.0      3440\n",
              "4      1964  United States  3800.0      3600\n",
              "...     ...            ...     ...       ...\n",
              "11095  2015         Tuvalu     0.0         0\n",
              "11096  2016         Tuvalu     0.0         0\n",
              "11097  2017         Tuvalu     0.0         0\n",
              "11098  2018         Tuvalu     0.0         0\n",
              "11099  2019         Tuvalu     0.0         0\n",
              "\n",
              "[11100 rows x 4 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 90
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "rahWECV5yEgz"
      },
      "source": [
        "# rearranged[rearranged['Country'] == \"India\"]\n"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "id": "MsHp9VQhhbwv",
        "outputId": "a6f6c940-d6dc-453d-9e7a-40289f4cde2d"
      },
      "source": [
        "rearranged = rearranged.sort_values([\"date\", \"Value\"], ascending = [True, False])\n",
        "rearranged"
      ],
      "execution_count": 94,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>date</th>\n",
              "      <th>Country</th>\n",
              "      <th>Value</th>\n",
              "      <th>lastValue</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1960</td>\n",
              "      <td>United States</td>\n",
              "      <td>3170.0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>120</th>\n",
              "      <td>1960</td>\n",
              "      <td>Japan</td>\n",
              "      <td>796.0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>360</th>\n",
              "      <td>1960</td>\n",
              "      <td>United Kingdom</td>\n",
              "      <td>730.0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>240</th>\n",
              "      <td>1960</td>\n",
              "      <td>France</td>\n",
              "      <td>594.0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>480</th>\n",
              "      <td>1960</td>\n",
              "      <td>Italy</td>\n",
              "      <td>546.0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10859</th>\n",
              "      <td>2019</td>\n",
              "      <td>Sao Tome and Principe</td>\n",
              "      <td>0.3</td>\n",
              "      <td>0.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10919</th>\n",
              "      <td>2019</td>\n",
              "      <td>Kiribati</td>\n",
              "      <td>0.2</td>\n",
              "      <td>0.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10979</th>\n",
              "      <td>2019</td>\n",
              "      <td>Palau</td>\n",
              "      <td>0.2</td>\n",
              "      <td>0.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11039</th>\n",
              "      <td>2019</td>\n",
              "      <td>Nauru</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11099</th>\n",
              "      <td>2019</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>11100 rows × 4 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       date                Country   Value lastValue\n",
              "0      1960          United States  3170.0         0\n",
              "120    1960                  Japan   796.0         0\n",
              "360    1960         United Kingdom   730.0         0\n",
              "240    1960                 France   594.0         0\n",
              "480    1960                  Italy   546.0         0\n",
              "...     ...                    ...     ...       ...\n",
              "10859  2019  Sao Tome and Principe     0.3       0.3\n",
              "10919  2019               Kiribati     0.2       0.2\n",
              "10979  2019                  Palau     0.2       0.2\n",
              "11039  2019                  Nauru     0.1       0.1\n",
              "11099  2019                 Tuvalu     0.0         0\n",
              "\n",
              "[11100 rows x 4 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 94
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "bocPZZtMhmjO",
        "outputId": "ce6ae208-8c93-4156-f6be-136afde2c025"
      },
      "source": [
        "##list of ranks from 1 to 185\n",
        "ranks = [x+1 for x in range(185)]\n",
        "rearranged['Rank']= pd.np.tile(ranks, len(rearranged) // len(ranks)).tolist() + ranks[:len(rearranged)%len(ranks)]\n"
      ],
      "execution_count": 95,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:3: FutureWarning: The pandas.np module is deprecated and will be removed from pandas in a future version. Import numpy directly instead\n",
            "  This is separate from the ipykernel package so we can avoid doing imports until\n"
          ],
          "name": "stderr"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "id": "-0YMOTdElzEd",
        "outputId": "82911f38-be52-48c3-dff7-07116730b75e"
      },
      "source": [
        "rearranged"
      ],
      "execution_count": 96,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>date</th>\n",
              "      <th>Country</th>\n",
              "      <th>Value</th>\n",
              "      <th>lastValue</th>\n",
              "      <th>Rank</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1960</td>\n",
              "      <td>United States</td>\n",
              "      <td>3170.0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>120</th>\n",
              "      <td>1960</td>\n",
              "      <td>Japan</td>\n",
              "      <td>796.0</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>360</th>\n",
              "      <td>1960</td>\n",
              "      <td>United Kingdom</td>\n",
              "      <td>730.0</td>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>240</th>\n",
              "      <td>1960</td>\n",
              "      <td>France</td>\n",
              "      <td>594.0</td>\n",
              "      <td>0</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>480</th>\n",
              "      <td>1960</td>\n",
              "      <td>Italy</td>\n",
              "      <td>546.0</td>\n",
              "      <td>0</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10859</th>\n",
              "      <td>2019</td>\n",
              "      <td>Sao Tome and Principe</td>\n",
              "      <td>0.3</td>\n",
              "      <td>0.3</td>\n",
              "      <td>181</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10919</th>\n",
              "      <td>2019</td>\n",
              "      <td>Kiribati</td>\n",
              "      <td>0.2</td>\n",
              "      <td>0.2</td>\n",
              "      <td>182</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10979</th>\n",
              "      <td>2019</td>\n",
              "      <td>Palau</td>\n",
              "      <td>0.2</td>\n",
              "      <td>0.2</td>\n",
              "      <td>183</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11039</th>\n",
              "      <td>2019</td>\n",
              "      <td>Nauru</td>\n",
              "      <td>0.1</td>\n",
              "      <td>0.1</td>\n",
              "      <td>184</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11099</th>\n",
              "      <td>2019</td>\n",
              "      <td>Tuvalu</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0</td>\n",
              "      <td>185</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>11100 rows × 5 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       date                Country   Value lastValue  Rank\n",
              "0      1960          United States  3170.0         0     1\n",
              "120    1960                  Japan   796.0         0     2\n",
              "360    1960         United Kingdom   730.0         0     3\n",
              "240    1960                 France   594.0         0     4\n",
              "480    1960                  Italy   546.0         0     5\n",
              "...     ...                    ...     ...       ...   ...\n",
              "10859  2019  Sao Tome and Principe     0.3       0.3   181\n",
              "10919  2019               Kiribati     0.2       0.2   182\n",
              "10979  2019                  Palau     0.2       0.2   183\n",
              "11039  2019                  Nauru     0.1       0.1   184\n",
              "11099  2019                 Tuvalu     0.0         0   185\n",
              "\n",
              "[11100 rows x 5 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 96
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "6F8b7i3Gm4LQ"
      },
      "source": [
        "rearranged.to_csv('rearranged.csv')"
      ],
      "execution_count": 97,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "hm-4CnYIlzhm"
      },
      "source": [
        "# https://stackoverflow.com/questions/50804427/how-to-create-a-column-with-repeating-values-pandas-mismatching-indexes\n",
        "# https://stackoverflow.com/questions/49968316/groupwise-sorting-in-pandas"
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}