08- Explicit Indexes.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "aca24b19-61bb-4bbf-a8a9-f29df63e656a",
   "metadata": {},
   "outputs": [],
   "source": [
    "from IPython.display import display"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "952fd3be-f85b-4e39-b562-e9620d27e9fc",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "df = pd.read_csv('./datasets/game_sales.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "69192873-a8d7-4734-b3c2-d399e4a321ed",
   "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>name</th>\n",
       "      <th>platform</th>\n",
       "      <th>year</th>\n",
       "      <th>genre</th>\n",
       "      <th>publisher</th>\n",
       "      <th>na_sales</th>\n",
       "      <th>eu_sales</th>\n",
       "      <th>jp_sales</th>\n",
       "      <th>other_sales</th>\n",
       "      <th>global_sales</th>\n",
       "      <th>critic_score</th>\n",
       "      <th>critic_count</th>\n",
       "      <th>user_score</th>\n",
       "      <th>user_count</th>\n",
       "      <th>rating</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Wii Sports</td>\n",
       "      <td>Wii</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>Sports</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>41.36</td>\n",
       "      <td>28.96</td>\n",
       "      <td>3.77</td>\n",
       "      <td>8.45</td>\n",
       "      <td>82.54</td>\n",
       "      <td>76.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>324.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2006-10-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Super Mario Bros.</td>\n",
       "      <td>NES</td>\n",
       "      <td>1985.0</td>\n",
       "      <td>Platform</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>29.08</td>\n",
       "      <td>3.58</td>\n",
       "      <td>6.81</td>\n",
       "      <td>0.77</td>\n",
       "      <td>40.24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1985-01-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Mario Kart Wii</td>\n",
       "      <td>Wii</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>Racing</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>15.68</td>\n",
       "      <td>12.80</td>\n",
       "      <td>3.79</td>\n",
       "      <td>3.29</td>\n",
       "      <td>35.57</td>\n",
       "      <td>82.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>8.3</td>\n",
       "      <td>712.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2008-11-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Wii Sports Resort</td>\n",
       "      <td>Wii</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>Sports</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>15.61</td>\n",
       "      <td>10.95</td>\n",
       "      <td>3.28</td>\n",
       "      <td>2.95</td>\n",
       "      <td>32.78</td>\n",
       "      <td>80.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>193.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2009-11-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Pokemon Red/Pokemon Blue</td>\n",
       "      <td>G</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>Role-Playing</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>11.27</td>\n",
       "      <td>8.89</td>\n",
       "      <td>10.22</td>\n",
       "      <td>1.00</td>\n",
       "      <td>31.37</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1996-08-17</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       name platform    year         genre publisher  \\\n",
       "0                Wii Sports      Wii  2006.0        Sports  Nintendo   \n",
       "1         Super Mario Bros.      NES  1985.0      Platform  Nintendo   \n",
       "2            Mario Kart Wii      Wii  2008.0        Racing  Nintendo   \n",
       "3         Wii Sports Resort      Wii  2009.0        Sports  Nintendo   \n",
       "4  Pokemon Red/Pokemon Blue        G  1996.0  Role-Playing  Nintendo   \n",
       "\n",
       "   na_sales  eu_sales  jp_sales  other_sales  global_sales  critic_score  \\\n",
       "0     41.36     28.96      3.77         8.45         82.54          76.0   \n",
       "1     29.08      3.58      6.81         0.77         40.24           NaN   \n",
       "2     15.68     12.80      3.79         3.29         35.57          82.0   \n",
       "3     15.61     10.95      3.28         2.95         32.78          80.0   \n",
       "4     11.27      8.89     10.22         1.00         31.37           NaN   \n",
       "\n",
       "   critic_count  user_score  user_count rating        date  \n",
       "0          51.0         8.0       324.0      E  2006-10-09  \n",
       "1           NaN         NaN         NaN    NaN  1985-01-20  \n",
       "2          73.0         8.3       712.0      E  2008-11-16  \n",
       "3          73.0         8.0       193.0      E  2009-11-25  \n",
       "4           NaN         NaN         NaN    NaN  1996-08-17  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "138a088c-39a2-441d-8c3e-ec6ebb094f1d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RangeIndex(start=0, stop=17408, step=1)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "5fccc84f-9e15-4afd-9f7c-f0a8755f31f8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['name', 'platform', 'year', 'genre', 'publisher', 'na_sales',\n",
       "       'eu_sales', 'jp_sales', 'other_sales', 'global_sales', 'critic_score',\n",
       "       'critic_count', 'user_score', 'user_count', 'rating', 'date'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "c227b32e-2564-4b99-849e-792a5aabb328",
   "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>platform</th>\n",
       "      <th>year</th>\n",
       "      <th>genre</th>\n",
       "      <th>publisher</th>\n",
       "      <th>na_sales</th>\n",
       "      <th>eu_sales</th>\n",
       "      <th>jp_sales</th>\n",
       "      <th>other_sales</th>\n",
       "      <th>global_sales</th>\n",
       "      <th>critic_score</th>\n",
       "      <th>critic_count</th>\n",
       "      <th>user_score</th>\n",
       "      <th>user_count</th>\n",
       "      <th>rating</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Wii Sports</th>\n",
       "      <td>Wii</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>Sports</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>41.36</td>\n",
       "      <td>28.96</td>\n",
       "      <td>3.77</td>\n",
       "      <td>8.45</td>\n",
       "      <td>82.54</td>\n",
       "      <td>76.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>324.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2006-10-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Super Mario Bros.</th>\n",
       "      <td>NES</td>\n",
       "      <td>1985.0</td>\n",
       "      <td>Platform</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>29.08</td>\n",
       "      <td>3.58</td>\n",
       "      <td>6.81</td>\n",
       "      <td>0.77</td>\n",
       "      <td>40.24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1985-01-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mario Kart Wii</th>\n",
       "      <td>Wii</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>Racing</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>15.68</td>\n",
       "      <td>12.80</td>\n",
       "      <td>3.79</td>\n",
       "      <td>3.29</td>\n",
       "      <td>35.57</td>\n",
       "      <td>82.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>8.3</td>\n",
       "      <td>712.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2008-11-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wii Sports Resort</th>\n",
       "      <td>Wii</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>Sports</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>15.61</td>\n",
       "      <td>10.95</td>\n",
       "      <td>3.28</td>\n",
       "      <td>2.95</td>\n",
       "      <td>32.78</td>\n",
       "      <td>80.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>193.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2009-11-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Pokemon Red/Pokemon Blue</th>\n",
       "      <td>G</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>Role-Playing</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>11.27</td>\n",
       "      <td>8.89</td>\n",
       "      <td>10.22</td>\n",
       "      <td>1.00</td>\n",
       "      <td>31.37</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1996-08-17</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                         platform    year         genre publisher  na_sales  \\\n",
       "name                                                                          \n",
       "Wii Sports                    Wii  2006.0        Sports  Nintendo     41.36   \n",
       "Super Mario Bros.             NES  1985.0      Platform  Nintendo     29.08   \n",
       "Mario Kart Wii                Wii  2008.0        Racing  Nintendo     15.68   \n",
       "Wii Sports Resort             Wii  2009.0        Sports  Nintendo     15.61   \n",
       "Pokemon Red/Pokemon Blue        G  1996.0  Role-Playing  Nintendo     11.27   \n",
       "\n",
       "                          eu_sales  jp_sales  other_sales  global_sales  \\\n",
       "name                                                                      \n",
       "Wii Sports                   28.96      3.77         8.45         82.54   \n",
       "Super Mario Bros.             3.58      6.81         0.77         40.24   \n",
       "Mario Kart Wii               12.80      3.79         3.29         35.57   \n",
       "Wii Sports Resort            10.95      3.28         2.95         32.78   \n",
       "Pokemon Red/Pokemon Blue      8.89     10.22         1.00         31.37   \n",
       "\n",
       "                          critic_score  critic_count  user_score  user_count  \\\n",
       "name                                                                           \n",
       "Wii Sports                        76.0          51.0         8.0       324.0   \n",
       "Super Mario Bros.                  NaN           NaN         NaN         NaN   \n",
       "Mario Kart Wii                    82.0          73.0         8.3       712.0   \n",
       "Wii Sports Resort                 80.0          73.0         8.0       193.0   \n",
       "Pokemon Red/Pokemon Blue           NaN           NaN         NaN         NaN   \n",
       "\n",
       "                         rating        date  \n",
       "name                                         \n",
       "Wii Sports                    E  2006-10-09  \n",
       "Super Mario Bros.           NaN  1985-01-20  \n",
       "Mario Kart Wii                E  2008-11-16  \n",
       "Wii Sports Resort             E  2009-11-25  \n",
       "Pokemon Red/Pokemon Blue    NaN  1996-08-17  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Setting a column as the index\n",
    "# Values dont need to be unique\n",
    "df = df.set_index(\"name\")\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "8ed179e1-0f4b-4108-9203-8f0e9def72c9",
   "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>name</th>\n",
       "      <th>platform</th>\n",
       "      <th>year</th>\n",
       "      <th>genre</th>\n",
       "      <th>publisher</th>\n",
       "      <th>na_sales</th>\n",
       "      <th>eu_sales</th>\n",
       "      <th>jp_sales</th>\n",
       "      <th>other_sales</th>\n",
       "      <th>global_sales</th>\n",
       "      <th>critic_score</th>\n",
       "      <th>critic_count</th>\n",
       "      <th>user_score</th>\n",
       "      <th>user_count</th>\n",
       "      <th>rating</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Wii Sports</td>\n",
       "      <td>Wii</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>Sports</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>41.36</td>\n",
       "      <td>28.96</td>\n",
       "      <td>3.77</td>\n",
       "      <td>8.45</td>\n",
       "      <td>82.54</td>\n",
       "      <td>76.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>324.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2006-10-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Super Mario Bros.</td>\n",
       "      <td>NES</td>\n",
       "      <td>1985.0</td>\n",
       "      <td>Platform</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>29.08</td>\n",
       "      <td>3.58</td>\n",
       "      <td>6.81</td>\n",
       "      <td>0.77</td>\n",
       "      <td>40.24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1985-01-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Mario Kart Wii</td>\n",
       "      <td>Wii</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>Racing</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>15.68</td>\n",
       "      <td>12.80</td>\n",
       "      <td>3.79</td>\n",
       "      <td>3.29</td>\n",
       "      <td>35.57</td>\n",
       "      <td>82.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>8.3</td>\n",
       "      <td>712.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2008-11-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Wii Sports Resort</td>\n",
       "      <td>Wii</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>Sports</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>15.61</td>\n",
       "      <td>10.95</td>\n",
       "      <td>3.28</td>\n",
       "      <td>2.95</td>\n",
       "      <td>32.78</td>\n",
       "      <td>80.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>193.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2009-11-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Pokemon Red/Pokemon Blue</td>\n",
       "      <td>G</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>Role-Playing</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>11.27</td>\n",
       "      <td>8.89</td>\n",
       "      <td>10.22</td>\n",
       "      <td>1.00</td>\n",
       "      <td>31.37</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1996-08-17</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       name platform    year         genre publisher  \\\n",
       "0                Wii Sports      Wii  2006.0        Sports  Nintendo   \n",
       "1         Super Mario Bros.      NES  1985.0      Platform  Nintendo   \n",
       "2            Mario Kart Wii      Wii  2008.0        Racing  Nintendo   \n",
       "3         Wii Sports Resort      Wii  2009.0        Sports  Nintendo   \n",
       "4  Pokemon Red/Pokemon Blue        G  1996.0  Role-Playing  Nintendo   \n",
       "\n",
       "   na_sales  eu_sales  jp_sales  other_sales  global_sales  critic_score  \\\n",
       "0     41.36     28.96      3.77         8.45         82.54          76.0   \n",
       "1     29.08      3.58      6.81         0.77         40.24           NaN   \n",
       "2     15.68     12.80      3.79         3.29         35.57          82.0   \n",
       "3     15.61     10.95      3.28         2.95         32.78          80.0   \n",
       "4     11.27      8.89     10.22         1.00         31.37           NaN   \n",
       "\n",
       "   critic_count  user_score  user_count rating        date  \n",
       "0          51.0         8.0       324.0      E  2006-10-09  \n",
       "1           NaN         NaN         NaN    NaN  1985-01-20  \n",
       "2          73.0         8.3       712.0      E  2008-11-16  \n",
       "3          73.0         8.0       193.0      E  2009-11-25  \n",
       "4           NaN         NaN         NaN    NaN  1996-08-17  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Removing an index\n",
    "df = df.reset_index()\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "3dd84b38-c119-48be-9b19-924395421bbe",
   "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>platform</th>\n",
       "      <th>year</th>\n",
       "      <th>genre</th>\n",
       "      <th>publisher</th>\n",
       "      <th>na_sales</th>\n",
       "      <th>eu_sales</th>\n",
       "      <th>jp_sales</th>\n",
       "      <th>other_sales</th>\n",
       "      <th>global_sales</th>\n",
       "      <th>critic_score</th>\n",
       "      <th>critic_count</th>\n",
       "      <th>user_score</th>\n",
       "      <th>user_count</th>\n",
       "      <th>rating</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Wii</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>Sports</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>41.36</td>\n",
       "      <td>28.96</td>\n",
       "      <td>3.77</td>\n",
       "      <td>8.45</td>\n",
       "      <td>82.54</td>\n",
       "      <td>76.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>324.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2006-10-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>NES</td>\n",
       "      <td>1985.0</td>\n",
       "      <td>Platform</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>29.08</td>\n",
       "      <td>3.58</td>\n",
       "      <td>6.81</td>\n",
       "      <td>0.77</td>\n",
       "      <td>40.24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1985-01-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Wii</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>Racing</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>15.68</td>\n",
       "      <td>12.80</td>\n",
       "      <td>3.79</td>\n",
       "      <td>3.29</td>\n",
       "      <td>35.57</td>\n",
       "      <td>82.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>8.3</td>\n",
       "      <td>712.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2008-11-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Wii</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>Sports</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>15.61</td>\n",
       "      <td>10.95</td>\n",
       "      <td>3.28</td>\n",
       "      <td>2.95</td>\n",
       "      <td>32.78</td>\n",
       "      <td>80.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>193.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2009-11-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>G</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>Role-Playing</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>11.27</td>\n",
       "      <td>8.89</td>\n",
       "      <td>10.22</td>\n",
       "      <td>1.00</td>\n",
       "      <td>31.37</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1996-08-17</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  platform    year         genre publisher  na_sales  eu_sales  jp_sales  \\\n",
       "0      Wii  2006.0        Sports  Nintendo     41.36     28.96      3.77   \n",
       "1      NES  1985.0      Platform  Nintendo     29.08      3.58      6.81   \n",
       "2      Wii  2008.0        Racing  Nintendo     15.68     12.80      3.79   \n",
       "3      Wii  2009.0        Sports  Nintendo     15.61     10.95      3.28   \n",
       "4        G  1996.0  Role-Playing  Nintendo     11.27      8.89     10.22   \n",
       "\n",
       "   other_sales  global_sales  critic_score  critic_count  user_score  \\\n",
       "0         8.45         82.54          76.0          51.0         8.0   \n",
       "1         0.77         40.24           NaN           NaN         NaN   \n",
       "2         3.29         35.57          82.0          73.0         8.3   \n",
       "3         2.95         32.78          80.0          73.0         8.0   \n",
       "4         1.00         31.37           NaN           NaN         NaN   \n",
       "\n",
       "   user_count rating        date  \n",
       "0       324.0      E  2006-10-09  \n",
       "1         NaN    NaN  1985-01-20  \n",
       "2       712.0      E  2008-11-16  \n",
       "3       193.0      E  2009-11-25  \n",
       "4         NaN    NaN  1996-08-17  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Dropping the index\n",
    "df_by_names = df.set_index('name')\n",
    "df_by_names.reset_index(drop=True).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "7a9faaa3-2fcb-4cc3-84c1-5d8dc10b2622",
   "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>name</th>\n",
       "      <th>platform</th>\n",
       "      <th>year</th>\n",
       "      <th>genre</th>\n",
       "      <th>publisher</th>\n",
       "      <th>na_sales</th>\n",
       "      <th>eu_sales</th>\n",
       "      <th>jp_sales</th>\n",
       "      <th>other_sales</th>\n",
       "      <th>global_sales</th>\n",
       "      <th>critic_score</th>\n",
       "      <th>critic_count</th>\n",
       "      <th>user_score</th>\n",
       "      <th>user_count</th>\n",
       "      <th>rating</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Super Mario Bros.</td>\n",
       "      <td>NES</td>\n",
       "      <td>1985.0</td>\n",
       "      <td>Platform</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>29.08</td>\n",
       "      <td>3.58</td>\n",
       "      <td>6.81</td>\n",
       "      <td>0.77</td>\n",
       "      <td>40.24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1985-01-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Grand Theft Auto V</td>\n",
       "      <td>PS3</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Action</td>\n",
       "      <td>Take-Two Interactive</td>\n",
       "      <td>7.02</td>\n",
       "      <td>9.14</td>\n",
       "      <td>0.98</td>\n",
       "      <td>3.97</td>\n",
       "      <td>21.12</td>\n",
       "      <td>97.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>8.2</td>\n",
       "      <td>4009.0</td>\n",
       "      <td>M</td>\n",
       "      <td>2013-07-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Grand Theft Auto V</td>\n",
       "      <td>X360</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Action</td>\n",
       "      <td>Take-Two Interactive</td>\n",
       "      <td>9.66</td>\n",
       "      <td>5.17</td>\n",
       "      <td>0.06</td>\n",
       "      <td>1.41</td>\n",
       "      <td>16.30</td>\n",
       "      <td>97.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>8.1</td>\n",
       "      <td>3722.0</td>\n",
       "      <td>M</td>\n",
       "      <td>2013-04-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Grand Theft Auto V</td>\n",
       "      <td>PS4</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Action</td>\n",
       "      <td>Take-Two Interactive</td>\n",
       "      <td>4.12</td>\n",
       "      <td>6.77</td>\n",
       "      <td>0.39</td>\n",
       "      <td>2.08</td>\n",
       "      <td>13.36</td>\n",
       "      <td>97.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>8.3</td>\n",
       "      <td>2955.0</td>\n",
       "      <td>M</td>\n",
       "      <td>2014-06-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>Grand Theft Auto V</td>\n",
       "      <td>XOne</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Action</td>\n",
       "      <td>Take-Two Interactive</td>\n",
       "      <td>2.93</td>\n",
       "      <td>2.32</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.49</td>\n",
       "      <td>5.74</td>\n",
       "      <td>97.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>7.9</td>\n",
       "      <td>774.0</td>\n",
       "      <td>M</td>\n",
       "      <td>2014-10-05</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   name platform    year     genre             publisher  \\\n",
       "1     Super Mario Bros.      NES  1985.0  Platform              Nintendo   \n",
       "16   Grand Theft Auto V      PS3  2013.0    Action  Take-Two Interactive   \n",
       "23   Grand Theft Auto V     X360  2013.0    Action  Take-Two Interactive   \n",
       "37   Grand Theft Auto V      PS4  2014.0    Action  Take-Two Interactive   \n",
       "156  Grand Theft Auto V     XOne  2014.0    Action  Take-Two Interactive   \n",
       "\n",
       "     na_sales  eu_sales  jp_sales  other_sales  global_sales  critic_score  \\\n",
       "1       29.08      3.58      6.81         0.77         40.24           NaN   \n",
       "16       7.02      9.14      0.98         3.97         21.12          97.0   \n",
       "23       9.66      5.17      0.06         1.41         16.30          97.0   \n",
       "37       4.12      6.77      0.39         2.08         13.36          97.0   \n",
       "156      2.93      2.32      0.00         0.49          5.74          97.0   \n",
       "\n",
       "     critic_count  user_score  user_count rating        date  \n",
       "1             NaN         NaN         NaN    NaN  1985-01-20  \n",
       "16           50.0         8.2      4009.0      M  2013-07-15  \n",
       "23           58.0         8.1      3722.0      M  2013-04-02  \n",
       "37           66.0         8.3      2955.0      M  2014-06-11  \n",
       "156          14.0         7.9       774.0      M  2014-10-05  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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>platform</th>\n",
       "      <th>year</th>\n",
       "      <th>genre</th>\n",
       "      <th>publisher</th>\n",
       "      <th>na_sales</th>\n",
       "      <th>eu_sales</th>\n",
       "      <th>jp_sales</th>\n",
       "      <th>other_sales</th>\n",
       "      <th>global_sales</th>\n",
       "      <th>critic_score</th>\n",
       "      <th>critic_count</th>\n",
       "      <th>user_score</th>\n",
       "      <th>user_count</th>\n",
       "      <th>rating</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Super Mario Bros.</th>\n",
       "      <td>NES</td>\n",
       "      <td>1985.0</td>\n",
       "      <td>Platform</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>29.08</td>\n",
       "      <td>3.58</td>\n",
       "      <td>6.81</td>\n",
       "      <td>0.77</td>\n",
       "      <td>40.24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1985-01-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Super Mario Bros.</th>\n",
       "      <td>G</td>\n",
       "      <td>1999.0</td>\n",
       "      <td>Platform</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>3.40</td>\n",
       "      <td>1.30</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.22</td>\n",
       "      <td>5.07</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1999-07-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Grand Theft Auto V</th>\n",
       "      <td>PS3</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Action</td>\n",
       "      <td>Take-Two Interactive</td>\n",
       "      <td>7.02</td>\n",
       "      <td>9.14</td>\n",
       "      <td>0.98</td>\n",
       "      <td>3.97</td>\n",
       "      <td>21.12</td>\n",
       "      <td>97.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>8.2</td>\n",
       "      <td>4009.0</td>\n",
       "      <td>M</td>\n",
       "      <td>2013-07-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Grand Theft Auto V</th>\n",
       "      <td>X360</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Action</td>\n",
       "      <td>Take-Two Interactive</td>\n",
       "      <td>9.66</td>\n",
       "      <td>5.17</td>\n",
       "      <td>0.06</td>\n",
       "      <td>1.41</td>\n",
       "      <td>16.30</td>\n",
       "      <td>97.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>8.1</td>\n",
       "      <td>3722.0</td>\n",
       "      <td>M</td>\n",
       "      <td>2013-04-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Grand Theft Auto V</th>\n",
       "      <td>PS4</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Action</td>\n",
       "      <td>Take-Two Interactive</td>\n",
       "      <td>4.12</td>\n",
       "      <td>6.77</td>\n",
       "      <td>0.39</td>\n",
       "      <td>2.08</td>\n",
       "      <td>13.36</td>\n",
       "      <td>97.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>8.3</td>\n",
       "      <td>2955.0</td>\n",
       "      <td>M</td>\n",
       "      <td>2014-06-11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   platform    year     genre             publisher  na_sales  \\\n",
       "name                                                                            \n",
       "Super Mario Bros.       NES  1985.0  Platform              Nintendo     29.08   \n",
       "Super Mario Bros.         G  1999.0  Platform              Nintendo      3.40   \n",
       "Grand Theft Auto V      PS3  2013.0    Action  Take-Two Interactive      7.02   \n",
       "Grand Theft Auto V     X360  2013.0    Action  Take-Two Interactive      9.66   \n",
       "Grand Theft Auto V      PS4  2014.0    Action  Take-Two Interactive      4.12   \n",
       "\n",
       "                    eu_sales  jp_sales  other_sales  global_sales  \\\n",
       "name                                                                \n",
       "Super Mario Bros.       3.58      6.81         0.77         40.24   \n",
       "Super Mario Bros.       1.30      0.15         0.22          5.07   \n",
       "Grand Theft Auto V      9.14      0.98         3.97         21.12   \n",
       "Grand Theft Auto V      5.17      0.06         1.41         16.30   \n",
       "Grand Theft Auto V      6.77      0.39         2.08         13.36   \n",
       "\n",
       "                    critic_score  critic_count  user_score  user_count rating  \\\n",
       "name                                                                            \n",
       "Super Mario Bros.            NaN           NaN         NaN         NaN    NaN   \n",
       "Super Mario Bros.            NaN           NaN         NaN         NaN    NaN   \n",
       "Grand Theft Auto V          97.0          50.0         8.2      4009.0      M   \n",
       "Grand Theft Auto V          97.0          58.0         8.1      3722.0      M   \n",
       "Grand Theft Auto V          97.0          66.0         8.3      2955.0      M   \n",
       "\n",
       "                          date  \n",
       "name                            \n",
       "Super Mario Bros.   1985-01-20  \n",
       "Super Mario Bros.   1999-07-04  \n",
       "Grand Theft Auto V  2013-07-15  \n",
       "Grand Theft Auto V  2013-04-02  \n",
       "Grand Theft Auto V  2014-06-11  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "filtr = [\"Super Mario Bros.\", \"Grand Theft Auto V\"]\n",
    "\n",
    "# Subsetting by column.\n",
    "ss1 = df[df[\"name\"].isin(filtr)]\n",
    "\n",
    "# Subsetting by index.\n",
    "# loc filters on index values.\n",
    "ss2 = df.set_index('name').loc[filtr]\n",
    "\n",
    "display(ss1.head())\n",
    "display(ss2.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "63d5120e-3a6c-46e4-876c-e456277cd9f6",
   "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>name</th>\n",
       "      <th>year</th>\n",
       "      <th>publisher</th>\n",
       "      <th>na_sales</th>\n",
       "      <th>eu_sales</th>\n",
       "      <th>jp_sales</th>\n",
       "      <th>other_sales</th>\n",
       "      <th>global_sales</th>\n",
       "      <th>critic_score</th>\n",
       "      <th>critic_count</th>\n",
       "      <th>user_score</th>\n",
       "      <th>user_count</th>\n",
       "      <th>rating</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>platform</th>\n",
       "      <th>genre</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Wii</th>\n",
       "      <th>Sports</th>\n",
       "      <td>Wii Sports</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>41.36</td>\n",
       "      <td>28.96</td>\n",
       "      <td>3.77</td>\n",
       "      <td>8.45</td>\n",
       "      <td>82.54</td>\n",
       "      <td>76.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>324.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2006-10-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NES</th>\n",
       "      <th>Platform</th>\n",
       "      <td>Super Mario Bros.</td>\n",
       "      <td>1985.0</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>29.08</td>\n",
       "      <td>3.58</td>\n",
       "      <td>6.81</td>\n",
       "      <td>0.77</td>\n",
       "      <td>40.24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1985-01-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">Wii</th>\n",
       "      <th>Racing</th>\n",
       "      <td>Mario Kart Wii</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>15.68</td>\n",
       "      <td>12.80</td>\n",
       "      <td>3.79</td>\n",
       "      <td>3.29</td>\n",
       "      <td>35.57</td>\n",
       "      <td>82.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>8.3</td>\n",
       "      <td>712.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2008-11-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sports</th>\n",
       "      <td>Wii Sports Resort</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>15.61</td>\n",
       "      <td>10.95</td>\n",
       "      <td>3.28</td>\n",
       "      <td>2.95</td>\n",
       "      <td>32.78</td>\n",
       "      <td>80.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>193.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2009-11-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>G</th>\n",
       "      <th>Role-Playing</th>\n",
       "      <td>Pokemon Red/Pokemon Blue</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>11.27</td>\n",
       "      <td>8.89</td>\n",
       "      <td>10.22</td>\n",
       "      <td>1.00</td>\n",
       "      <td>31.37</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1996-08-17</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           name    year publisher  na_sales  \\\n",
       "platform genre                                                                \n",
       "Wii      Sports                      Wii Sports  2006.0  Nintendo     41.36   \n",
       "NES      Platform             Super Mario Bros.  1985.0  Nintendo     29.08   \n",
       "Wii      Racing                  Mario Kart Wii  2008.0  Nintendo     15.68   \n",
       "         Sports               Wii Sports Resort  2009.0  Nintendo     15.61   \n",
       "G        Role-Playing  Pokemon Red/Pokemon Blue  1996.0  Nintendo     11.27   \n",
       "\n",
       "                       eu_sales  jp_sales  other_sales  global_sales  \\\n",
       "platform genre                                                         \n",
       "Wii      Sports           28.96      3.77         8.45         82.54   \n",
       "NES      Platform          3.58      6.81         0.77         40.24   \n",
       "Wii      Racing           12.80      3.79         3.29         35.57   \n",
       "         Sports           10.95      3.28         2.95         32.78   \n",
       "G        Role-Playing      8.89     10.22         1.00         31.37   \n",
       "\n",
       "                       critic_score  critic_count  user_score  user_count  \\\n",
       "platform genre                                                              \n",
       "Wii      Sports                76.0          51.0         8.0       324.0   \n",
       "NES      Platform               NaN           NaN         NaN         NaN   \n",
       "Wii      Racing                82.0          73.0         8.3       712.0   \n",
       "         Sports                80.0          73.0         8.0       193.0   \n",
       "G        Role-Playing           NaN           NaN         NaN         NaN   \n",
       "\n",
       "                      rating        date  \n",
       "platform genre                            \n",
       "Wii      Sports            E  2006-10-09  \n",
       "NES      Platform        NaN  1985-01-20  \n",
       "Wii      Racing            E  2008-11-16  \n",
       "         Sports            E  2009-11-25  \n",
       "G        Role-Playing    NaN  1996-08-17  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Multi-level indexes aka Hierarchical Indexes\n",
    "# Values dont need to be unique and can be multiple.\n",
    "\n",
    "indexed = df.set_index(['platform', 'genre'])\n",
    "indexed.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "c00af994-8a71-4acd-8d73-7bed65374850",
   "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>name</th>\n",
       "      <th>year</th>\n",
       "      <th>publisher</th>\n",
       "      <th>na_sales</th>\n",
       "      <th>eu_sales</th>\n",
       "      <th>jp_sales</th>\n",
       "      <th>other_sales</th>\n",
       "      <th>global_sales</th>\n",
       "      <th>critic_score</th>\n",
       "      <th>critic_count</th>\n",
       "      <th>user_score</th>\n",
       "      <th>user_count</th>\n",
       "      <th>rating</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>platform</th>\n",
       "      <th>genre</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"11\" valign=\"top\">PC</th>\n",
       "      <th>Simulation</th>\n",
       "      <td>The Sims 3</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>Electronic Arts</td>\n",
       "      <td>0.99</td>\n",
       "      <td>6.42</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.60</td>\n",
       "      <td>8.01</td>\n",
       "      <td>86.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>7.6</td>\n",
       "      <td>894.0</td>\n",
       "      <td>T</td>\n",
       "      <td>2009-09-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Role-Playing</th>\n",
       "      <td>World of Warcraft</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>Activision</td>\n",
       "      <td>0.09</td>\n",
       "      <td>6.22</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6.31</td>\n",
       "      <td>93.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>7.3</td>\n",
       "      <td>2199.0</td>\n",
       "      <td>T</td>\n",
       "      <td>2004-04-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Role-Playing</th>\n",
       "      <td>Diablo III</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Activision</td>\n",
       "      <td>2.45</td>\n",
       "      <td>2.17</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.54</td>\n",
       "      <td>5.17</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9643.0</td>\n",
       "      <td>M</td>\n",
       "      <td>2012-08-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Simulation</th>\n",
       "      <td>Microsoft Flight Simulator</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>Microsoft Game Studios</td>\n",
       "      <td>3.22</td>\n",
       "      <td>1.69</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.20</td>\n",
       "      <td>5.12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1996-02-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strategy</th>\n",
       "      <td>StarCraft II: Wings of Liberty</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Activision</td>\n",
       "      <td>2.58</td>\n",
       "      <td>1.69</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.59</td>\n",
       "      <td>4.85</td>\n",
       "      <td>93.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>8.2</td>\n",
       "      <td>3057.0</td>\n",
       "      <td>T</td>\n",
       "      <td>2010-01-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Shooter</th>\n",
       "      <td>Blacksite: Area 51</td>\n",
       "      <td>2007.0</td>\n",
       "      <td>Midway Games</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>60.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>4.9</td>\n",
       "      <td>42.0</td>\n",
       "      <td>T</td>\n",
       "      <td>2007-04-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sports</th>\n",
       "      <td>Virtua Tennis 2009</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>Sega</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>68.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.5</td>\n",
       "      <td>19.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2009-03-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strategy</th>\n",
       "      <td>BC Kings</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>Strategy First</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008-03-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strategy</th>\n",
       "      <td>CivCity: Rome</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>Take-Two Interactive</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>67.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>6.9</td>\n",
       "      <td>32.0</td>\n",
       "      <td>E10+</td>\n",
       "      <td>2006-12-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Adventure</th>\n",
       "      <td>CSI: 3 Dimensions of Murder</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>Ubisoft</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2006-09-07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1128 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 name    year  \\\n",
       "platform genre                                                  \n",
       "PC       Simulation                        The Sims 3  2009.0   \n",
       "         Role-Playing               World of Warcraft  2004.0   \n",
       "         Role-Playing                      Diablo III  2012.0   \n",
       "         Simulation        Microsoft Flight Simulator  1996.0   \n",
       "         Strategy      StarCraft II: Wings of Liberty  2010.0   \n",
       "...                                               ...     ...   \n",
       "         Shooter                   Blacksite: Area 51  2007.0   \n",
       "         Sports                    Virtua Tennis 2009  2009.0   \n",
       "         Strategy                            BC Kings  2008.0   \n",
       "         Strategy                       CivCity: Rome  2006.0   \n",
       "         Adventure        CSI: 3 Dimensions of Murder  2006.0   \n",
       "\n",
       "                                    publisher  na_sales  eu_sales  jp_sales  \\\n",
       "platform genre                                                                \n",
       "PC       Simulation           Electronic Arts      0.99      6.42       0.0   \n",
       "         Role-Playing              Activision      0.09      6.22       0.0   \n",
       "         Role-Playing              Activision      2.45      2.17       0.0   \n",
       "         Simulation    Microsoft Game Studios      3.22      1.69       0.0   \n",
       "         Strategy                  Activision      2.58      1.69       0.0   \n",
       "...                                       ...       ...       ...       ...   \n",
       "         Shooter                 Midway Games      0.00      0.00       0.0   \n",
       "         Sports                          Sega      0.00      0.00       0.0   \n",
       "         Strategy              Strategy First      0.00      0.00       0.0   \n",
       "         Strategy        Take-Two Interactive      0.00      0.00       0.0   \n",
       "         Adventure                    Ubisoft      0.00      0.00       0.0   \n",
       "\n",
       "                       other_sales  global_sales  critic_score  critic_count  \\\n",
       "platform genre                                                                 \n",
       "PC       Simulation           0.60          8.01          86.0          75.0   \n",
       "         Role-Playing         0.00          6.31          93.0          57.0   \n",
       "         Role-Playing         0.54          5.17          88.0          86.0   \n",
       "         Simulation           0.20          5.12           NaN           NaN   \n",
       "         Strategy             0.59          4.85          93.0          82.0   \n",
       "...                            ...           ...           ...           ...   \n",
       "         Shooter              0.00          0.01          60.0          20.0   \n",
       "         Sports               0.00          0.01          68.0           8.0   \n",
       "         Strategy             0.00          0.01           NaN           NaN   \n",
       "         Strategy             0.00          0.01          67.0          46.0   \n",
       "         Adventure            0.00          0.01           NaN           NaN   \n",
       "\n",
       "                       user_score  user_count rating        date  \n",
       "platform genre                                                    \n",
       "PC       Simulation           7.6       894.0      T  2009-09-23  \n",
       "         Role-Playing         7.3      2199.0      T  2004-04-06  \n",
       "         Role-Playing         4.0      9643.0      M  2012-08-13  \n",
       "         Simulation           NaN         NaN    NaN  1996-02-15  \n",
       "         Strategy             8.2      3057.0      T  2010-01-08  \n",
       "...                           ...         ...    ...         ...  \n",
       "         Shooter              4.9        42.0      T  2007-04-08  \n",
       "         Sports               6.5        19.0      E  2009-03-17  \n",
       "         Strategy             NaN         NaN    NaN  2008-03-10  \n",
       "         Strategy             6.9        32.0   E10+  2006-12-08  \n",
       "         Adventure            NaN         NaN    NaN  2006-09-07  \n",
       "\n",
       "[1128 rows x 14 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Subsetting the outer level index.\n",
    "indexed.loc[['PC']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "5e3dc259-dab4-42f8-a0b7-33087aaf7fdc",
   "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>name</th>\n",
       "      <th>year</th>\n",
       "      <th>publisher</th>\n",
       "      <th>na_sales</th>\n",
       "      <th>eu_sales</th>\n",
       "      <th>jp_sales</th>\n",
       "      <th>other_sales</th>\n",
       "      <th>global_sales</th>\n",
       "      <th>critic_score</th>\n",
       "      <th>critic_count</th>\n",
       "      <th>user_score</th>\n",
       "      <th>user_count</th>\n",
       "      <th>rating</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>platform</th>\n",
       "      <th>genre</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">PC</th>\n",
       "      <th>Simulation</th>\n",
       "      <td>The Sims 3</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>Electronic Arts</td>\n",
       "      <td>0.99</td>\n",
       "      <td>6.42</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.60</td>\n",
       "      <td>8.01</td>\n",
       "      <td>86.0</td>\n",
       "      <td>75.0</td>\n",
       "      <td>7.6</td>\n",
       "      <td>894.0</td>\n",
       "      <td>T</td>\n",
       "      <td>2009-09-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Role-Playing</th>\n",
       "      <td>World of Warcraft</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>Activision</td>\n",
       "      <td>0.09</td>\n",
       "      <td>6.22</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>6.31</td>\n",
       "      <td>93.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>7.3</td>\n",
       "      <td>2199.0</td>\n",
       "      <td>T</td>\n",
       "      <td>2004-04-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Role-Playing</th>\n",
       "      <td>Diablo III</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>Activision</td>\n",
       "      <td>2.45</td>\n",
       "      <td>2.17</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.54</td>\n",
       "      <td>5.17</td>\n",
       "      <td>88.0</td>\n",
       "      <td>86.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9643.0</td>\n",
       "      <td>M</td>\n",
       "      <td>2012-08-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Simulation</th>\n",
       "      <td>Microsoft Flight Simulator</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>Microsoft Game Studios</td>\n",
       "      <td>3.22</td>\n",
       "      <td>1.69</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.20</td>\n",
       "      <td>5.12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1996-02-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strategy</th>\n",
       "      <td>StarCraft II: Wings of Liberty</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>Activision</td>\n",
       "      <td>2.58</td>\n",
       "      <td>1.69</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.59</td>\n",
       "      <td>4.85</td>\n",
       "      <td>93.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>8.2</td>\n",
       "      <td>3057.0</td>\n",
       "      <td>T</td>\n",
       "      <td>2010-01-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">PS4</th>\n",
       "      <th>Action</th>\n",
       "      <td>Woodcutter Simulator 2016</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Namco Bandai Games</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-11-24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Misc</th>\n",
       "      <td>We Sing (2016)</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>THQ Nordic</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2016-01-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action</th>\n",
       "      <td>The Escapists: The Walking Dead</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Team17 Software</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>63.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.4</td>\n",
       "      <td>5.0</td>\n",
       "      <td>T</td>\n",
       "      <td>2016-12-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action</th>\n",
       "      <td>Ziggurat</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Milkstone Studios</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>80.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>7.1</td>\n",
       "      <td>19.0</td>\n",
       "      <td>T</td>\n",
       "      <td>2016-07-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Platform</th>\n",
       "      <td>Super Meat Boy</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Team Meat</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>85.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>114.0</td>\n",
       "      <td>T</td>\n",
       "      <td>2016-02-16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1552 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  name    year  \\\n",
       "platform genre                                                   \n",
       "PC       Simulation                         The Sims 3  2009.0   \n",
       "         Role-Playing                World of Warcraft  2004.0   \n",
       "         Role-Playing                       Diablo III  2012.0   \n",
       "         Simulation         Microsoft Flight Simulator  1996.0   \n",
       "         Strategy       StarCraft II: Wings of Liberty  2010.0   \n",
       "...                                                ...     ...   \n",
       "PS4      Action              Woodcutter Simulator 2016  2015.0   \n",
       "         Misc                           We Sing (2016)  2016.0   \n",
       "         Action        The Escapists: The Walking Dead  2016.0   \n",
       "         Action                               Ziggurat  2016.0   \n",
       "         Platform                       Super Meat Boy  2016.0   \n",
       "\n",
       "                                    publisher  na_sales  eu_sales  jp_sales  \\\n",
       "platform genre                                                                \n",
       "PC       Simulation           Electronic Arts      0.99      6.42       0.0   \n",
       "         Role-Playing              Activision      0.09      6.22       0.0   \n",
       "         Role-Playing              Activision      2.45      2.17       0.0   \n",
       "         Simulation    Microsoft Game Studios      3.22      1.69       0.0   \n",
       "         Strategy                  Activision      2.58      1.69       0.0   \n",
       "...                                       ...       ...       ...       ...   \n",
       "PS4      Action            Namco Bandai Games      0.00      0.01       0.0   \n",
       "         Misc                      THQ Nordic      0.01      0.00       0.0   \n",
       "         Action               Team17 Software      0.00      0.00       0.0   \n",
       "         Action             Milkstone Studios      0.00      0.00       0.0   \n",
       "         Platform                   Team Meat      0.00      0.00       0.0   \n",
       "\n",
       "                       other_sales  global_sales  critic_score  critic_count  \\\n",
       "platform genre                                                                 \n",
       "PC       Simulation           0.60          8.01          86.0          75.0   \n",
       "         Role-Playing         0.00          6.31          93.0          57.0   \n",
       "         Role-Playing         0.54          5.17          88.0          86.0   \n",
       "         Simulation           0.20          5.12           NaN           NaN   \n",
       "         Strategy             0.59          4.85          93.0          82.0   \n",
       "...                            ...           ...           ...           ...   \n",
       "PS4      Action               0.00          0.01           NaN           NaN   \n",
       "         Misc                 0.00          0.01           NaN           NaN   \n",
       "         Action               0.00          0.01          63.0           5.0   \n",
       "         Action               0.00          0.01          80.0           8.0   \n",
       "         Platform             0.00          0.01          85.0           7.0   \n",
       "\n",
       "                       user_score  user_count rating        date  \n",
       "platform genre                                                    \n",
       "PC       Simulation           7.6       894.0      T  2009-09-23  \n",
       "         Role-Playing         7.3      2199.0      T  2004-04-06  \n",
       "         Role-Playing         4.0      9643.0      M  2012-08-13  \n",
       "         Simulation           NaN         NaN    NaN  1996-02-15  \n",
       "         Strategy             8.2      3057.0      T  2010-01-08  \n",
       "...                           ...         ...    ...         ...  \n",
       "PS4      Action               NaN         NaN    NaN  2015-11-24  \n",
       "         Misc                 NaN         NaN    NaN  2016-01-25  \n",
       "         Action               7.4         5.0      T  2016-12-14  \n",
       "         Action               7.1        19.0      T  2016-07-03  \n",
       "         Platform             7.0       114.0      T  2016-02-16  \n",
       "\n",
       "[1552 rows x 14 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Subsetting the outer level index.\n",
    "indexed.loc[['PC', 'PS4']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "c8dda022-a2f0-4567-8f33-d90c70d51145",
   "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>name</th>\n",
       "      <th>year</th>\n",
       "      <th>publisher</th>\n",
       "      <th>na_sales</th>\n",
       "      <th>eu_sales</th>\n",
       "      <th>jp_sales</th>\n",
       "      <th>other_sales</th>\n",
       "      <th>global_sales</th>\n",
       "      <th>critic_score</th>\n",
       "      <th>critic_count</th>\n",
       "      <th>user_score</th>\n",
       "      <th>user_count</th>\n",
       "      <th>rating</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>platform</th>\n",
       "      <th>genre</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">PC</th>\n",
       "      <th>Action</th>\n",
       "      <td>Guild Wars 2</td>\n",
       "      <td>2012.0</td>\n",
       "      <td>NCSoft</td>\n",
       "      <td>0.97</td>\n",
       "      <td>1.09</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.28</td>\n",
       "      <td>2.34</td>\n",
       "      <td>90.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>7.9</td>\n",
       "      <td>2958.0</td>\n",
       "      <td>T</td>\n",
       "      <td>2012-11-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action</th>\n",
       "      <td>Tomb Raider II</td>\n",
       "      <td>1997.0</td>\n",
       "      <td>Eidos Interactive</td>\n",
       "      <td>0.91</td>\n",
       "      <td>1.25</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.13</td>\n",
       "      <td>2.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.2</td>\n",
       "      <td>39.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1997-02-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action</th>\n",
       "      <td>Grand Theft Auto V</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Take-Two Interactive</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.74</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.09</td>\n",
       "      <td>1.23</td>\n",
       "      <td>96.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>7.9</td>\n",
       "      <td>3826.0</td>\n",
       "      <td>M</td>\n",
       "      <td>2015-01-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action</th>\n",
       "      <td>Tomb Raider</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>Eidos Interactive</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0.07</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.03</td>\n",
       "      <td>86.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>8.5</td>\n",
       "      <td>3572.0</td>\n",
       "      <td>M</td>\n",
       "      <td>1996-07-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action</th>\n",
       "      <td>Grand Theft Auto: San Andreas</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>Take-Two Interactive</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.93</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.97</td>\n",
       "      <td>93.0</td>\n",
       "      <td>47.0</td>\n",
       "      <td>8.9</td>\n",
       "      <td>1864.0</td>\n",
       "      <td>M</td>\n",
       "      <td>2005-07-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">PS4</th>\n",
       "      <th>Action</th>\n",
       "      <td>Tumblestone</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Nighthawk Interactive</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>E</td>\n",
       "      <td>2016-03-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action</th>\n",
       "      <td>Gal Gun: Double Peace</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>PQube</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-06-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action</th>\n",
       "      <td>Woodcutter Simulator 2016</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Namco Bandai Games</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-11-24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action</th>\n",
       "      <td>The Escapists: The Walking Dead</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Team17 Software</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>63.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.4</td>\n",
       "      <td>5.0</td>\n",
       "      <td>T</td>\n",
       "      <td>2016-12-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action</th>\n",
       "      <td>Ziggurat</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Milkstone Studios</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>80.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>7.1</td>\n",
       "      <td>19.0</td>\n",
       "      <td>T</td>\n",
       "      <td>2016-07-03</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>351 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            name    year  \\\n",
       "platform genre                                             \n",
       "PC       Action                     Guild Wars 2  2012.0   \n",
       "         Action                   Tomb Raider II  1997.0   \n",
       "         Action               Grand Theft Auto V  2015.0   \n",
       "         Action                      Tomb Raider  1996.0   \n",
       "         Action    Grand Theft Auto: San Andreas  2005.0   \n",
       "...                                          ...     ...   \n",
       "PS4      Action                      Tumblestone  2016.0   \n",
       "         Action            Gal Gun: Double Peace  2015.0   \n",
       "         Action        Woodcutter Simulator 2016  2015.0   \n",
       "         Action  The Escapists: The Walking Dead  2016.0   \n",
       "         Action                         Ziggurat  2016.0   \n",
       "\n",
       "                             publisher  na_sales  eu_sales  jp_sales  \\\n",
       "platform genre                                                         \n",
       "PC       Action                 NCSoft      0.97      1.09      0.00   \n",
       "         Action      Eidos Interactive      0.91      1.25      0.00   \n",
       "         Action   Take-Two Interactive      0.40      0.74      0.00   \n",
       "         Action      Eidos Interactive      0.96      0.07      0.00   \n",
       "         Action   Take-Two Interactive      0.00      0.93      0.00   \n",
       "...                                ...       ...       ...       ...   \n",
       "PS4      Action  Nighthawk Interactive      0.01      0.00      0.00   \n",
       "         Action                  PQube      0.00      0.00      0.01   \n",
       "         Action     Namco Bandai Games      0.00      0.01      0.00   \n",
       "         Action        Team17 Software      0.00      0.00      0.00   \n",
       "         Action      Milkstone Studios      0.00      0.00      0.00   \n",
       "\n",
       "                 other_sales  global_sales  critic_score  critic_count  \\\n",
       "platform genre                                                           \n",
       "PC       Action         0.28          2.34          90.0          69.0   \n",
       "         Action         0.13          2.29           NaN           NaN   \n",
       "         Action         0.09          1.23          96.0          57.0   \n",
       "         Action         0.00          1.03          86.0          18.0   \n",
       "         Action         0.04          0.97          93.0          47.0   \n",
       "...                      ...           ...           ...           ...   \n",
       "PS4      Action         0.00          0.01           NaN           NaN   \n",
       "         Action         0.00          0.01           NaN           NaN   \n",
       "         Action         0.00          0.01           NaN           NaN   \n",
       "         Action         0.00          0.01          63.0           5.0   \n",
       "         Action         0.00          0.01          80.0           8.0   \n",
       "\n",
       "                 user_score  user_count rating        date  \n",
       "platform genre                                              \n",
       "PC       Action         7.9      2958.0      T  2012-11-09  \n",
       "         Action         8.2        39.0    NaN  1997-02-02  \n",
       "         Action         7.9      3826.0      M  2015-01-04  \n",
       "         Action         8.5      3572.0      M  1996-07-07  \n",
       "         Action         8.9      1864.0      M  2005-07-01  \n",
       "...                     ...         ...    ...         ...  \n",
       "PS4      Action         NaN         NaN      E  2016-03-19  \n",
       "         Action         NaN         NaN    NaN  2015-06-03  \n",
       "         Action         NaN         NaN    NaN  2015-11-24  \n",
       "         Action         7.4         5.0      T  2016-12-14  \n",
       "         Action         7.1        19.0      T  2016-07-03  \n",
       "\n",
       "[351 rows x 14 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Subsetting the inner level indexes.\n",
    "indexed.loc[[('PC', 'Action'), ('PS4','Action')]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "0bcfacc1-6257-43cb-9621-022cfa5f15f5",
   "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>name</th>\n",
       "      <th>year</th>\n",
       "      <th>publisher</th>\n",
       "      <th>na_sales</th>\n",
       "      <th>eu_sales</th>\n",
       "      <th>jp_sales</th>\n",
       "      <th>other_sales</th>\n",
       "      <th>global_sales</th>\n",
       "      <th>critic_score</th>\n",
       "      <th>critic_count</th>\n",
       "      <th>user_score</th>\n",
       "      <th>user_count</th>\n",
       "      <th>rating</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>platform</th>\n",
       "      <th>genre</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Wii</th>\n",
       "      <th>Sports</th>\n",
       "      <td>Wii Sports</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>41.36</td>\n",
       "      <td>28.96</td>\n",
       "      <td>3.77</td>\n",
       "      <td>8.45</td>\n",
       "      <td>82.54</td>\n",
       "      <td>76.0</td>\n",
       "      <td>51.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>324.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2006-10-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NES</th>\n",
       "      <th>Platform</th>\n",
       "      <td>Super Mario Bros.</td>\n",
       "      <td>1985.0</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>29.08</td>\n",
       "      <td>3.58</td>\n",
       "      <td>6.81</td>\n",
       "      <td>0.77</td>\n",
       "      <td>40.24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1985-01-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">Wii</th>\n",
       "      <th>Racing</th>\n",
       "      <td>Mario Kart Wii</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>15.68</td>\n",
       "      <td>12.80</td>\n",
       "      <td>3.79</td>\n",
       "      <td>3.29</td>\n",
       "      <td>35.57</td>\n",
       "      <td>82.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>8.3</td>\n",
       "      <td>712.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2008-11-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sports</th>\n",
       "      <td>Wii Sports Resort</td>\n",
       "      <td>2009.0</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>15.61</td>\n",
       "      <td>10.95</td>\n",
       "      <td>3.28</td>\n",
       "      <td>2.95</td>\n",
       "      <td>32.78</td>\n",
       "      <td>80.0</td>\n",
       "      <td>73.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>193.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2009-11-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>G</th>\n",
       "      <th>Role-Playing</th>\n",
       "      <td>Pokemon Red/Pokemon Blue</td>\n",
       "      <td>1996.0</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>11.27</td>\n",
       "      <td>8.89</td>\n",
       "      <td>10.22</td>\n",
       "      <td>1.00</td>\n",
       "      <td>31.37</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1996-08-17</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           name    year publisher  na_sales  \\\n",
       "platform genre                                                                \n",
       "Wii      Sports                      Wii Sports  2006.0  Nintendo     41.36   \n",
       "NES      Platform             Super Mario Bros.  1985.0  Nintendo     29.08   \n",
       "Wii      Racing                  Mario Kart Wii  2008.0  Nintendo     15.68   \n",
       "         Sports               Wii Sports Resort  2009.0  Nintendo     15.61   \n",
       "G        Role-Playing  Pokemon Red/Pokemon Blue  1996.0  Nintendo     11.27   \n",
       "\n",
       "                       eu_sales  jp_sales  other_sales  global_sales  \\\n",
       "platform genre                                                         \n",
       "Wii      Sports           28.96      3.77         8.45         82.54   \n",
       "NES      Platform          3.58      6.81         0.77         40.24   \n",
       "Wii      Racing           12.80      3.79         3.29         35.57   \n",
       "         Sports           10.95      3.28         2.95         32.78   \n",
       "G        Role-Playing      8.89     10.22         1.00         31.37   \n",
       "\n",
       "                       critic_score  critic_count  user_score  user_count  \\\n",
       "platform genre                                                              \n",
       "Wii      Sports                76.0          51.0         8.0       324.0   \n",
       "NES      Platform               NaN           NaN         NaN         NaN   \n",
       "Wii      Racing                82.0          73.0         8.3       712.0   \n",
       "         Sports                80.0          73.0         8.0       193.0   \n",
       "G        Role-Playing           NaN           NaN         NaN         NaN   \n",
       "\n",
       "                      rating        date  \n",
       "platform genre                            \n",
       "Wii      Sports            E  2006-10-09  \n",
       "NES      Platform        NaN  1985-01-20  \n",
       "Wii      Racing            E  2008-11-16  \n",
       "         Sports            E  2009-11-25  \n",
       "G        Role-Playing    NaN  1996-08-17  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indexed.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "30b0eb1a-8aa6-4320-b41e-b93b0bbda122",
   "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>name</th>\n",
       "      <th>year</th>\n",
       "      <th>publisher</th>\n",
       "      <th>na_sales</th>\n",
       "      <th>eu_sales</th>\n",
       "      <th>jp_sales</th>\n",
       "      <th>other_sales</th>\n",
       "      <th>global_sales</th>\n",
       "      <th>critic_score</th>\n",
       "      <th>critic_count</th>\n",
       "      <th>user_score</th>\n",
       "      <th>user_count</th>\n",
       "      <th>rating</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>platform</th>\n",
       "      <th>genre</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">2600</th>\n",
       "      <th>Action</th>\n",
       "      <td>Frogger</td>\n",
       "      <td>1981.0</td>\n",
       "      <td>Parker Bros.</td>\n",
       "      <td>2.06</td>\n",
       "      <td>0.12</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>2.20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1981-08-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action</th>\n",
       "      <td>E.T.: The Extra Terrestrial</td>\n",
       "      <td>1981.0</td>\n",
       "      <td>Atari</td>\n",
       "      <td>1.84</td>\n",
       "      <td>0.11</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>1.97</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1981-03-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action</th>\n",
       "      <td>Combat</td>\n",
       "      <td>1977.0</td>\n",
       "      <td>Atari</td>\n",
       "      <td>1.17</td>\n",
       "      <td>0.07</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>1.25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1977-11-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action</th>\n",
       "      <td>Spider-Man</td>\n",
       "      <td>1981.0</td>\n",
       "      <td>Parker Bros.</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.93</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1981-11-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action</th>\n",
       "      <td>Custers Revenge</td>\n",
       "      <td>1981.0</td>\n",
       "      <td>Mystique</td>\n",
       "      <td>0.76</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.82</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1981-10-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">XOne</th>\n",
       "      <th>Sports</th>\n",
       "      <td>Rugby Challenge 3</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Alternative Software</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6.6</td>\n",
       "      <td>5.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2016-12-18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strategy</th>\n",
       "      <td>State of Decay</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Microsoft Game Studios</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-07-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strategy</th>\n",
       "      <td>Angry Birds Star Wars</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Activision</td>\n",
       "      <td>0.11</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.16</td>\n",
       "      <td>53.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.9</td>\n",
       "      <td>63.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2013-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strategy</th>\n",
       "      <td>XCOM 2</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Take-Two Interactive</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.09</td>\n",
       "      <td>87.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>T</td>\n",
       "      <td>2016-04-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strategy</th>\n",
       "      <td>Battle Worlds: Kronos</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Nordic Games</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>65.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>E10+</td>\n",
       "      <td>2016-12-02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17408 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          name    year  \\\n",
       "platform genre                                           \n",
       "2600     Action                        Frogger  1981.0   \n",
       "         Action    E.T.: The Extra Terrestrial  1981.0   \n",
       "         Action                         Combat  1977.0   \n",
       "         Action                     Spider-Man  1981.0   \n",
       "         Action                Custers Revenge  1981.0   \n",
       "...                                        ...     ...   \n",
       "XOne     Sports              Rugby Challenge 3  2016.0   \n",
       "         Strategy               State of Decay  2015.0   \n",
       "         Strategy        Angry Birds Star Wars  2013.0   \n",
       "         Strategy                       XCOM 2  2016.0   \n",
       "         Strategy        Battle Worlds: Kronos  2016.0   \n",
       "\n",
       "                                publisher  na_sales  eu_sales  jp_sales  \\\n",
       "platform genre                                                            \n",
       "2600     Action              Parker Bros.      2.06      0.12       0.0   \n",
       "         Action                     Atari      1.84      0.11       0.0   \n",
       "         Action                     Atari      1.17      0.07       0.0   \n",
       "         Action              Parker Bros.      0.87      0.05       0.0   \n",
       "         Action                  Mystique      0.76      0.05       0.0   \n",
       "...                                   ...       ...       ...       ...   \n",
       "XOne     Sports      Alternative Software      0.00      0.01       0.0   \n",
       "         Strategy  Microsoft Game Studios      0.15      0.05       0.0   \n",
       "         Strategy              Activision      0.11      0.04       0.0   \n",
       "         Strategy    Take-Two Interactive      0.06      0.02       0.0   \n",
       "         Strategy            Nordic Games      0.01      0.00       0.0   \n",
       "\n",
       "                   other_sales  global_sales  critic_score  critic_count  \\\n",
       "platform genre                                                             \n",
       "2600     Action           0.02          2.20           NaN           NaN   \n",
       "         Action           0.02          1.97           NaN           NaN   \n",
       "         Action           0.01          1.25           NaN           NaN   \n",
       "         Action           0.01          0.93           NaN           NaN   \n",
       "         Action           0.01          0.82           NaN           NaN   \n",
       "...                        ...           ...           ...           ...   \n",
       "XOne     Sports           0.00          0.01           NaN           NaN   \n",
       "         Strategy         0.02          0.22           NaN           NaN   \n",
       "         Strategy         0.02          0.16          53.0           4.0   \n",
       "         Strategy         0.01          0.09          87.0          17.0   \n",
       "         Strategy         0.00          0.01          65.0           4.0   \n",
       "\n",
       "                   user_score  user_count rating        date  \n",
       "platform genre                                                \n",
       "2600     Action           NaN         NaN    NaN  1981-08-18  \n",
       "         Action           NaN         NaN    NaN  1981-03-02  \n",
       "         Action           NaN         NaN    NaN  1977-11-10  \n",
       "         Action           NaN         NaN    NaN  1981-11-19  \n",
       "         Action           NaN         NaN    NaN  1981-10-18  \n",
       "...                       ...         ...    ...         ...  \n",
       "XOne     Sports           6.6         5.0      E  2016-12-18  \n",
       "         Strategy         NaN         NaN    NaN  2015-07-01  \n",
       "         Strategy         6.9        63.0      E  2013-01-01  \n",
       "         Strategy         8.0        45.0      T  2016-04-12  \n",
       "         Strategy         NaN         NaN   E10+  2016-12-02  \n",
       "\n",
       "[17408 rows x 14 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Sorting by index values\n",
    "indexed.sort_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "c20efb6e-84ac-4e6b-b8e3-ad9020264b37",
   "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>name</th>\n",
       "      <th>year</th>\n",
       "      <th>publisher</th>\n",
       "      <th>na_sales</th>\n",
       "      <th>eu_sales</th>\n",
       "      <th>jp_sales</th>\n",
       "      <th>other_sales</th>\n",
       "      <th>global_sales</th>\n",
       "      <th>critic_score</th>\n",
       "      <th>critic_count</th>\n",
       "      <th>user_score</th>\n",
       "      <th>user_count</th>\n",
       "      <th>rating</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>platform</th>\n",
       "      <th>genre</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">XOne</th>\n",
       "      <th>Strategy</th>\n",
       "      <td>State of Decay</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Microsoft Game Studios</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2015-07-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strategy</th>\n",
       "      <td>Angry Birds Star Wars</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Activision</td>\n",
       "      <td>0.11</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.16</td>\n",
       "      <td>53.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>6.9</td>\n",
       "      <td>63.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2013-01-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strategy</th>\n",
       "      <td>XCOM 2</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Take-Two Interactive</td>\n",
       "      <td>0.06</td>\n",
       "      <td>0.02</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.09</td>\n",
       "      <td>87.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>T</td>\n",
       "      <td>2016-04-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strategy</th>\n",
       "      <td>Battle Worlds: Kronos</td>\n",
       "      <td>2016.0</td>\n",
       "      <td>Nordic Games</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>65.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>E10+</td>\n",
       "      <td>2016-12-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sports</th>\n",
       "      <td>FIFA 16</td>\n",
       "      <td>2015.0</td>\n",
       "      <td>Electronic Arts</td>\n",
       "      <td>0.90</td>\n",
       "      <td>2.12</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.24</td>\n",
       "      <td>3.26</td>\n",
       "      <td>84.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>4.4</td>\n",
       "      <td>463.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2015-07-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">2600</th>\n",
       "      <th>Action</th>\n",
       "      <td>Mr. Do!s Castle</td>\n",
       "      <td>1983.0</td>\n",
       "      <td>Parker Bros.</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1983-06-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action</th>\n",
       "      <td>Armor Ambush</td>\n",
       "      <td>1981.0</td>\n",
       "      <td>Mattel Interactive</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1981-10-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action</th>\n",
       "      <td>Death Trap</td>\n",
       "      <td>1982.0</td>\n",
       "      <td>Avalon Interactive</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1982-11-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action</th>\n",
       "      <td>Pressure Cooker</td>\n",
       "      <td>1982.0</td>\n",
       "      <td>Activision</td>\n",
       "      <td>0.14</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1982-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Action</th>\n",
       "      <td>Krull</td>\n",
       "      <td>1982.0</td>\n",
       "      <td>Atari</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1982-07-13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17408 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    name    year               publisher  \\\n",
       "platform genre                                                             \n",
       "XOne     Strategy         State of Decay  2015.0  Microsoft Game Studios   \n",
       "         Strategy  Angry Birds Star Wars  2013.0              Activision   \n",
       "         Strategy                 XCOM 2  2016.0    Take-Two Interactive   \n",
       "         Strategy  Battle Worlds: Kronos  2016.0            Nordic Games   \n",
       "         Sports                  FIFA 16  2015.0         Electronic Arts   \n",
       "...                                  ...     ...                     ...   \n",
       "2600     Action          Mr. Do!s Castle  1983.0            Parker Bros.   \n",
       "         Action             Armor Ambush  1981.0      Mattel Interactive   \n",
       "         Action               Death Trap  1982.0      Avalon Interactive   \n",
       "         Action          Pressure Cooker  1982.0              Activision   \n",
       "         Action                    Krull  1982.0                   Atari   \n",
       "\n",
       "                   na_sales  eu_sales  jp_sales  other_sales  global_sales  \\\n",
       "platform genre                                                               \n",
       "XOne     Strategy      0.15      0.05       0.0         0.02          0.22   \n",
       "         Strategy      0.11      0.04       0.0         0.02          0.16   \n",
       "         Strategy      0.06      0.02       0.0         0.01          0.09   \n",
       "         Strategy      0.01      0.00       0.0         0.00          0.01   \n",
       "         Sports        0.90      2.12       0.0         0.24          3.26   \n",
       "...                     ...       ...       ...          ...           ...   \n",
       "2600     Action        0.15      0.01       0.0         0.00          0.17   \n",
       "         Action        0.15      0.01       0.0         0.00          0.17   \n",
       "         Action        0.15      0.01       0.0         0.00          0.17   \n",
       "         Action        0.14      0.01       0.0         0.00          0.15   \n",
       "         Action        0.13      0.01       0.0         0.00          0.14   \n",
       "\n",
       "                   critic_score  critic_count  user_score  user_count rating  \\\n",
       "platform genre                                                                 \n",
       "XOne     Strategy           NaN           NaN         NaN         NaN    NaN   \n",
       "         Strategy          53.0           4.0         6.9        63.0      E   \n",
       "         Strategy          87.0          17.0         8.0        45.0      T   \n",
       "         Strategy          65.0           4.0         NaN         NaN   E10+   \n",
       "         Sports            84.0          45.0         4.4       463.0      E   \n",
       "...                         ...           ...         ...         ...    ...   \n",
       "2600     Action             NaN           NaN         NaN         NaN    NaN   \n",
       "         Action             NaN           NaN         NaN         NaN    NaN   \n",
       "         Action             NaN           NaN         NaN         NaN    NaN   \n",
       "         Action             NaN           NaN         NaN         NaN    NaN   \n",
       "         Action             NaN           NaN         NaN         NaN    NaN   \n",
       "\n",
       "                         date  \n",
       "platform genre                 \n",
       "XOne     Strategy  2015-07-01  \n",
       "         Strategy  2013-01-01  \n",
       "         Strategy  2016-04-12  \n",
       "         Strategy  2016-12-02  \n",
       "         Sports    2015-07-10  \n",
       "...                       ...  \n",
       "2600     Action    1983-06-20  \n",
       "         Action    1981-10-19  \n",
       "         Action    1982-11-14  \n",
       "         Action    1982-10-11  \n",
       "         Action    1982-07-13  \n",
       "\n",
       "[17408 rows x 14 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Controlling the sorting.\n",
    "indexed.sort_index(level=['platform', 'genre'], ascending=[False, False])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "361406e1-f11e-4286-af9f-5012b115289c",
   "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>name</th>\n",
       "      <th>year</th>\n",
       "      <th>publisher</th>\n",
       "      <th>na_sales</th>\n",
       "      <th>eu_sales</th>\n",
       "      <th>jp_sales</th>\n",
       "      <th>other_sales</th>\n",
       "      <th>global_sales</th>\n",
       "      <th>critic_score</th>\n",
       "      <th>critic_count</th>\n",
       "      <th>user_score</th>\n",
       "      <th>user_count</th>\n",
       "      <th>rating</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>platform</th>\n",
       "      <th>genre</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>PS3</th>\n",
       "      <th>Action</th>\n",
       "      <td>Grand Theft Auto V</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Take-Two Interactive</td>\n",
       "      <td>7.02</td>\n",
       "      <td>9.14</td>\n",
       "      <td>0.98</td>\n",
       "      <td>3.97</td>\n",
       "      <td>21.12</td>\n",
       "      <td>97.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>8.2</td>\n",
       "      <td>4009.0</td>\n",
       "      <td>M</td>\n",
       "      <td>2013-07-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PS2</th>\n",
       "      <th>Action</th>\n",
       "      <td>Grand Theft Auto: San Andreas</td>\n",
       "      <td>2004.0</td>\n",
       "      <td>Take-Two Interactive</td>\n",
       "      <td>9.43</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.41</td>\n",
       "      <td>10.57</td>\n",
       "      <td>20.81</td>\n",
       "      <td>95.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>1606.0</td>\n",
       "      <td>M</td>\n",
       "      <td>2004-09-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>X360</th>\n",
       "      <th>Action</th>\n",
       "      <td>Grand Theft Auto V</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>Take-Two Interactive</td>\n",
       "      <td>9.66</td>\n",
       "      <td>5.17</td>\n",
       "      <td>0.06</td>\n",
       "      <td>1.41</td>\n",
       "      <td>16.30</td>\n",
       "      <td>97.0</td>\n",
       "      <td>58.0</td>\n",
       "      <td>8.1</td>\n",
       "      <td>3722.0</td>\n",
       "      <td>M</td>\n",
       "      <td>2013-04-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PS2</th>\n",
       "      <th>Action</th>\n",
       "      <td>Grand Theft Auto: Vice City</td>\n",
       "      <td>2002.0</td>\n",
       "      <td>Take-Two Interactive</td>\n",
       "      <td>8.41</td>\n",
       "      <td>5.49</td>\n",
       "      <td>0.47</td>\n",
       "      <td>1.78</td>\n",
       "      <td>16.15</td>\n",
       "      <td>95.0</td>\n",
       "      <td>62.0</td>\n",
       "      <td>8.7</td>\n",
       "      <td>736.0</td>\n",
       "      <td>M</td>\n",
       "      <td>2002-09-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PS4</th>\n",
       "      <th>Action</th>\n",
       "      <td>Grand Theft Auto V</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Take-Two Interactive</td>\n",
       "      <td>4.12</td>\n",
       "      <td>6.77</td>\n",
       "      <td>0.39</td>\n",
       "      <td>2.08</td>\n",
       "      <td>13.36</td>\n",
       "      <td>97.0</td>\n",
       "      <td>66.0</td>\n",
       "      <td>8.3</td>\n",
       "      <td>2955.0</td>\n",
       "      <td>M</td>\n",
       "      <td>2014-06-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">PC</th>\n",
       "      <th>Strategy</th>\n",
       "      <td>Greed Corp</td>\n",
       "      <td>2010.0</td>\n",
       "      <td>DTP Entertainment</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>76.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>7.1</td>\n",
       "      <td>44.0</td>\n",
       "      <td>E</td>\n",
       "      <td>2010-10-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strategy</th>\n",
       "      <td>Stronghold Crusader 2</td>\n",
       "      <td>2014.0</td>\n",
       "      <td>Firefly Studios</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2014-12-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strategy</th>\n",
       "      <td>Medieval: Total War Gold Edition</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>Activision</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>T</td>\n",
       "      <td>2006-04-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strategy</th>\n",
       "      <td>BC Kings</td>\n",
       "      <td>2008.0</td>\n",
       "      <td>Strategy First</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2008-03-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Strategy</th>\n",
       "      <td>CivCity: Rome</td>\n",
       "      <td>2006.0</td>\n",
       "      <td>Take-Two Interactive</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.01</td>\n",
       "      <td>67.0</td>\n",
       "      <td>46.0</td>\n",
       "      <td>6.9</td>\n",
       "      <td>32.0</td>\n",
       "      <td>E10+</td>\n",
       "      <td>2006-12-08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>17408 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               name    year  \\\n",
       "platform genre                                                \n",
       "PS3      Action                  Grand Theft Auto V  2013.0   \n",
       "PS2      Action       Grand Theft Auto: San Andreas  2004.0   \n",
       "X360     Action                  Grand Theft Auto V  2013.0   \n",
       "PS2      Action         Grand Theft Auto: Vice City  2002.0   \n",
       "PS4      Action                  Grand Theft Auto V  2014.0   \n",
       "...                                             ...     ...   \n",
       "PC       Strategy                        Greed Corp  2010.0   \n",
       "         Strategy             Stronghold Crusader 2  2014.0   \n",
       "         Strategy  Medieval: Total War Gold Edition  2006.0   \n",
       "         Strategy                          BC Kings  2008.0   \n",
       "         Strategy                     CivCity: Rome  2006.0   \n",
       "\n",
       "                              publisher  na_sales  eu_sales  jp_sales  \\\n",
       "platform genre                                                          \n",
       "PS3      Action    Take-Two Interactive      7.02      9.14      0.98   \n",
       "PS2      Action    Take-Two Interactive      9.43      0.40      0.41   \n",
       "X360     Action    Take-Two Interactive      9.66      5.17      0.06   \n",
       "PS2      Action    Take-Two Interactive      8.41      5.49      0.47   \n",
       "PS4      Action    Take-Two Interactive      4.12      6.77      0.39   \n",
       "...                                 ...       ...       ...       ...   \n",
       "PC       Strategy     DTP Entertainment      0.00      0.00      0.00   \n",
       "         Strategy       Firefly Studios      0.00      0.00      0.00   \n",
       "         Strategy            Activision      0.00      0.01      0.00   \n",
       "         Strategy        Strategy First      0.00      0.00      0.00   \n",
       "         Strategy  Take-Two Interactive      0.00      0.00      0.00   \n",
       "\n",
       "                   other_sales  global_sales  critic_score  critic_count  \\\n",
       "platform genre                                                             \n",
       "PS3      Action           3.97         21.12          97.0          50.0   \n",
       "PS2      Action          10.57         20.81          95.0          80.0   \n",
       "X360     Action           1.41         16.30          97.0          58.0   \n",
       "PS2      Action           1.78         16.15          95.0          62.0   \n",
       "PS4      Action           2.08         13.36          97.0          66.0   \n",
       "...                        ...           ...           ...           ...   \n",
       "PC       Strategy         0.00          0.01          76.0           7.0   \n",
       "         Strategy         0.00          0.01           NaN           NaN   \n",
       "         Strategy         0.00          0.01           NaN           NaN   \n",
       "         Strategy         0.00          0.01           NaN           NaN   \n",
       "         Strategy         0.00          0.01          67.0          46.0   \n",
       "\n",
       "                   user_score  user_count rating        date  \n",
       "platform genre                                                \n",
       "PS3      Action           8.2      4009.0      M  2013-07-15  \n",
       "PS2      Action           9.0      1606.0      M  2004-09-04  \n",
       "X360     Action           8.1      3722.0      M  2013-04-02  \n",
       "PS2      Action           8.7       736.0      M  2002-09-20  \n",
       "PS4      Action           8.3      2955.0      M  2014-06-11  \n",
       "...                       ...         ...    ...         ...  \n",
       "PC       Strategy         7.1        44.0      E  2010-10-05  \n",
       "         Strategy         NaN         NaN    NaN  2014-12-17  \n",
       "         Strategy         NaN         NaN      T  2006-04-08  \n",
       "         Strategy         NaN         NaN    NaN  2008-03-10  \n",
       "         Strategy         6.9        32.0   E10+  2006-12-08  \n",
       "\n",
       "[17408 rows x 14 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indexed.sort_index(level=['genre'], ascending=[True])"
   ]
  }
 ],
 "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.10.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}