SummariseData.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'/Users/marie-louise/Documents/sites/JupyterNotebooks/PublicationScripts'"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "os.getcwd()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['versicolor.csv',\n",
       " 'Excel_diff.xlsx',\n",
       " '.DS_Store',\n",
       " 'learning_objectives.md',\n",
       " 'SummariseData.ipynb',\n",
       " 'merge_csv.ipynb',\n",
       " 'Filter.ipynb',\n",
       " 'setosa.csv',\n",
       " 'README.md',\n",
       " 'compareData.ipynb',\n",
       " 'quality_assurance.ipynb',\n",
       " '.gitignore',\n",
       " 'returns-datasets-sep-2020.xlsx',\n",
       " '.ipynb_checkpoints',\n",
       " 'test_merge.csv',\n",
       " '.git',\n",
       " '.idea']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "os.listdir(os.getcwd())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Pivot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_D01 = pd.read_excel (r'returns-datasets-sep-2020.xlsx', sheet_name='Data - Ret_D01')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Year', 'Quarter', 'Nationality', 'Region', 'Return type group',\n",
       "       'Return type', 'Age', 'Sex', 'Return destination group',\n",
       "       'Number of returns'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_D01.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>Year</th>\n",
       "      <th>Quarter</th>\n",
       "      <th>Nationality</th>\n",
       "      <th>Region</th>\n",
       "      <th>Return type group</th>\n",
       "      <th>Return type</th>\n",
       "      <th>Age</th>\n",
       "      <th>Sex</th>\n",
       "      <th>Return destination group</th>\n",
       "      <th>Number of returns</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2004</td>\n",
       "      <td>2004 Q1</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Asia Central</td>\n",
       "      <td>Enforced return</td>\n",
       "      <td>Enforced removals</td>\n",
       "      <td>Under 18</td>\n",
       "      <td>Male</td>\n",
       "      <td>EU Member State</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2004</td>\n",
       "      <td>2004 Q1</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Asia Central</td>\n",
       "      <td>Enforced return</td>\n",
       "      <td>Enforced removals</td>\n",
       "      <td>Under 18</td>\n",
       "      <td>Male</td>\n",
       "      <td>Other country</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2004</td>\n",
       "      <td>2004 Q1</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Asia Central</td>\n",
       "      <td>Enforced return</td>\n",
       "      <td>Enforced removals</td>\n",
       "      <td>18-29</td>\n",
       "      <td>Male</td>\n",
       "      <td>EU Member State</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Year  Quarter  Nationality        Region Return type group  \\\n",
       "0  2004  2004 Q1  Afghanistan  Asia Central   Enforced return   \n",
       "1  2004  2004 Q1  Afghanistan  Asia Central   Enforced return   \n",
       "2  2004  2004 Q1  Afghanistan  Asia Central   Enforced return   \n",
       "\n",
       "         Return type       Age   Sex Return destination group  \\\n",
       "0  Enforced removals  Under 18  Male          EU Member State   \n",
       "1  Enforced removals  Under 18  Male            Other country   \n",
       "2  Enforced removals     18-29  Male          EU Member State   \n",
       "\n",
       "   Number of returns  \n",
       "0                  6  \n",
       "1                  1  \n",
       "2                 39  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_D01.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "210895    2020 Q2\n",
       "210896    2020 Q2\n",
       "210897    2020 Q2\n",
       "210898    2020 Q2\n",
       "210899    2020 Q2\n",
       "210900    2020 Q2\n",
       "210901    2020 Q2\n",
       "Name: Quarter, dtype: object"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_D01['Quarter'][210895:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "pivot = df_D01.pivot_table(index=['Return type group', 'Return type',], columns=['Quarter'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th colspan=\"10\" halign=\"left\">Number of returns</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"10\" halign=\"left\">Year</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>Quarter</th>\n",
       "      <th>2004 Q1</th>\n",
       "      <th>2004 Q2</th>\n",
       "      <th>2004 Q3</th>\n",
       "      <th>2004 Q4</th>\n",
       "      <th>2005 Q1</th>\n",
       "      <th>2005 Q2</th>\n",
       "      <th>2005 Q3</th>\n",
       "      <th>2005 Q4</th>\n",
       "      <th>2006 Q1</th>\n",
       "      <th>2006 Q2</th>\n",
       "      <th>...</th>\n",
       "      <th>2018 Q1</th>\n",
       "      <th>2018 Q2</th>\n",
       "      <th>2018 Q3</th>\n",
       "      <th>2018 Q4</th>\n",
       "      <th>2019 Q1</th>\n",
       "      <th>2019 Q2</th>\n",
       "      <th>2019 Q3</th>\n",
       "      <th>2019 Q4</th>\n",
       "      <th>2020 Q1</th>\n",
       "      <th>2020 Q2</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Return type group</th>\n",
       "      <th>Return type</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",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Enforced return</th>\n",
       "      <th>Enforced removals</th>\n",
       "      <td>7.908163</td>\n",
       "      <td>6.613184</td>\n",
       "      <td>6.359948</td>\n",
       "      <td>6.740988</td>\n",
       "      <td>6.714286</td>\n",
       "      <td>6.631847</td>\n",
       "      <td>6.546366</td>\n",
       "      <td>7.038158</td>\n",
       "      <td>6.912821</td>\n",
       "      <td>7.008380</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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>Enforced removals from detention</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Non-detained Enforced removals</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Non-detained enforced removals</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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>Other returns from detention</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">Refused entry at port and subsequently departed</th>\n",
       "      <th>Departed from Juxtaposed controls</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Departed from UK Ports</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>N/A - pre-2007</th>\n",
       "      <td>8.667990</td>\n",
       "      <td>6.701853</td>\n",
       "      <td>6.304450</td>\n",
       "      <td>6.779648</td>\n",
       "      <td>6.443478</td>\n",
       "      <td>6.362343</td>\n",
       "      <td>5.755700</td>\n",
       "      <td>6.694974</td>\n",
       "      <td>6.636042</td>\n",
       "      <td>6.662862</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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 rowspan=\"3\" valign=\"top\">Voluntary return</th>\n",
       "      <th>Assisted returns</th>\n",
       "      <td>3.473958</td>\n",
       "      <td>3.271795</td>\n",
       "      <td>4.026596</td>\n",
       "      <td>3.431579</td>\n",
       "      <td>3.725581</td>\n",
       "      <td>3.975728</td>\n",
       "      <td>4.260163</td>\n",
       "      <td>4.182203</td>\n",
       "      <td>5.315254</td>\n",
       "      <td>5.385604</td>\n",
       "      <td>...</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Controlled returns</th>\n",
       "      <td>1.507042</td>\n",
       "      <td>1.471429</td>\n",
       "      <td>1.671329</td>\n",
       "      <td>1.569106</td>\n",
       "      <td>2.469231</td>\n",
       "      <td>1.488372</td>\n",
       "      <td>2.981383</td>\n",
       "      <td>3.660494</td>\n",
       "      <td>2.230366</td>\n",
       "      <td>2.004651</td>\n",
       "      <td>...</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other verified returns</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.818182</td>\n",
       "      <td>3.361111</td>\n",
       "      <td>2.346667</td>\n",
       "      <td>2.294118</td>\n",
       "      <td>2.909091</td>\n",
       "      <td>3.049419</td>\n",
       "      <td>...</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2018.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2019.0</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>2020.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>11 rows × 132 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                  Number of returns  \\\n",
       "Quarter                                                                                     2004 Q1   \n",
       "Return type group                               Return type                                           \n",
       "Enforced return                                 Enforced removals                          7.908163   \n",
       "                                                Enforced removals from detention                NaN   \n",
       "                                                Non-detained Enforced removals                  NaN   \n",
       "                                                Non-detained enforced removals                  NaN   \n",
       "                                                Other returns from detention                    NaN   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls               NaN   \n",
       "                                                Departed from UK Ports                          NaN   \n",
       "                                                N/A - pre-2007                             8.667990   \n",
       "Voluntary return                                Assisted returns                           3.473958   \n",
       "                                                Controlled returns                         1.507042   \n",
       "                                                Other verified returns                          NaN   \n",
       "\n",
       "                                                                                             \\\n",
       "Quarter                                                                             2004 Q2   \n",
       "Return type group                               Return type                                   \n",
       "Enforced return                                 Enforced removals                  6.613184   \n",
       "                                                Enforced removals from detention        NaN   \n",
       "                                                Non-detained Enforced removals          NaN   \n",
       "                                                Non-detained enforced removals          NaN   \n",
       "                                                Other returns from detention            NaN   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls       NaN   \n",
       "                                                Departed from UK Ports                  NaN   \n",
       "                                                N/A - pre-2007                     6.701853   \n",
       "Voluntary return                                Assisted returns                   3.271795   \n",
       "                                                Controlled returns                 1.471429   \n",
       "                                                Other verified returns                  NaN   \n",
       "\n",
       "                                                                                             \\\n",
       "Quarter                                                                             2004 Q3   \n",
       "Return type group                               Return type                                   \n",
       "Enforced return                                 Enforced removals                  6.359948   \n",
       "                                                Enforced removals from detention        NaN   \n",
       "                                                Non-detained Enforced removals          NaN   \n",
       "                                                Non-detained enforced removals          NaN   \n",
       "                                                Other returns from detention            NaN   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls       NaN   \n",
       "                                                Departed from UK Ports                  NaN   \n",
       "                                                N/A - pre-2007                     6.304450   \n",
       "Voluntary return                                Assisted returns                   4.026596   \n",
       "                                                Controlled returns                 1.671329   \n",
       "                                                Other verified returns                  NaN   \n",
       "\n",
       "                                                                                             \\\n",
       "Quarter                                                                             2004 Q4   \n",
       "Return type group                               Return type                                   \n",
       "Enforced return                                 Enforced removals                  6.740988   \n",
       "                                                Enforced removals from detention        NaN   \n",
       "                                                Non-detained Enforced removals          NaN   \n",
       "                                                Non-detained enforced removals          NaN   \n",
       "                                                Other returns from detention            NaN   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls       NaN   \n",
       "                                                Departed from UK Ports                  NaN   \n",
       "                                                N/A - pre-2007                     6.779648   \n",
       "Voluntary return                                Assisted returns                   3.431579   \n",
       "                                                Controlled returns                 1.569106   \n",
       "                                                Other verified returns                  NaN   \n",
       "\n",
       "                                                                                             \\\n",
       "Quarter                                                                             2005 Q1   \n",
       "Return type group                               Return type                                   \n",
       "Enforced return                                 Enforced removals                  6.714286   \n",
       "                                                Enforced removals from detention        NaN   \n",
       "                                                Non-detained Enforced removals          NaN   \n",
       "                                                Non-detained enforced removals          NaN   \n",
       "                                                Other returns from detention            NaN   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls       NaN   \n",
       "                                                Departed from UK Ports                  NaN   \n",
       "                                                N/A - pre-2007                     6.443478   \n",
       "Voluntary return                                Assisted returns                   3.725581   \n",
       "                                                Controlled returns                 2.469231   \n",
       "                                                Other verified returns             1.818182   \n",
       "\n",
       "                                                                                             \\\n",
       "Quarter                                                                             2005 Q2   \n",
       "Return type group                               Return type                                   \n",
       "Enforced return                                 Enforced removals                  6.631847   \n",
       "                                                Enforced removals from detention        NaN   \n",
       "                                                Non-detained Enforced removals          NaN   \n",
       "                                                Non-detained enforced removals          NaN   \n",
       "                                                Other returns from detention            NaN   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls       NaN   \n",
       "                                                Departed from UK Ports                  NaN   \n",
       "                                                N/A - pre-2007                     6.362343   \n",
       "Voluntary return                                Assisted returns                   3.975728   \n",
       "                                                Controlled returns                 1.488372   \n",
       "                                                Other verified returns             3.361111   \n",
       "\n",
       "                                                                                             \\\n",
       "Quarter                                                                             2005 Q3   \n",
       "Return type group                               Return type                                   \n",
       "Enforced return                                 Enforced removals                  6.546366   \n",
       "                                                Enforced removals from detention        NaN   \n",
       "                                                Non-detained Enforced removals          NaN   \n",
       "                                                Non-detained enforced removals          NaN   \n",
       "                                                Other returns from detention            NaN   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls       NaN   \n",
       "                                                Departed from UK Ports                  NaN   \n",
       "                                                N/A - pre-2007                     5.755700   \n",
       "Voluntary return                                Assisted returns                   4.260163   \n",
       "                                                Controlled returns                 2.981383   \n",
       "                                                Other verified returns             2.346667   \n",
       "\n",
       "                                                                                             \\\n",
       "Quarter                                                                             2005 Q4   \n",
       "Return type group                               Return type                                   \n",
       "Enforced return                                 Enforced removals                  7.038158   \n",
       "                                                Enforced removals from detention        NaN   \n",
       "                                                Non-detained Enforced removals          NaN   \n",
       "                                                Non-detained enforced removals          NaN   \n",
       "                                                Other returns from detention            NaN   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls       NaN   \n",
       "                                                Departed from UK Ports                  NaN   \n",
       "                                                N/A - pre-2007                     6.694974   \n",
       "Voluntary return                                Assisted returns                   4.182203   \n",
       "                                                Controlled returns                 3.660494   \n",
       "                                                Other verified returns             2.294118   \n",
       "\n",
       "                                                                                             \\\n",
       "Quarter                                                                             2006 Q1   \n",
       "Return type group                               Return type                                   \n",
       "Enforced return                                 Enforced removals                  6.912821   \n",
       "                                                Enforced removals from detention        NaN   \n",
       "                                                Non-detained Enforced removals          NaN   \n",
       "                                                Non-detained enforced removals          NaN   \n",
       "                                                Other returns from detention            NaN   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls       NaN   \n",
       "                                                Departed from UK Ports                  NaN   \n",
       "                                                N/A - pre-2007                     6.636042   \n",
       "Voluntary return                                Assisted returns                   5.315254   \n",
       "                                                Controlled returns                 2.230366   \n",
       "                                                Other verified returns             2.909091   \n",
       "\n",
       "                                                                                             \\\n",
       "Quarter                                                                             2006 Q2   \n",
       "Return type group                               Return type                                   \n",
       "Enforced return                                 Enforced removals                  7.008380   \n",
       "                                                Enforced removals from detention        NaN   \n",
       "                                                Non-detained Enforced removals          NaN   \n",
       "                                                Non-detained enforced removals          NaN   \n",
       "                                                Other returns from detention            NaN   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls       NaN   \n",
       "                                                Departed from UK Ports                  NaN   \n",
       "                                                N/A - pre-2007                     6.662862   \n",
       "Voluntary return                                Assisted returns                   5.385604   \n",
       "                                                Controlled returns                 2.004651   \n",
       "                                                Other verified returns             3.049419   \n",
       "\n",
       "                                                                                   ...  \\\n",
       "Quarter                                                                            ...   \n",
       "Return type group                               Return type                        ...   \n",
       "Enforced return                                 Enforced removals                  ...   \n",
       "                                                Enforced removals from detention   ...   \n",
       "                                                Non-detained Enforced removals     ...   \n",
       "                                                Non-detained enforced removals     ...   \n",
       "                                                Other returns from detention       ...   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls  ...   \n",
       "                                                Departed from UK Ports             ...   \n",
       "                                                N/A - pre-2007                     ...   \n",
       "Voluntary return                                Assisted returns                   ...   \n",
       "                                                Controlled returns                 ...   \n",
       "                                                Other verified returns             ...   \n",
       "\n",
       "                                                                                     Year  \\\n",
       "Quarter                                                                           2018 Q1   \n",
       "Return type group                               Return type                                 \n",
       "Enforced return                                 Enforced removals                     NaN   \n",
       "                                                Enforced removals from detention   2018.0   \n",
       "                                                Non-detained Enforced removals        NaN   \n",
       "                                                Non-detained enforced removals     2018.0   \n",
       "                                                Other returns from detention       2018.0   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls  2018.0   \n",
       "                                                Departed from UK Ports             2018.0   \n",
       "                                                N/A - pre-2007                        NaN   \n",
       "Voluntary return                                Assisted returns                   2018.0   \n",
       "                                                Controlled returns                 2018.0   \n",
       "                                                Other verified returns             2018.0   \n",
       "\n",
       "                                                                                           \\\n",
       "Quarter                                                                           2018 Q2   \n",
       "Return type group                               Return type                                 \n",
       "Enforced return                                 Enforced removals                     NaN   \n",
       "                                                Enforced removals from detention   2018.0   \n",
       "                                                Non-detained Enforced removals        NaN   \n",
       "                                                Non-detained enforced removals     2018.0   \n",
       "                                                Other returns from detention       2018.0   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls  2018.0   \n",
       "                                                Departed from UK Ports             2018.0   \n",
       "                                                N/A - pre-2007                        NaN   \n",
       "Voluntary return                                Assisted returns                   2018.0   \n",
       "                                                Controlled returns                 2018.0   \n",
       "                                                Other verified returns             2018.0   \n",
       "\n",
       "                                                                                           \\\n",
       "Quarter                                                                           2018 Q3   \n",
       "Return type group                               Return type                                 \n",
       "Enforced return                                 Enforced removals                     NaN   \n",
       "                                                Enforced removals from detention   2018.0   \n",
       "                                                Non-detained Enforced removals     2018.0   \n",
       "                                                Non-detained enforced removals        NaN   \n",
       "                                                Other returns from detention       2018.0   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls  2018.0   \n",
       "                                                Departed from UK Ports             2018.0   \n",
       "                                                N/A - pre-2007                        NaN   \n",
       "Voluntary return                                Assisted returns                   2018.0   \n",
       "                                                Controlled returns                 2018.0   \n",
       "                                                Other verified returns             2018.0   \n",
       "\n",
       "                                                                                           \\\n",
       "Quarter                                                                           2018 Q4   \n",
       "Return type group                               Return type                                 \n",
       "Enforced return                                 Enforced removals                     NaN   \n",
       "                                                Enforced removals from detention   2018.0   \n",
       "                                                Non-detained Enforced removals     2018.0   \n",
       "                                                Non-detained enforced removals        NaN   \n",
       "                                                Other returns from detention       2018.0   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls  2018.0   \n",
       "                                                Departed from UK Ports             2018.0   \n",
       "                                                N/A - pre-2007                        NaN   \n",
       "Voluntary return                                Assisted returns                   2018.0   \n",
       "                                                Controlled returns                 2018.0   \n",
       "                                                Other verified returns             2018.0   \n",
       "\n",
       "                                                                                           \\\n",
       "Quarter                                                                           2019 Q1   \n",
       "Return type group                               Return type                                 \n",
       "Enforced return                                 Enforced removals                     NaN   \n",
       "                                                Enforced removals from detention   2019.0   \n",
       "                                                Non-detained Enforced removals     2019.0   \n",
       "                                                Non-detained enforced removals        NaN   \n",
       "                                                Other returns from detention       2019.0   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls  2019.0   \n",
       "                                                Departed from UK Ports             2019.0   \n",
       "                                                N/A - pre-2007                        NaN   \n",
       "Voluntary return                                Assisted returns                   2019.0   \n",
       "                                                Controlled returns                 2019.0   \n",
       "                                                Other verified returns             2019.0   \n",
       "\n",
       "                                                                                           \\\n",
       "Quarter                                                                           2019 Q2   \n",
       "Return type group                               Return type                                 \n",
       "Enforced return                                 Enforced removals                     NaN   \n",
       "                                                Enforced removals from detention   2019.0   \n",
       "                                                Non-detained Enforced removals     2019.0   \n",
       "                                                Non-detained enforced removals        NaN   \n",
       "                                                Other returns from detention       2019.0   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls  2019.0   \n",
       "                                                Departed from UK Ports             2019.0   \n",
       "                                                N/A - pre-2007                        NaN   \n",
       "Voluntary return                                Assisted returns                   2019.0   \n",
       "                                                Controlled returns                 2019.0   \n",
       "                                                Other verified returns             2019.0   \n",
       "\n",
       "                                                                                           \\\n",
       "Quarter                                                                           2019 Q3   \n",
       "Return type group                               Return type                                 \n",
       "Enforced return                                 Enforced removals                     NaN   \n",
       "                                                Enforced removals from detention   2019.0   \n",
       "                                                Non-detained Enforced removals     2019.0   \n",
       "                                                Non-detained enforced removals        NaN   \n",
       "                                                Other returns from detention       2019.0   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls  2019.0   \n",
       "                                                Departed from UK Ports             2019.0   \n",
       "                                                N/A - pre-2007                        NaN   \n",
       "Voluntary return                                Assisted returns                   2019.0   \n",
       "                                                Controlled returns                 2019.0   \n",
       "                                                Other verified returns             2019.0   \n",
       "\n",
       "                                                                                           \\\n",
       "Quarter                                                                           2019 Q4   \n",
       "Return type group                               Return type                                 \n",
       "Enforced return                                 Enforced removals                     NaN   \n",
       "                                                Enforced removals from detention   2019.0   \n",
       "                                                Non-detained Enforced removals     2019.0   \n",
       "                                                Non-detained enforced removals        NaN   \n",
       "                                                Other returns from detention       2019.0   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls  2019.0   \n",
       "                                                Departed from UK Ports             2019.0   \n",
       "                                                N/A - pre-2007                        NaN   \n",
       "Voluntary return                                Assisted returns                   2019.0   \n",
       "                                                Controlled returns                 2019.0   \n",
       "                                                Other verified returns             2019.0   \n",
       "\n",
       "                                                                                           \\\n",
       "Quarter                                                                           2020 Q1   \n",
       "Return type group                               Return type                                 \n",
       "Enforced return                                 Enforced removals                     NaN   \n",
       "                                                Enforced removals from detention   2020.0   \n",
       "                                                Non-detained Enforced removals     2020.0   \n",
       "                                                Non-detained enforced removals        NaN   \n",
       "                                                Other returns from detention       2020.0   \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls  2020.0   \n",
       "                                                Departed from UK Ports             2020.0   \n",
       "                                                N/A - pre-2007                        NaN   \n",
       "Voluntary return                                Assisted returns                   2020.0   \n",
       "                                                Controlled returns                 2020.0   \n",
       "                                                Other verified returns             2020.0   \n",
       "\n",
       "                                                                                           \n",
       "Quarter                                                                           2020 Q2  \n",
       "Return type group                               Return type                                \n",
       "Enforced return                                 Enforced removals                     NaN  \n",
       "                                                Enforced removals from detention   2020.0  \n",
       "                                                Non-detained Enforced removals     2020.0  \n",
       "                                                Non-detained enforced removals        NaN  \n",
       "                                                Other returns from detention       2020.0  \n",
       "Refused entry at port and subsequently departed Departed from Juxtaposed controls  2020.0  \n",
       "                                                Departed from UK Ports             2020.0  \n",
       "                                                N/A - pre-2007                        NaN  \n",
       "Voluntary return                                Assisted returns                   2020.0  \n",
       "                                                Controlled returns                 2020.0  \n",
       "                                                Other verified returns             2020.0  \n",
       "\n",
       "[11 rows x 132 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pivot"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_Ret = pd.read_excel (r'returns-datasets-sep-2020.xlsx', sheet_name='Ret_D01', skiprows = 8)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>Row Labels</th>\n",
       "      <th>2010 Q1</th>\n",
       "      <th>2010 Q2</th>\n",
       "      <th>2010 Q3</th>\n",
       "      <th>2010 Q4</th>\n",
       "      <th>2011 Q1</th>\n",
       "      <th>2011 Q2</th>\n",
       "      <th>2011 Q3</th>\n",
       "      <th>2011 Q4</th>\n",
       "      <th>2012 Q1</th>\n",
       "      <th>...</th>\n",
       "      <th>2018 Q2</th>\n",
       "      <th>2018 Q3</th>\n",
       "      <th>2018 Q4</th>\n",
       "      <th>2019 Q1</th>\n",
       "      <th>2019 Q2</th>\n",
       "      <th>2019 Q3</th>\n",
       "      <th>2019 Q4</th>\n",
       "      <th>2020 Q1</th>\n",
       "      <th>2020 Q2</th>\n",
       "      <th>Grand Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Enforced return</td>\n",
       "      <td>3568</td>\n",
       "      <td>3236</td>\n",
       "      <td>3654</td>\n",
       "      <td>3470</td>\n",
       "      <td>3765</td>\n",
       "      <td>3277</td>\n",
       "      <td>3527</td>\n",
       "      <td>3997</td>\n",
       "      <td>3774</td>\n",
       "      <td>...</td>\n",
       "      <td>2367</td>\n",
       "      <td>2115</td>\n",
       "      <td>2089</td>\n",
       "      <td>1892</td>\n",
       "      <td>1799</td>\n",
       "      <td>1686</td>\n",
       "      <td>1817</td>\n",
       "      <td>1344</td>\n",
       "      <td>361</td>\n",
       "      <td>126721</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Enforced removals from detention</td>\n",
       "      <td>3011</td>\n",
       "      <td>2794</td>\n",
       "      <td>3147</td>\n",
       "      <td>3011</td>\n",
       "      <td>3313</td>\n",
       "      <td>2801</td>\n",
       "      <td>2985</td>\n",
       "      <td>3340</td>\n",
       "      <td>3182</td>\n",
       "      <td>...</td>\n",
       "      <td>1583</td>\n",
       "      <td>1397</td>\n",
       "      <td>1350</td>\n",
       "      <td>1345</td>\n",
       "      <td>1223</td>\n",
       "      <td>1179</td>\n",
       "      <td>1209</td>\n",
       "      <td>977</td>\n",
       "      <td>109</td>\n",
       "      <td>97033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Non-detained Enforced removals</td>\n",
       "      <td>244</td>\n",
       "      <td>130</td>\n",
       "      <td>149</td>\n",
       "      <td>164</td>\n",
       "      <td>128</td>\n",
       "      <td>194</td>\n",
       "      <td>148</td>\n",
       "      <td>171</td>\n",
       "      <td>153</td>\n",
       "      <td>...</td>\n",
       "      <td>222</td>\n",
       "      <td>219</td>\n",
       "      <td>192</td>\n",
       "      <td>188</td>\n",
       "      <td>207</td>\n",
       "      <td>185</td>\n",
       "      <td>216</td>\n",
       "      <td>132</td>\n",
       "      <td>14</td>\n",
       "      <td>9448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Other returns from detention</td>\n",
       "      <td>313</td>\n",
       "      <td>312</td>\n",
       "      <td>358</td>\n",
       "      <td>295</td>\n",
       "      <td>324</td>\n",
       "      <td>282</td>\n",
       "      <td>394</td>\n",
       "      <td>486</td>\n",
       "      <td>439</td>\n",
       "      <td>...</td>\n",
       "      <td>562</td>\n",
       "      <td>499</td>\n",
       "      <td>547</td>\n",
       "      <td>359</td>\n",
       "      <td>369</td>\n",
       "      <td>322</td>\n",
       "      <td>392</td>\n",
       "      <td>235</td>\n",
       "      <td>238</td>\n",
       "      <td>20240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Refused entry at port and subsequently departed</td>\n",
       "      <td>4952</td>\n",
       "      <td>4575</td>\n",
       "      <td>4776</td>\n",
       "      <td>4143</td>\n",
       "      <td>3911</td>\n",
       "      <td>4010</td>\n",
       "      <td>4269</td>\n",
       "      <td>3779</td>\n",
       "      <td>3207</td>\n",
       "      <td>...</td>\n",
       "      <td>4476</td>\n",
       "      <td>5179</td>\n",
       "      <td>5772</td>\n",
       "      <td>4794</td>\n",
       "      <td>4242</td>\n",
       "      <td>4415</td>\n",
       "      <td>4848</td>\n",
       "      <td>3507</td>\n",
       "      <td>666</td>\n",
       "      <td>176443</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Departed from Juxtaposed controls</td>\n",
       "      <td>1403</td>\n",
       "      <td>1500</td>\n",
       "      <td>1452</td>\n",
       "      <td>1304</td>\n",
       "      <td>1285</td>\n",
       "      <td>1346</td>\n",
       "      <td>1427</td>\n",
       "      <td>1224</td>\n",
       "      <td>935</td>\n",
       "      <td>...</td>\n",
       "      <td>1940</td>\n",
       "      <td>2499</td>\n",
       "      <td>2629</td>\n",
       "      <td>2239</td>\n",
       "      <td>1800</td>\n",
       "      <td>2029</td>\n",
       "      <td>2267</td>\n",
       "      <td>1642</td>\n",
       "      <td>358</td>\n",
       "      <td>67680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Departed from UK Ports</td>\n",
       "      <td>3549</td>\n",
       "      <td>3075</td>\n",
       "      <td>3324</td>\n",
       "      <td>2839</td>\n",
       "      <td>2626</td>\n",
       "      <td>2664</td>\n",
       "      <td>2842</td>\n",
       "      <td>2555</td>\n",
       "      <td>2272</td>\n",
       "      <td>...</td>\n",
       "      <td>2536</td>\n",
       "      <td>2680</td>\n",
       "      <td>3143</td>\n",
       "      <td>2555</td>\n",
       "      <td>2442</td>\n",
       "      <td>2386</td>\n",
       "      <td>2581</td>\n",
       "      <td>1865</td>\n",
       "      <td>308</td>\n",
       "      <td>108763</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Voluntary return</td>\n",
       "      <td>8350</td>\n",
       "      <td>7977</td>\n",
       "      <td>7909</td>\n",
       "      <td>7526</td>\n",
       "      <td>7827</td>\n",
       "      <td>5931</td>\n",
       "      <td>7623</td>\n",
       "      <td>8707</td>\n",
       "      <td>8025</td>\n",
       "      <td>...</td>\n",
       "      <td>3613</td>\n",
       "      <td>3742</td>\n",
       "      <td>3569</td>\n",
       "      <td>3706</td>\n",
       "      <td>3043</td>\n",
       "      <td>2694</td>\n",
       "      <td>2653</td>\n",
       "      <td>2477</td>\n",
       "      <td>430</td>\n",
       "      <td>262714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Assisted returns</td>\n",
       "      <td>1205</td>\n",
       "      <td>866</td>\n",
       "      <td>994</td>\n",
       "      <td>649</td>\n",
       "      <td>681</td>\n",
       "      <td>315</td>\n",
       "      <td>642</td>\n",
       "      <td>629</td>\n",
       "      <td>722</td>\n",
       "      <td>...</td>\n",
       "      <td>557</td>\n",
       "      <td>472</td>\n",
       "      <td>505</td>\n",
       "      <td>570</td>\n",
       "      <td>452</td>\n",
       "      <td>400</td>\n",
       "      <td>500</td>\n",
       "      <td>414</td>\n",
       "      <td>81</td>\n",
       "      <td>21508</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Controlled returns</td>\n",
       "      <td>2035</td>\n",
       "      <td>2062</td>\n",
       "      <td>2082</td>\n",
       "      <td>2002</td>\n",
       "      <td>2216</td>\n",
       "      <td>2211</td>\n",
       "      <td>2456</td>\n",
       "      <td>2639</td>\n",
       "      <td>2097</td>\n",
       "      <td>...</td>\n",
       "      <td>1441</td>\n",
       "      <td>1304</td>\n",
       "      <td>1284</td>\n",
       "      <td>1209</td>\n",
       "      <td>961</td>\n",
       "      <td>799</td>\n",
       "      <td>738</td>\n",
       "      <td>633</td>\n",
       "      <td>145</td>\n",
       "      <td>88867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Other verified returns</td>\n",
       "      <td>5110</td>\n",
       "      <td>5049</td>\n",
       "      <td>4833</td>\n",
       "      <td>4875</td>\n",
       "      <td>4930</td>\n",
       "      <td>3405</td>\n",
       "      <td>4525</td>\n",
       "      <td>5439</td>\n",
       "      <td>5206</td>\n",
       "      <td>...</td>\n",
       "      <td>1615</td>\n",
       "      <td>1966</td>\n",
       "      <td>1780</td>\n",
       "      <td>1927</td>\n",
       "      <td>1630</td>\n",
       "      <td>1495</td>\n",
       "      <td>1415</td>\n",
       "      <td>1430</td>\n",
       "      <td>204</td>\n",
       "      <td>152339</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Grand Total</td>\n",
       "      <td>16870</td>\n",
       "      <td>15788</td>\n",
       "      <td>16339</td>\n",
       "      <td>15139</td>\n",
       "      <td>15503</td>\n",
       "      <td>13218</td>\n",
       "      <td>15419</td>\n",
       "      <td>16483</td>\n",
       "      <td>15006</td>\n",
       "      <td>...</td>\n",
       "      <td>10456</td>\n",
       "      <td>11036</td>\n",
       "      <td>11430</td>\n",
       "      <td>10392</td>\n",
       "      <td>9084</td>\n",
       "      <td>8795</td>\n",
       "      <td>9318</td>\n",
       "      <td>7328</td>\n",
       "      <td>1457</td>\n",
       "      <td>565878</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12 rows × 44 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         Row Labels  2010 Q1  2010 Q2  \\\n",
       "0                                   Enforced return     3568     3236   \n",
       "1                  Enforced removals from detention     3011     2794   \n",
       "2                    Non-detained Enforced removals      244      130   \n",
       "3                      Other returns from detention      313      312   \n",
       "4   Refused entry at port and subsequently departed     4952     4575   \n",
       "5                 Departed from Juxtaposed controls     1403     1500   \n",
       "6                            Departed from UK Ports     3549     3075   \n",
       "7                                  Voluntary return     8350     7977   \n",
       "8                                  Assisted returns     1205      866   \n",
       "9                                Controlled returns     2035     2062   \n",
       "10                           Other verified returns     5110     5049   \n",
       "11                                      Grand Total    16870    15788   \n",
       "\n",
       "    2010 Q3  2010 Q4  2011 Q1  2011 Q2  2011 Q3  2011 Q4  2012 Q1  ...  \\\n",
       "0      3654     3470     3765     3277     3527     3997     3774  ...   \n",
       "1      3147     3011     3313     2801     2985     3340     3182  ...   \n",
       "2       149      164      128      194      148      171      153  ...   \n",
       "3       358      295      324      282      394      486      439  ...   \n",
       "4      4776     4143     3911     4010     4269     3779     3207  ...   \n",
       "5      1452     1304     1285     1346     1427     1224      935  ...   \n",
       "6      3324     2839     2626     2664     2842     2555     2272  ...   \n",
       "7      7909     7526     7827     5931     7623     8707     8025  ...   \n",
       "8       994      649      681      315      642      629      722  ...   \n",
       "9      2082     2002     2216     2211     2456     2639     2097  ...   \n",
       "10     4833     4875     4930     3405     4525     5439     5206  ...   \n",
       "11    16339    15139    15503    13218    15419    16483    15006  ...   \n",
       "\n",
       "    2018 Q2  2018 Q3  2018 Q4  2019 Q1  2019 Q2  2019 Q3  2019 Q4  2020 Q1  \\\n",
       "0      2367     2115     2089     1892     1799     1686     1817     1344   \n",
       "1      1583     1397     1350     1345     1223     1179     1209      977   \n",
       "2       222      219      192      188      207      185      216      132   \n",
       "3       562      499      547      359      369      322      392      235   \n",
       "4      4476     5179     5772     4794     4242     4415     4848     3507   \n",
       "5      1940     2499     2629     2239     1800     2029     2267     1642   \n",
       "6      2536     2680     3143     2555     2442     2386     2581     1865   \n",
       "7      3613     3742     3569     3706     3043     2694     2653     2477   \n",
       "8       557      472      505      570      452      400      500      414   \n",
       "9      1441     1304     1284     1209      961      799      738      633   \n",
       "10     1615     1966     1780     1927     1630     1495     1415     1430   \n",
       "11    10456    11036    11430    10392     9084     8795     9318     7328   \n",
       "\n",
       "    2020 Q2  Grand Total  \n",
       "0       361       126721  \n",
       "1       109        97033  \n",
       "2        14         9448  \n",
       "3       238        20240  \n",
       "4       666       176443  \n",
       "5       358        67680  \n",
       "6       308       108763  \n",
       "7       430       262714  \n",
       "8        81        21508  \n",
       "9       145        88867  \n",
       "10      204       152339  \n",
       "11     1457       565878  \n",
       "\n",
       "[12 rows x 44 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_Ret"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Row Labels', '2010 Q1', '2010 Q2', '2010 Q3', '2010 Q4', '2011 Q1',\n",
       "       '2011 Q2', '2011 Q3', '2011 Q4', '2012 Q1', '2012 Q2', '2012 Q3',\n",
       "       '2012 Q4', '2013 Q1', '2013 Q2', '2013 Q3', '2013 Q4', '2014 Q1',\n",
       "       '2014 Q2', '2014 Q3', '2014 Q4', '2015 Q1', '2015 Q2', '2015 Q3',\n",
       "       '2015 Q4', '2016 Q1', '2016 Q2', '2016 Q3', '2016 Q4', '2017 Q1',\n",
       "       '2017 Q2', '2017 Q3', '2017 Q4', '2018 Q1', '2018 Q2', '2018 Q3',\n",
       "       '2018 Q4', '2019 Q1', '2019 Q2', '2019 Q3', '2019 Q4', '2020 Q1',\n",
       "       '2020 Q2', 'Grand Total'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_Ret.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_Ret.to_csv('summary_table.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}