Pandas-Index5.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "3f7b9e84",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "57aba24f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "MultiIndex([('sale1', 'city1'),\n",
       "            ('sale1', 'city2'),\n",
       "            ('sale3', 'city1'),\n",
       "            ('sale3', 'city2'),\n",
       "            ('sale2', 'city1'),\n",
       "            ('sale2', 'city2'),\n",
       "            ('sale4', 'city1'),\n",
       "            ('sale4', 'city2')],\n",
       "           names=['sale', 'city'])"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Q16\n",
    "sales_arrays = [['sale1', 'sale1', 'sale3', 'sale3', 'sale2', 'sale2', 'sale4', 'sale4'],\n",
    "          ['city1', 'city2', 'city1', 'city2', 'city1', 'city2', 'city1', 'city2']]\n",
    "sales_tuples = list(zip(*sales_arrays))\n",
    "sales_index = pd.MultiIndex.from_tuples(sales_tuples, names=['sale', 'city'])\n",
    "sales_index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "aa65c148",
   "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></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale</th>\n",
       "      <th>city</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale1</th>\n",
       "      <th>city1</th>\n",
       "      <td>-0.461717</td>\n",
       "      <td>-0.849750</td>\n",
       "      <td>1.536588</td>\n",
       "      <td>-0.134867</td>\n",
       "      <td>-1.229712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>0.526030</td>\n",
       "      <td>0.013659</td>\n",
       "      <td>0.508688</td>\n",
       "      <td>-0.912416</td>\n",
       "      <td>0.807268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale3</th>\n",
       "      <th>city1</th>\n",
       "      <td>0.238338</td>\n",
       "      <td>-0.198246</td>\n",
       "      <td>1.049587</td>\n",
       "      <td>-0.772416</td>\n",
       "      <td>-0.866806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>-0.765368</td>\n",
       "      <td>-0.757655</td>\n",
       "      <td>0.937963</td>\n",
       "      <td>-0.059179</td>\n",
       "      <td>1.748848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale2</th>\n",
       "      <th>city1</th>\n",
       "      <td>-0.061157</td>\n",
       "      <td>0.919326</td>\n",
       "      <td>-0.392212</td>\n",
       "      <td>-1.488231</td>\n",
       "      <td>-0.775506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>0.894558</td>\n",
       "      <td>-0.031363</td>\n",
       "      <td>-1.876255</td>\n",
       "      <td>0.007966</td>\n",
       "      <td>-0.163100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale4</th>\n",
       "      <th>city1</th>\n",
       "      <td>-2.067706</td>\n",
       "      <td>1.925042</td>\n",
       "      <td>-1.515836</td>\n",
       "      <td>-0.525976</td>\n",
       "      <td>0.339392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>-0.351080</td>\n",
       "      <td>-0.693101</td>\n",
       "      <td>-0.189494</td>\n",
       "      <td>-0.064504</td>\n",
       "      <td>0.893700</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    0         1         2         3         4\n",
       "sale  city                                                   \n",
       "sale1 city1 -0.461717 -0.849750  1.536588 -0.134867 -1.229712\n",
       "      city2  0.526030  0.013659  0.508688 -0.912416  0.807268\n",
       "sale3 city1  0.238338 -0.198246  1.049587 -0.772416 -0.866806\n",
       "      city2 -0.765368 -0.757655  0.937963 -0.059179  1.748848\n",
       "sale2 city1 -0.061157  0.919326 -0.392212 -1.488231 -0.775506\n",
       "      city2  0.894558 -0.031363 -1.876255  0.007966 -0.163100\n",
       "sale4 city1 -2.067706  1.925042 -1.515836 -0.525976  0.339392\n",
       "      city2 -0.351080 -0.693101 -0.189494 -0.064504  0.893700"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame(np.random.randn(8,5), index=sales_index)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "49831d3c",
   "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></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale</th>\n",
       "      <th>city</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale1</th>\n",
       "      <th>city1</th>\n",
       "      <td>-0.461717</td>\n",
       "      <td>-0.849750</td>\n",
       "      <td>1.536588</td>\n",
       "      <td>-0.134867</td>\n",
       "      <td>-1.229712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>0.526030</td>\n",
       "      <td>0.013659</td>\n",
       "      <td>0.508688</td>\n",
       "      <td>-0.912416</td>\n",
       "      <td>0.807268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale2</th>\n",
       "      <th>city1</th>\n",
       "      <td>-0.061157</td>\n",
       "      <td>0.919326</td>\n",
       "      <td>-0.392212</td>\n",
       "      <td>-1.488231</td>\n",
       "      <td>-0.775506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>0.894558</td>\n",
       "      <td>-0.031363</td>\n",
       "      <td>-1.876255</td>\n",
       "      <td>0.007966</td>\n",
       "      <td>-0.163100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale3</th>\n",
       "      <th>city1</th>\n",
       "      <td>0.238338</td>\n",
       "      <td>-0.198246</td>\n",
       "      <td>1.049587</td>\n",
       "      <td>-0.772416</td>\n",
       "      <td>-0.866806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>-0.765368</td>\n",
       "      <td>-0.757655</td>\n",
       "      <td>0.937963</td>\n",
       "      <td>-0.059179</td>\n",
       "      <td>1.748848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale4</th>\n",
       "      <th>city1</th>\n",
       "      <td>-2.067706</td>\n",
       "      <td>1.925042</td>\n",
       "      <td>-1.515836</td>\n",
       "      <td>-0.525976</td>\n",
       "      <td>0.339392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>-0.351080</td>\n",
       "      <td>-0.693101</td>\n",
       "      <td>-0.189494</td>\n",
       "      <td>-0.064504</td>\n",
       "      <td>0.893700</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    0         1         2         3         4\n",
       "sale  city                                                   \n",
       "sale1 city1 -0.461717 -0.849750  1.536588 -0.134867 -1.229712\n",
       "      city2  0.526030  0.013659  0.508688 -0.912416  0.807268\n",
       "sale2 city1 -0.061157  0.919326 -0.392212 -1.488231 -0.775506\n",
       "      city2  0.894558 -0.031363 -1.876255  0.007966 -0.163100\n",
       "sale3 city1  0.238338 -0.198246  1.049587 -0.772416 -0.866806\n",
       "      city2 -0.765368 -0.757655  0.937963 -0.059179  1.748848\n",
       "sale4 city1 -2.067706  1.925042 -1.515836 -0.525976  0.339392\n",
       "      city2 -0.351080 -0.693101 -0.189494 -0.064504  0.893700"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1 = df.sort_index()\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "b9717eee",
   "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></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale</th>\n",
       "      <th>city</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale1</th>\n",
       "      <th>city1</th>\n",
       "      <td>-0.461717</td>\n",
       "      <td>-0.849750</td>\n",
       "      <td>1.536588</td>\n",
       "      <td>-0.134867</td>\n",
       "      <td>-1.229712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>0.526030</td>\n",
       "      <td>0.013659</td>\n",
       "      <td>0.508688</td>\n",
       "      <td>-0.912416</td>\n",
       "      <td>0.807268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale2</th>\n",
       "      <th>city1</th>\n",
       "      <td>-0.061157</td>\n",
       "      <td>0.919326</td>\n",
       "      <td>-0.392212</td>\n",
       "      <td>-1.488231</td>\n",
       "      <td>-0.775506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>0.894558</td>\n",
       "      <td>-0.031363</td>\n",
       "      <td>-1.876255</td>\n",
       "      <td>0.007966</td>\n",
       "      <td>-0.163100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale3</th>\n",
       "      <th>city1</th>\n",
       "      <td>0.238338</td>\n",
       "      <td>-0.198246</td>\n",
       "      <td>1.049587</td>\n",
       "      <td>-0.772416</td>\n",
       "      <td>-0.866806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>-0.765368</td>\n",
       "      <td>-0.757655</td>\n",
       "      <td>0.937963</td>\n",
       "      <td>-0.059179</td>\n",
       "      <td>1.748848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale4</th>\n",
       "      <th>city1</th>\n",
       "      <td>-2.067706</td>\n",
       "      <td>1.925042</td>\n",
       "      <td>-1.515836</td>\n",
       "      <td>-0.525976</td>\n",
       "      <td>0.339392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>-0.351080</td>\n",
       "      <td>-0.693101</td>\n",
       "      <td>-0.189494</td>\n",
       "      <td>-0.064504</td>\n",
       "      <td>0.893700</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    0         1         2         3         4\n",
       "sale  city                                                   \n",
       "sale1 city1 -0.461717 -0.849750  1.536588 -0.134867 -1.229712\n",
       "      city2  0.526030  0.013659  0.508688 -0.912416  0.807268\n",
       "sale2 city1 -0.061157  0.919326 -0.392212 -1.488231 -0.775506\n",
       "      city2  0.894558 -0.031363 -1.876255  0.007966 -0.163100\n",
       "sale3 city1  0.238338 -0.198246  1.049587 -0.772416 -0.866806\n",
       "      city2 -0.765368 -0.757655  0.937963 -0.059179  1.748848\n",
       "sale4 city1 -2.067706  1.925042 -1.515836 -0.525976  0.339392\n",
       "      city2 -0.351080 -0.693101 -0.189494 -0.064504  0.893700"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = df.sort_index(level=0)\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "37de079c",
   "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></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale</th>\n",
       "      <th>city</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>sale1</th>\n",
       "      <th>city1</th>\n",
       "      <td>-0.461717</td>\n",
       "      <td>-0.849750</td>\n",
       "      <td>1.536588</td>\n",
       "      <td>-0.134867</td>\n",
       "      <td>-1.229712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale2</th>\n",
       "      <th>city1</th>\n",
       "      <td>-0.061157</td>\n",
       "      <td>0.919326</td>\n",
       "      <td>-0.392212</td>\n",
       "      <td>-1.488231</td>\n",
       "      <td>-0.775506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale3</th>\n",
       "      <th>city1</th>\n",
       "      <td>0.238338</td>\n",
       "      <td>-0.198246</td>\n",
       "      <td>1.049587</td>\n",
       "      <td>-0.772416</td>\n",
       "      <td>-0.866806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale4</th>\n",
       "      <th>city1</th>\n",
       "      <td>-2.067706</td>\n",
       "      <td>1.925042</td>\n",
       "      <td>-1.515836</td>\n",
       "      <td>-0.525976</td>\n",
       "      <td>0.339392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale1</th>\n",
       "      <th>city2</th>\n",
       "      <td>0.526030</td>\n",
       "      <td>0.013659</td>\n",
       "      <td>0.508688</td>\n",
       "      <td>-0.912416</td>\n",
       "      <td>0.807268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale2</th>\n",
       "      <th>city2</th>\n",
       "      <td>0.894558</td>\n",
       "      <td>-0.031363</td>\n",
       "      <td>-1.876255</td>\n",
       "      <td>0.007966</td>\n",
       "      <td>-0.163100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale3</th>\n",
       "      <th>city2</th>\n",
       "      <td>-0.765368</td>\n",
       "      <td>-0.757655</td>\n",
       "      <td>0.937963</td>\n",
       "      <td>-0.059179</td>\n",
       "      <td>1.748848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale4</th>\n",
       "      <th>city2</th>\n",
       "      <td>-0.351080</td>\n",
       "      <td>-0.693101</td>\n",
       "      <td>-0.189494</td>\n",
       "      <td>-0.064504</td>\n",
       "      <td>0.893700</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    0         1         2         3         4\n",
       "sale  city                                                   \n",
       "sale1 city1 -0.461717 -0.849750  1.536588 -0.134867 -1.229712\n",
       "sale2 city1 -0.061157  0.919326 -0.392212 -1.488231 -0.775506\n",
       "sale3 city1  0.238338 -0.198246  1.049587 -0.772416 -0.866806\n",
       "sale4 city1 -2.067706  1.925042 -1.515836 -0.525976  0.339392\n",
       "sale1 city2  0.526030  0.013659  0.508688 -0.912416  0.807268\n",
       "sale2 city2  0.894558 -0.031363 -1.876255  0.007966 -0.163100\n",
       "sale3 city2 -0.765368 -0.757655  0.937963 -0.059179  1.748848\n",
       "sale4 city2 -0.351080 -0.693101 -0.189494 -0.064504  0.893700"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = df.sort_index(level=1)\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "50b87dd4",
   "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></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale</th>\n",
       "      <th>city</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>sale1</th>\n",
       "      <th>city1</th>\n",
       "      <td>-0.461717</td>\n",
       "      <td>-0.849750</td>\n",
       "      <td>1.536588</td>\n",
       "      <td>-0.134867</td>\n",
       "      <td>-1.229712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale2</th>\n",
       "      <th>city1</th>\n",
       "      <td>-0.061157</td>\n",
       "      <td>0.919326</td>\n",
       "      <td>-0.392212</td>\n",
       "      <td>-1.488231</td>\n",
       "      <td>-0.775506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale3</th>\n",
       "      <th>city1</th>\n",
       "      <td>0.238338</td>\n",
       "      <td>-0.198246</td>\n",
       "      <td>1.049587</td>\n",
       "      <td>-0.772416</td>\n",
       "      <td>-0.866806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale4</th>\n",
       "      <th>city1</th>\n",
       "      <td>-2.067706</td>\n",
       "      <td>1.925042</td>\n",
       "      <td>-1.515836</td>\n",
       "      <td>-0.525976</td>\n",
       "      <td>0.339392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale1</th>\n",
       "      <th>city2</th>\n",
       "      <td>0.526030</td>\n",
       "      <td>0.013659</td>\n",
       "      <td>0.508688</td>\n",
       "      <td>-0.912416</td>\n",
       "      <td>0.807268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale2</th>\n",
       "      <th>city2</th>\n",
       "      <td>0.894558</td>\n",
       "      <td>-0.031363</td>\n",
       "      <td>-1.876255</td>\n",
       "      <td>0.007966</td>\n",
       "      <td>-0.163100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale3</th>\n",
       "      <th>city2</th>\n",
       "      <td>-0.765368</td>\n",
       "      <td>-0.757655</td>\n",
       "      <td>0.937963</td>\n",
       "      <td>-0.059179</td>\n",
       "      <td>1.748848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale4</th>\n",
       "      <th>city2</th>\n",
       "      <td>-0.351080</td>\n",
       "      <td>-0.693101</td>\n",
       "      <td>-0.189494</td>\n",
       "      <td>-0.064504</td>\n",
       "      <td>0.893700</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    0         1         2         3         4\n",
       "sale  city                                                   \n",
       "sale1 city1 -0.461717 -0.849750  1.536588 -0.134867 -1.229712\n",
       "sale2 city1 -0.061157  0.919326 -0.392212 -1.488231 -0.775506\n",
       "sale3 city1  0.238338 -0.198246  1.049587 -0.772416 -0.866806\n",
       "sale4 city1 -2.067706  1.925042 -1.515836 -0.525976  0.339392\n",
       "sale1 city2  0.526030  0.013659  0.508688 -0.912416  0.807268\n",
       "sale2 city2  0.894558 -0.031363 -1.876255  0.007966 -0.163100\n",
       "sale3 city2 -0.765368 -0.757655  0.937963 -0.059179  1.748848\n",
       "sale4 city2 -0.351080 -0.693101 -0.189494 -0.064504  0.893700"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3 = df.sort_index(level='city')\n",
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "898f7fd8",
   "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></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale</th>\n",
       "      <th>city</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale1</th>\n",
       "      <th>city1</th>\n",
       "      <td>-0.461717</td>\n",
       "      <td>-0.849750</td>\n",
       "      <td>1.536588</td>\n",
       "      <td>-0.134867</td>\n",
       "      <td>-1.229712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>0.526030</td>\n",
       "      <td>0.013659</td>\n",
       "      <td>0.508688</td>\n",
       "      <td>-0.912416</td>\n",
       "      <td>0.807268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale3</th>\n",
       "      <th>city1</th>\n",
       "      <td>0.238338</td>\n",
       "      <td>-0.198246</td>\n",
       "      <td>1.049587</td>\n",
       "      <td>-0.772416</td>\n",
       "      <td>-0.866806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>-0.765368</td>\n",
       "      <td>-0.757655</td>\n",
       "      <td>0.937963</td>\n",
       "      <td>-0.059179</td>\n",
       "      <td>1.748848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale2</th>\n",
       "      <th>city1</th>\n",
       "      <td>-0.061157</td>\n",
       "      <td>0.919326</td>\n",
       "      <td>-0.392212</td>\n",
       "      <td>-1.488231</td>\n",
       "      <td>-0.775506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>0.894558</td>\n",
       "      <td>-0.031363</td>\n",
       "      <td>-1.876255</td>\n",
       "      <td>0.007966</td>\n",
       "      <td>-0.163100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale4</th>\n",
       "      <th>city1</th>\n",
       "      <td>-2.067706</td>\n",
       "      <td>1.925042</td>\n",
       "      <td>-1.515836</td>\n",
       "      <td>-0.525976</td>\n",
       "      <td>0.339392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>-0.351080</td>\n",
       "      <td>-0.693101</td>\n",
       "      <td>-0.189494</td>\n",
       "      <td>-0.064504</td>\n",
       "      <td>0.893700</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    0         1         2         3         4\n",
       "sale  city                                                   \n",
       "sale1 city1 -0.461717 -0.849750  1.536588 -0.134867 -1.229712\n",
       "      city2  0.526030  0.013659  0.508688 -0.912416  0.807268\n",
       "sale3 city1  0.238338 -0.198246  1.049587 -0.772416 -0.866806\n",
       "      city2 -0.765368 -0.757655  0.937963 -0.059179  1.748848\n",
       "sale2 city1 -0.061157  0.919326 -0.392212 -1.488231 -0.775506\n",
       "      city2  0.894558 -0.031363 -1.876255  0.007966 -0.163100\n",
       "sale4 city1 -2.067706  1.925042 -1.515836 -0.525976  0.339392\n",
       "      city2 -0.351080 -0.693101 -0.189494 -0.064504  0.893700"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Q17\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "1f035742",
   "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></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale</th>\n",
       "      <th>city</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale1</th>\n",
       "      <th>city1</th>\n",
       "      <td>-0.461717</td>\n",
       "      <td>-0.849750</td>\n",
       "      <td>1.536588</td>\n",
       "      <td>-0.134867</td>\n",
       "      <td>-1.229712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>0.526030</td>\n",
       "      <td>0.013659</td>\n",
       "      <td>0.508688</td>\n",
       "      <td>-0.912416</td>\n",
       "      <td>0.807268</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale3</th>\n",
       "      <th>city1</th>\n",
       "      <td>0.238338</td>\n",
       "      <td>-0.198246</td>\n",
       "      <td>1.049587</td>\n",
       "      <td>-0.772416</td>\n",
       "      <td>-0.866806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>-0.765368</td>\n",
       "      <td>-0.757655</td>\n",
       "      <td>0.937963</td>\n",
       "      <td>-0.059179</td>\n",
       "      <td>1.748848</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    0         1         2         3         4\n",
       "sale  city                                                   \n",
       "sale1 city1 -0.461717 -0.849750  1.536588 -0.134867 -1.229712\n",
       "      city2  0.526030  0.013659  0.508688 -0.912416  0.807268\n",
       "sale3 city1  0.238338 -0.198246  1.049587 -0.772416 -0.866806\n",
       "      city2 -0.765368 -0.757655  0.937963 -0.059179  1.748848"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "positions = [0,1, 2, 3]\n",
    "df.take(positions)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "8b9bd177",
   "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></th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale</th>\n",
       "      <th>city</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale1</th>\n",
       "      <th>city1</th>\n",
       "      <td>-0.849750</td>\n",
       "      <td>1.536588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>0.013659</td>\n",
       "      <td>0.508688</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale3</th>\n",
       "      <th>city1</th>\n",
       "      <td>-0.198246</td>\n",
       "      <td>1.049587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>-0.757655</td>\n",
       "      <td>0.937963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale2</th>\n",
       "      <th>city1</th>\n",
       "      <td>0.919326</td>\n",
       "      <td>-0.392212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>-0.031363</td>\n",
       "      <td>-1.876255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale4</th>\n",
       "      <th>city1</th>\n",
       "      <td>1.925042</td>\n",
       "      <td>-1.515836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>-0.693101</td>\n",
       "      <td>-0.189494</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    1         2\n",
       "sale  city                     \n",
       "sale1 city1 -0.849750  1.536588\n",
       "      city2  0.013659  0.508688\n",
       "sale3 city1 -0.198246  1.049587\n",
       "      city2 -0.757655  0.937963\n",
       "sale2 city1  0.919326 -0.392212\n",
       "      city2 -0.031363 -1.876255\n",
       "sale4 city1  1.925042 -1.515836\n",
       "      city2 -0.693101 -0.189494"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.take([1,2], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "586b9dfa",
   "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></th>\n",
       "      <th>4</th>\n",
       "      <th>3</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale</th>\n",
       "      <th>city</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale1</th>\n",
       "      <th>city1</th>\n",
       "      <td>-1.229712</td>\n",
       "      <td>-0.134867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>0.807268</td>\n",
       "      <td>-0.912416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale3</th>\n",
       "      <th>city1</th>\n",
       "      <td>-0.866806</td>\n",
       "      <td>-0.772416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>1.748848</td>\n",
       "      <td>-0.059179</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale2</th>\n",
       "      <th>city1</th>\n",
       "      <td>-0.775506</td>\n",
       "      <td>-1.488231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>-0.163100</td>\n",
       "      <td>0.007966</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">sale4</th>\n",
       "      <th>city1</th>\n",
       "      <td>0.339392</td>\n",
       "      <td>-0.525976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city2</th>\n",
       "      <td>0.893700</td>\n",
       "      <td>-0.064504</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    4         3\n",
       "sale  city                     \n",
       "sale1 city1 -1.229712 -0.134867\n",
       "      city2  0.807268 -0.912416\n",
       "sale3 city1 -0.866806 -0.772416\n",
       "      city2  1.748848 -0.059179\n",
       "sale2 city1 -0.775506 -1.488231\n",
       "      city2 -0.163100  0.007966\n",
       "sale4 city1  0.339392 -0.525976\n",
       "      city2  0.893700 -0.064504"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.take([-1,-2], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "bfb56ebc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     1\n",
       "1     3\n",
       "2     5\n",
       "3     7\n",
       "4     9\n",
       "5    11\n",
       "7    13\n",
       "8    15\n",
       "dtype: int64"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Q18\n",
    "ds = pd.Series([1,3,5,7,9,11,13,15], index=[0,1,2,3,4,5,7,8])\n",
    "ds"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "5ec1c7ca",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "7"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x = ds[ds==13].index[0]\n",
    "x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "758cf004",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Q19\n",
    "ds.iloc[2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "7ff557a7",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "11"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ds.iloc[5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "f7605cc6",
   "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></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sale</th>\n",
       "      <th>city</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>sale4</th>\n",
       "      <th>city2</th>\n",
       "      <td>-0.35108</td>\n",
       "      <td>-0.693101</td>\n",
       "      <td>-0.189494</td>\n",
       "      <td>-0.064504</td>\n",
       "      <td>0.8937</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   0         1         2         3       4\n",
       "sale  city                                                \n",
       "sale4 city2 -0.35108 -0.693101 -0.189494 -0.064504  0.8937"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[[-1]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "b2e7187c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "MultiIndex([], names=['sale', 'city'])"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Q20\n",
    "df.index[df[1]=='0.013659']"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}