game_reviews.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Games reviews on metacritic from 1995 to 2021"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Imports"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from typing import List"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Load data from CSV"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>release_date</th>\n",
       "      <th>summary</th>\n",
       "      <th>meta_score</th>\n",
       "      <th>user_review</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Legend of Zelda: Ocarina of Time</td>\n",
       "      <td>Nintendo 64</td>\n",
       "      <td>November 23, 1998</td>\n",
       "      <td>As a young boy, Link is tricked by Ganondorf, ...</td>\n",
       "      <td>99</td>\n",
       "      <td>9.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Tony Hawk's Pro Skater 2</td>\n",
       "      <td>PlayStation</td>\n",
       "      <td>September 20, 2000</td>\n",
       "      <td>As most major publishers' development efforts ...</td>\n",
       "      <td>98</td>\n",
       "      <td>7.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Grand Theft Auto IV</td>\n",
       "      <td>PlayStation 3</td>\n",
       "      <td>April 29, 2008</td>\n",
       "      <td>[Metacritic's 2008 PS3 Game of the Year; Also ...</td>\n",
       "      <td>98</td>\n",
       "      <td>7.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SoulCalibur</td>\n",
       "      <td>Dreamcast</td>\n",
       "      <td>September 8, 1999</td>\n",
       "      <td>This is a tale of souls and swords, transcendi...</td>\n",
       "      <td>98</td>\n",
       "      <td>8.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Grand Theft Auto IV</td>\n",
       "      <td>Xbox 360</td>\n",
       "      <td>April 29, 2008</td>\n",
       "      <td>[Metacritic's 2008 Xbox 360 Game of the Year; ...</td>\n",
       "      <td>98</td>\n",
       "      <td>7.9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   name        platform        release_date  \\\n",
       "0  The Legend of Zelda: Ocarina of Time     Nintendo 64   November 23, 1998   \n",
       "1              Tony Hawk's Pro Skater 2     PlayStation  September 20, 2000   \n",
       "2                   Grand Theft Auto IV   PlayStation 3      April 29, 2008   \n",
       "3                           SoulCalibur       Dreamcast   September 8, 1999   \n",
       "4                   Grand Theft Auto IV        Xbox 360      April 29, 2008   \n",
       "\n",
       "                                             summary  meta_score user_review  \n",
       "0  As a young boy, Link is tricked by Ganondorf, ...          99         9.1  \n",
       "1  As most major publishers' development efforts ...          98         7.4  \n",
       "2  [Metacritic's 2008 PS3 Game of the Year; Also ...          98         7.7  \n",
       "3  This is a tale of souls and swords, transcendi...          98         8.4  \n",
       "4  [Metacritic's 2008 Xbox 360 Game of the Year; ...          98         7.9  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "games_reviews = pd.read_csv(\"all_games.csv\")\n",
    "games_reviews.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Data Cleanup"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Cleanup release date"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       1998-11-23\n",
       "1       2000-09-20\n",
       "2       2008-04-29\n",
       "3       1999-09-08\n",
       "4       2008-04-29\n",
       "           ...    \n",
       "18795   2013-05-21\n",
       "18796   2003-11-03\n",
       "18797   2015-09-22\n",
       "18798   2012-10-15\n",
       "18799   2009-03-31\n",
       "Name: release_date, Length: 18800, dtype: datetime64[ns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "games_reviews[\"release_date\"] = pd.to_datetime(games_reviews[\"release_date\"])\n",
    "games_reviews[\"release_date\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Use same scale from meta score in the user reviews (0-100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0        9.9\n",
       "1        9.8\n",
       "2        9.8\n",
       "3        9.8\n",
       "4        9.8\n",
       "        ... \n",
       "18795    2.2\n",
       "18796    2.2\n",
       "18797    2.1\n",
       "18798    2.0\n",
       "18799    2.0\n",
       "Name: meta_score, Length: 18800, dtype: float64"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "games_reviews[\"meta_score\"] = games_reviews[\"meta_score\"] / 10\n",
    "games_reviews[\"meta_score\"]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Replace \"tbd\" user_reviews with 0\n",
    "### **WARNING!** remember to not compare user scores and meta scores when the user score is 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "games_reviews[\"user_review\"] = games_reviews[\"user_review\"].replace(\"tbd\", 0)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Cast user_review to float64"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "games_reviews[\"user_review\"] = games_reviews[\"user_review\"].astype(\"float64\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Rename user_review to user_score"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "games_reviews = games_reviews.rename(columns={\"user_review\": \"user_score\"})"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Check for NAN"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>platform</th>\n",
       "      <th>release_date</th>\n",
       "      <th>summary</th>\n",
       "      <th>meta_score</th>\n",
       "      <th>user_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>833</th>\n",
       "      <td>Injustice 2: Legendary Edition</td>\n",
       "      <td>PlayStation 4</td>\n",
       "      <td>2018-03-27</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.8</td>\n",
       "      <td>7.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1472</th>\n",
       "      <td>Moto Racer Advance</td>\n",
       "      <td>Game Boy Advance</td>\n",
       "      <td>2002-12-05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.6</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1535</th>\n",
       "      <td>Mini Metro</td>\n",
       "      <td>Switch</td>\n",
       "      <td>2018-08-30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.6</td>\n",
       "      <td>8.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1649</th>\n",
       "      <td>Out of the Park Baseball 13</td>\n",
       "      <td>PC</td>\n",
       "      <td>2012-04-09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.5</td>\n",
       "      <td>7.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2427</th>\n",
       "      <td>Guild Wars 2: Path of Fire</td>\n",
       "      <td>PC</td>\n",
       "      <td>2017-09-22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8.3</td>\n",
       "      <td>7.3</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17999</th>\n",
       "      <td>One Piece: Unlimited Cruise SP</td>\n",
       "      <td>PlayStation 4</td>\n",
       "      <td>2012-02-10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.6</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18134</th>\n",
       "      <td>AeternoBlade II</td>\n",
       "      <td>Wii U</td>\n",
       "      <td>2019-10-11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.4</td>\n",
       "      <td>4.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18253</th>\n",
       "      <td>Surgeon Simulator: Experience Reality</td>\n",
       "      <td>PlayStation 4</td>\n",
       "      <td>2016-12-03</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.3</td>\n",
       "      <td>4.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18532</th>\n",
       "      <td>The Ripping Friends</td>\n",
       "      <td>Game Boy Advance</td>\n",
       "      <td>2002-03-24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.8</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18717</th>\n",
       "      <td>Smash 'N' Survive</td>\n",
       "      <td>PlayStation 3</td>\n",
       "      <td>2012-02-22</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.1</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>114 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        name           platform release_date  \\\n",
       "833           Injustice 2: Legendary Edition      PlayStation 4   2018-03-27   \n",
       "1472                      Moto Racer Advance   Game Boy Advance   2002-12-05   \n",
       "1535                              Mini Metro             Switch   2018-08-30   \n",
       "1649             Out of the Park Baseball 13                 PC   2012-04-09   \n",
       "2427              Guild Wars 2: Path of Fire                 PC   2017-09-22   \n",
       "...                                      ...                ...          ...   \n",
       "17999         One Piece: Unlimited Cruise SP      PlayStation 4   2012-02-10   \n",
       "18134                        AeternoBlade II              Wii U   2019-10-11   \n",
       "18253  Surgeon Simulator: Experience Reality      PlayStation 4   2016-12-03   \n",
       "18532                    The Ripping Friends   Game Boy Advance   2002-03-24   \n",
       "18717                      Smash 'N' Survive      PlayStation 3   2012-02-22   \n",
       "\n",
       "      summary  meta_score  user_score  \n",
       "833       NaN         8.8         7.6  \n",
       "1472      NaN         8.6         0.0  \n",
       "1535      NaN         8.6         8.4  \n",
       "1649      NaN         8.5         7.8  \n",
       "2427      NaN         8.3         7.3  \n",
       "...       ...         ...         ...  \n",
       "17999     NaN         4.6         7.0  \n",
       "18134     NaN         4.4         4.4  \n",
       "18253     NaN         4.3         4.3  \n",
       "18532     NaN         3.8         0.0  \n",
       "18717     NaN         3.1         0.0  \n",
       "\n",
       "[114 rows x 6 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "games_reviews[games_reviews.isna().any(axis=1)]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### The only field that seems to have NaN's is the summary field"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Replace NaN summary with empty string"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "games_reviews[\"summary\"] = games_reviews[\"summary\"].fillna(\"\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Check for NaN again"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>platform</th>\n",
       "      <th>release_date</th>\n",
       "      <th>summary</th>\n",
       "      <th>meta_score</th>\n",
       "      <th>user_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [name, platform, release_date, summary, meta_score, user_score]\n",
       "Index: []"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "games_reviews[games_reviews.isna().any(axis=1)]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Add supporting fields to data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Add release year, month and day"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>platform</th>\n",
       "      <th>release_date</th>\n",
       "      <th>summary</th>\n",
       "      <th>meta_score</th>\n",
       "      <th>user_score</th>\n",
       "      <th>release_year</th>\n",
       "      <th>release_month</th>\n",
       "      <th>release_month_name</th>\n",
       "      <th>release_day</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Legend of Zelda: Ocarina of Time</td>\n",
       "      <td>Nintendo 64</td>\n",
       "      <td>1998-11-23</td>\n",
       "      <td>As a young boy, Link is tricked by Ganondorf, ...</td>\n",
       "      <td>9.9</td>\n",
       "      <td>9.1</td>\n",
       "      <td>1998</td>\n",
       "      <td>11</td>\n",
       "      <td>November</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Tony Hawk's Pro Skater 2</td>\n",
       "      <td>PlayStation</td>\n",
       "      <td>2000-09-20</td>\n",
       "      <td>As most major publishers' development efforts ...</td>\n",
       "      <td>9.8</td>\n",
       "      <td>7.4</td>\n",
       "      <td>2000</td>\n",
       "      <td>9</td>\n",
       "      <td>September</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Grand Theft Auto IV</td>\n",
       "      <td>PlayStation 3</td>\n",
       "      <td>2008-04-29</td>\n",
       "      <td>[Metacritic's 2008 PS3 Game of the Year; Also ...</td>\n",
       "      <td>9.8</td>\n",
       "      <td>7.7</td>\n",
       "      <td>2008</td>\n",
       "      <td>4</td>\n",
       "      <td>April</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SoulCalibur</td>\n",
       "      <td>Dreamcast</td>\n",
       "      <td>1999-09-08</td>\n",
       "      <td>This is a tale of souls and swords, transcendi...</td>\n",
       "      <td>9.8</td>\n",
       "      <td>8.4</td>\n",
       "      <td>1999</td>\n",
       "      <td>9</td>\n",
       "      <td>September</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Grand Theft Auto IV</td>\n",
       "      <td>Xbox 360</td>\n",
       "      <td>2008-04-29</td>\n",
       "      <td>[Metacritic's 2008 Xbox 360 Game of the Year; ...</td>\n",
       "      <td>9.8</td>\n",
       "      <td>7.9</td>\n",
       "      <td>2008</td>\n",
       "      <td>4</td>\n",
       "      <td>April</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   name        platform release_date  \\\n",
       "0  The Legend of Zelda: Ocarina of Time     Nintendo 64   1998-11-23   \n",
       "1              Tony Hawk's Pro Skater 2     PlayStation   2000-09-20   \n",
       "2                   Grand Theft Auto IV   PlayStation 3   2008-04-29   \n",
       "3                           SoulCalibur       Dreamcast   1999-09-08   \n",
       "4                   Grand Theft Auto IV        Xbox 360   2008-04-29   \n",
       "\n",
       "                                             summary  meta_score  user_score  \\\n",
       "0  As a young boy, Link is tricked by Ganondorf, ...         9.9         9.1   \n",
       "1  As most major publishers' development efforts ...         9.8         7.4   \n",
       "2  [Metacritic's 2008 PS3 Game of the Year; Also ...         9.8         7.7   \n",
       "3  This is a tale of souls and swords, transcendi...         9.8         8.4   \n",
       "4  [Metacritic's 2008 Xbox 360 Game of the Year; ...         9.8         7.9   \n",
       "\n",
       "   release_year  release_month release_month_name  release_day  \n",
       "0          1998             11           November           23  \n",
       "1          2000              9          September           20  \n",
       "2          2008              4              April           29  \n",
       "3          1999              9          September            8  \n",
       "4          2008              4              April           29  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "games_reviews[\"release_year\"] = games_reviews[\"release_date\"].dt.year\n",
    "games_reviews[\"release_month\"] =  games_reviews[\"release_date\"].dt.month\n",
    "games_reviews[\"release_month_name\"] =  games_reviews[\"release_date\"].dt.month_name()\n",
    "games_reviews[\"release_day\"] = games_reviews[\"release_date\"].dt.day\n",
    "games_reviews.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Add mean score (meta_score, user_review)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>release_date</th>\n",
       "      <th>summary</th>\n",
       "      <th>meta_score</th>\n",
       "      <th>user_score</th>\n",
       "      <th>release_year</th>\n",
       "      <th>release_month</th>\n",
       "      <th>release_month_name</th>\n",
       "      <th>release_day</th>\n",
       "      <th>mean_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>The Legend of Zelda: Ocarina of Time</td>\n",
       "      <td>Nintendo 64</td>\n",
       "      <td>1998-11-23</td>\n",
       "      <td>As a young boy, Link is tricked by Ganondorf, ...</td>\n",
       "      <td>9.9</td>\n",
       "      <td>9.1</td>\n",
       "      <td>1998</td>\n",
       "      <td>11</td>\n",
       "      <td>November</td>\n",
       "      <td>23</td>\n",
       "      <td>9.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Tony Hawk's Pro Skater 2</td>\n",
       "      <td>PlayStation</td>\n",
       "      <td>2000-09-20</td>\n",
       "      <td>As most major publishers' development efforts ...</td>\n",
       "      <td>9.8</td>\n",
       "      <td>7.4</td>\n",
       "      <td>2000</td>\n",
       "      <td>9</td>\n",
       "      <td>September</td>\n",
       "      <td>20</td>\n",
       "      <td>8.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Grand Theft Auto IV</td>\n",
       "      <td>PlayStation 3</td>\n",
       "      <td>2008-04-29</td>\n",
       "      <td>[Metacritic's 2008 PS3 Game of the Year; Also ...</td>\n",
       "      <td>9.8</td>\n",
       "      <td>7.7</td>\n",
       "      <td>2008</td>\n",
       "      <td>4</td>\n",
       "      <td>April</td>\n",
       "      <td>29</td>\n",
       "      <td>8.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SoulCalibur</td>\n",
       "      <td>Dreamcast</td>\n",
       "      <td>1999-09-08</td>\n",
       "      <td>This is a tale of souls and swords, transcendi...</td>\n",
       "      <td>9.8</td>\n",
       "      <td>8.4</td>\n",
       "      <td>1999</td>\n",
       "      <td>9</td>\n",
       "      <td>September</td>\n",
       "      <td>8</td>\n",
       "      <td>9.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Grand Theft Auto IV</td>\n",
       "      <td>Xbox 360</td>\n",
       "      <td>2008-04-29</td>\n",
       "      <td>[Metacritic's 2008 Xbox 360 Game of the Year; ...</td>\n",
       "      <td>9.8</td>\n",
       "      <td>7.9</td>\n",
       "      <td>2008</td>\n",
       "      <td>4</td>\n",
       "      <td>April</td>\n",
       "      <td>29</td>\n",
       "      <td>8.9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   name        platform release_date  \\\n",
       "0  The Legend of Zelda: Ocarina of Time     Nintendo 64   1998-11-23   \n",
       "1              Tony Hawk's Pro Skater 2     PlayStation   2000-09-20   \n",
       "2                   Grand Theft Auto IV   PlayStation 3   2008-04-29   \n",
       "3                           SoulCalibur       Dreamcast   1999-09-08   \n",
       "4                   Grand Theft Auto IV        Xbox 360   2008-04-29   \n",
       "\n",
       "                                             summary  meta_score  user_score  \\\n",
       "0  As a young boy, Link is tricked by Ganondorf, ...         9.9         9.1   \n",
       "1  As most major publishers' development efforts ...         9.8         7.4   \n",
       "2  [Metacritic's 2008 PS3 Game of the Year; Also ...         9.8         7.7   \n",
       "3  This is a tale of souls and swords, transcendi...         9.8         8.4   \n",
       "4  [Metacritic's 2008 Xbox 360 Game of the Year; ...         9.8         7.9   \n",
       "\n",
       "   release_year  release_month release_month_name  release_day  mean_score  \n",
       "0          1998             11           November           23         9.5  \n",
       "1          2000              9          September           20         8.6  \n",
       "2          2008              4              April           29         8.8  \n",
       "3          1999              9          September            8         9.1  \n",
       "4          2008              4              April           29         8.9  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def mean_score(meta_score: float, user_score: float) -> float:\n",
    "    if user_score == 0:\n",
    "        result = meta_score\n",
    "\n",
    "    else:\n",
    "        result = (meta_score + user_score) / 2\n",
    "\n",
    "    return round(result, 1)\n",
    "\n",
    "\n",
    "games_reviews[\"mean_score\"] = games_reviews.apply(\n",
    "    lambda x: mean_score(x[\"meta_score\"], x[\"user_score\"]), axis=1\n",
    ")\n",
    "games_reviews.head()\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Top 10 rated games by meta score, user score and mean score\n",
    "### *The tiebreaker for games with the same score will be the release date*"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Helper functions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "def view_group_n(\n",
    "    df: pd.DataFrame,\n",
    "    groupby_fields: List[str],\n",
    "    value_fields: List[str],\n",
    "    agg_funcs: List[str],\n",
    "    sort_by: List[str],\n",
    "    asc: List[bool],\n",
    "    n: int = 10,\n",
    "):\n",
    "    view = (\n",
    "        df.groupby(groupby_fields)[value_fields]\n",
    "        .agg(dict(zip(value_fields, agg_funcs)))\n",
    "        .sort_values(ascending=asc, by=sort_by)[:n]\n",
    "        .reset_index()\n",
    "    )\n",
    "    view.index += 1\n",
    "    return view\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## By meta score (released first)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "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>meta_score</th>\n",
       "      <th>release_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Legend of Zelda: Ocarina of Time</td>\n",
       "      <td>9.9</td>\n",
       "      <td>1998-11-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Tony Hawk's Pro Skater 2</td>\n",
       "      <td>9.8</td>\n",
       "      <td>2001-08-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SoulCalibur</td>\n",
       "      <td>9.8</td>\n",
       "      <td>2008-07-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Grand Theft Auto IV</td>\n",
       "      <td>9.8</td>\n",
       "      <td>2008-12-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NFL 2K1</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2000-09-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Tony Hawk's Pro Skater 3</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2002-03-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Grand Theft Auto III</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2002-05-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Metroid Prime</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2002-11-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Halo: Combat Evolved</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2003-09-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Super Mario Galaxy</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2007-11-12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    name  meta_score release_date\n",
       "1   The Legend of Zelda: Ocarina of Time         9.9   1998-11-23\n",
       "2               Tony Hawk's Pro Skater 2         9.8   2001-08-21\n",
       "3                            SoulCalibur         9.8   2008-07-02\n",
       "4                    Grand Theft Auto IV         9.8   2008-12-02\n",
       "5                                NFL 2K1         9.7   2000-09-07\n",
       "6               Tony Hawk's Pro Skater 3         9.7   2002-03-28\n",
       "7                   Grand Theft Auto III         9.7   2002-05-20\n",
       "8                          Metroid Prime         9.7   2002-11-17\n",
       "9                   Halo: Combat Evolved         9.7   2003-09-30\n",
       "10                    Super Mario Galaxy         9.7   2007-11-12"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "view_group_n(\n",
    "    games_reviews,\n",
    "    groupby_fields=[\"name\"],\n",
    "    value_fields=[\"meta_score\", \"release_date\"],\n",
    "    agg_funcs=[\"max\", \"max\"],\n",
    "    sort_by=[\"meta_score\", \"release_date\"],\n",
    "    asc=[False, True],\n",
    ")\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## By meta score (released last)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>meta_score</th>\n",
       "      <th>release_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Legend of Zelda: Ocarina of Time</td>\n",
       "      <td>9.9</td>\n",
       "      <td>1998-11-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Grand Theft Auto IV</td>\n",
       "      <td>9.8</td>\n",
       "      <td>2008-12-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SoulCalibur</td>\n",
       "      <td>9.8</td>\n",
       "      <td>2008-07-02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Tony Hawk's Pro Skater 2</td>\n",
       "      <td>9.8</td>\n",
       "      <td>2001-08-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Disco Elysium: The Final Cut</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2021-10-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>The House in Fata Morgana - Dreams of the Reve...</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2021-04-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Red Dead Redemption 2</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2019-11-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Super Mario Odyssey</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2017-10-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>The Legend of Zelda: Breath of the Wild</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2017-03-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Grand Theft Auto V</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2015-04-13</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 name  meta_score release_date\n",
       "1                The Legend of Zelda: Ocarina of Time         9.9   1998-11-23\n",
       "2                                 Grand Theft Auto IV         9.8   2008-12-02\n",
       "3                                         SoulCalibur         9.8   2008-07-02\n",
       "4                            Tony Hawk's Pro Skater 2         9.8   2001-08-21\n",
       "5                        Disco Elysium: The Final Cut         9.7   2021-10-12\n",
       "6   The House in Fata Morgana - Dreams of the Reve...         9.7   2021-04-09\n",
       "7                               Red Dead Redemption 2         9.7   2019-11-05\n",
       "8                                 Super Mario Odyssey         9.7   2017-10-27\n",
       "9             The Legend of Zelda: Breath of the Wild         9.7   2017-03-03\n",
       "10                                 Grand Theft Auto V         9.7   2015-04-13"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "view_group_n(\n",
    "    games_reviews,\n",
    "    groupby_fields=[\"name\"],\n",
    "    value_fields=[\"meta_score\", \"release_date\"],\n",
    "    agg_funcs=[\"max\", \"max\"],\n",
    "    sort_by=[\"meta_score\", \"release_date\"],\n",
    "    asc=[False, False],\n",
    ")\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## By user score (released first)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>user_score</th>\n",
       "      <th>release_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>GrimGrimoire</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2007-06-26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>After Burner Climax</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2010-04-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Metal Torrent</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2010-05-24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Z.H.P. Unlosing Ranger vs Darkdeath Evilman</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2010-10-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Ghost Trick: Phantom Detective</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2011-01-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Rochard</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2011-11-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Tengami</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2014-11-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Diaries of a Spaceport Janitor</td>\n",
       "      <td>9.6</td>\n",
       "      <td>2016-09-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Crystar</td>\n",
       "      <td>9.6</td>\n",
       "      <td>2019-08-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Superliminal</td>\n",
       "      <td>9.6</td>\n",
       "      <td>2020-07-07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           name  user_score release_date\n",
       "1                                  GrimGrimoire         9.7   2007-06-26\n",
       "2                           After Burner Climax         9.7   2010-04-22\n",
       "3                                 Metal Torrent         9.7   2010-05-24\n",
       "4   Z.H.P. Unlosing Ranger vs Darkdeath Evilman         9.7   2010-10-25\n",
       "5                Ghost Trick: Phantom Detective         9.7   2011-01-11\n",
       "6                                       Rochard         9.7   2011-11-15\n",
       "7                                       Tengami         9.7   2014-11-13\n",
       "8                Diaries of a Spaceport Janitor         9.6   2016-09-16\n",
       "9                                       Crystar         9.6   2019-08-27\n",
       "10                                 Superliminal         9.6   2020-07-07"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "view_group_n(\n",
    "    games_reviews,\n",
    "    groupby_fields=[\"name\"],\n",
    "    value_fields=[\"user_score\", \"release_date\"],\n",
    "    agg_funcs=[\"max\", \"max\"],\n",
    "    sort_by=[\"user_score\", \"release_date\"],\n",
    "    asc=[False, True],\n",
    ")\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## By user score (released last)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>user_score</th>\n",
       "      <th>release_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Tengami</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2014-11-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Rochard</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2011-11-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ghost Trick: Phantom Detective</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2011-01-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Z.H.P. Unlosing Ranger vs Darkdeath Evilman</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2010-10-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Metal Torrent</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2010-05-24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>After Burner Climax</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2010-04-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>GrimGrimoire</td>\n",
       "      <td>9.7</td>\n",
       "      <td>2007-06-26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Superliminal</td>\n",
       "      <td>9.6</td>\n",
       "      <td>2020-07-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Crystar</td>\n",
       "      <td>9.6</td>\n",
       "      <td>2019-08-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Diaries of a Spaceport Janitor</td>\n",
       "      <td>9.6</td>\n",
       "      <td>2016-09-16</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           name  user_score release_date\n",
       "1                                       Tengami         9.7   2014-11-13\n",
       "2                                       Rochard         9.7   2011-11-15\n",
       "3                Ghost Trick: Phantom Detective         9.7   2011-01-11\n",
       "4   Z.H.P. Unlosing Ranger vs Darkdeath Evilman         9.7   2010-10-25\n",
       "5                                 Metal Torrent         9.7   2010-05-24\n",
       "6                           After Burner Climax         9.7   2010-04-22\n",
       "7                                  GrimGrimoire         9.7   2007-06-26\n",
       "8                                  Superliminal         9.6   2020-07-07\n",
       "9                                       Crystar         9.6   2019-08-27\n",
       "10               Diaries of a Spaceport Janitor         9.6   2016-09-16"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "view_group_n(\n",
    "    games_reviews,\n",
    "    groupby_fields=[\"name\"],\n",
    "    value_fields=[\"user_score\", \"release_date\"],\n",
    "    agg_funcs=[\"max\", \"max\"],\n",
    "    sort_by=[\"user_score\", \"release_date\"],\n",
    "    asc=[False, False],\n",
    ")\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## By mean score (released first)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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>mean_score</th>\n",
       "      <th>release_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Legend of Zelda: Ocarina of Time</td>\n",
       "      <td>9.5</td>\n",
       "      <td>1998-11-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Half-Life 2</td>\n",
       "      <td>9.4</td>\n",
       "      <td>2005-11-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Super Mario Galaxy</td>\n",
       "      <td>9.4</td>\n",
       "      <td>2007-11-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>The Orange Box</td>\n",
       "      <td>9.4</td>\n",
       "      <td>2007-12-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Super Mario Galaxy 2</td>\n",
       "      <td>9.4</td>\n",
       "      <td>2010-05-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>The Witcher 3: Wild Hunt</td>\n",
       "      <td>9.4</td>\n",
       "      <td>2015-05-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Resident Evil 4</td>\n",
       "      <td>9.4</td>\n",
       "      <td>2019-05-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Tekken 3</td>\n",
       "      <td>9.3</td>\n",
       "      <td>1998-04-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Baldur's Gate II: Shadows of Amn</td>\n",
       "      <td>9.3</td>\n",
       "      <td>2000-09-24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Metal Gear Solid</td>\n",
       "      <td>9.3</td>\n",
       "      <td>2000-09-24</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    name  mean_score release_date\n",
       "1   The Legend of Zelda: Ocarina of Time         9.5   1998-11-23\n",
       "2                            Half-Life 2         9.4   2005-11-15\n",
       "3                     Super Mario Galaxy         9.4   2007-11-12\n",
       "4                         The Orange Box         9.4   2007-12-11\n",
       "5                   Super Mario Galaxy 2         9.4   2010-05-23\n",
       "6               The Witcher 3: Wild Hunt         9.4   2015-05-19\n",
       "7                        Resident Evil 4         9.4   2019-05-21\n",
       "8                               Tekken 3         9.3   1998-04-29\n",
       "9       Baldur's Gate II: Shadows of Amn         9.3   2000-09-24\n",
       "10                      Metal Gear Solid         9.3   2000-09-24"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "view_group_n(\n",
    "    games_reviews,\n",
    "    groupby_fields=[\"name\"],\n",
    "    value_fields=[\"mean_score\", \"release_date\"],\n",
    "    agg_funcs=[\"max\", \"max\"],\n",
    "    sort_by=[\"mean_score\", \"release_date\"],\n",
    "    asc=[False, True],\n",
    ")\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## By mean score (release last)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>mean_score</th>\n",
       "      <th>release_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>The Legend of Zelda: Ocarina of Time</td>\n",
       "      <td>9.5</td>\n",
       "      <td>1998-11-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Resident Evil 4</td>\n",
       "      <td>9.4</td>\n",
       "      <td>2019-05-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>The Witcher 3: Wild Hunt</td>\n",
       "      <td>9.4</td>\n",
       "      <td>2015-05-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Super Mario Galaxy 2</td>\n",
       "      <td>9.4</td>\n",
       "      <td>2010-05-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>The Orange Box</td>\n",
       "      <td>9.4</td>\n",
       "      <td>2007-12-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Super Mario Galaxy</td>\n",
       "      <td>9.4</td>\n",
       "      <td>2007-11-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Half-Life 2</td>\n",
       "      <td>9.4</td>\n",
       "      <td>2005-11-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>God of War</td>\n",
       "      <td>9.3</td>\n",
       "      <td>2018-04-20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Super Mario Odyssey</td>\n",
       "      <td>9.3</td>\n",
       "      <td>2017-10-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>The Last of Us Remastered</td>\n",
       "      <td>9.3</td>\n",
       "      <td>2014-07-29</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    name  mean_score release_date\n",
       "1   The Legend of Zelda: Ocarina of Time         9.5   1998-11-23\n",
       "2                        Resident Evil 4         9.4   2019-05-21\n",
       "3               The Witcher 3: Wild Hunt         9.4   2015-05-19\n",
       "4                   Super Mario Galaxy 2         9.4   2010-05-23\n",
       "5                         The Orange Box         9.4   2007-12-11\n",
       "6                     Super Mario Galaxy         9.4   2007-11-12\n",
       "7                            Half-Life 2         9.4   2005-11-15\n",
       "8                             God of War         9.3   2018-04-20\n",
       "9                    Super Mario Odyssey         9.3   2017-10-27\n",
       "10             The Last of Us Remastered         9.3   2014-07-29"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "view_group_n(\n",
    "    games_reviews,\n",
    "    groupby_fields=[\"name\"],\n",
    "    value_fields=[\"mean_score\", \"release_date\"],\n",
    "    agg_funcs=[\"max\", \"max\"],\n",
    "    sort_by=[\"mean_score\", \"release_date\"],\n",
    "    asc=[False, False],\n",
    ")\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Bottom 10 rated games by meta score, user score and mean score\n",
    "### *The tiebreaker for games with the same score will be the release date*"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## By meta score (released first)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>meta_score</th>\n",
       "      <th>release_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Leisure Suit Larry: Box Office Bust</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2009-03-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Infestation: Survivor Stories (The War Z)</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2012-10-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Afro Samurai 2: Revenge of Kuma Volume One</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2015-09-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Drake of the 99 Dragons</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2003-11-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Fast &amp; Furious: Showdown</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2013-05-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Charlie's Angels</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2003-07-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Homie Rollerz</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2008-03-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>FlatOut 3: Chaos &amp; Destruction</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2011-12-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Fighter Within</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2013-11-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Rambo: The Video Game</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2014-02-21</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          name  meta_score release_date\n",
       "1          Leisure Suit Larry: Box Office Bust         2.0   2009-03-31\n",
       "2    Infestation: Survivor Stories (The War Z)         2.0   2012-10-15\n",
       "3   Afro Samurai 2: Revenge of Kuma Volume One         2.1   2015-09-22\n",
       "4                      Drake of the 99 Dragons         2.2   2003-11-03\n",
       "5                     Fast & Furious: Showdown         2.2   2013-05-21\n",
       "6                             Charlie's Angels         2.3   2003-07-09\n",
       "7                                Homie Rollerz         2.3   2008-03-05\n",
       "8               FlatOut 3: Chaos & Destruction         2.3   2011-12-13\n",
       "9                               Fighter Within         2.3   2013-11-19\n",
       "10                       Rambo: The Video Game         2.3   2014-02-21"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "view_group_n(\n",
    "    games_reviews,\n",
    "    groupby_fields=[\"name\"],\n",
    "    value_fields=[\"meta_score\", \"release_date\"],\n",
    "    agg_funcs=[\"min\", \"min\"],\n",
    "    sort_by=[\"meta_score\", \"release_date\"],\n",
    "    asc=[True, True],\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## By meta score (released last)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>meta_score</th>\n",
       "      <th>release_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Infestation: Survivor Stories (The War Z)</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2012-10-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Leisure Suit Larry: Box Office Bust</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2009-03-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Afro Samurai 2: Revenge of Kuma Volume One</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2015-09-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Fast &amp; Furious: Showdown</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2013-05-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Drake of the 99 Dragons</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2003-11-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Rambo: The Video Game</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2014-02-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Fighter Within</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2013-11-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>FlatOut 3: Chaos &amp; Destruction</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2011-12-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Homie Rollerz</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2008-03-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Charlie's Angels</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2003-07-09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          name  meta_score release_date\n",
       "1    Infestation: Survivor Stories (The War Z)         2.0   2012-10-15\n",
       "2          Leisure Suit Larry: Box Office Bust         2.0   2009-03-31\n",
       "3   Afro Samurai 2: Revenge of Kuma Volume One         2.1   2015-09-22\n",
       "4                     Fast & Furious: Showdown         2.2   2013-05-21\n",
       "5                      Drake of the 99 Dragons         2.2   2003-11-03\n",
       "6                        Rambo: The Video Game         2.3   2014-02-21\n",
       "7                               Fighter Within         2.3   2013-11-19\n",
       "8               FlatOut 3: Chaos & Destruction         2.3   2011-12-13\n",
       "9                                Homie Rollerz         2.3   2008-03-05\n",
       "10                            Charlie's Angels         2.3   2003-07-09"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "view_group_n(\n",
    "    games_reviews,\n",
    "    groupby_fields=[\"name\"],\n",
    "    value_fields=[\"meta_score\", \"release_date\"],\n",
    "    agg_funcs=[\"min\", \"min\"],\n",
    "    sort_by=[\"meta_score\", \"release_date\"],\n",
    "    asc=[True, False],\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## By user score (released first)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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>user_score</th>\n",
       "      <th>release_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Madden NFL 21</td>\n",
       "      <td>0.2</td>\n",
       "      <td>2020-08-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Madden NFL 22</td>\n",
       "      <td>0.5</td>\n",
       "      <td>2021-08-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Warcraft III: Reforged</td>\n",
       "      <td>0.6</td>\n",
       "      <td>2020-01-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FIFA 20: Legacy Edition</td>\n",
       "      <td>0.7</td>\n",
       "      <td>2019-09-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NBA 2K21</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2020-09-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>FIFA 21</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2020-10-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Tom Clancy's The Division 2: Warlords of New York</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2020-03-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>When Ski Lifts Go Wrong</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2019-01-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>The Sims 4: Star Wars - Journey to Batuu</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2020-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>WWE 2K20</td>\n",
       "      <td>1.1</td>\n",
       "      <td>2019-10-22</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 name  user_score release_date\n",
       "1                                       Madden NFL 21         0.2   2020-08-25\n",
       "2                                       Madden NFL 22         0.5   2021-08-17\n",
       "3                              Warcraft III: Reforged         0.6   2020-01-28\n",
       "4                             FIFA 20: Legacy Edition         0.7   2019-09-27\n",
       "5                                            NBA 2K21         0.8   2020-09-04\n",
       "6                                             FIFA 21         0.8   2020-10-06\n",
       "7   Tom Clancy's The Division 2: Warlords of New York         0.9   2020-03-03\n",
       "8                             When Ski Lifts Go Wrong         1.0   2019-01-23\n",
       "9            The Sims 4: Star Wars - Journey to Batuu         1.0   2020-09-08\n",
       "10                                           WWE 2K20         1.1   2019-10-22"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "view_group_n(\n",
    "    games_reviews[games_reviews.user_score != 0],\n",
    "    groupby_fields=[\"name\"],\n",
    "    value_fields=[\"user_score\", \"release_date\"],\n",
    "    agg_funcs=[\"min\", \"min\"],\n",
    "    sort_by=[\"user_score\", \"release_date\"],\n",
    "    asc=[True, True],\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## By user score (released last)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "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>user_score</th>\n",
       "      <th>release_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Madden NFL 21</td>\n",
       "      <td>0.2</td>\n",
       "      <td>2020-08-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Madden NFL 22</td>\n",
       "      <td>0.5</td>\n",
       "      <td>2021-08-17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Warcraft III: Reforged</td>\n",
       "      <td>0.6</td>\n",
       "      <td>2020-01-28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>FIFA 20: Legacy Edition</td>\n",
       "      <td>0.7</td>\n",
       "      <td>2019-09-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>FIFA 21</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2020-10-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>NBA 2K21</td>\n",
       "      <td>0.8</td>\n",
       "      <td>2020-09-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Tom Clancy's The Division 2: Warlords of New York</td>\n",
       "      <td>0.9</td>\n",
       "      <td>2020-03-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>The Sims 4: Star Wars - Journey to Batuu</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2020-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>When Ski Lifts Go Wrong</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2019-01-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>WWE 2K20</td>\n",
       "      <td>1.1</td>\n",
       "      <td>2019-10-22</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                 name  user_score release_date\n",
       "1                                       Madden NFL 21         0.2   2020-08-25\n",
       "2                                       Madden NFL 22         0.5   2021-08-17\n",
       "3                              Warcraft III: Reforged         0.6   2020-01-28\n",
       "4                             FIFA 20: Legacy Edition         0.7   2019-09-27\n",
       "5                                             FIFA 21         0.8   2020-10-06\n",
       "6                                            NBA 2K21         0.8   2020-09-04\n",
       "7   Tom Clancy's The Division 2: Warlords of New York         0.9   2020-03-03\n",
       "8            The Sims 4: Star Wars - Journey to Batuu         1.0   2020-09-08\n",
       "9                             When Ski Lifts Go Wrong         1.0   2019-01-23\n",
       "10                                           WWE 2K20         1.1   2019-10-22"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "view_group_n(\n",
    "    games_reviews[games_reviews.user_score != 0],\n",
    "    groupby_fields=[\"name\"],\n",
    "    value_fields=[\"user_score\", \"release_date\"],\n",
    "    agg_funcs=[\"min\", \"min\"],\n",
    "    sort_by=[\"user_score\", \"release_date\"],\n",
    "    asc=[True, False],\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## By mean score (released first)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>mean_score</th>\n",
       "      <th>release_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Fast &amp; Furious: Showdown</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2013-05-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Infestation: Survivor Stories (The War Z)</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2012-10-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Drake of the 99 Dragons</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2003-11-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Leisure Suit Larry: Box Office Bust</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2009-03-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>R.I.P.D. The Game</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2013-07-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Rambo: The Video Game</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2014-02-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Dragon Ball: Evolution</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2009-04-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>NBA Unrivaled</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2009-11-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Thundercats</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2012-10-30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Ghostbusters</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2016-07-12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         name  mean_score release_date\n",
       "1                    Fast & Furious: Showdown         1.8   2013-05-21\n",
       "2   Infestation: Survivor Stories (The War Z)         1.9   2012-10-15\n",
       "3                     Drake of the 99 Dragons         2.0   2003-11-03\n",
       "4         Leisure Suit Larry: Box Office Bust         2.0   2009-03-31\n",
       "5                           R.I.P.D. The Game         2.0   2013-07-16\n",
       "6                       Rambo: The Video Game         2.0   2014-02-21\n",
       "7                      Dragon Ball: Evolution         2.1   2009-04-08\n",
       "8                               NBA Unrivaled         2.1   2009-11-11\n",
       "9                                 Thundercats         2.2   2012-10-30\n",
       "10                               Ghostbusters         2.2   2016-07-12"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "view_group_n(\n",
    "    games_reviews,\n",
    "    groupby_fields=[\"name\"],\n",
    "    value_fields=[\"mean_score\", \"release_date\"],\n",
    "    agg_funcs=[\"min\", \"min\"],\n",
    "    sort_by=[\"mean_score\", \"release_date\"],\n",
    "    asc=[True, True],\n",
    ")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## By mean score (released last)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>mean_score</th>\n",
       "      <th>release_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Fast &amp; Furious: Showdown</td>\n",
       "      <td>1.8</td>\n",
       "      <td>2013-05-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Infestation: Survivor Stories (The War Z)</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2012-10-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Rambo: The Video Game</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2014-02-21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>R.I.P.D. The Game</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2013-07-16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Leisure Suit Larry: Box Office Bust</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2009-03-31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Drake of the 99 Dragons</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2003-11-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>NBA Unrivaled</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2009-11-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Dragon Ball: Evolution</td>\n",
       "      <td>2.1</td>\n",
       "      <td>2009-04-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Wild West Online</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2018-05-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Ghostbusters</td>\n",
       "      <td>2.2</td>\n",
       "      <td>2016-07-12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         name  mean_score release_date\n",
       "1                    Fast & Furious: Showdown         1.8   2013-05-21\n",
       "2   Infestation: Survivor Stories (The War Z)         1.9   2012-10-15\n",
       "3                       Rambo: The Video Game         2.0   2014-02-21\n",
       "4                           R.I.P.D. The Game         2.0   2013-07-16\n",
       "5         Leisure Suit Larry: Box Office Bust         2.0   2009-03-31\n",
       "6                     Drake of the 99 Dragons         2.0   2003-11-03\n",
       "7                               NBA Unrivaled         2.1   2009-11-11\n",
       "8                      Dragon Ball: Evolution         2.1   2009-04-08\n",
       "9                            Wild West Online         2.2   2018-05-10\n",
       "10                               Ghostbusters         2.2   2016-07-12"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "view_group_n(\n",
    "    games_reviews,\n",
    "    groupby_fields=[\"name\"],\n",
    "    value_fields=[\"mean_score\", \"release_date\"],\n",
    "    agg_funcs=[\"min\", \"min\"],\n",
    "    sort_by=[\"mean_score\", \"release_date\"],\n",
    "    asc=[True, False],\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "6968c2bf9e8b433e7e06181df53468a77e47930d8750800a0f7c84d93e6d5ad4"
  },
  "kernelspec": {
   "display_name": "Python 3.10.0 64-bit ('.venv': poetry)",
   "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.0"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}