Modern Family Planning_Data Cleaning and Data Transformation_Roshni.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "#importing Pandas dataframe\n",
    "import pandas as pd\n",
    "from importlib import resources"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Importing Data Source"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>IndicatorCode</th>\n",
       "      <th>Indicator</th>\n",
       "      <th>ValueType</th>\n",
       "      <th>ParentLocationCode</th>\n",
       "      <th>ParentLocation</th>\n",
       "      <th>Location type</th>\n",
       "      <th>SpatialDimValueCode</th>\n",
       "      <th>Location</th>\n",
       "      <th>Period type</th>\n",
       "      <th>Period</th>\n",
       "      <th>...</th>\n",
       "      <th>FactValueUoM</th>\n",
       "      <th>FactValueNumericLowPrefix</th>\n",
       "      <th>FactValueNumericLow</th>\n",
       "      <th>FactValueNumericHighPrefix</th>\n",
       "      <th>FactValueNumericHigh</th>\n",
       "      <th>Value</th>\n",
       "      <th>FactValueTranslationID</th>\n",
       "      <th>FactComments</th>\n",
       "      <th>Language</th>\n",
       "      <th>DateModified</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>text</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Country</td>\n",
       "      <td>UGA</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>Year</td>\n",
       "      <td>2021</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>65.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2023-03-08T05:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>text</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Country</td>\n",
       "      <td>NER</td>\n",
       "      <td>Niger</td>\n",
       "      <td>Year</td>\n",
       "      <td>2020-2021</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>36.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Niger 2021 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "      <td>2023-03-08T05:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>text</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Country</td>\n",
       "      <td>BFA</td>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>Year</td>\n",
       "      <td>2020-2021</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>58.2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Burkina Faso 2021 PMA Survey Phase 2</td>\n",
       "      <td>EN</td>\n",
       "      <td>2023-03-08T05:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>text</td>\n",
       "      <td>WPR</td>\n",
       "      <td>Western Pacific</td>\n",
       "      <td>Country</td>\n",
       "      <td>VNM</td>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>Year</td>\n",
       "      <td>2020-2021</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>72.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2023-03-08T05:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>text</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Country</td>\n",
       "      <td>CIV</td>\n",
       "      <td>Cote d'Ivoire</td>\n",
       "      <td>Year</td>\n",
       "      <td>2020</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>46.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Côte d'Ivoire 2020 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "      <td>2023-03-08T05:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>text</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Europe</td>\n",
       "      <td>Country</td>\n",
       "      <td>MDA</td>\n",
       "      <td>Republic of Moldova</td>\n",
       "      <td>Year</td>\n",
       "      <td>2020</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>59.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Moldova 2020 Gender and Generations Survey</td>\n",
       "      <td>EN</td>\n",
       "      <td>2023-03-08T05:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>text</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Country</td>\n",
       "      <td>ETH</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>Year</td>\n",
       "      <td>2020</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>62.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2023-03-08T05:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>text</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Country</td>\n",
       "      <td>MDG</td>\n",
       "      <td>Madagascar</td>\n",
       "      <td>Year</td>\n",
       "      <td>2020</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>65.6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2023-03-08T05:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>text</td>\n",
       "      <td>AMR</td>\n",
       "      <td>Americas</td>\n",
       "      <td>Country</td>\n",
       "      <td>PER</td>\n",
       "      <td>Peru</td>\n",
       "      <td>Year</td>\n",
       "      <td>2020</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>65.9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2023-03-08T05:00:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>text</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>Country</td>\n",
       "      <td>KEN</td>\n",
       "      <td>Kenya</td>\n",
       "      <td>Year</td>\n",
       "      <td>2020</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>77.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Kenya 2020 PMA Survey Phase 2</td>\n",
       "      <td>EN</td>\n",
       "      <td>2023-03-08T05:00:00.000Z</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  IndicatorCode                                          Indicator ValueType  \\\n",
       "0      SDGFPALL  Women of reproductive age (aged 15-49 years) w...      text   \n",
       "1      SDGFPALL  Women of reproductive age (aged 15-49 years) w...      text   \n",
       "2      SDGFPALL  Women of reproductive age (aged 15-49 years) w...      text   \n",
       "3      SDGFPALL  Women of reproductive age (aged 15-49 years) w...      text   \n",
       "4      SDGFPALL  Women of reproductive age (aged 15-49 years) w...      text   \n",
       "5      SDGFPALL  Women of reproductive age (aged 15-49 years) w...      text   \n",
       "6      SDGFPALL  Women of reproductive age (aged 15-49 years) w...      text   \n",
       "7      SDGFPALL  Women of reproductive age (aged 15-49 years) w...      text   \n",
       "8      SDGFPALL  Women of reproductive age (aged 15-49 years) w...      text   \n",
       "9      SDGFPALL  Women of reproductive age (aged 15-49 years) w...      text   \n",
       "\n",
       "  ParentLocationCode   ParentLocation Location type SpatialDimValueCode  \\\n",
       "0                AFR           Africa       Country                 UGA   \n",
       "1                AFR           Africa       Country                 NER   \n",
       "2                AFR           Africa       Country                 BFA   \n",
       "3                WPR  Western Pacific       Country                 VNM   \n",
       "4                AFR           Africa       Country                 CIV   \n",
       "5                EUR           Europe       Country                 MDA   \n",
       "6                AFR           Africa       Country                 ETH   \n",
       "7                AFR           Africa       Country                 MDG   \n",
       "8                AMR         Americas       Country                 PER   \n",
       "9                AFR           Africa       Country                 KEN   \n",
       "\n",
       "              Location Period type     Period  ...  FactValueUoM  \\\n",
       "0               Uganda        Year       2021  ...           NaN   \n",
       "1                Niger        Year  2020-2021  ...           NaN   \n",
       "2         Burkina Faso        Year  2020-2021  ...           NaN   \n",
       "3             Viet Nam        Year  2020-2021  ...           NaN   \n",
       "4        Cote d'Ivoire        Year       2020  ...           NaN   \n",
       "5  Republic of Moldova        Year       2020  ...           NaN   \n",
       "6             Ethiopia        Year       2020  ...           NaN   \n",
       "7           Madagascar        Year       2020  ...           NaN   \n",
       "8                 Peru        Year       2020  ...           NaN   \n",
       "9                Kenya        Year       2020  ...           NaN   \n",
       "\n",
       "  FactValueNumericLowPrefix FactValueNumericLow FactValueNumericHighPrefix  \\\n",
       "0                       NaN                 NaN                        NaN   \n",
       "1                       NaN                 NaN                        NaN   \n",
       "2                       NaN                 NaN                        NaN   \n",
       "3                       NaN                 NaN                        NaN   \n",
       "4                       NaN                 NaN                        NaN   \n",
       "5                       NaN                 NaN                        NaN   \n",
       "6                       NaN                 NaN                        NaN   \n",
       "7                       NaN                 NaN                        NaN   \n",
       "8                       NaN                 NaN                        NaN   \n",
       "9                       NaN                 NaN                        NaN   \n",
       "\n",
       "  FactValueNumericHigh Value FactValueTranslationID  \\\n",
       "0                  NaN  65.5                    NaN   \n",
       "1                  NaN  36.9                    NaN   \n",
       "2                  NaN  58.2                    NaN   \n",
       "3                  NaN  72.1                    NaN   \n",
       "4                  NaN  46.1                    NaN   \n",
       "5                  NaN  59.5                    NaN   \n",
       "6                  NaN  62.6                    NaN   \n",
       "7                  NaN  65.6                    NaN   \n",
       "8                  NaN  65.9                    NaN   \n",
       "9                  NaN  77.1                    NaN   \n",
       "\n",
       "                                        FactComments  Language  \\\n",
       "0  The global indicator represents all women of r...        EN   \n",
       "1                      Niger 2021 PMA Survey Phase 1        EN   \n",
       "2               Burkina Faso 2021 PMA Survey Phase 2        EN   \n",
       "3  The global indicator represents all women of r...        EN   \n",
       "4              Côte d'Ivoire 2020 PMA Survey Phase 1        EN   \n",
       "5         Moldova 2020 Gender and Generations Survey        EN   \n",
       "6  The global indicator represents all women of r...        EN   \n",
       "7  The global indicator represents all women of r...        EN   \n",
       "8  The global indicator represents all women of r...        EN   \n",
       "9                      Kenya 2020 PMA Survey Phase 2        EN   \n",
       "\n",
       "               DateModified  \n",
       "0  2023-03-08T05:00:00.000Z  \n",
       "1  2023-03-08T05:00:00.000Z  \n",
       "2  2023-03-08T05:00:00.000Z  \n",
       "3  2023-03-08T05:00:00.000Z  \n",
       "4  2023-03-08T05:00:00.000Z  \n",
       "5  2023-03-08T05:00:00.000Z  \n",
       "6  2023-03-08T05:00:00.000Z  \n",
       "7  2023-03-08T05:00:00.000Z  \n",
       "8  2023-03-08T05:00:00.000Z  \n",
       "9  2023-03-08T05:00:00.000Z  \n",
       "\n",
       "[10 rows x 34 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#importing Raw-data \n",
    "df = pd.read_csv('Resources\\Modern Family Planning_Raw data.csv')\n",
    "df.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "DATA Cleaning"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['IndicatorCode', 'Indicator', 'ValueType', 'ParentLocationCode',\n",
       "       'ParentLocation', 'Location type', 'SpatialDimValueCode', 'Location',\n",
       "       'Period type', 'Period', 'IsLatestYear', 'Dim1 type', 'Dim1',\n",
       "       'Dim1ValueCode', 'Dim2 type', 'Dim2', 'Dim2ValueCode', 'Dim3 type',\n",
       "       'Dim3', 'Dim3ValueCode', 'DataSourceDimValueCode', 'DataSource',\n",
       "       'FactValueNumericPrefix', 'FactValueNumeric', 'FactValueUoM',\n",
       "       'FactValueNumericLowPrefix', 'FactValueNumericLow',\n",
       "       'FactValueNumericHighPrefix', 'FactValueNumericHigh', 'Value',\n",
       "       'FactValueTranslationID', 'FactComments', 'Language', 'DateModified'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#checking numbers of Columns\n",
    "df.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Dropping unnecessary data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "#removing unnecessery columns \n",
    "drop_colums = df.drop(['ValueType','Location type','Period type','Dim1 type','IsLatestYear','Dim1ValueCode','Dim2 type','Dim2ValueCode',\n",
    "         'Dim3 type', 'Dim3', 'Dim3ValueCode','DataSourceDimValueCode', 'DataSource','FactValueNumericPrefix','FactValueUoM',\n",
    "          'FactValueTranslationID', 'FactValueNumericHigh','FactValueNumericHighPrefix','FactValueNumericLow',\n",
    "         'FactValueNumericLowPrefix','DateModified'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>IndicatorCode</th>\n",
       "      <th>Indicator</th>\n",
       "      <th>ParentLocationCode</th>\n",
       "      <th>ParentLocation</th>\n",
       "      <th>SpatialDimValueCode</th>\n",
       "      <th>Location</th>\n",
       "      <th>Period</th>\n",
       "      <th>Dim1</th>\n",
       "      <th>Dim2</th>\n",
       "      <th>FactValueNumeric</th>\n",
       "      <th>Value</th>\n",
       "      <th>FactComments</th>\n",
       "      <th>Language</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>UGA</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.5</td>\n",
       "      <td>65.5</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>NER</td>\n",
       "      <td>Niger</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>36.9</td>\n",
       "      <td>36.9</td>\n",
       "      <td>Niger 2021 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>BFA</td>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>58.2</td>\n",
       "      <td>58.2</td>\n",
       "      <td>Burkina Faso 2021 PMA Survey Phase 2</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>WPR</td>\n",
       "      <td>Western Pacific</td>\n",
       "      <td>VNM</td>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>72.1</td>\n",
       "      <td>72.1</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>CIV</td>\n",
       "      <td>Cote d'Ivoire</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>46.1</td>\n",
       "      <td>46.1</td>\n",
       "      <td>Côte d'Ivoire 2020 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Europe</td>\n",
       "      <td>MDA</td>\n",
       "      <td>Republic of Moldova</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>59.5</td>\n",
       "      <td>59.5</td>\n",
       "      <td>Moldova 2020 Gender and Generations Survey</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>ETH</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>62.6</td>\n",
       "      <td>62.6</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>MDG</td>\n",
       "      <td>Madagascar</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.6</td>\n",
       "      <td>65.6</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AMR</td>\n",
       "      <td>Americas</td>\n",
       "      <td>PER</td>\n",
       "      <td>Peru</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.9</td>\n",
       "      <td>65.9</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>KEN</td>\n",
       "      <td>Kenya</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>77.1</td>\n",
       "      <td>77.1</td>\n",
       "      <td>Kenya 2020 PMA Survey Phase 2</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  IndicatorCode                                          Indicator  \\\n",
       "0      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "1      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "2      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "3      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "4      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "5      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "6      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "7      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "8      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "9      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "\n",
       "  ParentLocationCode   ParentLocation SpatialDimValueCode  \\\n",
       "0                AFR           Africa                 UGA   \n",
       "1                AFR           Africa                 NER   \n",
       "2                AFR           Africa                 BFA   \n",
       "3                WPR  Western Pacific                 VNM   \n",
       "4                AFR           Africa                 CIV   \n",
       "5                EUR           Europe                 MDA   \n",
       "6                AFR           Africa                 ETH   \n",
       "7                AFR           Africa                 MDG   \n",
       "8                AMR         Americas                 PER   \n",
       "9                AFR           Africa                 KEN   \n",
       "\n",
       "              Location     Period    Dim1         Dim2  FactValueNumeric  \\\n",
       "0               Uganda       2021  Female  15-49 years              65.5   \n",
       "1                Niger  2020-2021  Female  15-49 years              36.9   \n",
       "2         Burkina Faso  2020-2021  Female  15-49 years              58.2   \n",
       "3             Viet Nam  2020-2021  Female  15-49 years              72.1   \n",
       "4        Cote d'Ivoire       2020  Female  15-49 years              46.1   \n",
       "5  Republic of Moldova       2020  Female  15-49 years              59.5   \n",
       "6             Ethiopia       2020  Female  15-49 years              62.6   \n",
       "7           Madagascar       2020  Female  15-49 years              65.6   \n",
       "8                 Peru       2020  Female  15-49 years              65.9   \n",
       "9                Kenya       2020  Female  15-49 years              77.1   \n",
       "\n",
       "   Value                                       FactComments Language  \n",
       "0   65.5  The global indicator represents all women of r...       EN  \n",
       "1   36.9                      Niger 2021 PMA Survey Phase 1       EN  \n",
       "2   58.2               Burkina Faso 2021 PMA Survey Phase 2       EN  \n",
       "3   72.1  The global indicator represents all women of r...       EN  \n",
       "4   46.1              Côte d'Ivoire 2020 PMA Survey Phase 1       EN  \n",
       "5   59.5         Moldova 2020 Gender and Generations Survey       EN  \n",
       "6   62.6  The global indicator represents all women of r...       EN  \n",
       "7   65.6  The global indicator represents all women of r...       EN  \n",
       "8   65.9  The global indicator represents all women of r...       EN  \n",
       "9   77.1                      Kenya 2020 PMA Survey Phase 2       EN  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "drop_colums.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Removing Duplicates "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Removing duplicate column\n",
    "Cleaned_Data = drop_colums.drop(['FactValueNumeric'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>IndicatorCode</th>\n",
       "      <th>Indicator</th>\n",
       "      <th>ParentLocationCode</th>\n",
       "      <th>ParentLocation</th>\n",
       "      <th>SpatialDimValueCode</th>\n",
       "      <th>Location</th>\n",
       "      <th>Period</th>\n",
       "      <th>Dim1</th>\n",
       "      <th>Dim2</th>\n",
       "      <th>Value</th>\n",
       "      <th>FactComments</th>\n",
       "      <th>Language</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>UGA</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.5</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>NER</td>\n",
       "      <td>Niger</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>36.9</td>\n",
       "      <td>Niger 2021 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>BFA</td>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>58.2</td>\n",
       "      <td>Burkina Faso 2021 PMA Survey Phase 2</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>WPR</td>\n",
       "      <td>Western Pacific</td>\n",
       "      <td>VNM</td>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>72.1</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>CIV</td>\n",
       "      <td>Cote d'Ivoire</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>46.1</td>\n",
       "      <td>Côte d'Ivoire 2020 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  IndicatorCode                                          Indicator  \\\n",
       "0      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "1      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "2      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "3      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "4      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "\n",
       "  ParentLocationCode   ParentLocation SpatialDimValueCode       Location  \\\n",
       "0                AFR           Africa                 UGA         Uganda   \n",
       "1                AFR           Africa                 NER          Niger   \n",
       "2                AFR           Africa                 BFA   Burkina Faso   \n",
       "3                WPR  Western Pacific                 VNM       Viet Nam   \n",
       "4                AFR           Africa                 CIV  Cote d'Ivoire   \n",
       "\n",
       "      Period    Dim1         Dim2  Value  \\\n",
       "0       2021  Female  15-49 years   65.5   \n",
       "1  2020-2021  Female  15-49 years   36.9   \n",
       "2  2020-2021  Female  15-49 years   58.2   \n",
       "3  2020-2021  Female  15-49 years   72.1   \n",
       "4       2020  Female  15-49 years   46.1   \n",
       "\n",
       "                                        FactComments Language  \n",
       "0  The global indicator represents all women of r...       EN  \n",
       "1                      Niger 2021 PMA Survey Phase 1       EN  \n",
       "2               Burkina Faso 2021 PMA Survey Phase 2       EN  \n",
       "3  The global indicator represents all women of r...       EN  \n",
       "4              Côte d'Ivoire 2020 PMA Survey Phase 1       EN  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Cleaned_Data.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['IndicatorCode', 'Indicator', 'ParentLocationCode', 'ParentLocation',\n",
       "       'SpatialDimValueCode', 'Location', 'Period', 'Dim1', 'Dim2', 'Value',\n",
       "       'FactComments', 'Language'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Extracted coulmns List\n",
    "Cleaned_Data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>IndicatorCode</th>\n",
       "      <th>Indicator</th>\n",
       "      <th>ParentLocationCode</th>\n",
       "      <th>ParentLocation</th>\n",
       "      <th>SpatialDimValueCode</th>\n",
       "      <th>Location</th>\n",
       "      <th>Period</th>\n",
       "      <th>Dim1</th>\n",
       "      <th>Dim2</th>\n",
       "      <th>Value</th>\n",
       "      <th>FactComments</th>\n",
       "      <th>Language</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>UGA</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.5</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>NER</td>\n",
       "      <td>Niger</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>36.9</td>\n",
       "      <td>Niger 2021 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>BFA</td>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>58.2</td>\n",
       "      <td>Burkina Faso 2021 PMA Survey Phase 2</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>WPR</td>\n",
       "      <td>Western Pacific</td>\n",
       "      <td>VNM</td>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>72.1</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>CIV</td>\n",
       "      <td>Cote d'Ivoire</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>46.1</td>\n",
       "      <td>Côte d'Ivoire 2020 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Europe</td>\n",
       "      <td>MDA</td>\n",
       "      <td>Republic of Moldova</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>59.5</td>\n",
       "      <td>Moldova 2020 Gender and Generations Survey</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>ETH</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>62.6</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>MDG</td>\n",
       "      <td>Madagascar</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.6</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AMR</td>\n",
       "      <td>Americas</td>\n",
       "      <td>PER</td>\n",
       "      <td>Peru</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.9</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>KEN</td>\n",
       "      <td>Kenya</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>77.1</td>\n",
       "      <td>Kenya 2020 PMA Survey Phase 2</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  IndicatorCode                                          Indicator  \\\n",
       "0      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "1      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "2      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "3      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "4      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "5      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "6      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "7      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "8      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "9      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "\n",
       "  ParentLocationCode   ParentLocation SpatialDimValueCode  \\\n",
       "0                AFR           Africa                 UGA   \n",
       "1                AFR           Africa                 NER   \n",
       "2                AFR           Africa                 BFA   \n",
       "3                WPR  Western Pacific                 VNM   \n",
       "4                AFR           Africa                 CIV   \n",
       "5                EUR           Europe                 MDA   \n",
       "6                AFR           Africa                 ETH   \n",
       "7                AFR           Africa                 MDG   \n",
       "8                AMR         Americas                 PER   \n",
       "9                AFR           Africa                 KEN   \n",
       "\n",
       "              Location     Period    Dim1         Dim2  Value  \\\n",
       "0               Uganda       2021  Female  15-49 years   65.5   \n",
       "1                Niger  2020-2021  Female  15-49 years   36.9   \n",
       "2         Burkina Faso  2020-2021  Female  15-49 years   58.2   \n",
       "3             Viet Nam  2020-2021  Female  15-49 years   72.1   \n",
       "4        Cote d'Ivoire       2020  Female  15-49 years   46.1   \n",
       "5  Republic of Moldova       2020  Female  15-49 years   59.5   \n",
       "6             Ethiopia       2020  Female  15-49 years   62.6   \n",
       "7           Madagascar       2020  Female  15-49 years   65.6   \n",
       "8                 Peru       2020  Female  15-49 years   65.9   \n",
       "9                Kenya       2020  Female  15-49 years   77.1   \n",
       "\n",
       "                                        FactComments Language  \n",
       "0  The global indicator represents all women of r...       EN  \n",
       "1                      Niger 2021 PMA Survey Phase 1       EN  \n",
       "2               Burkina Faso 2021 PMA Survey Phase 2       EN  \n",
       "3  The global indicator represents all women of r...       EN  \n",
       "4              Côte d'Ivoire 2020 PMA Survey Phase 1       EN  \n",
       "5         Moldova 2020 Gender and Generations Survey       EN  \n",
       "6  The global indicator represents all women of r...       EN  \n",
       "7  The global indicator represents all women of r...       EN  \n",
       "8  The global indicator represents all women of r...       EN  \n",
       "9                      Kenya 2020 PMA Survey Phase 2       EN  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Cleaned_Data.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Data Transformation-Renaming the Columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Renaming Colums\n",
    "Cleaned_Data = Cleaned_Data.rename(columns={'Dim1':'Gender','Dim2':'Age_Group','Value':'Planning_Value_Rate','Language':'Language_Code', 'Location':'Country',\n",
    "                                            'SpatialDimValueCode':'Country_Code', 'ParentLocation':'ParentLocation_Continent',\n",
    "                                            'ParentLocationCode':'Patents_Continent_Code'})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>IndicatorCode</th>\n",
       "      <th>Indicator</th>\n",
       "      <th>Patents_Continent_Code</th>\n",
       "      <th>ParentLocation_Continent</th>\n",
       "      <th>Country_Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Period</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age_Group</th>\n",
       "      <th>Planning_Value_Rate</th>\n",
       "      <th>FactComments</th>\n",
       "      <th>Language_Code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>UGA</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.5</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>NER</td>\n",
       "      <td>Niger</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>36.9</td>\n",
       "      <td>Niger 2021 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>BFA</td>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>58.2</td>\n",
       "      <td>Burkina Faso 2021 PMA Survey Phase 2</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>WPR</td>\n",
       "      <td>Western Pacific</td>\n",
       "      <td>VNM</td>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>72.1</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>CIV</td>\n",
       "      <td>Cote d'Ivoire</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>46.1</td>\n",
       "      <td>Côte d'Ivoire 2020 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Europe</td>\n",
       "      <td>MDA</td>\n",
       "      <td>Republic of Moldova</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>59.5</td>\n",
       "      <td>Moldova 2020 Gender and Generations Survey</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>ETH</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>62.6</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>MDG</td>\n",
       "      <td>Madagascar</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.6</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AMR</td>\n",
       "      <td>Americas</td>\n",
       "      <td>PER</td>\n",
       "      <td>Peru</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.9</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>KEN</td>\n",
       "      <td>Kenya</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>77.1</td>\n",
       "      <td>Kenya 2020 PMA Survey Phase 2</td>\n",
       "      <td>EN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  IndicatorCode                                          Indicator  \\\n",
       "0      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "1      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "2      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "3      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "4      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "5      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "6      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "7      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "8      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "9      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "\n",
       "  Patents_Continent_Code ParentLocation_Continent Country_Code  \\\n",
       "0                    AFR                   Africa          UGA   \n",
       "1                    AFR                   Africa          NER   \n",
       "2                    AFR                   Africa          BFA   \n",
       "3                    WPR          Western Pacific          VNM   \n",
       "4                    AFR                   Africa          CIV   \n",
       "5                    EUR                   Europe          MDA   \n",
       "6                    AFR                   Africa          ETH   \n",
       "7                    AFR                   Africa          MDG   \n",
       "8                    AMR                 Americas          PER   \n",
       "9                    AFR                   Africa          KEN   \n",
       "\n",
       "               Country     Period  Gender    Age_Group  Planning_Value_Rate  \\\n",
       "0               Uganda       2021  Female  15-49 years                 65.5   \n",
       "1                Niger  2020-2021  Female  15-49 years                 36.9   \n",
       "2         Burkina Faso  2020-2021  Female  15-49 years                 58.2   \n",
       "3             Viet Nam  2020-2021  Female  15-49 years                 72.1   \n",
       "4        Cote d'Ivoire       2020  Female  15-49 years                 46.1   \n",
       "5  Republic of Moldova       2020  Female  15-49 years                 59.5   \n",
       "6             Ethiopia       2020  Female  15-49 years                 62.6   \n",
       "7           Madagascar       2020  Female  15-49 years                 65.6   \n",
       "8                 Peru       2020  Female  15-49 years                 65.9   \n",
       "9                Kenya       2020  Female  15-49 years                 77.1   \n",
       "\n",
       "                                        FactComments Language_Code  \n",
       "0  The global indicator represents all women of r...            EN  \n",
       "1                      Niger 2021 PMA Survey Phase 1            EN  \n",
       "2               Burkina Faso 2021 PMA Survey Phase 2            EN  \n",
       "3  The global indicator represents all women of r...            EN  \n",
       "4              Côte d'Ivoire 2020 PMA Survey Phase 1            EN  \n",
       "5         Moldova 2020 Gender and Generations Survey            EN  \n",
       "6  The global indicator represents all women of r...            EN  \n",
       "7  The global indicator represents all women of r...            EN  \n",
       "8  The global indicator represents all women of r...            EN  \n",
       "9                      Kenya 2020 PMA Survey Phase 2            EN  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Cleaned_Data.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Dealing with Null Values "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>IndicatorCode</th>\n",
       "      <th>Indicator</th>\n",
       "      <th>Patents_Continent_Code</th>\n",
       "      <th>ParentLocation_Continent</th>\n",
       "      <th>Country_Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Period</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age_Group</th>\n",
       "      <th>Planning_Value_Rate</th>\n",
       "      <th>FactComments</th>\n",
       "      <th>Language_Code</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>137 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     IndicatorCode  Indicator  Patents_Continent_Code  \\\n",
       "0            False      False                   False   \n",
       "1            False      False                   False   \n",
       "2            False      False                   False   \n",
       "3            False      False                   False   \n",
       "4            False      False                   False   \n",
       "..             ...        ...                     ...   \n",
       "132          False      False                   False   \n",
       "133          False      False                   False   \n",
       "134          False      False                   False   \n",
       "135          False      False                   False   \n",
       "136          False      False                   False   \n",
       "\n",
       "     ParentLocation_Continent  Country_Code  Country  Period  Gender  \\\n",
       "0                       False         False    False   False   False   \n",
       "1                       False         False    False   False   False   \n",
       "2                       False         False    False   False   False   \n",
       "3                       False         False    False   False   False   \n",
       "4                       False         False    False   False   False   \n",
       "..                        ...           ...      ...     ...     ...   \n",
       "132                     False         False    False   False   False   \n",
       "133                     False         False    False   False   False   \n",
       "134                     False         False    False   False   False   \n",
       "135                     False         False    False   False   False   \n",
       "136                     False         False    False   False   False   \n",
       "\n",
       "     Age_Group  Planning_Value_Rate  FactComments  Language_Code  \n",
       "0        False                False         False          False  \n",
       "1        False                False         False          False  \n",
       "2        False                False         False          False  \n",
       "3        False                False         False          False  \n",
       "4        False                False         False          False  \n",
       "..         ...                  ...           ...            ...  \n",
       "132      False                False         False          False  \n",
       "133      False                False         False          False  \n",
       "134      False                False         False          False  \n",
       "135      False                False         False          False  \n",
       "136      False                False         False          False  \n",
       "\n",
       "[137 rows x 12 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Checking the null values\n",
    "Cleaned_Data.isnull()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Data set doesnot Have any null values, However if we have null values we can run codes below\n",
    "'Cleaned_Data.isnull()' # if output is true!! :\n",
    "'Cleaned_Data[Cleaned_Data['column_Name'].isna()--1]' #for checking null values\n",
    "'Cleaned_Data['column_Name']=Cleaned_Data['column_Name'].fillna(0)' #Rplacing null values with zero \n",
    "\n",
    "'Cleaned_Data[Cleaned_Data['column_Name'] == 'any Null Records value/observation'] #to varify null value replacement"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Chrecking the Duplicates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      False\n",
       "1      False\n",
       "2      False\n",
       "3      False\n",
       "4      False\n",
       "       ...  \n",
       "132    False\n",
       "133    False\n",
       "134    False\n",
       "135    False\n",
       "136    False\n",
       "Length: 137, dtype: bool"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#checking duplicates\n",
    "Cleaned_Data.duplicated()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Data set doesnot Have any Duplicate values, However if we have duplicate values than we can run codes below\n",
    "'Cleaned_Data.duplicated()' # if output is true!! :\n",
    "'Cleaned_Data[Cleaned_Data['column_Name'].duplicated()--1]' #for checking duplicates values\n",
    "'Cleaned_Data[Cleaned_Data['column_Name'].isin(['duplicate value1','duplicate value2','duplicate value3'])]'\n",
    "'Cleaned_Data=Cleaned_Data.drop_duplicates()'"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Data Transformation for Time period columns or Dates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0           2021\n",
       "1      2020-2021\n",
       "2      2020-2021\n",
       "3      2020-2021\n",
       "4           2020\n",
       "         ...    \n",
       "132         2006\n",
       "133         2005\n",
       "134    2004-2005\n",
       "135         2004\n",
       "136         2001\n",
       "Name: Period, Length: 137, dtype: object"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#split up span in to start and end date\n",
    "Cleaned_Data['Period']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Spliting the uneven Time period columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0            [2021]\n",
       "1      [2020, 2021]\n",
       "2      [2020, 2021]\n",
       "3      [2020, 2021]\n",
       "4            [2020]\n",
       "           ...     \n",
       "132          [2006]\n",
       "133          [2005]\n",
       "134    [2004, 2005]\n",
       "135          [2004]\n",
       "136          [2001]\n",
       "Name: Period, Length: 137, dtype: object"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Splitting years by pattern '-'\n",
    "Cleaned_Data['Period'].str.split(pat='-')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      2021\n",
       "1      2020\n",
       "2      2020\n",
       "3      2020\n",
       "4      2020\n",
       "       ... \n",
       "132    2006\n",
       "133    2005\n",
       "134    2004\n",
       "135    2004\n",
       "136    2001\n",
       "Name: Period, Length: 137, dtype: object"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#checking plit where 0=starting year=LHS values\n",
    "Cleaned_Data['Period'].str.split(pat='-').str[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "#adding left hand values to new column name 'Starting_Year'\n",
    "Cleaned_Data['Starting_Year'] = Cleaned_Data['Period'].str.split(pat='-').str[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       NaN\n",
       "1      2021\n",
       "2      2021\n",
       "3      2021\n",
       "4       NaN\n",
       "       ... \n",
       "132     NaN\n",
       "133     NaN\n",
       "134    2005\n",
       "135     NaN\n",
       "136     NaN\n",
       "Name: Period, Length: 137, dtype: object"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#checking plit where 1=year_Ending=RHS values\n",
    "Cleaned_Data['Period'].str.split(pat='-').str[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "##adding Right hand values to new column name 'Year_Ending'\n",
    "Cleaned_Data['Year_Ending'] = Cleaned_Data['Period'].str.split(pat='-').str[1]"
   ]
  },
  {
   "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>IndicatorCode</th>\n",
       "      <th>Indicator</th>\n",
       "      <th>Patents_Continent_Code</th>\n",
       "      <th>ParentLocation_Continent</th>\n",
       "      <th>Country_Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Period</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age_Group</th>\n",
       "      <th>Planning_Value_Rate</th>\n",
       "      <th>FactComments</th>\n",
       "      <th>Language_Code</th>\n",
       "      <th>Starting_Year</th>\n",
       "      <th>Year_Ending</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>UGA</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.5</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2021</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>NER</td>\n",
       "      <td>Niger</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>36.9</td>\n",
       "      <td>Niger 2021 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>BFA</td>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>58.2</td>\n",
       "      <td>Burkina Faso 2021 PMA Survey Phase 2</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>WPR</td>\n",
       "      <td>Western Pacific</td>\n",
       "      <td>VNM</td>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>72.1</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>CIV</td>\n",
       "      <td>Cote d'Ivoire</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>46.1</td>\n",
       "      <td>Côte d'Ivoire 2020 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  IndicatorCode                                          Indicator  \\\n",
       "0      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "1      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "2      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "3      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "4      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "\n",
       "  Patents_Continent_Code ParentLocation_Continent Country_Code        Country  \\\n",
       "0                    AFR                   Africa          UGA         Uganda   \n",
       "1                    AFR                   Africa          NER          Niger   \n",
       "2                    AFR                   Africa          BFA   Burkina Faso   \n",
       "3                    WPR          Western Pacific          VNM       Viet Nam   \n",
       "4                    AFR                   Africa          CIV  Cote d'Ivoire   \n",
       "\n",
       "      Period  Gender    Age_Group  Planning_Value_Rate  \\\n",
       "0       2021  Female  15-49 years                 65.5   \n",
       "1  2020-2021  Female  15-49 years                 36.9   \n",
       "2  2020-2021  Female  15-49 years                 58.2   \n",
       "3  2020-2021  Female  15-49 years                 72.1   \n",
       "4       2020  Female  15-49 years                 46.1   \n",
       "\n",
       "                                        FactComments Language_Code  \\\n",
       "0  The global indicator represents all women of r...            EN   \n",
       "1                      Niger 2021 PMA Survey Phase 1            EN   \n",
       "2               Burkina Faso 2021 PMA Survey Phase 2            EN   \n",
       "3  The global indicator represents all women of r...            EN   \n",
       "4              Côte d'Ivoire 2020 PMA Survey Phase 1            EN   \n",
       "\n",
       "  Starting_Year Year_Ending  \n",
       "0          2021         NaN  \n",
       "1          2020        2021  \n",
       "2          2020        2021  \n",
       "3          2020        2021  \n",
       "4          2020         NaN  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Cleaned_Data.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "checking the null values after Date columns transformation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "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>IndicatorCode</th>\n",
       "      <th>Indicator</th>\n",
       "      <th>Patents_Continent_Code</th>\n",
       "      <th>ParentLocation_Continent</th>\n",
       "      <th>Country_Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Period</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age_Group</th>\n",
       "      <th>Planning_Value_Rate</th>\n",
       "      <th>FactComments</th>\n",
       "      <th>Language_Code</th>\n",
       "      <th>Starting_Year</th>\n",
       "      <th>Year_Ending</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>137 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     IndicatorCode  Indicator  Patents_Continent_Code  \\\n",
       "0            False      False                   False   \n",
       "1            False      False                   False   \n",
       "2            False      False                   False   \n",
       "3            False      False                   False   \n",
       "4            False      False                   False   \n",
       "..             ...        ...                     ...   \n",
       "132          False      False                   False   \n",
       "133          False      False                   False   \n",
       "134          False      False                   False   \n",
       "135          False      False                   False   \n",
       "136          False      False                   False   \n",
       "\n",
       "     ParentLocation_Continent  Country_Code  Country  Period  Gender  \\\n",
       "0                       False         False    False   False   False   \n",
       "1                       False         False    False   False   False   \n",
       "2                       False         False    False   False   False   \n",
       "3                       False         False    False   False   False   \n",
       "4                       False         False    False   False   False   \n",
       "..                        ...           ...      ...     ...     ...   \n",
       "132                     False         False    False   False   False   \n",
       "133                     False         False    False   False   False   \n",
       "134                     False         False    False   False   False   \n",
       "135                     False         False    False   False   False   \n",
       "136                     False         False    False   False   False   \n",
       "\n",
       "     Age_Group  Planning_Value_Rate  FactComments  Language_Code  \\\n",
       "0        False                False         False          False   \n",
       "1        False                False         False          False   \n",
       "2        False                False         False          False   \n",
       "3        False                False         False          False   \n",
       "4        False                False         False          False   \n",
       "..         ...                  ...           ...            ...   \n",
       "132      False                False         False          False   \n",
       "133      False                False         False          False   \n",
       "134      False                False         False          False   \n",
       "135      False                False         False          False   \n",
       "136      False                False         False          False   \n",
       "\n",
       "     Starting_Year  Year_Ending  \n",
       "0            False         True  \n",
       "1            False        False  \n",
       "2            False        False  \n",
       "3            False        False  \n",
       "4            False         True  \n",
       "..             ...          ...  \n",
       "132          False         True  \n",
       "133          False         True  \n",
       "134          False        False  \n",
       "135          False         True  \n",
       "136          False         True  \n",
       "\n",
       "[137 rows x 14 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# checking null values for column 'year_Ending'\n",
    "Cleaned_Data.isnull()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>IndicatorCode</th>\n",
       "      <th>Indicator</th>\n",
       "      <th>Patents_Continent_Code</th>\n",
       "      <th>ParentLocation_Continent</th>\n",
       "      <th>Country_Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Period</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age_Group</th>\n",
       "      <th>Planning_Value_Rate</th>\n",
       "      <th>FactComments</th>\n",
       "      <th>Language_Code</th>\n",
       "      <th>Starting_Year</th>\n",
       "      <th>Year_Ending</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>UGA</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.5</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2021</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>CIV</td>\n",
       "      <td>Cote d'Ivoire</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>46.1</td>\n",
       "      <td>Côte d'Ivoire 2020 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Europe</td>\n",
       "      <td>MDA</td>\n",
       "      <td>Republic of Moldova</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>59.5</td>\n",
       "      <td>Moldova 2020 Gender and Generations Survey</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>ETH</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>62.6</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>MDG</td>\n",
       "      <td>Madagascar</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.6</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>WPR</td>\n",
       "      <td>Western Pacific</td>\n",
       "      <td>MHL</td>\n",
       "      <td>Marshall Islands</td>\n",
       "      <td>2007</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>80.5</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2007</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Europe</td>\n",
       "      <td>AZE</td>\n",
       "      <td>Azerbaijan</td>\n",
       "      <td>2006</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>21.5</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2006</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>CPV</td>\n",
       "      <td>Cabo Verde</td>\n",
       "      <td>2005</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>73.2</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2005</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Europe</td>\n",
       "      <td>ROU</td>\n",
       "      <td>Romania</td>\n",
       "      <td>2004</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>46.5</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2004</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>WPR</td>\n",
       "      <td>Western Pacific</td>\n",
       "      <td>CHN</td>\n",
       "      <td>China</td>\n",
       "      <td>2001</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>96.6</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2001</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>86 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    IndicatorCode                                          Indicator  \\\n",
       "0        SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "4        SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "5        SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "6        SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "7        SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "..            ...                                                ...   \n",
       "130      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "132      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "133      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "135      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "136      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "\n",
       "    Patents_Continent_Code ParentLocation_Continent Country_Code  \\\n",
       "0                      AFR                   Africa          UGA   \n",
       "4                      AFR                   Africa          CIV   \n",
       "5                      EUR                   Europe          MDA   \n",
       "6                      AFR                   Africa          ETH   \n",
       "7                      AFR                   Africa          MDG   \n",
       "..                     ...                      ...          ...   \n",
       "130                    WPR          Western Pacific          MHL   \n",
       "132                    EUR                   Europe          AZE   \n",
       "133                    AFR                   Africa          CPV   \n",
       "135                    EUR                   Europe          ROU   \n",
       "136                    WPR          Western Pacific          CHN   \n",
       "\n",
       "                 Country Period  Gender    Age_Group  Planning_Value_Rate  \\\n",
       "0                 Uganda   2021  Female  15-49 years                 65.5   \n",
       "4          Cote d'Ivoire   2020  Female  15-49 years                 46.1   \n",
       "5    Republic of Moldova   2020  Female  15-49 years                 59.5   \n",
       "6               Ethiopia   2020  Female  15-49 years                 62.6   \n",
       "7             Madagascar   2020  Female  15-49 years                 65.6   \n",
       "..                   ...    ...     ...          ...                  ...   \n",
       "130     Marshall Islands   2007  Female  15-49 years                 80.5   \n",
       "132           Azerbaijan   2006  Female  15-49 years                 21.5   \n",
       "133           Cabo Verde   2005  Female  15-49 years                 73.2   \n",
       "135              Romania   2004  Female  15-49 years                 46.5   \n",
       "136                China   2001  Female  15-49 years                 96.6   \n",
       "\n",
       "                                          FactComments Language_Code  \\\n",
       "0    The global indicator represents all women of r...            EN   \n",
       "4                Côte d'Ivoire 2020 PMA Survey Phase 1            EN   \n",
       "5           Moldova 2020 Gender and Generations Survey            EN   \n",
       "6    The global indicator represents all women of r...            EN   \n",
       "7    The global indicator represents all women of r...            EN   \n",
       "..                                                 ...           ...   \n",
       "130  The global indicator represents all women of r...            EN   \n",
       "132  The global indicator represents all women of r...            EN   \n",
       "133  The global indicator represents all women of r...            EN   \n",
       "135  The global indicator represents all women of r...            EN   \n",
       "136  The global indicator represents all women of r...            EN   \n",
       "\n",
       "    Starting_Year Year_Ending  \n",
       "0            2021         NaN  \n",
       "4            2020         NaN  \n",
       "5            2020         NaN  \n",
       "6            2020         NaN  \n",
       "7            2020         NaN  \n",
       "..            ...         ...  \n",
       "130          2007         NaN  \n",
       "132          2006         NaN  \n",
       "133          2005         NaN  \n",
       "135          2004         NaN  \n",
       "136          2001         NaN  \n",
       "\n",
       "[86 rows x 14 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#checking records who is carrying null values for year_ending column\n",
    "Cleaned_Data[Cleaned_Data['Year_Ending'].isna()==1]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Replacing null values by starting years as per the descriptions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>IndicatorCode</th>\n",
       "      <th>Indicator</th>\n",
       "      <th>Patents_Continent_Code</th>\n",
       "      <th>ParentLocation_Continent</th>\n",
       "      <th>Country_Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Period</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age_Group</th>\n",
       "      <th>Planning_Value_Rate</th>\n",
       "      <th>FactComments</th>\n",
       "      <th>Language_Code</th>\n",
       "      <th>Starting_Year</th>\n",
       "      <th>Year_Ending</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>UGA</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.5</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2021</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>NER</td>\n",
       "      <td>Niger</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>36.9</td>\n",
       "      <td>Niger 2021 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>BFA</td>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>58.2</td>\n",
       "      <td>Burkina Faso 2021 PMA Survey Phase 2</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>WPR</td>\n",
       "      <td>Western Pacific</td>\n",
       "      <td>VNM</td>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>72.1</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>CIV</td>\n",
       "      <td>Cote d'Ivoire</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>46.1</td>\n",
       "      <td>Côte d'Ivoire 2020 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Europe</td>\n",
       "      <td>MDA</td>\n",
       "      <td>Republic of Moldova</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>59.5</td>\n",
       "      <td>Moldova 2020 Gender and Generations Survey</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>ETH</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>62.6</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>MDG</td>\n",
       "      <td>Madagascar</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.6</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AMR</td>\n",
       "      <td>Americas</td>\n",
       "      <td>PER</td>\n",
       "      <td>Peru</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.9</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>KEN</td>\n",
       "      <td>Kenya</td>\n",
       "      <td>2020</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>77.1</td>\n",
       "      <td>Kenya 2020 PMA Survey Phase 2</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  IndicatorCode                                          Indicator  \\\n",
       "0      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "1      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "2      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "3      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "4      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "5      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "6      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "7      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "8      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "9      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "\n",
       "  Patents_Continent_Code ParentLocation_Continent Country_Code  \\\n",
       "0                    AFR                   Africa          UGA   \n",
       "1                    AFR                   Africa          NER   \n",
       "2                    AFR                   Africa          BFA   \n",
       "3                    WPR          Western Pacific          VNM   \n",
       "4                    AFR                   Africa          CIV   \n",
       "5                    EUR                   Europe          MDA   \n",
       "6                    AFR                   Africa          ETH   \n",
       "7                    AFR                   Africa          MDG   \n",
       "8                    AMR                 Americas          PER   \n",
       "9                    AFR                   Africa          KEN   \n",
       "\n",
       "               Country     Period  Gender    Age_Group  Planning_Value_Rate  \\\n",
       "0               Uganda       2021  Female  15-49 years                 65.5   \n",
       "1                Niger  2020-2021  Female  15-49 years                 36.9   \n",
       "2         Burkina Faso  2020-2021  Female  15-49 years                 58.2   \n",
       "3             Viet Nam  2020-2021  Female  15-49 years                 72.1   \n",
       "4        Cote d'Ivoire       2020  Female  15-49 years                 46.1   \n",
       "5  Republic of Moldova       2020  Female  15-49 years                 59.5   \n",
       "6             Ethiopia       2020  Female  15-49 years                 62.6   \n",
       "7           Madagascar       2020  Female  15-49 years                 65.6   \n",
       "8                 Peru       2020  Female  15-49 years                 65.9   \n",
       "9                Kenya       2020  Female  15-49 years                 77.1   \n",
       "\n",
       "                                        FactComments Language_Code  \\\n",
       "0  The global indicator represents all women of r...            EN   \n",
       "1                      Niger 2021 PMA Survey Phase 1            EN   \n",
       "2               Burkina Faso 2021 PMA Survey Phase 2            EN   \n",
       "3  The global indicator represents all women of r...            EN   \n",
       "4              Côte d'Ivoire 2020 PMA Survey Phase 1            EN   \n",
       "5         Moldova 2020 Gender and Generations Survey            EN   \n",
       "6  The global indicator represents all women of r...            EN   \n",
       "7  The global indicator represents all women of r...            EN   \n",
       "8  The global indicator represents all women of r...            EN   \n",
       "9                      Kenya 2020 PMA Survey Phase 2            EN   \n",
       "\n",
       "  Starting_Year Year_Ending  \n",
       "0          2021        2021  \n",
       "1          2020        2021  \n",
       "2          2020        2021  \n",
       "3          2020        2021  \n",
       "4          2020        2020  \n",
       "5          2020        2020  \n",
       "6          2020        2020  \n",
       "7          2020        2020  \n",
       "8          2020        2020  \n",
       "9          2020        2020  "
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#replacing null values by zero\n",
    "#Cleaned_Data['Year_Ending'] = Cleaned_Data['Year_Ending'].fillna(0)\n",
    "Cleaned_Data['Year_Ending'] = Cleaned_Data['Year_Ending'].fillna(Cleaned_Data['Starting_Year'])\n",
    "Cleaned_Data.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>IndicatorCode</th>\n",
       "      <th>Indicator</th>\n",
       "      <th>Patents_Continent_Code</th>\n",
       "      <th>ParentLocation_Continent</th>\n",
       "      <th>Country_Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age_Group</th>\n",
       "      <th>Planning_Value_Rate</th>\n",
       "      <th>FactComments</th>\n",
       "      <th>Language_Code</th>\n",
       "      <th>Starting_Year</th>\n",
       "      <th>Year_Ending</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>UGA</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.5</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2021</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>NER</td>\n",
       "      <td>Niger</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>36.9</td>\n",
       "      <td>Niger 2021 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>BFA</td>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>58.2</td>\n",
       "      <td>Burkina Faso 2021 PMA Survey Phase 2</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>WPR</td>\n",
       "      <td>Western Pacific</td>\n",
       "      <td>VNM</td>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>72.1</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>CIV</td>\n",
       "      <td>Cote d'Ivoire</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>46.1</td>\n",
       "      <td>Côte d'Ivoire 2020 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  IndicatorCode                                          Indicator  \\\n",
       "0      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "1      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "2      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "3      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "4      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "\n",
       "  Patents_Continent_Code ParentLocation_Continent Country_Code        Country  \\\n",
       "0                    AFR                   Africa          UGA         Uganda   \n",
       "1                    AFR                   Africa          NER          Niger   \n",
       "2                    AFR                   Africa          BFA   Burkina Faso   \n",
       "3                    WPR          Western Pacific          VNM       Viet Nam   \n",
       "4                    AFR                   Africa          CIV  Cote d'Ivoire   \n",
       "\n",
       "   Gender    Age_Group  Planning_Value_Rate  \\\n",
       "0  Female  15-49 years                 65.5   \n",
       "1  Female  15-49 years                 36.9   \n",
       "2  Female  15-49 years                 58.2   \n",
       "3  Female  15-49 years                 72.1   \n",
       "4  Female  15-49 years                 46.1   \n",
       "\n",
       "                                        FactComments Language_Code  \\\n",
       "0  The global indicator represents all women of r...            EN   \n",
       "1                      Niger 2021 PMA Survey Phase 1            EN   \n",
       "2               Burkina Faso 2021 PMA Survey Phase 2            EN   \n",
       "3  The global indicator represents all women of r...            EN   \n",
       "4              Côte d'Ivoire 2020 PMA Survey Phase 1            EN   \n",
       "\n",
       "  Starting_Year Year_Ending  \n",
       "0          2021        2021  \n",
       "1          2020        2021  \n",
       "2          2020        2021  \n",
       "3          2020        2021  \n",
       "4          2020        2020  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Cleaned_Data=Cleaned_Data.drop(['Period'],axis=1)\n",
    "Cleaned_Data.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Coinforming Null values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "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>IndicatorCode</th>\n",
       "      <th>Indicator</th>\n",
       "      <th>Patents_Continent_Code</th>\n",
       "      <th>ParentLocation_Continent</th>\n",
       "      <th>Country_Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age_Group</th>\n",
       "      <th>Planning_Value_Rate</th>\n",
       "      <th>FactComments</th>\n",
       "      <th>Language_Code</th>\n",
       "      <th>Starting_Year</th>\n",
       "      <th>Year_Ending</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>137 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     IndicatorCode  Indicator  Patents_Continent_Code  \\\n",
       "0            False      False                   False   \n",
       "1            False      False                   False   \n",
       "2            False      False                   False   \n",
       "3            False      False                   False   \n",
       "4            False      False                   False   \n",
       "..             ...        ...                     ...   \n",
       "132          False      False                   False   \n",
       "133          False      False                   False   \n",
       "134          False      False                   False   \n",
       "135          False      False                   False   \n",
       "136          False      False                   False   \n",
       "\n",
       "     ParentLocation_Continent  Country_Code  Country  Gender  Age_Group  \\\n",
       "0                       False         False    False   False      False   \n",
       "1                       False         False    False   False      False   \n",
       "2                       False         False    False   False      False   \n",
       "3                       False         False    False   False      False   \n",
       "4                       False         False    False   False      False   \n",
       "..                        ...           ...      ...     ...        ...   \n",
       "132                     False         False    False   False      False   \n",
       "133                     False         False    False   False      False   \n",
       "134                     False         False    False   False      False   \n",
       "135                     False         False    False   False      False   \n",
       "136                     False         False    False   False      False   \n",
       "\n",
       "     Planning_Value_Rate  FactComments  Language_Code  Starting_Year  \\\n",
       "0                  False         False          False          False   \n",
       "1                  False         False          False          False   \n",
       "2                  False         False          False          False   \n",
       "3                  False         False          False          False   \n",
       "4                  False         False          False          False   \n",
       "..                   ...           ...            ...            ...   \n",
       "132                False         False          False          False   \n",
       "133                False         False          False          False   \n",
       "134                False         False          False          False   \n",
       "135                False         False          False          False   \n",
       "136                False         False          False          False   \n",
       "\n",
       "     Year_Ending  \n",
       "0          False  \n",
       "1          False  \n",
       "2          False  \n",
       "3          False  \n",
       "4          False  \n",
       "..           ...  \n",
       "132        False  \n",
       "133        False  \n",
       "134        False  \n",
       "135        False  \n",
       "136        False  \n",
       "\n",
       "[137 rows x 13 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Varifying null values for column 'year_Ending'\n",
    "Cleaned_Data.isnull()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      False\n",
       "1      False\n",
       "2      False\n",
       "3      False\n",
       "4      False\n",
       "       ...  \n",
       "132    False\n",
       "133    False\n",
       "134    False\n",
       "135    False\n",
       "136    False\n",
       "Length: 137, dtype: bool"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# checking duplicates values for column 'year_Ending'\n",
    "Cleaned_Data.duplicated()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Changing the Data type"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "IndicatorCode                object\n",
       "Indicator                    object\n",
       "Patents_Continent_Code       object\n",
       "ParentLocation_Continent     object\n",
       "Country_Code                 object\n",
       "Country                      object\n",
       "Gender                       object\n",
       "Age_Group                    object\n",
       "Planning_Value_Rate         float64\n",
       "FactComments                 object\n",
       "Language_Code                object\n",
       "Starting_Year                object\n",
       "Year_Ending                  object\n",
       "dtype: object"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Checking Data type\n",
    "Cleaned_Data.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "#change data type\n",
    "Cleaned_Data['Starting_Year'] = pd.to_numeric(Cleaned_Data['Starting_Year'], errors='coerce')\n",
    "Cleaned_Data['Year_Ending'] = pd.to_numeric(Cleaned_Data['Year_Ending'], errors='coerce')\n",
    "Cleaned_Data['Gender'] = Cleaned_Data['Gender'].astype('category')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "IndicatorCode                 object\n",
       "Indicator                     object\n",
       "Patents_Continent_Code        object\n",
       "ParentLocation_Continent      object\n",
       "Country_Code                  object\n",
       "Country                       object\n",
       "Gender                      category\n",
       "Age_Group                     object\n",
       "Planning_Value_Rate          float64\n",
       "FactComments                  object\n",
       "Language_Code                 object\n",
       "Starting_Year                  int64\n",
       "Year_Ending                    int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Cleaned_Data.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Data Transformation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "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>IndicatorCode</th>\n",
       "      <th>Indicator</th>\n",
       "      <th>Patents_Continent_Code</th>\n",
       "      <th>ParentLocation_Continent</th>\n",
       "      <th>Country_Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age_Group</th>\n",
       "      <th>Planning_Value_Rate</th>\n",
       "      <th>FactComments</th>\n",
       "      <th>Language_Code</th>\n",
       "      <th>Starting_Year</th>\n",
       "      <th>Year_Ending</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>UGA</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.5</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2021</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>NER</td>\n",
       "      <td>Niger</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>36.9</td>\n",
       "      <td>Niger 2021 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>BFA</td>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>58.2</td>\n",
       "      <td>Burkina Faso 2021 PMA Survey Phase 2</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>WPR</td>\n",
       "      <td>Western Pacific</td>\n",
       "      <td>VNM</td>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>72.1</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>CIV</td>\n",
       "      <td>Cote d'Ivoire</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>46.1</td>\n",
       "      <td>Côte d'Ivoire 2020 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Europe</td>\n",
       "      <td>MDA</td>\n",
       "      <td>Republic of Moldova</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>59.5</td>\n",
       "      <td>Moldova 2020 Gender and Generations Survey</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>ETH</td>\n",
       "      <td>Ethiopia</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>62.6</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>MDG</td>\n",
       "      <td>Madagascar</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.6</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AMR</td>\n",
       "      <td>Americas</td>\n",
       "      <td>PER</td>\n",
       "      <td>Peru</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.9</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>KEN</td>\n",
       "      <td>Kenya</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>77.1</td>\n",
       "      <td>Kenya 2020 PMA Survey Phase 2</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2020</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  IndicatorCode                                          Indicator  \\\n",
       "0      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "1      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "2      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "3      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "4      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "5      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "6      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "7      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "8      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "9      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "\n",
       "  Patents_Continent_Code ParentLocation_Continent Country_Code  \\\n",
       "0                    AFR                   Africa          UGA   \n",
       "1                    AFR                   Africa          NER   \n",
       "2                    AFR                   Africa          BFA   \n",
       "3                    WPR          Western Pacific          VNM   \n",
       "4                    AFR                   Africa          CIV   \n",
       "5                    EUR                   Europe          MDA   \n",
       "6                    AFR                   Africa          ETH   \n",
       "7                    AFR                   Africa          MDG   \n",
       "8                    AMR                 Americas          PER   \n",
       "9                    AFR                   Africa          KEN   \n",
       "\n",
       "               Country  Gender    Age_Group  Planning_Value_Rate  \\\n",
       "0               Uganda  Female  15-49 years                 65.5   \n",
       "1                Niger  Female  15-49 years                 36.9   \n",
       "2         Burkina Faso  Female  15-49 years                 58.2   \n",
       "3             Viet Nam  Female  15-49 years                 72.1   \n",
       "4        Cote d'Ivoire  Female  15-49 years                 46.1   \n",
       "5  Republic of Moldova  Female  15-49 years                 59.5   \n",
       "6             Ethiopia  Female  15-49 years                 62.6   \n",
       "7           Madagascar  Female  15-49 years                 65.6   \n",
       "8                 Peru  Female  15-49 years                 65.9   \n",
       "9                Kenya  Female  15-49 years                 77.1   \n",
       "\n",
       "                                        FactComments Language_Code  \\\n",
       "0  The global indicator represents all women of r...            EN   \n",
       "1                      Niger 2021 PMA Survey Phase 1            EN   \n",
       "2               Burkina Faso 2021 PMA Survey Phase 2            EN   \n",
       "3  The global indicator represents all women of r...            EN   \n",
       "4              Côte d'Ivoire 2020 PMA Survey Phase 1            EN   \n",
       "5         Moldova 2020 Gender and Generations Survey            EN   \n",
       "6  The global indicator represents all women of r...            EN   \n",
       "7  The global indicator represents all women of r...            EN   \n",
       "8  The global indicator represents all women of r...            EN   \n",
       "9                      Kenya 2020 PMA Survey Phase 2            EN   \n",
       "\n",
       "   Starting_Year  Year_Ending  \n",
       "0           2021         2021  \n",
       "1           2020         2021  \n",
       "2           2020         2021  \n",
       "3           2020         2021  \n",
       "4           2020         2020  \n",
       "5           2020         2020  \n",
       "6           2020         2020  \n",
       "7           2020         2020  \n",
       "8           2020         2020  \n",
       "9           2020         2020  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Cleaned DataFrame\n",
    "Cleaned_Data.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Merging Starting year and ending year column named \"Year_Period\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "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>IndicatorCode</th>\n",
       "      <th>Indicator</th>\n",
       "      <th>Patents_Continent_Code</th>\n",
       "      <th>ParentLocation_Continent</th>\n",
       "      <th>Country_Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age_Group</th>\n",
       "      <th>Planning_Value_Rate</th>\n",
       "      <th>FactComments</th>\n",
       "      <th>Language_Code</th>\n",
       "      <th>Starting_Year</th>\n",
       "      <th>Year_Ending</th>\n",
       "      <th>Year_Group</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>UGA</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.5</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2021</td>\n",
       "      <td>2021</td>\n",
       "      <td>2021-2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>NER</td>\n",
       "      <td>Niger</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>36.9</td>\n",
       "      <td>Niger 2021 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "      <td>2020-2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>BFA</td>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>58.2</td>\n",
       "      <td>Burkina Faso 2021 PMA Survey Phase 2</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "      <td>2020-2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>WPR</td>\n",
       "      <td>Western Pacific</td>\n",
       "      <td>VNM</td>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>72.1</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "      <td>2020-2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>CIV</td>\n",
       "      <td>Cote d'Ivoire</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>46.1</td>\n",
       "      <td>Côte d'Ivoire 2020 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2020</td>\n",
       "      <td>2020-2020</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  IndicatorCode                                          Indicator  \\\n",
       "0      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "1      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "2      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "3      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "4      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "\n",
       "  Patents_Continent_Code ParentLocation_Continent Country_Code        Country  \\\n",
       "0                    AFR                   Africa          UGA         Uganda   \n",
       "1                    AFR                   Africa          NER          Niger   \n",
       "2                    AFR                   Africa          BFA   Burkina Faso   \n",
       "3                    WPR          Western Pacific          VNM       Viet Nam   \n",
       "4                    AFR                   Africa          CIV  Cote d'Ivoire   \n",
       "\n",
       "   Gender    Age_Group  Planning_Value_Rate  \\\n",
       "0  Female  15-49 years                 65.5   \n",
       "1  Female  15-49 years                 36.9   \n",
       "2  Female  15-49 years                 58.2   \n",
       "3  Female  15-49 years                 72.1   \n",
       "4  Female  15-49 years                 46.1   \n",
       "\n",
       "                                        FactComments Language_Code  \\\n",
       "0  The global indicator represents all women of r...            EN   \n",
       "1                      Niger 2021 PMA Survey Phase 1            EN   \n",
       "2               Burkina Faso 2021 PMA Survey Phase 2            EN   \n",
       "3  The global indicator represents all women of r...            EN   \n",
       "4              Côte d'Ivoire 2020 PMA Survey Phase 1            EN   \n",
       "\n",
       "   Starting_Year  Year_Ending Year_Group  \n",
       "0           2021         2021  2021-2021  \n",
       "1           2020         2021  2020-2021  \n",
       "2           2020         2021  2020-2021  \n",
       "3           2020         2021  2020-2021  \n",
       "4           2020         2020  2020-2020  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Create a new column by merging Starting_Year and Year_Ending\n",
    "Cleaned_Data['Year_Group'] = Cleaned_Data['Starting_Year'].astype(str) + '-' + Cleaned_Data['Year_Ending'].astype(str)\n",
    "Cleaned_Data.head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Year Group column Groupped by Year Ranges as per requirements \n",
    "from, \n",
    "Ranges, \n",
    "2003-2005,  \n",
    "2006-2008,\n",
    "2009-2011,\n",
    "2012-2014,\n",
    "2015-2017,\n",
    "2018-2020,\n",
    "2021-2023"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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>IndicatorCode</th>\n",
       "      <th>Indicator</th>\n",
       "      <th>Patents_Continent_Code</th>\n",
       "      <th>ParentLocation_Continent</th>\n",
       "      <th>Country_Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age_Group</th>\n",
       "      <th>Planning_Value_Rate</th>\n",
       "      <th>FactComments</th>\n",
       "      <th>Language_Code</th>\n",
       "      <th>Starting_Year</th>\n",
       "      <th>Year_Ending</th>\n",
       "      <th>Year_Group</th>\n",
       "      <th>Year_Period_Range</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>UGA</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.5</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2021</td>\n",
       "      <td>2021</td>\n",
       "      <td>2021-2021</td>\n",
       "      <td>2021-2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>NER</td>\n",
       "      <td>Niger</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>36.9</td>\n",
       "      <td>Niger 2021 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>2021-2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>BFA</td>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>58.2</td>\n",
       "      <td>Burkina Faso 2021 PMA Survey Phase 2</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>2021-2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>WPR</td>\n",
       "      <td>Western Pacific</td>\n",
       "      <td>VNM</td>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>72.1</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>2021-2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>CIV</td>\n",
       "      <td>Cote d'Ivoire</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>46.1</td>\n",
       "      <td>Côte d'Ivoire 2020 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2020</td>\n",
       "      <td>2020-2020</td>\n",
       "      <td>2018-2020</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  IndicatorCode                                          Indicator  \\\n",
       "0      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "1      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "2      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "3      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "4      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "\n",
       "  Patents_Continent_Code ParentLocation_Continent Country_Code        Country  \\\n",
       "0                    AFR                   Africa          UGA         Uganda   \n",
       "1                    AFR                   Africa          NER          Niger   \n",
       "2                    AFR                   Africa          BFA   Burkina Faso   \n",
       "3                    WPR          Western Pacific          VNM       Viet Nam   \n",
       "4                    AFR                   Africa          CIV  Cote d'Ivoire   \n",
       "\n",
       "   Gender    Age_Group  Planning_Value_Rate  \\\n",
       "0  Female  15-49 years                 65.5   \n",
       "1  Female  15-49 years                 36.9   \n",
       "2  Female  15-49 years                 58.2   \n",
       "3  Female  15-49 years                 72.1   \n",
       "4  Female  15-49 years                 46.1   \n",
       "\n",
       "                                        FactComments Language_Code  \\\n",
       "0  The global indicator represents all women of r...            EN   \n",
       "1                      Niger 2021 PMA Survey Phase 1            EN   \n",
       "2               Burkina Faso 2021 PMA Survey Phase 2            EN   \n",
       "3  The global indicator represents all women of r...            EN   \n",
       "4              Côte d'Ivoire 2020 PMA Survey Phase 1            EN   \n",
       "\n",
       "   Starting_Year  Year_Ending Year_Group Year_Period_Range  \n",
       "0           2021         2021  2021-2021         2021-2023  \n",
       "1           2020         2021  2020-2021         2021-2023  \n",
       "2           2020         2021  2020-2021         2021-2023  \n",
       "3           2020         2021  2020-2021         2021-2023  \n",
       "4           2020         2020  2020-2020         2018-2020  "
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "# Function to determine the range for each Year_Period\n",
    "def get_year_range(year_Group):\n",
    "    end_year = int(year_Group.split('-')[1])\n",
    "    if 2003 <= end_year <= 2005:\n",
    "        return '2003-2005'\n",
    "    elif 2006 <= end_year <= 2008:\n",
    "        return '2006-2008'\n",
    "    elif 2009 <= end_year <= 2011:\n",
    "        return '2009-2011'\n",
    "    elif 2012 <= end_year <= 2014:\n",
    "        return '2012-2014'\n",
    "    elif 2015 <= end_year <= 2017:\n",
    "        return '2015-2017'\n",
    "    elif 2018 <= end_year <= 2020:\n",
    "        return '2018-2020'\n",
    "    elif 2021 <= end_year <= 2023:\n",
    "        return '2021-2023'\n",
    "    else:\n",
    "        return 'Out of Range'\n",
    "\n",
    "# Apply the function to Year_Period\n",
    "Cleaned_Data['Year_Period_Range'] = Cleaned_Data['Year_Group'].apply(get_year_range)\n",
    "\n",
    "# Display the DataFrame with the new Year_Range column\n",
    "Cleaned_Data.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "IndicatorCode                 object\n",
       "Indicator                     object\n",
       "Patents_Continent_Code        object\n",
       "ParentLocation_Continent      object\n",
       "Country_Code                  object\n",
       "Country                       object\n",
       "Gender                      category\n",
       "Age_Group                     object\n",
       "Planning_Value_Rate          float64\n",
       "FactComments                  object\n",
       "Language_Code                 object\n",
       "Starting_Year                  int64\n",
       "Year_Ending                    int64\n",
       "Year_Group                    object\n",
       "Year_Period_Range             object\n",
       "dtype: object"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Cleaned_Data.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Cleaned Data for Family Planning"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "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>IndicatorCode</th>\n",
       "      <th>Indicator</th>\n",
       "      <th>Patents_Continent_Code</th>\n",
       "      <th>ParentLocation_Continent</th>\n",
       "      <th>Country_Code</th>\n",
       "      <th>Country</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Age_Group</th>\n",
       "      <th>Planning_Value_Rate</th>\n",
       "      <th>FactComments</th>\n",
       "      <th>Language_Code</th>\n",
       "      <th>Starting_Year</th>\n",
       "      <th>Year_Ending</th>\n",
       "      <th>Year_Group</th>\n",
       "      <th>Year_Period_Range</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>UGA</td>\n",
       "      <td>Uganda</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>65.5</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2021</td>\n",
       "      <td>2021</td>\n",
       "      <td>2021-2021</td>\n",
       "      <td>2021-2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>NER</td>\n",
       "      <td>Niger</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>36.9</td>\n",
       "      <td>Niger 2021 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>2021-2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>BFA</td>\n",
       "      <td>Burkina Faso</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>58.2</td>\n",
       "      <td>Burkina Faso 2021 PMA Survey Phase 2</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>2021-2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>WPR</td>\n",
       "      <td>Western Pacific</td>\n",
       "      <td>VNM</td>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>72.1</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2021</td>\n",
       "      <td>2020-2021</td>\n",
       "      <td>2021-2023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>CIV</td>\n",
       "      <td>Cote d'Ivoire</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>46.1</td>\n",
       "      <td>Côte d'Ivoire 2020 PMA Survey Phase 1</td>\n",
       "      <td>EN</td>\n",
       "      <td>2020</td>\n",
       "      <td>2020</td>\n",
       "      <td>2020-2020</td>\n",
       "      <td>2018-2020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Europe</td>\n",
       "      <td>AZE</td>\n",
       "      <td>Azerbaijan</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>21.5</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2006</td>\n",
       "      <td>2006</td>\n",
       "      <td>2006-2006</td>\n",
       "      <td>2006-2008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>AFR</td>\n",
       "      <td>Africa</td>\n",
       "      <td>CPV</td>\n",
       "      <td>Cabo Verde</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>73.2</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2005</td>\n",
       "      <td>2005</td>\n",
       "      <td>2005-2005</td>\n",
       "      <td>2003-2005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Europe</td>\n",
       "      <td>FRA</td>\n",
       "      <td>France</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>95.5</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2004</td>\n",
       "      <td>2005</td>\n",
       "      <td>2004-2005</td>\n",
       "      <td>2003-2005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>EUR</td>\n",
       "      <td>Europe</td>\n",
       "      <td>ROU</td>\n",
       "      <td>Romania</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>46.5</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2004</td>\n",
       "      <td>2004</td>\n",
       "      <td>2004-2004</td>\n",
       "      <td>2003-2005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>SDGFPALL</td>\n",
       "      <td>Women of reproductive age (aged 15-49 years) w...</td>\n",
       "      <td>WPR</td>\n",
       "      <td>Western Pacific</td>\n",
       "      <td>CHN</td>\n",
       "      <td>China</td>\n",
       "      <td>Female</td>\n",
       "      <td>15-49 years</td>\n",
       "      <td>96.6</td>\n",
       "      <td>The global indicator represents all women of r...</td>\n",
       "      <td>EN</td>\n",
       "      <td>2001</td>\n",
       "      <td>2001</td>\n",
       "      <td>2001-2001</td>\n",
       "      <td>Out of Range</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>137 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    IndicatorCode                                          Indicator  \\\n",
       "0        SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "1        SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "2        SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "3        SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "4        SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "..            ...                                                ...   \n",
       "132      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "133      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "134      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "135      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "136      SDGFPALL  Women of reproductive age (aged 15-49 years) w...   \n",
       "\n",
       "    Patents_Continent_Code ParentLocation_Continent Country_Code  \\\n",
       "0                      AFR                   Africa          UGA   \n",
       "1                      AFR                   Africa          NER   \n",
       "2                      AFR                   Africa          BFA   \n",
       "3                      WPR          Western Pacific          VNM   \n",
       "4                      AFR                   Africa          CIV   \n",
       "..                     ...                      ...          ...   \n",
       "132                    EUR                   Europe          AZE   \n",
       "133                    AFR                   Africa          CPV   \n",
       "134                    EUR                   Europe          FRA   \n",
       "135                    EUR                   Europe          ROU   \n",
       "136                    WPR          Western Pacific          CHN   \n",
       "\n",
       "           Country  Gender    Age_Group  Planning_Value_Rate  \\\n",
       "0           Uganda  Female  15-49 years                 65.5   \n",
       "1            Niger  Female  15-49 years                 36.9   \n",
       "2     Burkina Faso  Female  15-49 years                 58.2   \n",
       "3         Viet Nam  Female  15-49 years                 72.1   \n",
       "4    Cote d'Ivoire  Female  15-49 years                 46.1   \n",
       "..             ...     ...          ...                  ...   \n",
       "132     Azerbaijan  Female  15-49 years                 21.5   \n",
       "133     Cabo Verde  Female  15-49 years                 73.2   \n",
       "134         France  Female  15-49 years                 95.5   \n",
       "135        Romania  Female  15-49 years                 46.5   \n",
       "136          China  Female  15-49 years                 96.6   \n",
       "\n",
       "                                          FactComments Language_Code  \\\n",
       "0    The global indicator represents all women of r...            EN   \n",
       "1                        Niger 2021 PMA Survey Phase 1            EN   \n",
       "2                 Burkina Faso 2021 PMA Survey Phase 2            EN   \n",
       "3    The global indicator represents all women of r...            EN   \n",
       "4                Côte d'Ivoire 2020 PMA Survey Phase 1            EN   \n",
       "..                                                 ...           ...   \n",
       "132  The global indicator represents all women of r...            EN   \n",
       "133  The global indicator represents all women of r...            EN   \n",
       "134  The global indicator represents all women of r...            EN   \n",
       "135  The global indicator represents all women of r...            EN   \n",
       "136  The global indicator represents all women of r...            EN   \n",
       "\n",
       "     Starting_Year  Year_Ending Year_Group Year_Period_Range  \n",
       "0             2021         2021  2021-2021         2021-2023  \n",
       "1             2020         2021  2020-2021         2021-2023  \n",
       "2             2020         2021  2020-2021         2021-2023  \n",
       "3             2020         2021  2020-2021         2021-2023  \n",
       "4             2020         2020  2020-2020         2018-2020  \n",
       "..             ...          ...        ...               ...  \n",
       "132           2006         2006  2006-2006         2006-2008  \n",
       "133           2005         2005  2005-2005         2003-2005  \n",
       "134           2004         2005  2004-2005         2003-2005  \n",
       "135           2004         2004  2004-2004         2003-2005  \n",
       "136           2001         2001  2001-2001      Out of Range  \n",
       "\n",
       "[137 rows x 15 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Cleaned_Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Cleaned_Data successfully exported to Extracted Cleaned Data File/Cleaned_Data.csv\n"
     ]
    }
   ],
   "source": [
    "# Set the path to the resources folder to exctract CSV of Cleaned Data\n",
    "resources_path = \"Extracted Cleaned Data File\"\n",
    "filename = \"Cleaned_Data.csv\"\n",
    "\n",
    "# Save the Cleaned_Data DataFrame to a CSV file in the resources folder\n",
    "Cleaned_Data.to_csv(f\"{resources_path}/{filename}\", index=False)\n",
    "\n",
    "print(f\"Cleaned_Data successfully exported to {resources_path}/{filename}\")\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "dev",
   "language": "python",
   "name": "dev"
  },
  "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.10.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}