{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1 = pd.read_csv('Stats/GDP-March-quarter.csv', heade)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1.rename(columns={'Series_title_2':'Industry', 'Series_title_1':'GDP_measure', 'Series_title_3':'Sector'}, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Series_reference</th>\n",
       "      <th>Period</th>\n",
       "      <th>Data_value</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>UNITS</th>\n",
       "      <th>MAGNTUDE</th>\n",
       "      <th>Subject</th>\n",
       "      <th>Group</th>\n",
       "      <th>GDP_measure</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Sector</th>\n",
       "      <th>Series_title_4</th>\n",
       "      <th>Series_title_5</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SNEA.SG00NAC00B15</td>\n",
       "      <td>1972.03</td>\n",
       "      <td>6990.0</td>\n",
       "      <td>FINAL</td>\n",
       "      <td>Dollars</td>\n",
       "      <td>6</td>\n",
       "      <td>National Accounts - SNA 2008 - SNE</td>\n",
       "      <td>Series, Key aggregates, Nominal, Actual, Total</td>\n",
       "      <td>Gross Domestic Product - expenditure measure</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SNEA.SG00NAC00B15</td>\n",
       "      <td>1973.03</td>\n",
       "      <td>8080.0</td>\n",
       "      <td>FINAL</td>\n",
       "      <td>Dollars</td>\n",
       "      <td>6</td>\n",
       "      <td>National Accounts - SNA 2008 - SNE</td>\n",
       "      <td>Series, Key aggregates, Nominal, Actual, Total</td>\n",
       "      <td>Gross Domestic Product - expenditure measure</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SNEA.SG00NAC00B15</td>\n",
       "      <td>1974.03</td>\n",
       "      <td>9361.0</td>\n",
       "      <td>FINAL</td>\n",
       "      <td>Dollars</td>\n",
       "      <td>6</td>\n",
       "      <td>National Accounts - SNA 2008 - SNE</td>\n",
       "      <td>Series, Key aggregates, Nominal, Actual, Total</td>\n",
       "      <td>Gross Domestic Product - expenditure measure</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SNEA.SG00NAC00B15</td>\n",
       "      <td>1975.03</td>\n",
       "      <td>10203.0</td>\n",
       "      <td>FINAL</td>\n",
       "      <td>Dollars</td>\n",
       "      <td>6</td>\n",
       "      <td>National Accounts - SNA 2008 - SNE</td>\n",
       "      <td>Series, Key aggregates, Nominal, Actual, Total</td>\n",
       "      <td>Gross Domestic Product - expenditure measure</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SNEA.SG00NAC00B15</td>\n",
       "      <td>1976.03</td>\n",
       "      <td>11506.0</td>\n",
       "      <td>FINAL</td>\n",
       "      <td>Dollars</td>\n",
       "      <td>6</td>\n",
       "      <td>National Accounts - SNA 2008 - SNE</td>\n",
       "      <td>Series, Key aggregates, Nominal, Actual, Total</td>\n",
       "      <td>Gross Domestic Product - expenditure measure</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Series_reference   Period  Data_value STATUS    UNITS  MAGNTUDE  \\\n",
       "0  SNEA.SG00NAC00B15  1972.03      6990.0  FINAL  Dollars         6   \n",
       "1  SNEA.SG00NAC00B15  1973.03      8080.0  FINAL  Dollars         6   \n",
       "2  SNEA.SG00NAC00B15  1974.03      9361.0  FINAL  Dollars         6   \n",
       "3  SNEA.SG00NAC00B15  1975.03     10203.0  FINAL  Dollars         6   \n",
       "4  SNEA.SG00NAC00B15  1976.03     11506.0  FINAL  Dollars         6   \n",
       "\n",
       "                              Subject  \\\n",
       "0  National Accounts - SNA 2008 - SNE   \n",
       "1  National Accounts - SNA 2008 - SNE   \n",
       "2  National Accounts - SNA 2008 - SNE   \n",
       "3  National Accounts - SNA 2008 - SNE   \n",
       "4  National Accounts - SNA 2008 - SNE   \n",
       "\n",
       "                                            Group  \\\n",
       "0  Series, Key aggregates, Nominal, Actual, Total   \n",
       "1  Series, Key aggregates, Nominal, Actual, Total   \n",
       "2  Series, Key aggregates, Nominal, Actual, Total   \n",
       "3  Series, Key aggregates, Nominal, Actual, Total   \n",
       "4  Series, Key aggregates, Nominal, Actual, Total   \n",
       "\n",
       "                                    GDP_measure Industry Sector  \\\n",
       "0  Gross Domestic Product - expenditure measure      NaN    NaN   \n",
       "1  Gross Domestic Product - expenditure measure      NaN    NaN   \n",
       "2  Gross Domestic Product - expenditure measure      NaN    NaN   \n",
       "3  Gross Domestic Product - expenditure measure      NaN    NaN   \n",
       "4  Gross Domestic Product - expenditure measure      NaN    NaN   \n",
       "\n",
       "   Series_title_4  Series_title_5  \n",
       "0             NaN             NaN  \n",
       "1             NaN             NaN  \n",
       "2             NaN             NaN  \n",
       "3             NaN             NaN  \n",
       "4             NaN             NaN  "
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2=df1[['Series_reference', 'GDP_measure','Industry','Sector','Period','Data_value']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "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>GDP_measure</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Gross Domestic Product - expenditure measure</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>Gross National Expenditure</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>342</th>\n",
       "      <td>Gross Domestic Product - production measure</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>507</th>\n",
       "      <td>Disposable Income - gross</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6364</th>\n",
       "      <td>Final Consumption Expenditure</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6411</th>\n",
       "      <td>Gross Fixed Capital Formation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6458</th>\n",
       "      <td>Changes in Inventories</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7804</th>\n",
       "      <td>Exports of Goods</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8084</th>\n",
       "      <td>Imports of Goods</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11777</th>\n",
       "      <td>National Income - gross</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11963</th>\n",
       "      <td>Trading Gain or Loss</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12118</th>\n",
       "      <td>Domestic Income - gross</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12273</th>\n",
       "      <td>Investment Income, net</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12397</th>\n",
       "      <td>Current Transfers and Taxes, net</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12521</th>\n",
       "      <td>Gross Capital Formation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12739</th>\n",
       "      <td>Exports of Goods and Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12818</th>\n",
       "      <td>Exports of Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12850</th>\n",
       "      <td>Imports of Goods and Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12929</th>\n",
       "      <td>Imports of Services</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        GDP_measure\n",
       "0      Gross Domestic Product - expenditure measure\n",
       "171                      Gross National Expenditure\n",
       "342     Gross Domestic Product - production measure\n",
       "507                       Disposable Income - gross\n",
       "6364                  Final Consumption Expenditure\n",
       "6411                  Gross Fixed Capital Formation\n",
       "6458                         Changes in Inventories\n",
       "7804                               Exports of Goods\n",
       "8084                               Imports of Goods\n",
       "11777                       National Income - gross\n",
       "11963                          Trading Gain or Loss\n",
       "12118                       Domestic Income - gross\n",
       "12273                        Investment Income, net\n",
       "12397              Current Transfers and Taxes, net\n",
       "12521                       Gross Capital Formation\n",
       "12739                 Exports of Goods and Services\n",
       "12818                           Exports of Services\n",
       "12850                 Imports of Goods and Services\n",
       "12929                           Imports of Services"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2[['GDP_measure']].drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "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>Industry</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1013</th>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1178</th>\n",
       "      <td>Mining</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1343</th>\n",
       "      <td>Primary Industries</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1508</th>\n",
       "      <td>Manufacturing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1673</th>\n",
       "      <td>Electricity, Gas, Water and Waste Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1838</th>\n",
       "      <td>Construction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2003</th>\n",
       "      <td>Food Manufacturing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2044</th>\n",
       "      <td>Manufacturing (excluding Food Manufacturing)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2075</th>\n",
       "      <td>Goods Producing Industries</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2240</th>\n",
       "      <td>Wholesale trade</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2405</th>\n",
       "      <td>Retail Trade and Accommodation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2570</th>\n",
       "      <td>Transport, Postal and Warehousing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2735</th>\n",
       "      <td>Information Media and Telecommunications</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2900</th>\n",
       "      <td>Financial and Insurance Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3065</th>\n",
       "      <td>Rental, Hiring and Real Estate Services (inclu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3230</th>\n",
       "      <td>Professional, Scientific, Technical, Administr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3395</th>\n",
       "      <td>Public Administration and Safety</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3560</th>\n",
       "      <td>Education and Training</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3725</th>\n",
       "      <td>Health Care and Social Assistance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3890</th>\n",
       "      <td>Arts, Recreation and Other Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4055</th>\n",
       "      <td>Service Industries</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4425</th>\n",
       "      <td>Wholesale Trade</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4630</th>\n",
       "      <td>Rental, Hiring and Real Estate Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4876</th>\n",
       "      <td>Total All Industries</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4917</th>\n",
       "      <td>Agriculture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4958</th>\n",
       "      <td>Forestry and Logging</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4999</th>\n",
       "      <td>Fishing, Aquaculture and Agriculture, Forestry...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5081</th>\n",
       "      <td>Food, Beverage and Tobacco Product Manufacturing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5122</th>\n",
       "      <td>Textile, Leather, Clothing and Footwear Manufa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8252</th>\n",
       "      <td>Intermediate goods - industrial supplies nes -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8280</th>\n",
       "      <td>Intermediate goods - fuels and lubricants - pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8308</th>\n",
       "      <td>Intermediate goods - fuels and lubricants - pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8336</th>\n",
       "      <td>Intermediate goods - parts and accessories of ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8364</th>\n",
       "      <td>Intermediate goods - Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8392</th>\n",
       "      <td>Consumption goods - food and beverages, mainly...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8420</th>\n",
       "      <td>Consumption goods - food and beverages, mainly...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8448</th>\n",
       "      <td>Consumption goods - transport equipment, non-i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8476</th>\n",
       "      <td>Consumption goods - consumer goods nes - durab...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8504</th>\n",
       "      <td>Consumption goods - consumer goods nes - semi-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8532</th>\n",
       "      <td>Consumption goods - consumer goods nes - non-d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8560</th>\n",
       "      <td>Consumption goods - Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8588</th>\n",
       "      <td>Passenger motor cars.  BEC 51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8616</th>\n",
       "      <td>Petrol and avgas.  BEC 321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8644</th>\n",
       "      <td>Military and other goods.  BEC 7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8672</th>\n",
       "      <td>General Government</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8704</th>\n",
       "      <td>Private Non Profit Organisations Serving House...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8736</th>\n",
       "      <td>Households</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8768</th>\n",
       "      <td>Private Non Profit Organisations and Household...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8800</th>\n",
       "      <td>Central Government</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8832</th>\n",
       "      <td>Local Government</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10018</th>\n",
       "      <td>Total Expenditure by Households in New Zealand</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10668</th>\n",
       "      <td>Consumption goods - Low value goods purchased ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14604</th>\n",
       "      <td>Per Capita in New Zealand dollars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16030</th>\n",
       "      <td>Percentage change from same period previous year</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22851</th>\n",
       "      <td>Tradeable direct</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22979</th>\n",
       "      <td>Non-tradeable direct</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23107</th>\n",
       "      <td>Tradeable Indirect</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23235</th>\n",
       "      <td>Non-tradeable Indirect</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23615</th>\n",
       "      <td>Percentage change from previous period</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>126 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                Industry\n",
       "0                                                    NaN\n",
       "1013                   Agriculture, Forestry and Fishing\n",
       "1178                                              Mining\n",
       "1343                                  Primary Industries\n",
       "1508                                       Manufacturing\n",
       "1673          Electricity, Gas, Water and Waste Services\n",
       "1838                                        Construction\n",
       "2003                                  Food Manufacturing\n",
       "2044        Manufacturing (excluding Food Manufacturing)\n",
       "2075                          Goods Producing Industries\n",
       "2240                                     Wholesale trade\n",
       "2405                      Retail Trade and Accommodation\n",
       "2570                   Transport, Postal and Warehousing\n",
       "2735            Information Media and Telecommunications\n",
       "2900                    Financial and Insurance Services\n",
       "3065   Rental, Hiring and Real Estate Services (inclu...\n",
       "3230   Professional, Scientific, Technical, Administr...\n",
       "3395                    Public Administration and Safety\n",
       "3560                              Education and Training\n",
       "3725                   Health Care and Social Assistance\n",
       "3890                 Arts, Recreation and Other Services\n",
       "4055                                  Service Industries\n",
       "4425                                     Wholesale Trade\n",
       "4630             Rental, Hiring and Real Estate Services\n",
       "4876                                Total All Industries\n",
       "4917                                         Agriculture\n",
       "4958                                Forestry and Logging\n",
       "4999   Fishing, Aquaculture and Agriculture, Forestry...\n",
       "5081    Food, Beverage and Tobacco Product Manufacturing\n",
       "5122   Textile, Leather, Clothing and Footwear Manufa...\n",
       "...                                                  ...\n",
       "8252   Intermediate goods - industrial supplies nes -...\n",
       "8280   Intermediate goods - fuels and lubricants - pr...\n",
       "8308   Intermediate goods - fuels and lubricants - pr...\n",
       "8336   Intermediate goods - parts and accessories of ...\n",
       "8364                          Intermediate goods - Total\n",
       "8392   Consumption goods - food and beverages, mainly...\n",
       "8420   Consumption goods - food and beverages, mainly...\n",
       "8448   Consumption goods - transport equipment, non-i...\n",
       "8476   Consumption goods - consumer goods nes - durab...\n",
       "8504   Consumption goods - consumer goods nes - semi-...\n",
       "8532   Consumption goods - consumer goods nes - non-d...\n",
       "8560                           Consumption goods - Total\n",
       "8588                       Passenger motor cars.  BEC 51\n",
       "8616                          Petrol and avgas.  BEC 321\n",
       "8644                    Military and other goods.  BEC 7\n",
       "8672                                  General Government\n",
       "8704   Private Non Profit Organisations Serving House...\n",
       "8736                                          Households\n",
       "8768   Private Non Profit Organisations and Household...\n",
       "8800                                  Central Government\n",
       "8832                                    Local Government\n",
       "10018     Total Expenditure by Households in New Zealand\n",
       "10668  Consumption goods - Low value goods purchased ...\n",
       "14604                  Per Capita in New Zealand dollars\n",
       "16030   Percentage change from same period previous year\n",
       "22851                                   Tradeable direct\n",
       "22979                               Non-tradeable direct\n",
       "23107                                 Tradeable Indirect\n",
       "23235                             Non-tradeable Indirect\n",
       "23615             Percentage change from previous period\n",
       "\n",
       "[126 rows x 1 columns]"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2[['Industry']].drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "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>Sector</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6505</th>\n",
       "      <td>Private</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6552</th>\n",
       "      <td>All Sectors</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6599</th>\n",
       "      <td>General Government</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7208</th>\n",
       "      <td>Households</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Sector\n",
       "0                    NaN\n",
       "6505             Private\n",
       "6552         All Sectors\n",
       "6599  General Government\n",
       "7208          Households"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2[['Sector']].drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [],
   "source": [
    "df3=df2[['Series_reference','GDP_measure','Industry', 'Sector']].drop_duplicates(['GDP_measure','Industry','Sector'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "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>Series_reference</th>\n",
       "      <th>GDP_measure</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Sector</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>23107</th>\n",
       "      <td>SNEQ.SG01RAC34B0113</td>\n",
       "      <td>Gross Domestic Product - production measure</td>\n",
       "      <td>Tradeable Indirect</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23235</th>\n",
       "      <td>SNEQ.SG01RAC34B0114</td>\n",
       "      <td>Gross Domestic Product - production measure</td>\n",
       "      <td>Non-tradeable Indirect</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23615</th>\n",
       "      <td>SNEQ.SG01RSC01B01PC</td>\n",
       "      <td>Gross Domestic Product - production measure</td>\n",
       "      <td>Percentage change from previous period</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31323</th>\n",
       "      <td>SNEQ.SG02NAC00P50Z</td>\n",
       "      <td>Gross Capital Formation</td>\n",
       "      <td>Total All Institutonal Sectors</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68812</th>\n",
       "      <td>SNEQ.SG02RSC31B15PC</td>\n",
       "      <td>Gross Domestic Product - expenditure measure</td>\n",
       "      <td>Percentage change from previous period</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Series_reference                                   GDP_measure  \\\n",
       "23107  SNEQ.SG01RAC34B0113   Gross Domestic Product - production measure   \n",
       "23235  SNEQ.SG01RAC34B0114   Gross Domestic Product - production measure   \n",
       "23615  SNEQ.SG01RSC01B01PC   Gross Domestic Product - production measure   \n",
       "31323   SNEQ.SG02NAC00P50Z                       Gross Capital Formation   \n",
       "68812  SNEQ.SG02RSC31B15PC  Gross Domestic Product - expenditure measure   \n",
       "\n",
       "                                     Industry Sector  \n",
       "23107                      Tradeable Indirect    NaN  \n",
       "23235                  Non-tradeable Indirect    NaN  \n",
       "23615  Percentage change from previous period    NaN  \n",
       "31323          Total All Institutonal Sectors    NaN  \n",
       "68812  Percentage change from previous period    NaN  "
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "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>Series_reference</th>\n",
       "      <th>GDP_measure</th>\n",
       "      <th>Industry</th>\n",
       "      <th>Sector</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SNEA.SG00NAC00B15</td>\n",
       "      <td>Gross Domestic Product - expenditure measure</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>SNEA.SG00NAC00B21</td>\n",
       "      <td>Gross National Expenditure</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>342</th>\n",
       "      <td>SNEA.SG00RAC00B01</td>\n",
       "      <td>Gross Domestic Product - production measure</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>507</th>\n",
       "      <td>SNEA.SG00RAC00B06</td>\n",
       "      <td>Disposable Income - gross</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1013</th>\n",
       "      <td>SNEA.SG01RAC02B01A01</td>\n",
       "      <td>Gross Domestic Product - production measure</td>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          Series_reference                                   GDP_measure  \\\n",
       "0        SNEA.SG00NAC00B15  Gross Domestic Product - expenditure measure   \n",
       "171      SNEA.SG00NAC00B21                    Gross National Expenditure   \n",
       "342      SNEA.SG00RAC00B01   Gross Domestic Product - production measure   \n",
       "507      SNEA.SG00RAC00B06                     Disposable Income - gross   \n",
       "1013  SNEA.SG01RAC02B01A01   Gross Domestic Product - production measure   \n",
       "\n",
       "                               Industry Sector  \n",
       "0                                   NaN    NaN  \n",
       "171                                 NaN    NaN  \n",
       "342                                 NaN    NaN  \n",
       "507                                 NaN    NaN  \n",
       "1013  Agriculture, Forestry and Fishing    NaN  "
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.head()"
   ]
  },
  {
   "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>Series_title_2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1013</th>\n",
       "      <td>Agriculture, Forestry and Fishing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1178</th>\n",
       "      <td>Mining</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1343</th>\n",
       "      <td>Primary Industries</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1508</th>\n",
       "      <td>Manufacturing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1673</th>\n",
       "      <td>Electricity, Gas, Water and Waste Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1838</th>\n",
       "      <td>Construction</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2003</th>\n",
       "      <td>Food Manufacturing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2044</th>\n",
       "      <td>Manufacturing (excluding Food Manufacturing)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2075</th>\n",
       "      <td>Goods Producing Industries</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2240</th>\n",
       "      <td>Wholesale trade</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2405</th>\n",
       "      <td>Retail Trade and Accommodation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2570</th>\n",
       "      <td>Transport, Postal and Warehousing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2735</th>\n",
       "      <td>Information Media and Telecommunications</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2900</th>\n",
       "      <td>Financial and Insurance Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3065</th>\n",
       "      <td>Rental, Hiring and Real Estate Services (inclu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3230</th>\n",
       "      <td>Professional, Scientific, Technical, Administr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3395</th>\n",
       "      <td>Public Administration and Safety</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3560</th>\n",
       "      <td>Education and Training</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3725</th>\n",
       "      <td>Health Care and Social Assistance</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3890</th>\n",
       "      <td>Arts, Recreation and Other Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4055</th>\n",
       "      <td>Service Industries</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4425</th>\n",
       "      <td>Wholesale Trade</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4630</th>\n",
       "      <td>Rental, Hiring and Real Estate Services</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4876</th>\n",
       "      <td>Total All Industries</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4917</th>\n",
       "      <td>Agriculture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4958</th>\n",
       "      <td>Forestry and Logging</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4999</th>\n",
       "      <td>Fishing, Aquaculture and Agriculture, Forestry...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5081</th>\n",
       "      <td>Food, Beverage and Tobacco Product Manufacturing</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5122</th>\n",
       "      <td>Textile, Leather, Clothing and Footwear Manufa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8252</th>\n",
       "      <td>Intermediate goods - industrial supplies nes -...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8280</th>\n",
       "      <td>Intermediate goods - fuels and lubricants - pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8308</th>\n",
       "      <td>Intermediate goods - fuels and lubricants - pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8336</th>\n",
       "      <td>Intermediate goods - parts and accessories of ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8364</th>\n",
       "      <td>Intermediate goods - Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8392</th>\n",
       "      <td>Consumption goods - food and beverages, mainly...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8420</th>\n",
       "      <td>Consumption goods - food and beverages, mainly...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8448</th>\n",
       "      <td>Consumption goods - transport equipment, non-i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8476</th>\n",
       "      <td>Consumption goods - consumer goods nes - durab...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8504</th>\n",
       "      <td>Consumption goods - consumer goods nes - semi-...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8532</th>\n",
       "      <td>Consumption goods - consumer goods nes - non-d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8560</th>\n",
       "      <td>Consumption goods - Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8588</th>\n",
       "      <td>Passenger motor cars.  BEC 51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8616</th>\n",
       "      <td>Petrol and avgas.  BEC 321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8644</th>\n",
       "      <td>Military and other goods.  BEC 7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8672</th>\n",
       "      <td>General Government</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8704</th>\n",
       "      <td>Private Non Profit Organisations Serving House...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8736</th>\n",
       "      <td>Households</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8768</th>\n",
       "      <td>Private Non Profit Organisations and Household...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8800</th>\n",
       "      <td>Central Government</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8832</th>\n",
       "      <td>Local Government</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10018</th>\n",
       "      <td>Total Expenditure by Households in New Zealand</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10668</th>\n",
       "      <td>Consumption goods - Low value goods purchased ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14604</th>\n",
       "      <td>Per Capita in New Zealand dollars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16030</th>\n",
       "      <td>Percentage change from same period previous year</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22851</th>\n",
       "      <td>Tradeable direct</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22979</th>\n",
       "      <td>Non-tradeable direct</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23107</th>\n",
       "      <td>Tradeable Indirect</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23235</th>\n",
       "      <td>Non-tradeable Indirect</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23615</th>\n",
       "      <td>Percentage change from previous period</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>126 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          Series_title_2\n",
       "0                                                    NaN\n",
       "1013                   Agriculture, Forestry and Fishing\n",
       "1178                                              Mining\n",
       "1343                                  Primary Industries\n",
       "1508                                       Manufacturing\n",
       "1673          Electricity, Gas, Water and Waste Services\n",
       "1838                                        Construction\n",
       "2003                                  Food Manufacturing\n",
       "2044        Manufacturing (excluding Food Manufacturing)\n",
       "2075                          Goods Producing Industries\n",
       "2240                                     Wholesale trade\n",
       "2405                      Retail Trade and Accommodation\n",
       "2570                   Transport, Postal and Warehousing\n",
       "2735            Information Media and Telecommunications\n",
       "2900                    Financial and Insurance Services\n",
       "3065   Rental, Hiring and Real Estate Services (inclu...\n",
       "3230   Professional, Scientific, Technical, Administr...\n",
       "3395                    Public Administration and Safety\n",
       "3560                              Education and Training\n",
       "3725                   Health Care and Social Assistance\n",
       "3890                 Arts, Recreation and Other Services\n",
       "4055                                  Service Industries\n",
       "4425                                     Wholesale Trade\n",
       "4630             Rental, Hiring and Real Estate Services\n",
       "4876                                Total All Industries\n",
       "4917                                         Agriculture\n",
       "4958                                Forestry and Logging\n",
       "4999   Fishing, Aquaculture and Agriculture, Forestry...\n",
       "5081    Food, Beverage and Tobacco Product Manufacturing\n",
       "5122   Textile, Leather, Clothing and Footwear Manufa...\n",
       "...                                                  ...\n",
       "8252   Intermediate goods - industrial supplies nes -...\n",
       "8280   Intermediate goods - fuels and lubricants - pr...\n",
       "8308   Intermediate goods - fuels and lubricants - pr...\n",
       "8336   Intermediate goods - parts and accessories of ...\n",
       "8364                          Intermediate goods - Total\n",
       "8392   Consumption goods - food and beverages, mainly...\n",
       "8420   Consumption goods - food and beverages, mainly...\n",
       "8448   Consumption goods - transport equipment, non-i...\n",
       "8476   Consumption goods - consumer goods nes - durab...\n",
       "8504   Consumption goods - consumer goods nes - semi-...\n",
       "8532   Consumption goods - consumer goods nes - non-d...\n",
       "8560                           Consumption goods - Total\n",
       "8588                       Passenger motor cars.  BEC 51\n",
       "8616                          Petrol and avgas.  BEC 321\n",
       "8644                    Military and other goods.  BEC 7\n",
       "8672                                  General Government\n",
       "8704   Private Non Profit Organisations Serving House...\n",
       "8736                                          Households\n",
       "8768   Private Non Profit Organisations and Household...\n",
       "8800                                  Central Government\n",
       "8832                                    Local Government\n",
       "10018     Total Expenditure by Households in New Zealand\n",
       "10668  Consumption goods - Low value goods purchased ...\n",
       "14604                  Per Capita in New Zealand dollars\n",
       "16030   Percentage change from same period previous year\n",
       "22851                                   Tradeable direct\n",
       "22979                               Non-tradeable direct\n",
       "23107                                 Tradeable Indirect\n",
       "23235                             Non-tradeable Indirect\n",
       "23615             Percentage change from previous period\n",
       "\n",
       "[126 rows x 1 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1[['Series_title_2']].drop_duplicates('Series_title_2')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "pvt1=pd.pivot_table(df1, values='Data_value', index=['Subject','Series_title_1', 'Series_title_2', 'Period'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>Data_value</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Subject</th>\n",
       "      <th>Series_title_1</th>\n",
       "      <th>Series_title_2</th>\n",
       "      <th>Period</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">National Accounts - SNA 2008 - SNE</th>\n",
       "      <th rowspan=\"5\" valign=\"top\">Changes in Inventories</th>\n",
       "      <th rowspan=\"5\" valign=\"top\">Agriculture</th>\n",
       "      <th>1987.06</th>\n",
       "      <td>-125.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1987.09</th>\n",
       "      <td>108.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1987.12</th>\n",
       "      <td>175.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1988.03</th>\n",
       "      <td>44.833333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1988.06</th>\n",
       "      <td>-124.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                  Data_value\n",
       "Subject                            Series_title_1         Series_title_2 Period             \n",
       "National Accounts - SNA 2008 - SNE Changes in Inventories Agriculture    1987.06 -125.250000\n",
       "                                                                         1987.09  108.500000\n",
       "                                                                         1987.12  175.250000\n",
       "                                                                         1988.03   44.833333\n",
       "                                                                         1988.06 -124.000000"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pvt1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}