10- Working with Pivot Tables.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "0eb8ff0f-8309-4a28-b8bc-882809d0f9a7",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "df = pd.read_csv('./datasets/game_sales.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "8aea46c3-67e9-47f7-8eb6-94c8420f34dd",
   "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": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "aabed7be-8f31-4528-b44c-0ab8210cdab7",
   "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>platform</th>\n",
       "      <th>2600</th>\n",
       "      <th>3DO</th>\n",
       "      <th>3DS</th>\n",
       "      <th>DC</th>\n",
       "      <th>DS</th>\n",
       "      <th>G</th>\n",
       "      <th>GBA</th>\n",
       "      <th>GC</th>\n",
       "      <th>GEN</th>\n",
       "      <th>GG</th>\n",
       "      <th>...</th>\n",
       "      <th>SAT</th>\n",
       "      <th>SCD</th>\n",
       "      <th>SNES</th>\n",
       "      <th>TG16</th>\n",
       "      <th>WS</th>\n",
       "      <th>Wii</th>\n",
       "      <th>WiiU</th>\n",
       "      <th>X</th>\n",
       "      <th>X360</th>\n",
       "      <th>XOne</th>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <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>Action</th>\n",
       "      <td>29.34</td>\n",
       "      <td>NaN</td>\n",
       "      <td>59.92</td>\n",
       "      <td>1.26</td>\n",
       "      <td>112.86</td>\n",
       "      <td>7.92</td>\n",
       "      <td>55.80</td>\n",
       "      <td>37.84</td>\n",
       "      <td>2.74</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0.65</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.08</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>114.45</td>\n",
       "      <td>19.63</td>\n",
       "      <td>49.28</td>\n",
       "      <td>240.69</td>\n",
       "      <td>40.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Adventure</th>\n",
       "      <td>1.70</td>\n",
       "      <td>0.06</td>\n",
       "      <td>5.05</td>\n",
       "      <td>2.50</td>\n",
       "      <td>46.19</td>\n",
       "      <td>17.16</td>\n",
       "      <td>14.70</td>\n",
       "      <td>5.93</td>\n",
       "      <td>0.19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4.16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.50</td>\n",
       "      <td>0.14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.88</td>\n",
       "      <td>0.19</td>\n",
       "      <td>3.07</td>\n",
       "      <td>15.20</td>\n",
       "      <td>2.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fighting</th>\n",
       "      <td>1.24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.67</td>\n",
       "      <td>1.83</td>\n",
       "      <td>7.12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.21</td>\n",
       "      <td>18.43</td>\n",
       "      <td>5.90</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8.52</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26.95</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.74</td>\n",
       "      <td>6.45</td>\n",
       "      <td>13.55</td>\n",
       "      <td>37.43</td>\n",
       "      <td>2.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Misc</th>\n",
       "      <td>3.58</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.67</td>\n",
       "      <td>NaN</td>\n",
       "      <td>136.02</td>\n",
       "      <td>13.35</td>\n",
       "      <td>36.28</td>\n",
       "      <td>16.73</td>\n",
       "      <td>0.03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1.20</td>\n",
       "      <td>0.1</td>\n",
       "      <td>5.02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>217.22</td>\n",
       "      <td>13.13</td>\n",
       "      <td>9.58</td>\n",
       "      <td>92.00</td>\n",
       "      <td>8.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Platform</th>\n",
       "      <td>13.27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34.29</td>\n",
       "      <td>2.54</td>\n",
       "      <td>75.98</td>\n",
       "      <td>54.91</td>\n",
       "      <td>78.32</td>\n",
       "      <td>28.66</td>\n",
       "      <td>15.45</td>\n",
       "      <td>0.04</td>\n",
       "      <td>...</td>\n",
       "      <td>0.76</td>\n",
       "      <td>1.5</td>\n",
       "      <td>65.65</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>89.13</td>\n",
       "      <td>22.18</td>\n",
       "      <td>9.66</td>\n",
       "      <td>11.42</td>\n",
       "      <td>1.02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "platform    2600   3DO    3DS    DC      DS      G    GBA     GC    GEN    GG  \\\n",
       "genre                                                                           \n",
       "Action     29.34   NaN  59.92  1.26  112.86   7.92  55.80  37.84   2.74   NaN   \n",
       "Adventure   1.70  0.06   5.05  2.50   46.19  17.16  14.70   5.93   0.19   NaN   \n",
       "Fighting    1.24   NaN  10.67  1.83    7.12    NaN   4.21  18.43   5.90   NaN   \n",
       "Misc        3.58   NaN  11.67   NaN  136.02  13.35  36.28  16.73   0.03   NaN   \n",
       "Platform   13.27   NaN  34.29  2.54   75.98  54.91  78.32  28.66  15.45  0.04   \n",
       "\n",
       "platform   ...   SAT  SCD   SNES  TG16  WS     Wii   WiiU      X    X360  \\\n",
       "genre      ...                                                             \n",
       "Action     ...  0.65  NaN  10.08   NaN NaN  114.45  19.63  49.28  240.69   \n",
       "Adventure  ...  4.16  NaN   1.50  0.14 NaN   17.88   0.19   3.07   15.20   \n",
       "Fighting   ...  8.52  NaN  26.95   NaN NaN   23.74   6.45  13.55   37.43   \n",
       "Misc       ...  1.20  0.1   5.02   NaN NaN  217.22  13.13   9.58   92.00   \n",
       "Platform   ...  0.76  1.5  65.65   NaN NaN   89.13  22.18   9.66   11.42   \n",
       "\n",
       "platform    XOne  \n",
       "genre             \n",
       "Action     40.24  \n",
       "Adventure   2.97  \n",
       "Fighting    2.55  \n",
       "Misc        8.42  \n",
       "Platform    1.02  \n",
       "\n",
       "[5 rows x 31 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Group by two variables.\n",
    "pt = df.pivot_table(values=\"global_sales\", index=\"genre\", columns=\"platform\", aggfunc=sum)\n",
    "\n",
    "pt.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "2e1c25ea-6196-43cf-be69-1213b5a8967c",
   "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>platform</th>\n",
       "      <th>2600</th>\n",
       "      <th>3DO</th>\n",
       "      <th>3DS</th>\n",
       "      <th>DC</th>\n",
       "      <th>DS</th>\n",
       "      <th>G</th>\n",
       "      <th>GBA</th>\n",
       "      <th>GC</th>\n",
       "      <th>GEN</th>\n",
       "      <th>GG</th>\n",
       "      <th>...</th>\n",
       "      <th>SAT</th>\n",
       "      <th>SCD</th>\n",
       "      <th>SNES</th>\n",
       "      <th>TG16</th>\n",
       "      <th>WS</th>\n",
       "      <th>Wii</th>\n",
       "      <th>WiiU</th>\n",
       "      <th>X</th>\n",
       "      <th>X360</th>\n",
       "      <th>XOne</th>\n",
       "    </tr>\n",
       "    <tr>\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",
       "      <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>Adventure</th>\n",
       "      <td>1.70</td>\n",
       "      <td>0.06</td>\n",
       "      <td>5.05</td>\n",
       "      <td>2.50</td>\n",
       "      <td>46.19</td>\n",
       "      <td>17.16</td>\n",
       "      <td>14.70</td>\n",
       "      <td>5.93</td>\n",
       "      <td>0.19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4.16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.50</td>\n",
       "      <td>0.14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17.88</td>\n",
       "      <td>0.19</td>\n",
       "      <td>3.07</td>\n",
       "      <td>15.20</td>\n",
       "      <td>2.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fighting</th>\n",
       "      <td>1.24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.67</td>\n",
       "      <td>1.83</td>\n",
       "      <td>7.12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.21</td>\n",
       "      <td>18.43</td>\n",
       "      <td>5.90</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>8.52</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26.95</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.74</td>\n",
       "      <td>6.45</td>\n",
       "      <td>13.55</td>\n",
       "      <td>37.43</td>\n",
       "      <td>2.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Misc</th>\n",
       "      <td>3.58</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11.67</td>\n",
       "      <td>NaN</td>\n",
       "      <td>136.02</td>\n",
       "      <td>13.35</td>\n",
       "      <td>36.28</td>\n",
       "      <td>16.73</td>\n",
       "      <td>0.03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1.20</td>\n",
       "      <td>0.1</td>\n",
       "      <td>5.02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>217.22</td>\n",
       "      <td>13.13</td>\n",
       "      <td>9.58</td>\n",
       "      <td>92.00</td>\n",
       "      <td>8.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Platform</th>\n",
       "      <td>13.27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34.29</td>\n",
       "      <td>2.54</td>\n",
       "      <td>75.98</td>\n",
       "      <td>54.91</td>\n",
       "      <td>78.32</td>\n",
       "      <td>28.66</td>\n",
       "      <td>15.45</td>\n",
       "      <td>0.04</td>\n",
       "      <td>...</td>\n",
       "      <td>0.76</td>\n",
       "      <td>1.5</td>\n",
       "      <td>65.65</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>89.13</td>\n",
       "      <td>22.18</td>\n",
       "      <td>9.66</td>\n",
       "      <td>11.42</td>\n",
       "      <td>1.02</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "platform    2600   3DO    3DS    DC      DS      G    GBA     GC    GEN    GG  \\\n",
       "genre                                                                           \n",
       "Adventure   1.70  0.06   5.05  2.50   46.19  17.16  14.70   5.93   0.19   NaN   \n",
       "Fighting    1.24   NaN  10.67  1.83    7.12    NaN   4.21  18.43   5.90   NaN   \n",
       "Misc        3.58   NaN  11.67   NaN  136.02  13.35  36.28  16.73   0.03   NaN   \n",
       "Platform   13.27   NaN  34.29  2.54   75.98  54.91  78.32  28.66  15.45  0.04   \n",
       "\n",
       "platform   ...   SAT  SCD   SNES  TG16  WS     Wii   WiiU      X   X360  XOne  \n",
       "genre      ...                                                                 \n",
       "Adventure  ...  4.16  NaN   1.50  0.14 NaN   17.88   0.19   3.07  15.20  2.97  \n",
       "Fighting   ...  8.52  NaN  26.95   NaN NaN   23.74   6.45  13.55  37.43  2.55  \n",
       "Misc       ...  1.20  0.1   5.02   NaN NaN  217.22  13.13   9.58  92.00  8.42  \n",
       "Platform   ...  0.76  1.5  65.65   NaN NaN   89.13  22.18   9.66  11.42  1.02  \n",
       "\n",
       "[4 rows x 31 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Pivot tables are just DataFrames with sorted indexes.\n",
    "\n",
    "pt.loc[\"Adventure\":\"Platform\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "35e9eb9c-30ed-47b6-890e-8c68e2343e7d",
   "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>platform</th>\n",
       "      <th>PC</th>\n",
       "      <th>PCFX</th>\n",
       "      <th>PS</th>\n",
       "      <th>PS2</th>\n",
       "      <th>PS3</th>\n",
       "      <th>PS4</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>genre</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>Adventure</th>\n",
       "      <td>10.34</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20.98</td>\n",
       "      <td>21.45</td>\n",
       "      <td>22.50</td>\n",
       "      <td>7.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fighting</th>\n",
       "      <td>0.29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>72.68</td>\n",
       "      <td>92.63</td>\n",
       "      <td>51.26</td>\n",
       "      <td>9.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Misc</th>\n",
       "      <td>8.74</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44.91</td>\n",
       "      <td>101.16</td>\n",
       "      <td>47.25</td>\n",
       "      <td>8.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Platform</th>\n",
       "      <td>0.51</td>\n",
       "      <td>NaN</td>\n",
       "      <td>64.21</td>\n",
       "      <td>72.51</td>\n",
       "      <td>29.83</td>\n",
       "      <td>8.31</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "platform      PC  PCFX     PS     PS2    PS3   PS4\n",
       "genre                                             \n",
       "Adventure  10.34   NaN  20.98   21.45  22.50  7.21\n",
       "Fighting    0.29   NaN  72.68   92.63  51.26  9.13\n",
       "Misc        8.74   NaN  44.91  101.16  47.25  8.93\n",
       "Platform    0.51   NaN  64.21   72.51  29.83  8.31"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pt.loc[\"Adventure\":\"Platform\", \"PC\":\"PS4\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "cbbf5080-a14a-4436-bbf4-5687ec020135",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "platform\n",
       "PS2     1256.09\n",
       "X360     975.43\n",
       "PS3      943.29\n",
       "Wii      910.14\n",
       "DS       808.82\n",
       "dtype: float64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# axis=index (default) means calculate the statistic across rows.\n",
    "sumt = pt.sum(axis=\"index\").sort_values(ascending=False)\n",
    "sumt.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "6759d4f7-1cbe-409e-928e-f2b26b3a1dc9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "platform\n",
       "PS2     1256.09\n",
       "X360     975.43\n",
       "PS3      943.29\n",
       "dtype: float64"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sumt['PS2':'PS3']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "a54f1f99-a724-4f82-becc-cae025f4a90b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1256.09"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sumt['PS2':'PS3'].iloc[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "0c932796-d274-46a3-9113-b5ff58248383",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1256.09"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sumt['PS2':'PS3'].max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "39fa8087-f24f-4347-b3c9-5755dffcc255",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "943.2900000000001"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sumt['PS2':'PS3'].min()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "ce6c5fb9-5065-4f80-ac8b-0378186366ba",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "genre\n",
       "Action          1761.89\n",
       "Sports          1340.99\n",
       "Shooter         1067.28\n",
       "Role-Playing     949.31\n",
       "Platform         831.74\n",
       "dtype: float64"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# axis=index means calculate the statistic across columns.\n",
    "\n",
    "# useful for pivot tables but for dataframes, this doesn't\n",
    "# makes sense since every column has different data type.\n",
    "\n",
    "sumt = pt.sum(axis=\"columns\").sort_values(ascending=False)\n",
    "sumt.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "a6be82b3-6772-4fef-96db-9696c19b2b2d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>2009.0</th>\n",
       "      <th>2010.0</th>\n",
       "      <th>2011.0</th>\n",
       "      <th>2012.0</th>\n",
       "      <th>2013.0</th>\n",
       "      <th>2014.0</th>\n",
       "      <th>2015.0</th>\n",
       "      <th>2016.0</th>\n",
       "      <th>2017.0</th>\n",
       "      <th>All</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>publisher</th>\n",
       "      <th>platform</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=\"2\" valign=\"top\">10TACLE Studios</th>\n",
       "      <th>DS</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PS2</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1C Company</th>\n",
       "      <th>PC</th>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20th Century Fox Video Games</th>\n",
       "      <th>2600</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2D Boy</th>\n",
       "      <th>PC</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3 O'Clock</th>\n",
       "      <th>DS</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">3DO</th>\n",
       "      <th>GBA</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GC</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>N64</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PS</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.93</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "year                                   2009.0  2010.0  2011.0  2012.0  2013.0  \\\n",
       "publisher                    platform                                           \n",
       "10TACLE Studios              DS          0.00     0.0     0.0     0.0     0.0   \n",
       "                             PS2         0.00     0.0     0.0     0.0     0.0   \n",
       "1C Company                   PC          0.01     0.0     0.1     0.0     0.0   \n",
       "20th Century Fox Video Games 2600        0.00     0.0     0.0     0.0     0.0   \n",
       "2D Boy                       PC          0.00     0.0     0.0     0.0     0.0   \n",
       "3 O'Clock                    DS          0.00     0.0     0.0     0.0     0.0   \n",
       "3DO                          GBA         0.00     0.0     0.0     0.0     0.0   \n",
       "                             GC          0.00     0.0     0.0     0.0     0.0   \n",
       "                             N64         0.00     0.0     0.0     0.0     0.0   \n",
       "                             PS          0.00     0.0     0.0     0.0     0.0   \n",
       "\n",
       "year                                   2014.0  2015.0  2016.0  2017.0   All  \n",
       "publisher                    platform                                        \n",
       "10TACLE Studios              DS           0.0     0.0     0.0     0.0  0.09  \n",
       "                             PS2          0.0     0.0     0.0     0.0  0.02  \n",
       "1C Company                   PC           0.0     0.0     0.0     0.0  0.11  \n",
       "20th Century Fox Video Games 2600         0.0     0.0     0.0     0.0  1.94  \n",
       "2D Boy                       PC           0.0     0.0     0.0     0.0  0.04  \n",
       "3 O'Clock                    DS           0.0     0.0     0.0     0.0  0.03  \n",
       "3DO                          GBA          0.0     0.0     0.0     0.0  0.36  \n",
       "                             GC           0.0     0.0     0.0     0.0  0.01  \n",
       "                             N64          0.0     0.0     0.0     0.0  2.19  \n",
       "                             PS           0.0     0.0     0.0     0.0  5.93  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Multiple index.\n",
    "mpt = df.pivot_table(\n",
    "        values=\"global_sales\", index=[\"publisher\", \"platform\"],\n",
    "        columns=\"year\", aggfunc=sum, fill_value=0, margins=True)\n",
    "\n",
    "mpt = mpt.sort_index() # DONT FORGET TO SORT INDEX\n",
    "mpt = mpt.loc[:, 2009:]\n",
    "\n",
    "mpt.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "85adfafa-067e-4ebb-9d20-4c4bc2bd5922",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>2009.0</th>\n",
       "      <th>2010.0</th>\n",
       "      <th>2011.0</th>\n",
       "      <th>2012.0</th>\n",
       "      <th>2013.0</th>\n",
       "      <th>2014.0</th>\n",
       "      <th>2015.0</th>\n",
       "      <th>2016.0</th>\n",
       "      <th>2017.0</th>\n",
       "      <th>All</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>publisher</th>\n",
       "      <th>platform</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=\"10\" valign=\"top\">Electronic Arts</th>\n",
       "      <th>PC</th>\n",
       "      <td>9.57</td>\n",
       "      <td>5.55</td>\n",
       "      <td>11.36</td>\n",
       "      <td>2.52</td>\n",
       "      <td>4.25</td>\n",
       "      <td>4.85</td>\n",
       "      <td>1.22</td>\n",
       "      <td>1.16</td>\n",
       "      <td>0.0</td>\n",
       "      <td>72.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PS</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PS2</th>\n",
       "      <td>4.57</td>\n",
       "      <td>1.64</td>\n",
       "      <td>0.09</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>257.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PS3</th>\n",
       "      <td>19.84</td>\n",
       "      <td>28.35</td>\n",
       "      <td>29.17</td>\n",
       "      <td>22.14</td>\n",
       "      <td>17.10</td>\n",
       "      <td>8.01</td>\n",
       "      <td>4.01</td>\n",
       "      <td>1.15</td>\n",
       "      <td>0.0</td>\n",
       "      <td>166.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PS4</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>9.76</td>\n",
       "      <td>12.80</td>\n",
       "      <td>26.03</td>\n",
       "      <td>20.05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>68.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PSP</th>\n",
       "      <td>4.33</td>\n",
       "      <td>2.56</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.19</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>39.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PSV</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>2.34</td>\n",
       "      <td>0.41</td>\n",
       "      <td>0.63</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAT</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wii</th>\n",
       "      <td>17.76</td>\n",
       "      <td>10.35</td>\n",
       "      <td>2.78</td>\n",
       "      <td>1.19</td>\n",
       "      <td>0.38</td>\n",
       "      <td>0.57</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>62.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WiiU</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.98</td>\n",
       "      <td>0.27</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.25</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "year                      2009.0  2010.0  2011.0  2012.0  2013.0  2014.0  \\\n",
       "publisher       platform                                                   \n",
       "Electronic Arts PC          9.57    5.55   11.36    2.52    4.25    4.85   \n",
       "                PS          0.00    0.00    0.00    0.00    0.00    0.00   \n",
       "                PS2         4.57    1.64    0.09    0.00    0.00    0.00   \n",
       "                PS3        19.84   28.35   29.17   22.14   17.10    8.01   \n",
       "                PS4         0.00    0.00    0.00    0.00    9.76   12.80   \n",
       "                PSP         4.33    2.56    0.75    0.35    0.19    0.00   \n",
       "                PSV         0.00    0.00    0.00    2.34    0.41    0.63   \n",
       "                SAT         0.00    0.00    0.00    0.00    0.00    0.00   \n",
       "                Wii        17.76   10.35    2.78    1.19    0.38    0.57   \n",
       "                WiiU        0.00    0.00    0.00    0.98    0.27    0.00   \n",
       "\n",
       "year                      2015.0  2016.0  2017.0     All  \n",
       "publisher       platform                                  \n",
       "Electronic Arts PC          1.22    1.16     0.0   72.45  \n",
       "                PS          0.00    0.00     0.0   91.92  \n",
       "                PS2         0.00    0.00     0.0  257.01  \n",
       "                PS3         4.01    1.15     0.0  166.17  \n",
       "                PS4        26.03   20.05     0.0   68.64  \n",
       "                PSP         0.00    0.00     0.0   39.55  \n",
       "                PSV         0.00    0.00     0.0    3.38  \n",
       "                SAT         0.00    0.00     0.0    0.08  \n",
       "                Wii         0.00    0.00     0.0   62.20  \n",
       "                WiiU        0.00    0.00     0.0    1.25  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Slicing by multiple index\n",
    "mpt = mpt.loc[('Electronic Arts','PC'):('Nintendo','PS4')]\n",
    "mpt.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "ec31b0c8-62e4-4b0b-9640-9018d1d68214",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th colspan=\"10\" halign=\"left\">2009.0</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"6\" halign=\"left\">2016.0</th>\n",
       "      <th colspan=\"3\" halign=\"left\">2017.0</th>\n",
       "      <th>All</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>genre</th>\n",
       "      <th>Action</th>\n",
       "      <th>Adventure</th>\n",
       "      <th>Fighting</th>\n",
       "      <th>Misc</th>\n",
       "      <th>Platform</th>\n",
       "      <th>Puzzle</th>\n",
       "      <th>Racing</th>\n",
       "      <th>Role-Playing</th>\n",
       "      <th>Shooter</th>\n",
       "      <th>Simulation</th>\n",
       "      <th>...</th>\n",
       "      <th>Racing</th>\n",
       "      <th>Role-Playing</th>\n",
       "      <th>Shooter</th>\n",
       "      <th>Simulation</th>\n",
       "      <th>Sports</th>\n",
       "      <th>Strategy</th>\n",
       "      <th>Action</th>\n",
       "      <th>Adventure</th>\n",
       "      <th>Role-Playing</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>publisher</th>\n",
       "      <th>platform</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"2\" valign=\"top\">10TACLE Studios</th>\n",
       "      <th>DS</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PS2</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1C Company</th>\n",
       "      <th>PC</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20th Century Fox Video Games</th>\n",
       "      <th>2600</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2D Boy</th>\n",
       "      <th>PC</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3 O'Clock</th>\n",
       "      <th>DS</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">3DO</th>\n",
       "      <th>GBA</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GC</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>N64</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PS</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.93</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 100 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "year                                  2009.0                                   \\\n",
       "genre                                 Action Adventure Fighting Misc Platform   \n",
       "publisher                    platform                                           \n",
       "10TACLE Studios              DS          0.0       0.0      0.0  0.0      0.0   \n",
       "                             PS2         0.0       0.0      0.0  0.0      0.0   \n",
       "1C Company                   PC          0.0       0.0      0.0  0.0      0.0   \n",
       "20th Century Fox Video Games 2600        0.0       0.0      0.0  0.0      0.0   \n",
       "2D Boy                       PC          0.0       0.0      0.0  0.0      0.0   \n",
       "3 O'Clock                    DS          0.0       0.0      0.0  0.0      0.0   \n",
       "3DO                          GBA         0.0       0.0      0.0  0.0      0.0   \n",
       "                             GC          0.0       0.0      0.0  0.0      0.0   \n",
       "                             N64         0.0       0.0      0.0  0.0      0.0   \n",
       "                             PS          0.0       0.0      0.0  0.0      0.0   \n",
       "\n",
       "year                                                                      \\\n",
       "genre                                 Puzzle Racing Role-Playing Shooter   \n",
       "publisher                    platform                                      \n",
       "10TACLE Studios              DS          0.0    0.0         0.00     0.0   \n",
       "                             PS2         0.0    0.0         0.00     0.0   \n",
       "1C Company                   PC          0.0    0.0         0.01     0.0   \n",
       "20th Century Fox Video Games 2600        0.0    0.0         0.00     0.0   \n",
       "2D Boy                       PC          0.0    0.0         0.00     0.0   \n",
       "3 O'Clock                    DS          0.0    0.0         0.00     0.0   \n",
       "3DO                          GBA         0.0    0.0         0.00     0.0   \n",
       "                             GC          0.0    0.0         0.00     0.0   \n",
       "                             N64         0.0    0.0         0.00     0.0   \n",
       "                             PS          0.0    0.0         0.00     0.0   \n",
       "\n",
       "year                                              ... 2016.0               \\\n",
       "genre                                 Simulation  ... Racing Role-Playing   \n",
       "publisher                    platform             ...                       \n",
       "10TACLE Studios              DS              0.0  ...    0.0          0.0   \n",
       "                             PS2             0.0  ...    0.0          0.0   \n",
       "1C Company                   PC              0.0  ...    0.0          0.0   \n",
       "20th Century Fox Video Games 2600            0.0  ...    0.0          0.0   \n",
       "2D Boy                       PC              0.0  ...    0.0          0.0   \n",
       "3 O'Clock                    DS              0.0  ...    0.0          0.0   \n",
       "3DO                          GBA             0.0  ...    0.0          0.0   \n",
       "                             GC              0.0  ...    0.0          0.0   \n",
       "                             N64             0.0  ...    0.0          0.0   \n",
       "                             PS              0.0  ...    0.0          0.0   \n",
       "\n",
       "year                                                                      \\\n",
       "genre                                 Shooter Simulation Sports Strategy   \n",
       "publisher                    platform                                      \n",
       "10TACLE Studios              DS           0.0        0.0    0.0      0.0   \n",
       "                             PS2          0.0        0.0    0.0      0.0   \n",
       "1C Company                   PC           0.0        0.0    0.0      0.0   \n",
       "20th Century Fox Video Games 2600         0.0        0.0    0.0      0.0   \n",
       "2D Boy                       PC           0.0        0.0    0.0      0.0   \n",
       "3 O'Clock                    DS           0.0        0.0    0.0      0.0   \n",
       "3DO                          GBA          0.0        0.0    0.0      0.0   \n",
       "                             GC           0.0        0.0    0.0      0.0   \n",
       "                             N64          0.0        0.0    0.0      0.0   \n",
       "                             PS           0.0        0.0    0.0      0.0   \n",
       "\n",
       "year                                  2017.0                          All  \n",
       "genre                                 Action Adventure Role-Playing        \n",
       "publisher                    platform                                      \n",
       "10TACLE Studios              DS          0.0       0.0          0.0  0.09  \n",
       "                             PS2         0.0       0.0          0.0  0.02  \n",
       "1C Company                   PC          0.0       0.0          0.0  0.11  \n",
       "20th Century Fox Video Games 2600        0.0       0.0          0.0  1.94  \n",
       "2D Boy                       PC          0.0       0.0          0.0  0.04  \n",
       "3 O'Clock                    DS          0.0       0.0          0.0  0.03  \n",
       "3DO                          GBA         0.0       0.0          0.0  0.36  \n",
       "                             GC          0.0       0.0          0.0  0.01  \n",
       "                             N64         0.0       0.0          0.0  2.19  \n",
       "                             PS          0.0       0.0          0.0  5.93  \n",
       "\n",
       "[10 rows x 100 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Multiple index and row.\n",
    "mpt = df.pivot_table(\n",
    "        values=\"global_sales\", index=[\"publisher\", \"platform\"],\n",
    "        columns=[\"year\", \"genre\"], aggfunc=sum, fill_value=0, margins=True)\n",
    "\n",
    "mpt = mpt.sort_index() # DONT FORGET TO SORT INDEX\n",
    "mpt = mpt.loc[:, 2009:]\n",
    "\n",
    "mpt.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "349b1cac-1658-48e5-8ebc-e53fdf0c1d48",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th colspan=\"3\" halign=\"left\">2016.0</th>\n",
       "      <th colspan=\"2\" halign=\"left\">2017.0</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>genre</th>\n",
       "      <th>Simulation</th>\n",
       "      <th>Sports</th>\n",
       "      <th>Strategy</th>\n",
       "      <th>Action</th>\n",
       "      <th>Adventure</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>publisher</th>\n",
       "      <th>platform</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=\"10\" valign=\"top\">Electronic Arts</th>\n",
       "      <th>PC</th>\n",
       "      <td>0.19</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PS</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PS2</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PS3</th>\n",
       "      <td>0.00</td>\n",
       "      <td>1.15</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PS4</th>\n",
       "      <td>0.00</td>\n",
       "      <td>12.79</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PSP</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PSV</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SAT</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wii</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WiiU</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "year                         2016.0                 2017.0          \n",
       "genre                    Simulation Sports Strategy Action Adventure\n",
       "publisher       platform                                            \n",
       "Electronic Arts PC             0.19   0.15      0.0    0.0       0.0\n",
       "                PS             0.00   0.00      0.0    0.0       0.0\n",
       "                PS2            0.00   0.00      0.0    0.0       0.0\n",
       "                PS3            0.00   1.15      0.0    0.0       0.0\n",
       "                PS4            0.00  12.79      0.0    0.0       0.0\n",
       "                PSP            0.00   0.00      0.0    0.0       0.0\n",
       "                PSV            0.00   0.00      0.0    0.0       0.0\n",
       "                SAT            0.00   0.00      0.0    0.0       0.0\n",
       "                Wii            0.00   0.00      0.0    0.0       0.0\n",
       "                WiiU           0.00   0.00      0.0    0.0       0.0"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Slicing by multiple index and columns.\n",
    "mpt = mpt.loc[\n",
    "    ('Electronic Arts','PC'):('Nintendo','PS4'),\n",
    "    (2016, 'Simulation'):(2017, 'Adventure')\n",
    "]\n",
    "\n",
    "mpt.head(10)"
   ]
  }
 ],
 "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
}