case study MVP1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 628,
   "id": "09f07b38",
   "metadata": {},
   "outputs": [],
   "source": [
    "import matplotlib.pyplot as plt\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "pd.set_option('display.float_format', lambda x: '%.4f' % x) # it helpe to reduce the number and delete 'e' in numbers"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 629,
   "id": "c488df16",
   "metadata": {},
   "outputs": [],
   "source": [
    "project =pd.read_csv('case study dataset.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 630,
   "id": "7a6ec954",
   "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_of_Release</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>Developer</th>\n",
       "      <th>Rating</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.0000</td>\n",
       "      <td>Sports</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>41.3600</td>\n",
       "      <td>28.9600</td>\n",
       "      <td>3.7700</td>\n",
       "      <td>8.4500</td>\n",
       "      <td>82.5300</td>\n",
       "      <td>76.0000</td>\n",
       "      <td>51.0000</td>\n",
       "      <td>8</td>\n",
       "      <td>322.0000</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Super Mario Bros.</td>\n",
       "      <td>NES</td>\n",
       "      <td>1985.0000</td>\n",
       "      <td>Platform</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>29.0800</td>\n",
       "      <td>3.5800</td>\n",
       "      <td>6.8100</td>\n",
       "      <td>0.7700</td>\n",
       "      <td>40.2400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Mario Kart Wii</td>\n",
       "      <td>Wii</td>\n",
       "      <td>2008.0000</td>\n",
       "      <td>Racing</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>15.6800</td>\n",
       "      <td>12.7600</td>\n",
       "      <td>3.7900</td>\n",
       "      <td>3.2900</td>\n",
       "      <td>35.5200</td>\n",
       "      <td>82.0000</td>\n",
       "      <td>73.0000</td>\n",
       "      <td>8.3</td>\n",
       "      <td>709.0000</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Wii Sports Resort</td>\n",
       "      <td>Wii</td>\n",
       "      <td>2009.0000</td>\n",
       "      <td>Sports</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>15.6100</td>\n",
       "      <td>10.9300</td>\n",
       "      <td>3.2800</td>\n",
       "      <td>2.9500</td>\n",
       "      <td>32.7700</td>\n",
       "      <td>80.0000</td>\n",
       "      <td>73.0000</td>\n",
       "      <td>8</td>\n",
       "      <td>192.0000</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Pokemon Red/Pokemon Blue</td>\n",
       "      <td>GB</td>\n",
       "      <td>1996.0000</td>\n",
       "      <td>Role-Playing</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>11.2700</td>\n",
       "      <td>8.8900</td>\n",
       "      <td>10.2200</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>31.3700</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Tetris</td>\n",
       "      <td>GB</td>\n",
       "      <td>1989.0000</td>\n",
       "      <td>Puzzle</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>23.2000</td>\n",
       "      <td>2.2600</td>\n",
       "      <td>4.2200</td>\n",
       "      <td>0.5800</td>\n",
       "      <td>30.2600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>New Super Mario Bros.</td>\n",
       "      <td>DS</td>\n",
       "      <td>2006.0000</td>\n",
       "      <td>Platform</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>11.2800</td>\n",
       "      <td>9.1400</td>\n",
       "      <td>6.5000</td>\n",
       "      <td>2.8800</td>\n",
       "      <td>29.8000</td>\n",
       "      <td>89.0000</td>\n",
       "      <td>65.0000</td>\n",
       "      <td>8.5</td>\n",
       "      <td>431.0000</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Wii Play</td>\n",
       "      <td>Wii</td>\n",
       "      <td>2006.0000</td>\n",
       "      <td>Misc</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>13.9600</td>\n",
       "      <td>9.1800</td>\n",
       "      <td>2.9300</td>\n",
       "      <td>2.8400</td>\n",
       "      <td>28.9200</td>\n",
       "      <td>58.0000</td>\n",
       "      <td>41.0000</td>\n",
       "      <td>6.6</td>\n",
       "      <td>129.0000</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>New Super Mario Bros. Wii</td>\n",
       "      <td>Wii</td>\n",
       "      <td>2009.0000</td>\n",
       "      <td>Platform</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>14.4400</td>\n",
       "      <td>6.9400</td>\n",
       "      <td>4.7000</td>\n",
       "      <td>2.2400</td>\n",
       "      <td>28.3200</td>\n",
       "      <td>87.0000</td>\n",
       "      <td>80.0000</td>\n",
       "      <td>8.4</td>\n",
       "      <td>594.0000</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>E</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Name Platform  Year_of_Release         Genre  \\\n",
       "0                 Wii Sports      Wii        2006.0000        Sports   \n",
       "1          Super Mario Bros.      NES        1985.0000      Platform   \n",
       "2             Mario Kart Wii      Wii        2008.0000        Racing   \n",
       "3          Wii Sports Resort      Wii        2009.0000        Sports   \n",
       "4   Pokemon Red/Pokemon Blue       GB        1996.0000  Role-Playing   \n",
       "5                     Tetris       GB        1989.0000        Puzzle   \n",
       "6      New Super Mario Bros.       DS        2006.0000      Platform   \n",
       "7                   Wii Play      Wii        2006.0000          Misc   \n",
       "8  New Super Mario Bros. Wii      Wii        2009.0000      Platform   \n",
       "\n",
       "  Publisher  NA_Sales  EU_Sales  JP_Sales  Other_Sales  Global_Sales  \\\n",
       "0  Nintendo   41.3600   28.9600    3.7700       8.4500       82.5300   \n",
       "1  Nintendo   29.0800    3.5800    6.8100       0.7700       40.2400   \n",
       "2  Nintendo   15.6800   12.7600    3.7900       3.2900       35.5200   \n",
       "3  Nintendo   15.6100   10.9300    3.2800       2.9500       32.7700   \n",
       "4  Nintendo   11.2700    8.8900   10.2200       1.0000       31.3700   \n",
       "5  Nintendo   23.2000    2.2600    4.2200       0.5800       30.2600   \n",
       "6  Nintendo   11.2800    9.1400    6.5000       2.8800       29.8000   \n",
       "7  Nintendo   13.9600    9.1800    2.9300       2.8400       28.9200   \n",
       "8  Nintendo   14.4400    6.9400    4.7000       2.2400       28.3200   \n",
       "\n",
       "   Critic_Score  Critic_Count User_Score  User_Count Developer Rating  \n",
       "0       76.0000       51.0000          8    322.0000  Nintendo      E  \n",
       "1           NaN           NaN        NaN         NaN       NaN    NaN  \n",
       "2       82.0000       73.0000        8.3    709.0000  Nintendo      E  \n",
       "3       80.0000       73.0000          8    192.0000  Nintendo      E  \n",
       "4           NaN           NaN        NaN         NaN       NaN    NaN  \n",
       "5           NaN           NaN        NaN         NaN       NaN    NaN  \n",
       "6       89.0000       65.0000        8.5    431.0000  Nintendo      E  \n",
       "7       58.0000       41.0000        6.6    129.0000  Nintendo      E  \n",
       "8       87.0000       80.0000        8.4    594.0000  Nintendo      E  "
      ]
     },
     "execution_count": 630,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "project.head(9) #show the first 9 rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 631,
   "id": "1c5fbe47",
   "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_of_Release</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>Developer</th>\n",
       "      <th>Rating</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>16714</th>\n",
       "      <td>Samurai Warriors: Sanada Maru</td>\n",
       "      <td>PS3</td>\n",
       "      <td>2016.0000</td>\n",
       "      <td>Action</td>\n",
       "      <td>Tecmo Koei</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0100</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16715</th>\n",
       "      <td>LMA Manager 2007</td>\n",
       "      <td>X360</td>\n",
       "      <td>2006.0000</td>\n",
       "      <td>Sports</td>\n",
       "      <td>Codemasters</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0100</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16716</th>\n",
       "      <td>Haitaka no Psychedelica</td>\n",
       "      <td>PSV</td>\n",
       "      <td>2016.0000</td>\n",
       "      <td>Adventure</td>\n",
       "      <td>Idea Factory</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0100</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16717</th>\n",
       "      <td>Spirits &amp; Spells</td>\n",
       "      <td>GBA</td>\n",
       "      <td>2003.0000</td>\n",
       "      <td>Platform</td>\n",
       "      <td>Wanadoo</td>\n",
       "      <td>0.0100</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16718</th>\n",
       "      <td>Winning Post 8 2016</td>\n",
       "      <td>PSV</td>\n",
       "      <td>2016.0000</td>\n",
       "      <td>Simulation</td>\n",
       "      <td>Tecmo Koei</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0100</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                Name Platform  Year_of_Release       Genre  \\\n",
       "16714  Samurai Warriors: Sanada Maru      PS3        2016.0000      Action   \n",
       "16715               LMA Manager 2007     X360        2006.0000      Sports   \n",
       "16716        Haitaka no Psychedelica      PSV        2016.0000   Adventure   \n",
       "16717               Spirits & Spells      GBA        2003.0000    Platform   \n",
       "16718            Winning Post 8 2016      PSV        2016.0000  Simulation   \n",
       "\n",
       "          Publisher  NA_Sales  EU_Sales  JP_Sales  Other_Sales  Global_Sales  \\\n",
       "16714    Tecmo Koei    0.0000    0.0000    0.0100       0.0000        0.0100   \n",
       "16715   Codemasters    0.0000    0.0100    0.0000       0.0000        0.0100   \n",
       "16716  Idea Factory    0.0000    0.0000    0.0100       0.0000        0.0100   \n",
       "16717       Wanadoo    0.0100    0.0000    0.0000       0.0000        0.0100   \n",
       "16718    Tecmo Koei    0.0000    0.0000    0.0100       0.0000        0.0100   \n",
       "\n",
       "       Critic_Score  Critic_Count User_Score  User_Count Developer Rating  \n",
       "16714           NaN           NaN        NaN         NaN       NaN    NaN  \n",
       "16715           NaN           NaN        NaN         NaN       NaN    NaN  \n",
       "16716           NaN           NaN        NaN         NaN       NaN    NaN  \n",
       "16717           NaN           NaN        NaN         NaN       NaN    NaN  \n",
       "16718           NaN           NaN        NaN         NaN       NaN    NaN  "
      ]
     },
     "execution_count": 631,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "project.tail() #show the last 5 rows by default"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 632,
   "id": "6502aac4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(16719, 16)"
      ]
     },
     "execution_count": 632,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "project.shape # the numbers of rows & columns in the dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 633,
   "id": "5482373e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Name', 'Platform', 'Year_of_Release', 'Genre', 'Publisher', 'NA_Sales',\n",
       "       'EU_Sales', 'JP_Sales', 'Other_Sales', 'Global_Sales', 'Critic_Score',\n",
       "       'Critic_Count', 'User_Score', 'User_Count', 'Developer', 'Rating'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 633,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "project.columns #shows the name of columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 634,
   "id": "99f14b90",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 16719 entries, 0 to 16718\n",
      "Data columns (total 16 columns):\n",
      " #   Column           Non-Null Count  Dtype  \n",
      "---  ------           --------------  -----  \n",
      " 0   Name             16717 non-null  object \n",
      " 1   Platform         16719 non-null  object \n",
      " 2   Year_of_Release  16450 non-null  float64\n",
      " 3   Genre            16717 non-null  object \n",
      " 4   Publisher        16665 non-null  object \n",
      " 5   NA_Sales         16719 non-null  float64\n",
      " 6   EU_Sales         16719 non-null  float64\n",
      " 7   JP_Sales         16719 non-null  float64\n",
      " 8   Other_Sales      16719 non-null  float64\n",
      " 9   Global_Sales     16719 non-null  float64\n",
      " 10  Critic_Score     8137 non-null   float64\n",
      " 11  Critic_Count     8137 non-null   float64\n",
      " 12  User_Score       10015 non-null  object \n",
      " 13  User_Count       7590 non-null   float64\n",
      " 14  Developer        10096 non-null  object \n",
      " 15  Rating           9950 non-null   object \n",
      "dtypes: float64(9), object(7)\n",
      "memory usage: 2.0+ MB\n"
     ]
    }
   ],
   "source": [
    "project.info() #print a concise summary of a DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 635,
   "id": "b5bbf97b",
   "metadata": {
    "scrolled": false
   },
   "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_of_Release</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_Count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>16450.0000</td>\n",
       "      <td>16719.0000</td>\n",
       "      <td>16719.0000</td>\n",
       "      <td>16719.0000</td>\n",
       "      <td>16719.0000</td>\n",
       "      <td>16719.0000</td>\n",
       "      <td>8137.0000</td>\n",
       "      <td>8137.0000</td>\n",
       "      <td>7590.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2006.4874</td>\n",
       "      <td>0.2633</td>\n",
       "      <td>0.1450</td>\n",
       "      <td>0.0776</td>\n",
       "      <td>0.0473</td>\n",
       "      <td>0.5335</td>\n",
       "      <td>68.9677</td>\n",
       "      <td>26.3608</td>\n",
       "      <td>162.2299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>5.8790</td>\n",
       "      <td>0.8135</td>\n",
       "      <td>0.5033</td>\n",
       "      <td>0.3088</td>\n",
       "      <td>0.1867</td>\n",
       "      <td>1.5479</td>\n",
       "      <td>13.9382</td>\n",
       "      <td>18.9805</td>\n",
       "      <td>561.2823</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1980.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0100</td>\n",
       "      <td>13.0000</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>4.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2003.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0600</td>\n",
       "      <td>60.0000</td>\n",
       "      <td>12.0000</td>\n",
       "      <td>10.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2007.0000</td>\n",
       "      <td>0.0800</td>\n",
       "      <td>0.0200</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0100</td>\n",
       "      <td>0.1700</td>\n",
       "      <td>71.0000</td>\n",
       "      <td>21.0000</td>\n",
       "      <td>24.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>2010.0000</td>\n",
       "      <td>0.2400</td>\n",
       "      <td>0.1100</td>\n",
       "      <td>0.0400</td>\n",
       "      <td>0.0300</td>\n",
       "      <td>0.4700</td>\n",
       "      <td>79.0000</td>\n",
       "      <td>36.0000</td>\n",
       "      <td>81.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2020.0000</td>\n",
       "      <td>41.3600</td>\n",
       "      <td>28.9600</td>\n",
       "      <td>10.2200</td>\n",
       "      <td>10.5700</td>\n",
       "      <td>82.5300</td>\n",
       "      <td>98.0000</td>\n",
       "      <td>113.0000</td>\n",
       "      <td>10665.0000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Year_of_Release   NA_Sales   EU_Sales   JP_Sales  Other_Sales  \\\n",
       "count       16450.0000 16719.0000 16719.0000 16719.0000   16719.0000   \n",
       "mean         2006.4874     0.2633     0.1450     0.0776       0.0473   \n",
       "std             5.8790     0.8135     0.5033     0.3088       0.1867   \n",
       "min          1980.0000     0.0000     0.0000     0.0000       0.0000   \n",
       "25%          2003.0000     0.0000     0.0000     0.0000       0.0000   \n",
       "50%          2007.0000     0.0800     0.0200     0.0000       0.0100   \n",
       "75%          2010.0000     0.2400     0.1100     0.0400       0.0300   \n",
       "max          2020.0000    41.3600    28.9600    10.2200      10.5700   \n",
       "\n",
       "       Global_Sales  Critic_Score  Critic_Count  User_Count  \n",
       "count    16719.0000     8137.0000     8137.0000   7590.0000  \n",
       "mean         0.5335       68.9677       26.3608    162.2299  \n",
       "std          1.5479       13.9382       18.9805    561.2823  \n",
       "min          0.0100       13.0000        3.0000      4.0000  \n",
       "25%          0.0600       60.0000       12.0000     10.0000  \n",
       "50%          0.1700       71.0000       21.0000     24.0000  \n",
       "75%          0.4700       79.0000       36.0000     81.0000  \n",
       "max         82.5300       98.0000      113.0000  10665.0000  "
      ]
     },
     "execution_count": 635,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "project.describe() #used to view some basic statistical details like percentile, mean, std"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 636,
   "id": "0fb1e3ed",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([8.253e+01, 4.024e+01, 3.552e+01, 3.277e+01, 3.137e+01, 3.026e+01,\n",
       "       2.980e+01, 2.892e+01, 2.832e+01, 2.831e+01, 2.467e+01, 2.321e+01,\n",
       "       2.310e+01, 2.270e+01, 2.181e+01, 2.179e+01, 2.104e+01, 2.081e+01,\n",
       "       2.061e+01, 2.015e+01, 1.825e+01, 1.814e+01, 1.728e+01, 1.627e+01,\n",
       "       1.615e+01, 1.585e+01, 1.529e+01, 1.514e+01, 1.498e+01, 1.473e+01,\n",
       "       1.464e+01, 1.463e+01, 1.461e+01, 1.460e+01, 1.379e+01, 1.367e+01,\n",
       "       1.347e+01, 1.332e+01, 1.310e+01, 1.284e+01, 1.266e+01, 1.263e+01,\n",
       "       1.261e+01, 1.213e+01, 1.212e+01, 1.189e+01, 1.177e+01, 1.168e+01,\n",
       "       1.166e+01, 1.135e+01, 1.118e+01, 1.101e+01, 1.095e+01, 1.081e+01,\n",
       "       1.070e+01, 1.060e+01, 1.055e+01, 1.050e+01, 1.049e+01, 1.030e+01,\n",
       "       1.025e+01, 1.012e+01, 9.900e+00, 9.870e+00, 9.860e+00, 9.720e+00,\n",
       "       9.710e+00, 9.490e+00, 9.440e+00, 9.360e+00, 9.310e+00, 9.300e+00,\n",
       "       9.180e+00, 9.160e+00, 8.910e+00, 8.790e+00, 8.760e+00, 8.570e+00,\n",
       "       8.490e+00, 8.380e+00, 8.270e+00, 8.160e+00, 8.090e+00, 8.070e+00,\n",
       "       8.050e+00, 8.010e+00, 7.990e+00, 7.980e+00, 7.860e+00, 7.810e+00,\n",
       "       7.720e+00, 7.690e+00, 7.660e+00, 7.600e+00, 7.590e+00, 7.580e+00,\n",
       "       7.550e+00, 7.510e+00, 7.460e+00, 7.390e+00, 7.380e+00, 7.320e+00,\n",
       "       7.200e+00, 7.170e+00, 7.160e+00, 7.150e+00, 7.140e+00, 7.130e+00,\n",
       "       7.090e+00, 7.070e+00, 6.950e+00, 6.900e+00, 6.830e+00, 6.820e+00,\n",
       "       6.760e+00, 6.750e+00, 6.740e+00, 6.710e+00, 6.680e+00, 6.660e+00,\n",
       "       6.650e+00, 6.620e+00, 6.510e+00, 6.490e+00, 6.470e+00, 6.450e+00,\n",
       "       6.440e+00, 6.430e+00, 6.410e+00, 6.400e+00, 6.390e+00, 6.340e+00,\n",
       "       6.320e+00, 6.310e+00, 6.300e+00, 6.290e+00, 6.270e+00, 6.210e+00,\n",
       "       6.190e+00, 6.090e+00, 6.080e+00, 6.050e+00, 6.030e+00, 5.990e+00,\n",
       "       5.950e+00, 5.870e+00, 5.820e+00, 5.780e+00, 5.740e+00, 5.640e+00,\n",
       "       5.630e+00, 5.580e+00, 5.550e+00, 5.540e+00, 5.490e+00, 5.480e+00,\n",
       "       5.470e+00, 5.460e+00, 5.450e+00, 5.420e+00, 5.390e+00, 5.380e+00,\n",
       "       5.340e+00, 5.330e+00, 5.310e+00, 5.300e+00, 5.290e+00, 5.270e+00,\n",
       "       5.260e+00, 5.240e+00, 5.230e+00, 5.220e+00, 5.210e+00, 5.200e+00,\n",
       "       5.190e+00, 5.160e+00, 5.150e+00, 5.140e+00, 5.130e+00, 5.120e+00,\n",
       "       5.100e+00, 5.090e+00, 5.080e+00, 5.070e+00, 5.050e+00, 5.030e+00,\n",
       "       5.020e+00, 5.010e+00, 5.000e+00, 4.980e+00, 4.930e+00, 4.920e+00,\n",
       "       4.910e+00, 4.880e+00, 4.870e+00, 4.850e+00, 4.840e+00, 4.820e+00,\n",
       "       4.800e+00, 4.790e+00, 4.760e+00, 4.730e+00, 4.710e+00, 4.700e+00,\n",
       "       4.680e+00, 4.670e+00, 4.630e+00, 4.620e+00, 4.610e+00, 4.600e+00,\n",
       "       4.590e+00, 4.570e+00, 4.530e+00, 4.500e+00, 4.490e+00, 4.480e+00,\n",
       "       4.470e+00, 4.460e+00, 4.450e+00, 4.430e+00, 4.420e+00, 4.410e+00,\n",
       "       4.390e+00, 4.380e+00, 4.370e+00, 4.360e+00, 4.340e+00, 4.330e+00,\n",
       "       4.320e+00, 4.310e+00, 4.290e+00, 4.280e+00, 4.270e+00, 4.240e+00,\n",
       "       4.230e+00, 4.220e+00, 4.210e+00, 4.200e+00, 4.190e+00, 4.180e+00,\n",
       "       4.170e+00, 4.160e+00, 4.140e+00, 4.120e+00, 4.110e+00, 4.100e+00,\n",
       "       4.090e+00, 4.080e+00, 4.070e+00, 4.060e+00, 4.050e+00, 4.040e+00,\n",
       "       4.030e+00, 4.010e+00, 3.980e+00, 3.970e+00, 3.960e+00, 3.950e+00,\n",
       "       3.940e+00, 3.910e+00, 3.900e+00, 3.890e+00, 3.880e+00, 3.870e+00,\n",
       "       3.850e+00, 3.840e+00, 3.830e+00, 3.800e+00, 3.790e+00, 3.770e+00,\n",
       "       3.760e+00, 3.740e+00, 3.730e+00, 3.720e+00, 3.710e+00, 3.700e+00,\n",
       "       3.670e+00, 3.660e+00, 3.650e+00, 3.640e+00, 3.630e+00, 3.620e+00,\n",
       "       3.610e+00, 3.600e+00, 3.590e+00, 3.580e+00, 3.560e+00, 3.540e+00,\n",
       "       3.530e+00, 3.520e+00, 3.510e+00, 3.500e+00, 3.490e+00, 3.480e+00,\n",
       "       3.470e+00, 3.460e+00, 3.450e+00, 3.440e+00, 3.420e+00, 3.410e+00,\n",
       "       3.400e+00, 3.390e+00, 3.380e+00, 3.370e+00, 3.360e+00, 3.350e+00,\n",
       "       3.340e+00, 3.330e+00, 3.320e+00, 3.310e+00, 3.300e+00, 3.280e+00,\n",
       "       3.270e+00, 3.260e+00, 3.250e+00, 3.240e+00, 3.230e+00, 3.210e+00,\n",
       "       3.200e+00, 3.190e+00, 3.180e+00, 3.170e+00, 3.150e+00, 3.140e+00,\n",
       "       3.130e+00, 3.120e+00, 3.110e+00, 3.100e+00, 3.090e+00, 3.080e+00,\n",
       "       3.070e+00, 3.060e+00, 3.050e+00, 3.040e+00, 3.030e+00, 3.020e+00,\n",
       "       3.010e+00, 3.000e+00, 2.990e+00, 2.960e+00, 2.950e+00, 2.940e+00,\n",
       "       2.930e+00, 2.920e+00, 2.910e+00, 2.900e+00, 2.890e+00, 2.880e+00,\n",
       "       2.870e+00, 2.860e+00, 2.850e+00, 2.840e+00, 2.830e+00, 2.820e+00,\n",
       "       2.810e+00, 2.800e+00, 2.790e+00, 2.780e+00, 2.770e+00, 2.760e+00,\n",
       "       2.750e+00, 2.730e+00, 2.710e+00, 2.700e+00, 2.690e+00, 2.680e+00,\n",
       "       2.670e+00, 2.660e+00, 2.650e+00, 2.630e+00, 2.620e+00, 2.610e+00,\n",
       "       2.600e+00, 2.590e+00, 2.580e+00, 2.570e+00, 2.560e+00, 2.540e+00,\n",
       "       2.530e+00, 2.520e+00, 2.500e+00, 2.490e+00, 2.480e+00, 2.470e+00,\n",
       "       2.460e+00, 2.450e+00, 2.440e+00, 2.430e+00, 2.420e+00, 2.410e+00,\n",
       "       2.400e+00, 2.390e+00, 2.380e+00, 2.370e+00, 2.360e+00, 2.350e+00,\n",
       "       2.340e+00, 2.320e+00, 2.310e+00, 2.300e+00, 2.290e+00, 2.280e+00,\n",
       "       2.270e+00, 2.260e+00, 2.250e+00, 2.240e+00, 2.230e+00, 2.220e+00,\n",
       "       2.210e+00, 2.200e+00, 2.190e+00, 2.180e+00, 2.170e+00, 2.160e+00,\n",
       "       2.150e+00, 2.140e+00, 2.130e+00, 2.120e+00, 2.110e+00, 2.100e+00,\n",
       "       2.090e+00, 2.080e+00, 2.070e+00, 2.060e+00, 2.050e+00, 2.040e+00,\n",
       "       2.030e+00, 2.020e+00, 2.010e+00, 2.000e+00, 1.990e+00, 1.980e+00,\n",
       "       1.970e+00, 1.960e+00, 1.950e+00, 1.940e+00, 1.930e+00, 1.920e+00,\n",
       "       1.910e+00, 1.900e+00, 1.890e+00, 1.880e+00, 1.870e+00, 1.860e+00,\n",
       "       1.850e+00, 1.840e+00, 1.830e+00, 1.820e+00, 1.810e+00, 1.800e+00,\n",
       "       1.790e+00, 1.780e+00, 1.770e+00, 1.760e+00, 1.750e+00, 1.740e+00,\n",
       "       1.730e+00, 1.720e+00, 1.710e+00, 1.700e+00, 1.690e+00, 1.680e+00,\n",
       "       1.670e+00, 1.660e+00, 1.650e+00, 1.640e+00, 1.630e+00, 1.620e+00,\n",
       "       1.610e+00, 1.600e+00, 1.590e+00, 1.580e+00, 1.570e+00, 1.560e+00,\n",
       "       1.550e+00, 1.540e+00, 1.530e+00, 1.520e+00, 1.510e+00, 1.500e+00,\n",
       "       1.490e+00, 1.480e+00, 1.470e+00, 1.460e+00, 1.450e+00, 1.440e+00,\n",
       "       1.430e+00, 1.420e+00, 1.410e+00, 1.400e+00, 1.390e+00, 1.380e+00,\n",
       "       1.370e+00, 1.360e+00, 1.350e+00, 1.340e+00, 1.330e+00, 1.320e+00,\n",
       "       1.310e+00, 1.300e+00, 1.290e+00, 1.280e+00, 1.270e+00, 1.260e+00,\n",
       "       1.250e+00, 1.240e+00, 1.230e+00, 1.220e+00, 1.210e+00, 1.200e+00,\n",
       "       1.190e+00, 1.180e+00, 1.170e+00, 1.160e+00, 1.150e+00, 1.140e+00,\n",
       "       1.130e+00, 1.120e+00, 1.110e+00, 1.100e+00, 1.090e+00, 1.080e+00,\n",
       "       1.070e+00, 1.060e+00, 1.050e+00, 1.040e+00, 1.030e+00, 1.020e+00,\n",
       "       1.010e+00, 1.000e+00, 9.900e-01, 9.800e-01, 9.700e-01, 9.600e-01,\n",
       "       9.500e-01, 9.400e-01, 9.300e-01, 9.200e-01, 9.100e-01, 9.000e-01,\n",
       "       8.900e-01, 8.800e-01, 8.700e-01, 8.600e-01, 8.500e-01, 8.400e-01,\n",
       "       8.300e-01, 8.200e-01, 8.100e-01, 8.000e-01, 7.900e-01, 7.800e-01,\n",
       "       7.700e-01, 7.600e-01, 7.500e-01, 7.400e-01, 7.300e-01, 7.200e-01,\n",
       "       7.100e-01, 7.000e-01, 6.900e-01, 6.800e-01, 6.700e-01, 6.600e-01,\n",
       "       6.500e-01, 6.400e-01, 6.300e-01, 6.200e-01, 6.100e-01, 6.000e-01,\n",
       "       5.900e-01, 5.800e-01, 5.700e-01, 5.600e-01, 5.500e-01, 5.400e-01,\n",
       "       5.300e-01, 5.200e-01, 5.100e-01, 5.000e-01, 4.900e-01, 4.800e-01,\n",
       "       4.700e-01, 4.600e-01, 4.500e-01, 4.400e-01, 4.300e-01, 4.200e-01,\n",
       "       4.100e-01, 4.000e-01, 3.900e-01, 3.800e-01, 3.700e-01, 3.600e-01,\n",
       "       3.500e-01, 3.400e-01, 3.300e-01, 3.200e-01, 3.100e-01, 3.000e-01,\n",
       "       2.900e-01, 2.800e-01, 2.700e-01, 2.600e-01, 2.500e-01, 2.400e-01,\n",
       "       2.300e-01, 2.200e-01, 2.100e-01, 2.000e-01, 1.900e-01, 1.800e-01,\n",
       "       1.700e-01, 1.600e-01, 1.500e-01, 1.400e-01, 1.300e-01, 1.200e-01,\n",
       "       1.100e-01, 1.000e-01, 9.000e-02, 8.000e-02, 7.000e-02, 6.000e-02,\n",
       "       5.000e-02, 4.000e-02, 3.000e-02, 2.000e-02, 1.000e-02])"
      ]
     },
     "execution_count": 636,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "project.Global_Sales.unique() #are returned in order of appearance"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 637,
   "id": "3d1ff3e2",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count   16719.0000\n",
       "mean        0.5335\n",
       "std         1.5479\n",
       "min         0.0100\n",
       "25%         0.0600\n",
       "50%         0.1700\n",
       "75%         0.4700\n",
       "max        82.5300\n",
       "Name: Global_Sales, dtype: float64"
      ]
     },
     "execution_count": 637,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "project.Global_Sales.describe() #to describe specific column"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 638,
   "id": "887ce71e",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Name                  2\n",
       "Platform              0\n",
       "Year_of_Release     269\n",
       "Genre                 2\n",
       "Publisher            54\n",
       "NA_Sales              0\n",
       "EU_Sales              0\n",
       "JP_Sales              0\n",
       "Other_Sales           0\n",
       "Global_Sales          0\n",
       "Critic_Score       8582\n",
       "Critic_Count       8582\n",
       "User_Score         6704\n",
       "User_Count         9129\n",
       "Developer          6623\n",
       "Rating             6769\n",
       "dtype: int64"
      ]
     },
     "execution_count": 638,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "project.isna().sum() #find sum of null values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 639,
   "id": "eeb0655c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "E       3991\n",
       "T       2961\n",
       "M       1563\n",
       "E10+    1420\n",
       "EC         8\n",
       "K-A        3\n",
       "RP         3\n",
       "AO         1\n",
       "Name: Rating, dtype: int64"
      ]
     },
     "execution_count": 639,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "project.Rating.value_counts() #Return the counts of values in a Series."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 640,
   "id": "3bcf520a",
   "metadata": {},
   "outputs": [],
   "source": [
    "project.Rating.fillna('E',inplace=True) #Replace NULL values with a value"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 641,
   "id": "dc8f1b77",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 641,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "project.Rating.isna().sum() #check nulls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 642,
   "id": "0b691371",
   "metadata": {},
   "outputs": [],
   "source": [
    "project.dropna(subset=['Publisher'],inplace=True) #drob null values by rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 643,
   "id": "2d15ecab",
   "metadata": {},
   "outputs": [],
   "source": [
    "project.dropna(subset=['Name'],inplace=True) #drob null values by rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 644,
   "id": "a5f837a9",
   "metadata": {},
   "outputs": [],
   "source": [
    "project.dropna(subset=['Year_of_Release'],inplace=True)  #drob null values by rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 645,
   "id": "1fc03125",
   "metadata": {},
   "outputs": [],
   "source": [
    "project.dropna(subset=['Developer'],inplace=True)  #drob null values by rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 646,
   "id": "d58a04dc",
   "metadata": {},
   "outputs": [],
   "source": [
    "project.dropna(subset=['Genre'],inplace=True) #drob null values by rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 647,
   "id": "0d5699c7",
   "metadata": {},
   "outputs": [],
   "source": [
    "project.dropna(subset=['User_Score'],inplace=True) #drob null values by rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 648,
   "id": "855fb1da",
   "metadata": {},
   "outputs": [],
   "source": [
    "project.dropna(subset=['Critic_Score'],inplace=True) #drob null values by rows"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 649,
   "id": "a8902a8f",
   "metadata": {},
   "outputs": [],
   "source": [
    "project.drop(['Critic_Count','User_Count','Developer','Other_Sales'], axis='columns', inplace=True)#drob unnecessary columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 650,
   "id": "4924041e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Name               0\n",
       "Platform           0\n",
       "Year_of_Release    0\n",
       "Genre              0\n",
       "Publisher          0\n",
       "NA_Sales           0\n",
       "EU_Sales           0\n",
       "JP_Sales           0\n",
       "Global_Sales       0\n",
       "Critic_Score       0\n",
       "User_Score         0\n",
       "Rating             0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 650,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "project.isna().sum() "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 651,
   "id": "bf1ee6c2",
   "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_of_Release</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>Global_Sales</th>\n",
       "      <th>Critic_Score</th>\n",
       "      <th>User_Score</th>\n",
       "      <th>Rating</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.0000</td>\n",
       "      <td>Sports</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>41.3600</td>\n",
       "      <td>28.9600</td>\n",
       "      <td>3.7700</td>\n",
       "      <td>82.5300</td>\n",
       "      <td>76.0000</td>\n",
       "      <td>8</td>\n",
       "      <td>E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Mario Kart Wii</td>\n",
       "      <td>Wii</td>\n",
       "      <td>2008.0000</td>\n",
       "      <td>Racing</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>15.6800</td>\n",
       "      <td>12.7600</td>\n",
       "      <td>3.7900</td>\n",
       "      <td>35.5200</td>\n",
       "      <td>82.0000</td>\n",
       "      <td>8.3</td>\n",
       "      <td>E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Wii Sports Resort</td>\n",
       "      <td>Wii</td>\n",
       "      <td>2009.0000</td>\n",
       "      <td>Sports</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>15.6100</td>\n",
       "      <td>10.9300</td>\n",
       "      <td>3.2800</td>\n",
       "      <td>32.7700</td>\n",
       "      <td>80.0000</td>\n",
       "      <td>8</td>\n",
       "      <td>E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>New Super Mario Bros.</td>\n",
       "      <td>DS</td>\n",
       "      <td>2006.0000</td>\n",
       "      <td>Platform</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>11.2800</td>\n",
       "      <td>9.1400</td>\n",
       "      <td>6.5000</td>\n",
       "      <td>29.8000</td>\n",
       "      <td>89.0000</td>\n",
       "      <td>8.5</td>\n",
       "      <td>E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Wii Play</td>\n",
       "      <td>Wii</td>\n",
       "      <td>2006.0000</td>\n",
       "      <td>Misc</td>\n",
       "      <td>Nintendo</td>\n",
       "      <td>13.9600</td>\n",
       "      <td>9.1800</td>\n",
       "      <td>2.9300</td>\n",
       "      <td>28.9200</td>\n",
       "      <td>58.0000</td>\n",
       "      <td>6.6</td>\n",
       "      <td>E</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    Name Platform  Year_of_Release     Genre Publisher  \\\n",
       "0             Wii Sports      Wii        2006.0000    Sports  Nintendo   \n",
       "2         Mario Kart Wii      Wii        2008.0000    Racing  Nintendo   \n",
       "3      Wii Sports Resort      Wii        2009.0000    Sports  Nintendo   \n",
       "6  New Super Mario Bros.       DS        2006.0000  Platform  Nintendo   \n",
       "7               Wii Play      Wii        2006.0000      Misc  Nintendo   \n",
       "\n",
       "   NA_Sales  EU_Sales  JP_Sales  Global_Sales  Critic_Score User_Score Rating  \n",
       "0   41.3600   28.9600    3.7700       82.5300       76.0000          8      E  \n",
       "2   15.6800   12.7600    3.7900       35.5200       82.0000        8.3      E  \n",
       "3   15.6100   10.9300    3.2800       32.7700       80.0000          8      E  \n",
       "6   11.2800    9.1400    6.5000       29.8000       89.0000        8.5      E  \n",
       "7   13.9600    9.1800    2.9300       28.9200       58.0000        6.6      E  "
      ]
     },
     "execution_count": 651,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "project.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 652,
   "id": "884b01b9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>Global_Sales</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>User_Score</th>\n",
       "      <th>Critic_Score</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <th>76.0000</th>\n",
       "      <td>87.1000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8.5</th>\n",
       "      <th>89.0000</th>\n",
       "      <td>46.4600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8.6</th>\n",
       "      <th>91.0000</th>\n",
       "      <td>42.6300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8.3</th>\n",
       "      <th>82.0000</th>\n",
       "      <td>37.7800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <th>80.0000</th>\n",
       "      <td>36.5700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6.2</th>\n",
       "      <th>72.0000</th>\n",
       "      <td>0.0100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.3</th>\n",
       "      <th>42.0000</th>\n",
       "      <td>0.0100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4.3</th>\n",
       "      <th>41.0000</th>\n",
       "      <td>0.0100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4.8</th>\n",
       "      <th>58.0000</th>\n",
       "      <td>0.0100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2.4</th>\n",
       "      <th>46.0000</th>\n",
       "      <td>0.0100</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2364 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         Global_Sales\n",
       "User_Score Critic_Score              \n",
       "8          76.0000            87.1000\n",
       "8.5        89.0000            46.4600\n",
       "8.6        91.0000            42.6300\n",
       "8.3        82.0000            37.7800\n",
       "8          80.0000            36.5700\n",
       "...                               ...\n",
       "6.2        72.0000             0.0100\n",
       "2.3        42.0000             0.0100\n",
       "4.3        41.0000             0.0100\n",
       "4.8        58.0000             0.0100\n",
       "2.4        46.0000             0.0100\n",
       "\n",
       "[2364 rows x 1 columns]"
      ]
     },
     "execution_count": 652,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Are the ratings affect the sales? \n",
    "project.groupby(['User_Score','Critic_Score'])[['Global_Sales']].sum().sort_values('Global_Sales',ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 653,
   "id": "81c90a80",
   "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>Genre</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Platform</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3DS</th>\n",
       "      <td>Strategy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DC</th>\n",
       "      <td>Sports</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DS</th>\n",
       "      <td>Strategy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GBA</th>\n",
       "      <td>Strategy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GC</th>\n",
       "      <td>Strategy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PC</th>\n",
       "      <td>Strategy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PS</th>\n",
       "      <td>Strategy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PS2</th>\n",
       "      <td>Strategy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PS3</th>\n",
       "      <td>Strategy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PS4</th>\n",
       "      <td>Strategy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PSP</th>\n",
       "      <td>Strategy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PSV</th>\n",
       "      <td>Sports</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Wii</th>\n",
       "      <td>Strategy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WiiU</th>\n",
       "      <td>Strategy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>X360</th>\n",
       "      <td>Strategy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>XB</th>\n",
       "      <td>Strategy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>XOne</th>\n",
       "      <td>Strategy</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Genre\n",
       "Platform          \n",
       "3DS       Strategy\n",
       "DC          Sports\n",
       "DS        Strategy\n",
       "GBA       Strategy\n",
       "GC        Strategy\n",
       "PC        Strategy\n",
       "PS        Strategy\n",
       "PS2       Strategy\n",
       "PS3       Strategy\n",
       "PS4       Strategy\n",
       "PSP       Strategy\n",
       "PSV         Sports\n",
       "Wii       Strategy\n",
       "WiiU      Strategy\n",
       "X360      Strategy\n",
       "XB        Strategy\n",
       "XOne      Strategy"
      ]
     },
     "execution_count": 653,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#What is the most widely Genre on each platform?\n",
    "project.groupby(['Platform'])[['Genre']].max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 654,
   "id": "8bebb239",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX4AAAGrCAYAAADHKfxgAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAA730lEQVR4nO3debwcVZ3//9c7EBIIBBIICCIElEWQQEJgwiIGQvyyJzqCoGBANC6goj/EyIigoyMwiLgwOmHNKLLJKgwIBCL7kgRI2BcNTCBkg0BYwvr5/XHq5lY63ff2vUl3dVLv5+PRj9t1qqv6c/vW/fSpU6fOUURgZmbl0aPoAMzMrLmc+M3MSsaJ38ysZJz4zcxKxonfzKxknPjNzErGiX8lJ+lgSXdJek1StD2ydadUlrUSSQPz8Uk6suiYWlnFZ3VKrnx4xbrhhQVpLcGJvwOSZlT8w9TzuLDouNtIGgFcCuwKrFVwOCulimPkwqLjMavHqkUHYA31RUDZ87eBs4B5ufU3Aa83OSYzK5gTf8d+DqxdUfafuef/AH5fsf6RhkbUNQNzzx+IiHH5lRFxN3B3UyOylZ6kVYGeEfFW0bFYDRHhRxceQOQek2q85hPAeOAp4E3gLeAZ4Dxg+yqvP6Viv72Ak7Lt3wZmkmrra9cZY+X+Kh+Tqr0uK+sBzMiV/3eV/X+2Yn/b5db1BL4C3ALMBd4hnWXcBBzcxc96YMX7HAnsCdwKvAYsBP4G7Fxj+z7A94A7gZezWGYD1wAja2zz6Wz9C9ln/ybwPHAbcDqwZfa6Czv5jAMYnr22N/AD4D5gAfBeFs+TwOXACVXiEHAIcB0wK4t9AXA7MBZYtZNj85Rc+fBqcVX5vS8H/i/7vV8D7geOB9ao8vr8MXIhsF32uc2v9R41Pu+R2e/0BvAK8Fdge6ocmxXbdek4q3EsHQZMJf1/Pgec3Pa5Al8lVeIWZZ/JacBqVfZ7aPaes4F3ScfkDOBG4N+BDxWds6p+7kUHsKI9Kg6eSVXWj80OwlrJ4F3gGxXbnFLxmltqbPswsGYdMVbur+7En5WfnCt/ufKAB/6SW39frrx/liw6eu8/Az3q/Kwr/1mvB96vss9FVCRyYHPSF2dHsZxWsc0XO3l9AEdmr72wjtcOz157U2evrYijFynhd7TNbVQk5Ir1p+TKh1eLK1snUiWlo/eaBqxf8V4zcuunkpoMq75HB3/fw4EPqrzfm5WfWcV2XT7OWPpYeqDGdueTKlnV1l1QEceJ9R4DrfYoPIAV7VHxR51UsW5XlkxMc4EzSc1Ds3PlHwC757Y7pWK/HwAXAT8FHqxYd2YdMe5Kqqk9m9vu2azseODz1d43t/1HKn6Pz+TWrU2qIbWt+0puXT5ZvQVcAPxb9k+Y39+JdX7Wlf+skX0eP80+n3zSeBHonW3Xg/Ql2bbuVeC/gB8B11bs7wu597s3V/4EqcZ2EvDfpFrpu7Qn/n2yz/Ll3DYP5D7j47PPceuK97uSlDB+AfyRdCYYFb/373Kvf590gf5HwDmkL7m2deM7ODZPyZUPr1g3PLfu+Ip1/5v9zr8hnWG0ld9U8V4zKrZ7D/hTtu0EYKdO/rYfYskvi3eBc4H/IDWhLvF3r9i2y8cZ1Y+lu4GfZH/rynV3ko6zZyr+Fhvm9vlSxd/+5OxxLumL6X2c+FeOR8XBMali3RUV/whb59ZtkR3cbeuvya07pWK/J+XW9WLJmutrVDnNrxHrpFqxVnvfinU35NZdkSv/cq58IdkZCKl5K/87HFKxv9Ny6+YDq9QRf+U/62NAr9z6n1R7T+CAivKdK/Z7aW7dQ7nyh3Llh1aJpy8d13wvrLLNDrn1r1K9uWCL3PN+FcfJCRWv/UbFMbZejWPzlFz58Ip1w7PyHsCcXPl/VbzXvhXb7VDj9w5gdBf/j06o2P5ruXXrkZp9ljo2u3ucVTmWHiVdh4DUzJVfNz23rvIzODD3Xgty5cOq/I7rUWfzbLMf7s65fO2ee35PRDzRthART5NqEW1262A/E3LbvQ1cklu3FrDlMsZZj3Nzz/eXtE72/Iu58ksjoq1X0Ccrtr+04h6BE3Lr+gMf70ZMl2SfR5sJFeuH1ojlvopYDsmt215SW1fX23PlF0r6u6TzJP0g6xr7VkTM6WLMj5PO/CB9ccyQdK2kX0kaK2nr7NhoM4wlO12cVhH7f+XWrZK9vru2Agbklr9R8V7/W/H63anukYi4uovvvVPu+QekWjsAETGPdL2gmuV1nF0eEe9mz2d0sO7pinX9cs/zx8vNkm6R9AdJ35O0K/ByRLxa4/0L5V49y1f/3POXqqzPl/Wrsr7N7E6WO9p2ebmWVBtcn3TWcbCk60m1xzbn5J7nf/d6DOj8JUup93Ppaizrkc5eTgQ2AQ4i/c57ZI82L0n6XETcVe+OI+JtSf9KuiawObAhcGD+NZJuBkZF6gXTjM+xzfJ6rydqlHdkndzzlyPinYr11f5/YPnF/ELueeV7v5h7/l7Funxl+WukL/NPAWsCI7JHm2ckHRART9YfbnM48S9fL5MSJaQ2zEr5slc62M8GpJ4k+eW8BV2OrIsi4l1J/0NqA4Z0Ia4v7Qf+IxFxX26Tlyt2cRpL3jNQ6dluhFX5OdT6XPKxBCmhV/4D570CkJ29jJa0AakmvUX2OJCUsD9EapffvCtBR8Qdkj4GDCL1WPkYqRfMgaRa+0jg+6Q25crP8RxSU18tk7sSS4XK9/oLqedRLffUKH+jG++9IPe8n6RVIyL/N6r2/wPL7zh7t0Y5dHysLBYRs4DhkjYBdiYdK1sBo0hfbB8jdffeq579NZMT//J1F/CZ7Pku2Wn8EwCStmDJU+WOao1jSBcWkdSL1GWszUJSN8BmOJf2xP9JUm04vy7vzorltyPijModSvoQsEtEPF+5rg6HSjo1VzscU7H+gVwsbaf8AmZHxAUVr0XSZqTumQuy5U8AT0dEW5fPttf9jXT9BmAzSetGxPxsOZ9A1qjyHqtl7/EI6YLzw7l119Je+29r+riXlHja/jd71fgc1wH2jYjpleu64ElSM1Rbrbg/cFZFAkbS6qS29LrPdOpwP/C57PkqpGP8T9n7rUdKntU04ziri6TtSRWg58lV1CR9D/hltji02rZFc+Jfvn4JjCYlm1WAO7Ja8wfAl2j/vIP2A6Oan0jamlRbOZBUk2hzfuU/ZqNExJOS7iR9YYn2G8LeJtV886+dLukG0sUwgB9L2p3Uc+ItYCPSP8FOwB3AVd0I6eOk9vq/Ah8l9cNu8xKpeQpS2/QjpAuBAOdIGk3qEfQeqbfNv5Bq3xNI9wIAnAp8UtKtpH/k2aSznPz7tPXtbzOTVLODdC3kNLJ+5RHxm2z76ZKezj6LWaQL9FsA++X28zJARLwi6RzSRVyAL0n6OKmL70LSGeVgUs+tF4GLO/zEOhARH0g6g1RrhlQznS7pOtKF0f6ks5Q9gNVZ+prKsvgjqQdMn2z5vOx4mU/6vNepEXMzjrN6XQRskB0vM0lnHgOAI3Kv6ejMvjhFX11e0R500KsnW/8NluyVUfl4D/hWxTanVLzmrzW2nQ707UKskzqJdYn3rbGPMVXi+HON165L5/2rq8ZSY38DK7a7jer9vt8G9qnYtp5+/EGuJw6d950P4BcV7/PNGq97PVu/Xh37fAMYkttn7zpjmdHBsXlKrnx4xbrhuXUiNSd19l5R8V4zqn2GXfxfqtWP/y2WvJflg2U9zqocS0cuh3WP1BHD14vOWdUe7tWznEXE74EdSXfpPkvqd/028E/SBb6dIuK3nezms6R26adIF55eBH4L7BERrzUm8pouI3VDzKts5gEgUvPHrqQun3+j/W7GV0jd5/4CHAUc3M1YJpBqereT+oC/DtwMfCoibqyI5R+krpTfIX0Bzid96c4j3ZD0R1Lzwndym/2SdN/FnaQa/1tZ/LNI3VsPjYgfVsT0B+CHpGaTyouEkD67b2bvN510wfw90lnDk6Sbp3aMiKm52BdFxAHAv9J+F/E7pDOFJ0hfCsewdA+XLovkq8DepN5jM0jH6+ukHi03kZr7tlrW96ry3n8i3Q9xJ+mzfo30Oe/Gkm3zr1Rs1+jjrF7/BpxN+hJqu9P7HdKdvlcC/y8i/tDgGLpF2TeXFSgbQvfktuWIUO1Xm60cJK0eVcbzkdSXVJv+SFZ0Y0TsW/k66z638ZtZUcZI+iZpjKCnSWdBmwNfpz3pQzoLs+XIid/MirRd9qjmPdKdyzc3MZ5ScOI3s6LcSbpetCvpPom+pAvdM0jXcf4QEY8WFt1KzG38ZmYl4149ZmYls0I09ay33noxcODAosMwM1uhTJkyZV5ELDVe0QqR+AcOHMjkycsyJImZWflIeq5auZt6zMxKxonfzKxknPjNzEpmhWjjN7PW8+677zJz5kwWLVpUdCil17t3bzbeeGN69uxZ1+ud+M2sW2bOnMlaa63FwIEDkTy8VFEigvnz5zNz5kw222yzurZxU4+ZdcuiRYtYd911nfQLJol11123S2deTvxm1m1O+q2hq38HJ34zs5IpTRv/wHHXFx0CM07dv+gQzBpmef+P1fv/Mnv2bL773e9y77330q9fP1ZbbTVOOOEE+vXrxxlnnMF1111Xc9tTTjmFNddck+OPP77mayqtueaavP7661XXffDBBxx33HHceuutSKJ3795cdtllHba9Dx8+nDPOOIOhQ5s3PW9pEr+ZrXwigtGjRzNmzBj+/Oc/A/Dcc89x7bXX0q9fv6bHc+mll/Liiy8ybdo0evTowcyZM+nTp0/nGzaZm3rMbIV16623stpqq/H1r399cdmmm27Kt771rSVe9/LLLzN69GgGDRrEsGHDmDZt2uJ1Dz/8MHvttRdbbLEF55xzDgCvv/46I0aMYMiQIWy33XZcc801dcUza9YsNtxwQ3r0SKl14403XvwF9I1vfIOhQ4ey7bbbcvLJJ1fd/qabbmKXXXZhyJAhHHzwwYvPLMaNG8c222zDoEGDunR2UktDa/ySvgt8hfaJwo8C1gAuJU1iPAM4JCJeqbELM7OaHn30UYYMGdLp604++WQGDx7M1Vdfza233sqXvvQlHnroIQCmTZvGvffeyxtvvMHgwYPZf//9WX/99bnqqqvo27cv8+bNY9iwYRx00EGdXkQ95JBD2H333bnjjjsYMWIEhx9+OIMHDwbg5z//Of379+f9999nxIgRTJs2jUGDBi3edt68efzsZz/jlltuoU+fPpx22mmceeaZHHvssVx11VU88cQTSGLBggXd/rzaNKzGL+nDwLeBoRHxCWAV0uTW44CJEbEFMDFbNjNbZscccwzbb789O+200xLld955J0cccQQAe+21F/Pnz+fVV18FYNSoUay++uqst9567Lnnntx///1EBCeeeCKDBg1i77335oUXXmD27Nmdvv/GG2/Mk08+yS9+8Qt69OjBiBEjmDhxIgCXXXYZQ4YMYfDgwTz66KM89thjS2x777338thjj7Hbbruxww47MGHCBJ577jn69u1L7969+cpXvsKVV17JGmusscyfU6Pb+FcFVpf0Lqmm/yLwQ2B4tn4CMAn4QYPjMLOV0LbbbssVV1yxePnss89m3rx5S10orTbhVFvtvbIWL4mLLrqIuXPnMmXKFHr27MnAgQPr7iffq1cv9t13X/bdd1822GADrr76ajbffHPOOOMMHnjgAfr168eRRx651P4igpEjR3LxxRcvtc/777+fiRMncskll/C73/2OW2+9ta5YamlYjT8iXgDOAJ4HZgGvRsRNwAYRMSt7zSxg/UbFYGYrt7322otFixbx+9//fnHZm2++udTr9thjDy666CIAJk2axHrrrUffvn0BuOaaa1i0aBHz589n0qRJ7LTTTrz66qusv/769OzZk9tuu43nnqs6uvFSpk6dyosvvgikHj7Tpk1j00035bXXXqNPnz6svfbazJ49mxtuuGGpbYcNG8Zdd93FM888s/j3eOqpp3j99dd59dVX2W+//TjrrLMWN1Eti4bV+CX1A0YBmwELgMslHd6F7ccCYwE22WSTRoRoZstREd2VJXH11Vfz3e9+l9NPP50BAwYsbh/PO+WUUzjqqKMYNGgQa6yxBhMmTFi8buedd2b//ffn+eef56STTmKjjTbii1/8IgceeCBDhw5lhx12YOutt64rnjlz5vDVr36Vt99+e/G+jz32WHr37s3gwYPZdttt2Xzzzdltt92W2nbAgAFceOGFHHbYYYu3/9nPfsZaa63FqFGjWLRoERHBr371q+5+XIs1bM5dSQcD+0TE0dnyl4BhwAhgeETMkrQhMCkitupoX0OHDo1lnYjF/fjNlq/HH3+cj3/840WHYZlqfw9JUyJiqRsEGtmd83lgmKQ1lBrRRgCPA9cCY7LXjAHq6ydlZmbLRcOaeiLiPkl/AaYC7wEPAuOBNYHLJB1N+nI4uFExmJk1wvTp0xf3EmrTq1cv7rvvvoIi6pqG9uqJiJOByjsV3ibV/s3MVkjbbbfdcrnIWhTfuWtm3daoa4TWNV39Ozjxm1m39O7dm/nz5zv5F6xtIpbevXvXvY0HaTOzbtl4442ZOXMmc+fOLTqU0muberFeTvxm1i09e/ase6o/ay1u6jEzKxknfjOzknHiNzMrGSd+M7OSceI3MysZJ34zs5Jx4jczKxknfjOzknHiNzMrGSd+M7OSceI3MysZJ34zs5JpWOKXtJWkh3KP1yQdJ6m/pJslPZ397NeoGMzMbGkNS/wR8WRE7BAROwA7Am8CVwHjgIkRsQUwMVs2M7MmaVZTzwjg2Yh4DhgFTMjKJwCjmxSDmZnRvMR/KHBx9nyDiJgFkP1cv0kxmJkZTUj8klYDDgIu7+J2YyVNljTZM/yYmS0/zajx7wtMjYjZ2fJsSRsCZD/nVNsoIsZHxNCIGDpgwIAmhGlmVg7NSPyH0d7MA3AtMCZ7Pga4pgkxmJlZpqGJX9IawEjgylzxqcBISU9n605tZAxmZrakhk62HhFvAutWlM0n9fIxM7MC+M5dM7OSceI3MysZJ34zs5Jx4jczKxknfjOzknHiNzMrGSd+M7OSceI3MysZJ34zs5Jx4jczKxknfjOzknHiNzMrGSd+M7OSceI3MysZJ34zs5Jx4jczK5lGz8C1jqS/SHpC0uOSdpHUX9LNkp7OfvZrZAxmZrakRtf4fw3cGBFbA9sDjwPjgIkRsQUwMVs2M7MmaVjil9QX2AM4DyAi3omIBcAoYEL2sgnA6EbFYGZmS2tkjX9zYC5wgaQHJZ0rqQ+wQUTMAsh+rt/AGMzMrEIjE/+qwBDg9xExGHiDLjTrSBorabKkyXPnzm1UjGZmpdPIxD8TmBkR92XLfyF9EcyWtCFA9nNOtY0jYnxEDI2IoQMGDGhgmGZm5dKwxB8RLwH/J2mrrGgE8BhwLTAmKxsDXNOoGMzMbGmrNnj/3wIukrQa8A/gKNKXzWWSjgaeBw5ucAxmZpbT0MQfEQ8BQ6usGtHI9zUzs9p8566ZWck48ZuZlYwTv5lZyXSpjT+7G7dvRMxsUDzWBAPHXV90CMw4df+iQzArrU5r/JIukvRrSVsCLwDPSfq3xodmZmaNUE9Tz0jgKeBzpJut7gC+2cigzMyscepJ/GsB7wCDgUuBc4F1GxmUmZk1Tj1t/E8BvwRWBz4DbA3MbmRQZmbWOPXU+L8B3AacBVwP9AL+0MCYzMysgTqt8UfE3ZIOBrYh9ej5eePDMjOzRqmnV89g4BlgMrCTpMckndPwyMzMrCHqaer5HfAmIOAD4CJg70YGZWZmjVNP4t8euDC3/CKeNcvMbIVVT6+emcCnsueDgMOAGY0KyMzMGquexH86qe8+wJnZzyMbEo2ZmTVcPb16zpf0LLA/qZ3/uoj4e8MjMzOzhqiZ+CUNyS0uBC7Jr4uIqZ3tXNKMbNv3gfciYqik/qQ7gAeSmowOiYhXuhO8mZl1XUc1/slAdLB+lTrfY8+ImJdbHgdMjIhTJY3Lln9Q577MzGwZdZT4/4eOE393jQKGZ88nAJNw4jcza5qaiT8ijlwO+w/gJkkB/HdEjAc2iIhZ2XvMkuSuoWZmTdTpxV1JfYBvA9sBvbPiiIh/rWP/u0XEi1lyv1nSE/UGJmksMBZgk002qXczMzPrRD3dOc8FPk+qvSsrq6sJKCJezH7OkXQVsDMwW9KGWW1/Q9IY/9W2HQ+MBxg6dGgjmpzMzEqpnjt39yYN2wDpC+AvQKczcEnqI2mttufAp4FHgGuBMdnLxgDXdDFmMzNbBvUk/jWBaaTa/jrAA8AxdWy3AXCnpIeB+4HrI+JG4FRgpKSnSbN7ndqNuM3MrJvqHbJhTeBZ4PekL4D/62yjiPgHaZyfyvL5wIiuhWlmZstLPYn/68DrwEO0185/2KiAzMysseoZsmFibnFYA2MxM7MmqNnGL+kwSd/Knn9E0j2SFkq6S9I2zQvRzMyWp44u7p4EbJ49/xnwL8C7wFDae/mYmdkKpqPEvwnwcPZ8f2AR8FHgR8CODY7LzMwapKPE/w7wMUl7Af2Be7JRNF+jMWP4mJlZE3SU+G8BTgRuJiX6i7PyXUldO83MbAXUUa+esaQ+/FsBd0TEuZJ6Ar1I/fnNzGwF1NHonAuA71WUvQsc2uCYzMysgeoZssHMzFYiTvxmZiXjxG9mVjL1Tra+lHomWzczs9bTjMnWzcyshRQx2bqZmRWo0ZOtm5lZi2n0ZOtIWoXUbPRCRBwgqT9wKTAQmAEckg0FYWZmTdDQydYz3wEeB/pmy+OAiRFxqqRx2fIPurA/MzNbBg2bbB1A0sakkT3PzRWPAiZkzycAo+vZl5mZLR+NnGwd4CzgBOCDXNkGETELIPu5fp37MjOz5aBhk61LOgCYExFTJA3vamCSxpIGimOTTTbp6uZmZlZDIydb3w04SNJ+pIvCfSX9CZgtacOImCVpQ2BOtY0jYjwwHmDo0KHuVmpmtpx02tSTTbY+FZgHfAX4ZETcVsd2P4yIjSNiIGlEz1sj4nDgWmBM9rIxwDXdjN3MzLqh08QvaU9St8uHs8c/utN0k3MqMFLS08BI2s8izMysCepp6jmP1MZ/EemL4sCs7KP1vklETAImZc/nAyO6GKeZmS0n9fTqETAuIr6UNdX8kPq+MMzMrAXVMzrnX4DPS3qc9CVwMGkcHzMzWwHVOzqngIm553sAJzUwLjMzaxCPzmlmVjJ1j84paY2s/M0Gx2RmZg1UT3fOD0uaBCwEFkq6VdKHGx6ZmZk1RD29c84GdgfuyZb3AH4LfLZRQZk1y8Bx1xcdAjNO3b/oEKxk6unO+Sng3yJi94jYnTQy5/CGRmVmZg1TT43/TWBLSauSevRsCbzV0KjMzKxh6qnxXwYcRUr2bwJHkmbQMjOzFVA9Nf4fkC7s7kfq3nk98B+NDMrMzBqn08QfEe8AP84eZma2gutoyIbXOtguImLtBsRjZmYN1lGN/2V8565Zabhra3l0dOfuwCbGYWZmTdJRU8/GwCbAFFLvn+/nVl8fEVMaHJuZmTVAR009vwM2iYghktYFTqG96Wdb4PMd7VhSb+B2oFf2Pn+JiJMl9Sd1Bx1ImtnrkIh4ZRl+BzMz64KO+vHvDFxSUfbvwLnAsDr2/TawV0RsD+wA7CNpGDAOmBgRW5CGeh7X1aDNzKz7Okr86wILsuevA98lJf37gA0623Ekr2eLPbNHAKOACVn5BGB0V4M2M7Pu66ipZxZwiKRzIuJt4NcAkg4G5tSzc0mrkK4RfAw4OyLuk7RBRMwCiIhZktZfpt/AzGw5W9l7OHWU+K8g1fKnSbqZVFsfAWwHnFXPziPifWAHSesAV0n6RL2BSRoLjAXYZJNN6t3MzMw60VHiPwnYkTQM87a58kl0cdrFiFiQjem/DzBb0oZZbX9Dapw9RMR4YDzA0KFDfT+Bmdly0lE//jeB4ZL2In0BAEyOiNvq2bGkAcC7WdJfHdgbOA24FhgDnJr9vGYZ4jczsy6qZ6yeW4Fbu7HvDYEJWTt/D+CyiLhO0j3AZZKOBp4HDu7Gvs3MrJvqGZ2zWyJiGjC4Svl80rUCMzMrQD3j8ZuZ2UrEid/MrGSc+M3MSsaJ38ysZJz4zcxKxonfzKxknPjNzErGid/MrGSc+M3MSsaJ38ysZJz4zcxKxonfzKxknPjNzErGid/MrGSc+M3MSsaJ38ysZBqW+CV9RNJtkh6X9Kik72Tl/SXdLOnp7Ge/RsVgZmZLa2SN/z3g/4uIjwPDgGMkbQOMAyZGxBbAxGzZzMyapGGJPyJmRcTU7PlC4HHgw8AoYEL2sgnA6EbFYGZmS2tKG7+kgaT5d+8DNoiIWZC+HID1mxGDmZklDU/8ktYErgCOi4jXurDdWEmTJU2eO3du4wI0MyuZhiZ+ST1JSf+iiLgyK54tacNs/YbAnGrbRsT4iBgaEUMHDBjQyDDNzEqlkb16BJwHPB4RZ+ZWXQuMyZ6PAa5pVAxmZra0VRu4792AI4Dpkh7Kyk4ETgUuk3Q08DxwcANjMDOzCg1L/BFxJ6Aaq0c06n3NzKxjvnPXzKxknPjNzErGid/MrGSc+M3MSsaJ38ysZJz4zcxKxonfzKxknPjNzErGid/MrGSc+M3MSsaJ38ysZJz4zcxKxonfzKxknPjNzErGid/MrGSc+M3MSsaJ38ysZBo55+75kuZIeiRX1l/SzZKezn72a9T7m5lZdY2s8V8I7FNRNg6YGBFbABOzZTMza6KGJf6IuB14uaJ4FDAhez4BGN2o9zczs+qa3ca/QUTMAsh+rl/rhZLGSposafLcuXObFqCZ2cquZS/uRsT4iBgaEUMHDBhQdDhmZiuNZif+2ZI2BMh+zmny+5uZlV6zE/+1wJjs+Rjgmia/v5lZ6TWyO+fFwD3AVpJmSjoaOBUYKelpYGS2bGZmTbRqo3YcEYfVWDWiUe9pZmada9mLu2Zm1hhO/GZmJePEb2ZWMk78ZmYl48RvZlYyTvxmZiXjxG9mVjJO/GZmJePEb2ZWMk78ZmYl48RvZlYyTvxmZiXjxG9mVjJO/GZmJePEb2ZWMk78ZmYlU0jil7SPpCclPSNpXBExmJmVVdMTv6RVgLOBfYFtgMMkbdPsOMzMyqqIGv/OwDMR8Y+IeAe4BBhVQBxmZqWkiGjuG0qfA/aJiK9ky0cA/xIRx1a8biwwNlvcCniyqYEubT1gXsExtAp/Fu38WbTzZ9GuVT6LTSNiQGVhwyZb74CqlC317RMR44HxjQ+nPpImR8TQouNoBf4s2vmzaOfPol2rfxZFNPXMBD6SW94YeLGAOMzMSqmIxP8AsIWkzSStBhwKXFtAHGZmpdT0pp6IeE/SscDfgFWA8yPi0WbH0Q0t0+zUAvxZtPNn0c6fRbuW/iyafnHXzMyK5Tt3zcxKxonfzKxknPjNzErGib8GSQdLWit7/iNJV0oaUnRczSTpeklflNSn6Fis9UiaWE/ZykzJIVm+kKQRkn4j6ZuSWja/tmxgLeCkiFgoaXfg/wETgN8XHFOzjQcOAP4p6VJJo7MuuKUj6c7s50JJr+UeCyW9VnR8zSSpt6T+wHqS+knqnz0GAhsVHF6znQ0cAhwB/BH4OjAZ2AP4VYFxdci9emqQ9GBEDJb0C2B6RPy5razo2JpN0urAQaR7LnYB/he4OCJuLjQwK4Sk7wDHkZL8C7Tfjf8acE5E/K6g0JpO0vSI2E5ST+AlYMOIeEfSqsCDEbFdwSFW5cRfg6TrSAf13sCOwFvA/RGxfaGBFUzSINLZz6CIWKXoeJpFUt+IeC2r6S4lIl5udkxFykbZPTEi/r3oWIqUrwxKujEi9smteygidigsuA64qae2Q0g3me0TEQuA/sD3C42oIJI2kPQtSXcBVwM3kb4My+TP2c8ppFP5KbnH5KKCKkpEvA/sV3QcLeAlSWsCVCT9DwHvFBZVJ1zjr0HSHyPiiM7KVmaSvgocRhod9Urgkoi4q9iorFVI+gkwDbgynEiWkHWI6BMRc4qOpRon/hokTY2IIbnlVUht/aWZNEbSBcDFwC0R8UHR8RRJ0nzgXuBu4C5Ss9+bxUZVLEkLgT7A+6SmUAEREX0LDcw65cRfQdIPgROB1YG2f2yRTtvGR8QPi4rNiiOpLzAM2DV77Aj8g+yLICIuKzA8sy5x4q8i6397bkR8uehYrDVlp/JHkXq3bFamC915kg4idV0EmBQR1xUZj9XHib8GSVMiomwXMK0GSRvRXtvfKSueQmr+uScinisqtqJIOpX0WVyUFR0GTImIccVFVZzsnp8tIuICSQOANSPin0XHVY0Tfw2SzgYujIgHio6lFUjaHvhktnhHRDxcZDzNJukDYCrpppzLs/miS03SNGCHtus/2XWwByNiULGRNZ+kk4GhwFYRsWVWUbg8InYrOLSq3J2ztj2BeyQ9K2mapOnZgV462Q07FwHrZ48/SfpWsVE13W6kLp2fIR0XV0g6XtJuknoVHFuR1sk9X7uoIFrAZ0g3Ob4BEBEvAmsVGlEHiphzd0Wxb9EBtJCjgX+JiDcAJJ0G3AP8ttComigi7iH9zmcCZMMTHEi6mW1joHdhwRXnF8CDkm4jdYDYAyhr54d3IiIkBSy+BtSynPhriIjnyt68kSNSl70279N+m35pSNqa9nb+3YB+pC+DPxQZV1Ei4mJJk0jt/AJ+EBEvFRtVYS6T9N/AOtn9L18Gzik4pprcxl9D1rzxVdKNS5BO5cZHRGlquW0kfQ8YA1yVFY0GJkREyw5CtbxJmgfMInXfbOvC+UyxURVL0m7AQxHxhqTDgSHAr8t2oVuSSGd9WwOfJn0J/q2Vx7Jy4q8ha8/fJde80YfUe6N0F64AsiGpdycd1LdHxIMFh9RUktaOiFeLjqOVZP8j2wODgP8Bzgc+GxGfKjSwAqxovQB9cbc2N29ksqEqpkbEbyLi1xHxoKQ/Fh1XMznpV/VeNlTDKOA3EfFrWviCZoPdK2mnzl/WGtzGX9sFwH2SriIl/FHAecWGVJht8wtZt70VpnZjDbMwu9P9COCT2XHRs+CYirIn8DVJz5F69rQNX9GSLQRu6ulArnkD0sXdsjVvVA5f0XbGU9rhKyRtVnlTTrWyMshGoPwC8EBE3CFpE2B4RPxPwaE1naRNq5W36vUON/V0TkBQwmaeiPhFRKwF/GdE9I2ItbLHumVM+pkrqpT9pelRtICsB88VQNt9DPNo7wBQKhHxXJbk3yLli7ZHS3JTTw2SfgwcTDqwBVwg6fKI+FmxkRXiBkl7VBZGxO1FBFOErCvntsDakj6bW9WXcvbhbxu2eyxproqPAh8mdW0dUWRcRcjGLPolaVayOcCmwONUNJO2Cjf11CDpcWBwRCzKllcHpkbEx4uNrPkk/TW32BvYmTQmy14FhdR0kkaRurEeBFybW7WQNE/B3UXEVSRJD5GOhftys1BNb9XpBhtJ0sPAXqQhzAdL2hM4LCLGFhxaVa7x1zaDlOQWZcu9gGcLi6ZAEXFgflnSR4DTCwqnEBFxTTYd5w8i4j+KjqdFvJ3NLwtANs9sWWuS70bEfEk9JPWIiNuyO9xbktv4a3sbeFTShdmEJI8Ar0v6jaTfFBxb0WYCnyg6iGbLphscWXQcLeTvkk4EVpc0Ergc+Gsn26ysFmRTMN4OXCTp18B7BcdUk5t6apA0pqP1ETGhWbEUTdJvaa/J9QB2AGZExOGFBVUQST8nDUZ2KdmAXAARMbWwoAqSzVtxNEverdqywxQ0gqReEfF2doPnItLn8EXSMXJRRMwvNMAanPg7IaknqXb7QqvOn9loFV+C75GSfinn3s0GJKsUZbreUYukTwPfj4jSnBW1TdG6os3H7Tb+CpL+APw2Ih6VtDZpEK73gf6Sjo+Ii4uNsPkqz24kfUTS9yPiP4uKqSgRsWfRMRRN0l6k3jsbAVcD/0EaskHAz4uLrBCrZRWjXSt6ewEQEVdW2aZwTvxL+2REfD17fhTwVESMzm5WuYE0+XjpSFqP1L31MFK3vVL21waQtD+pm97ibpwR8dPiImq6X5K6cd5DGr78XuCkbMiGsvk6qWlnHdIw3XlB+yCPLcWJf2n5mZXaLlgRES+19V4oC0lrkUYl/QKwJSnZbx4RGxcaWIGyM8I1SLfonwt8Dri/0KCaLyJiUvb8aklzS5r0iYg7Jd0NzIyIFeZsx4l/aQskHQC8QBpz/WhY3FVt9SIDK8AcUlL7EXBnNtHEZwqOqWi7RsQgSdMi4ieSfkmL1uoaaJ2KZg3ll1u1eaNRIuKDLGc48a/Avgb8BvgQcFxuYokRwPWFRVWME4FDgd8Df5Z0acHxtIK3sp9vZvOqzgc2KzCeIvydJZs18sst27zRYDdJ+lfgylgBesy4V491StLmpLb9Q4EtgJOBqyLiqUIDK4Ckk0hTTo4AziYlunMi4seFBmaFkrQQ6EPq9dbWrTMiom+hgdXgxG9dImk70pfA5yPio0XH0yzVJmLJJlnvDWwZEQ8UE5lZ1znxm9VB0mRgZES8UlE+Ejg/Ij5STGTWKiT1I50R53t7teRAhh6ywaw+/w3cJmlAW4GkLwDjgf0Li8pagqSvkIZr+Bvwk+znKUXG1BFf3K0g6fCI+FM2wfhSIuLMZsdkxYuIcyQtAm7N7lD9PKkP954RMaPQ4Aoi6WDgxohYKOlHpMnWf1bG4SuA7wA7AfdGxJ7ZMN4/KTimmlzjX1qf7OdaNR6lI+k79ZSt7CLij8BPgQdJ9zbsVtaknzkpS/q7A/8PmEDqAVZGi3JDuPeKiCeArQqOqSa38Vun2sYjqSh7sG0M9jKQNJ32mdg2BeayAsyt2khtx4CkXwDTI+LPZTsu2mRzcx8FHEcal/8VoGdE7FdkXLU48VeQdEJEnF4xIuViEfHtAsIqhKTDSDXbT5LaL9usBbwfEXsXElgBas2p2qZV51ZtpGx+gheAvYEdSfc43B8R2xcaWBNJ2gF4ON93X9KnSKNz3hgR79Tatkhu41/a49nPyYVG0RruBWYB65HGZ2mzEJhWSEQFKWNir8MhwD7AGRGxQNKGwPcLjqnZzgU2kzQVuAu4m9TO/1qxYXXMNf4Kko4j/QEfjIiWnUihGSRNiYgdJU2MiNLNo2odqzYU8Yo2PPHyIGkN0hSUu2aPnYCXgLsi4ptFxlaLa/xL2xj4NbC1pGmkb/C7gHsi4uVCI2u+HpJOBras1svJPZxKb4mJxCWtQmryKZWIeBOYJOkB4D7SGF9fIp0NtSQn/goRcTyApNWAoaRv8C8D50haEBHbFBlfkx1KmmB8VUrao6ma7NjYMlt8MiLeLTKeZpP0Q9I4TqtLamvSEGlk2/GFBVaA7F6OXUmz0r0NtCX/3XPjfLUcN/XUkE3Csgvp23sX0njb0yPiqCLjKoKkfSPihqLjaAWShpO6Lc4gJbuPAGNa9Q7NRsmmXTw3Ir5cdCxFkvQ68ARpYprbV5Txq5z4K0gaTzqFXUj65r6XdLHmlQ43XIlJ2oA0y9JGEbGvpG2AXSLivIJDazpJU4AvRMST2fKWwMURUbomjrZrQEXHUaSseWt72tv3tyJ1iLiH1Dx8a4Hh1eQbuJa2CdCLdHHmBWAmsKDIgFrAhaRb0DfKlp8i9Vcuo55tSR8gq+H1LDCeIt0raaeigyhSRLwfEVMj4ncR8QVgP9JMfUcBNxcbXW2u8VehNNXWtrR/i38CeJn0DX5ykbEVQdIDEbFT/uYcSQ9FxA4Fh9Z0ks4n3d/xx6zoi8CqJW0CfIx0reM5Snozm6RBtOeJXYHVSLX9u0m9elqyW7gv7laR3YzxiKQFwKvZ4wBSl63SJX7gDUnrkt3QJmkY6TMpo28AxwDfJiW624H/KjSi4uxbdAAt4EJSr78bSENYrBD3e7jGX0HSt0nf3LsB75J15cx+To+IDwoMrxCShpAmH/kE8AgwAPhcRJTqJi5bmqTtSXd2A9wREQ8XGY/Vx4m/gqQzaT9Nm1V0PK0im3N4K1Itt4xdGC+LiENyY/YsoUzNG22ygfq+SvtUi58BxkfEb4uLyurhxG91kbQrMJBc82BE/E9hATWZpA0jYlatMXtWlFP85Sm7wXGXiHgjW+5Dug5Wui/BFY3b+K1Tkv4IfBR4CHg/Kw6gNIk/S/qrAOeVaXC6Toj244HsuQqKxbrAid/qMRTYJkp+ehgR70t6s9r8uyV1AXBfNiSxgFFA6e7tgMX3c3yfNGR3/qx4r8KC6oATv9XjEeBDpBtTym4RMF3SzaQujEC5hutuExFnSpoE7J4VHRURDxYYUpEuJ929ew5LngW1JCd+q0nSX0lNOmsBj0m6nzQeCQARcVBRsRXo+uxh7QR8QLmbed6LiBVm9jFf3LWasgklaoqIvzcrFms9kn4MHAxcQUr6o4HLI+JnRcZVBEmnAHOAq1iyctSSI/o68VtNkm6KiE8XHUcrkbQF8AtgG6B3W3lEbF5YUAWR9DgwODfX7OrA1Ij4eLGRNZ+kf1YpjlY9LtzUYx1Zr+gAWtAFpLu3fwXsSRqTpaxNHDNIX36LsuVewLOFRVOQbKTScRFxadGx1Ms1fqtJ0j+A42utj4gra61bWeVmJZseEdtlZXdExCc723ZlI+lq0mxTN5OuBY0E7iQ1eZTqgrek2yNij6LjqJdr/NaRtUljFFWr0Qbtd2yWyaKshve0pGNJI7iuX3BMRbkqe7SZVFAcreBmSccDl7Jkby+38duKRdLUiBhSdBytJBuG+HHSxDz/TvpyPD0i7i0yriJJ6kkax+mFiJhTdDxFWNHa+J34rab8MMxmbST9AfhtRDyazVR3D6nven/g+Ii4uNAArVNO/FaTpE9ExCNFx9EKJF3b0foy3dMg6dGI2DZ7fhwwPCJGS/oQcEMZKwuS1gC+B2wSEWOz3l9bRcR1BYdWldv4rSYn/SXsAvwfcDFpSs6y9uSBNKl6m5Gku1aJiJfSHEaldAEwhTSkO6SZ+y4HWjLxe+pFs/p8CDiR1Jb9a1LCmxcRfy/hjWwLJB0gaTBp3oobYfHQ3asXGllxPhoRp5Pm8CAi3qKFKwdO/GZ1yOZWvTEixgDDgGeASZK+VXBoRfgacCyplntcRLyUlY+gvMNZvJPdwNY2S91Hyd3B22rcxm811Zp0pE3Zxl2X1AvYHziMNDfBtcD5EfFCkXFZ8SSNBH5EuqP7JtKZ0JERManIuGpx4reacpOOHJP9zE8w/mZE/LT5URVD0gRSM88NwCW+/mGVsnmph5GaeO6NiHkFh1STE791StJdEbFbZ2UrM0kf0H5jTv6fRqT+2n2bH5UVLZuPuqaImNqsWLrCvXqsHn0k7R4Rd8LiaRj7FBxTU0WEr4dZNb/MfvYmTVj0MKkyMIjU+2v3GtsVyonf6nE0cH52sw7AAuDLxYVjRZJ0eET8SdL3qq2PiDObHVNRImJPAEmXAGMjYnq2/Ak6GOeqaE781qmImAJsL6kvqXnQ0w6WW9vZ3lqFRtFatm5L+pDugZG0Q4HxdMht/NaprDfLv5J6suTnEy3NxV2zjki6mHQN6E+ka0CHA2tGxGGFBlaDE791StKNwKukOxMXzycaEb+suZGttCSdEBGnS/otVbr7lmk45jaSegPfANqGZr4d+H3bJDWtxk09Vo+NI2KfooOwlvF49nNyoVG0kIhYJOls4BbSl+GTEfFuwWHV5MRv9bhb0nb5NkwrtY9mw1NfFBHvFR1MK5A0HJhAmpVMwEckjYmI2wsMqyY39VinJD0GfAz4J+k29La+66W6c9cSSWeQBiPbGpgG3A3cBdzTqhOPNJqkKcAXIuLJbHlL4OKI2LHYyKpz4rdO5e7gXUJEPNfsWKx1SFqN1Hd9V9LopbsACyJim0IDK4CkaZUVoWplrcJNPdaptgQvaX3SjSpmkEbi7EuahWxt4EWgrM2BkyWdx5LDmkwpMJ4OucZvnZJ0EOkOxY1IE2lvCjzeNhmHlYuk8cC2wELS3an3ksameaXQwAqUdXk+hnSnrki9ev4rIlpyhE4nfuuUpIeBvYBbImKwpD2BwyJibMGhWQGy7r3rAY+Q2vfvAR4JJ5MVhhO/dUrS5IgYmn0BDI6IDyTdHxE7Fx2bFUNpqq1tSe37u5JGLn2ZdIH35CJjayZJ0zpa7zZ+W5EtkLQm6fT1IklzAHfjK7Gsdv+IpAWkm/teBQ4AdgZKk/iBD0j99v8M/BV4q9hw6uMav3VKUh/SAd2DdNFqbVIf7vmFBmaFkPRtUi1/N9JUg3eRmnvuAqZHxAcFhtd0krYmTc5zIPAY6Uvgpla+x8GJ3zokaRXgbxGxd9GxWGuQdCZZ3/2ImFV0PK1E0ueBs4HTIuI/i46nFjf1WIci4n1Jb0pa26NyGkBEVB2OuawkfRg4FPgM8ArwXeCqQoPqhBO/1WMRMF3SzbTPQlXKwbjM8iT9nTQ89WXAkaQL3ACrSerfqncyu6nHOiVpTLXyiJjQ7FjMWomkGbSPUFptSs7Nmx5UHZz4zcxKxvOIWk2SRkk6Jrd8n6R/ZI/PFRmbmXWfE7915ATg2txyL2AnYDhp0gkzWwH54q51ZLWI+L/c8p1Z3/35Wd9+M1sBucZvHemXX4iIY3OLA5oci5ktJ0781pH7JH21slDS14D7C4jHrGVJuq6j5VbiXj1WUzb+/tWkWbemZsU7ktr6R0fE7IJCM2spkvoDvfJ3MkvasFXvbHbit05J2os0EiPAoxFxa5HxmLUaSU8DDwEXADe0+hDVTvxmZssoG6Z6b+DLpBFKLwUujIinCg2sBid+M7PlKJuo6E/AmqSzgHERcU+hQVVw4jczW0aS1gUOB44AZgPnke6B2QG4PCI2Ky66pbkfv5nZsruHNNH66IiYmSufLOkPBcVUk2v8ZmbLSNIhEXFZRdnBEXF5UTF1xInfzGwZSZoaEUM6K2sVbuoxM+smSfsC+wEflvSb3Kq+tPC81E78Zmbd9yIwGTgImJIrX0iaiasluanHzGwZSVq1lSdXr+TEb2a2jCT9kyVn4AKgVWfgclOPmdmyG5p73hs4GOhfUCydco3fzKwBJN0ZEbsXHUc1rvGbmS0jSflumz1IZwBrFRROp5z4zcyW3S9zz98DZgCHFBNK59zUY2ZWMq7xm5ktA0lbAWOBrbOix4HxrTokM3jqRTOzbpO0CzAJeB0YD5wDvAFMkjSswNA65KYeM7NuknQDcFpETKoo/xRpHP59CwmsE078ZmbdJOmpiNiyxronI2KrZsdUDzf1mJl138IO1r3RtCi6yBd3zcy67yMVo3K2EfDhZgdTLyd+M7Pu+34H6yY3LYouchu/mVnJuI3fzKxknPjNzErGid/MrJsknZb9PLjoWLrCid/MrPv2k9QT+GHRgXSFe/WYmXXfjcA8oI+k10jdOKPtZ0T0LTK4Wtyrx8xsGUm6JiJGFR1HvZz4zcyWA0kbADtli/dFxNwi4+mI2/jNzJZRdnH3ftJcu4cA90v6XLFR1eYav5nZMpL0MDAyIuZkywOAWyJi+2Ijq841fjOzZdejLeln5tPC+dW9eszMlt2Nkv4GXJwtfx743wLj6ZCbeszMlgNJnwV2J3XlvD0irio4pJqc+M3MSqZl26DMzKwxnPjNzErGid/MrGTcq8fMrJskTSeNzbPUKtJYPYOaHFJdfHHXzKybJG3a0fqIeK5ZsXSFE7+ZWcm4qcfMrJskLaTjph4Py2xmZsVzjd/MbDmRtD7Qu205Ip4vMJya3J3TzGwZSTpI0tPAP4G/AzOAGwoNqgNO/GZmy+7fgWHAUxGxGTACuKvYkGpz4jczW3bvRsR8oIekHhFxG7BDwTHV5DZ+M7Nlt0DSmsDtwEWS5gDvFRxTTe7VY2a2jCT1Ad4itaJ8EVgbuCg7C2g5TvxmZt0k6WPABhFxV0X5HsALEfFsMZF1zG38ZmbddxawsEr5m9m6luTEb2bWfQMjYlplYURMBgY2P5z6OPGbmXVf7w7Wrd60KLrIid/MrPsekPTVykJJRwNTCoinLr64a2bWTZI2AK4C3qE90Q8FVgM+ExEvFRVbR5z4zcyWkaQ9gU9ki49GxK1FxtMZJ34zs5JxG7+ZWck48ZuZlYwTv5WepIGSInsMz8qOzJaPLzY6s+XPid9sSScWHYBZoznxm7V7DRgpaWi+UNJZkuZKelvSPyR9LbcuJD0p6U+SFkr6naQvZK9/VtKQ7HVrSzpf0hxJ8ySNl7RGk38/M8CJ3yzvTuARlq71Pw78G3A8MBs4W9KmufVbAs8CTwLHZK/7LbA58OPsNWcBRwAXAucCRwM/bcDvYNYpj8dv1i6AU4E/Ak/nyjcHjgXyNfSPA89lz1+IiJMlrQrsCJxNSvA/ATbLXnMA6f/t+7l9fHo5x29WF9f4zZZ0CWne1K9ny72BE4CngM8A5+fK2yzIfr6b/Xw1It7Pnq+Se91LwMjc45jlGbhZvZz4zXKyhH060DcrUvZzdWADYO9u7vo64EPAQcCmwGeBz3c/UrPuc+I3W9qFwIvZ87eAXwEbAV8BbujmPo8jte0fAvyaNDF3y07GbSs3D9lgZlYyrvGbmZWME7+ZWck48ZuZlYwTv5lZyTjxm5mVjBO/mVnJOPGbmZWME7+ZWcn8/3lfXCFlGTAaAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "#What is the Top five bestseller gems?\n",
    "project.groupby(['Name'])[['Global_Sales']].sum().sort_values('Global_Sales',ascending=False).iloc[0:5].plot(kind='bar');\n",
    "plt.title('Top five bestseller gems',fontsize = 20,weight='bold',color='black');\n",
    "plt.xlabel('Name',fontsize = 10,weight='bold',color='black');\n",
    "plt.ylabel('Global Sales',fontsize = 10,weight='bold',color='black');"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 655,
   "id": "a31adc65",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Global_Sales</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Publisher</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Electronic Arts</th>\n",
       "      <td>889.7900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nintendo</th>\n",
       "      <td>857.7800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Activision</th>\n",
       "      <td>551.3300</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Global_Sales\n",
       "Publisher                    \n",
       "Electronic Arts      889.7900\n",
       "Nintendo             857.7800\n",
       "Activision           551.3300"
      ]
     },
     "execution_count": 655,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Who is the top selling publisher?\n",
    "project.groupby(['Publisher'])[['Global_Sales']].sum().sort_values('Global_Sales',ascending=False).iloc[0:3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 656,
   "id": "cb8559f0",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYUAAAFaCAYAAADxS0GyAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAApYElEQVR4nO3de7wd873/8dc7RCIhJIQiCE5QjpB0u5UqohcU6cWt1YZq/epEi562Lq3KOaWlVdWqOg9H26SlyHE/etpqEzlFERER15ASsSXN9RBB4vb5/fGdPZms7MvayV571t77/Xw81mPPfGe+sz7rtj/z/c7MdxQRmJmZAfQqOwAzM6sfTgpmZpZzUjAzs5yTgpmZ5ZwUzMws56RgZmY5JwXrMiSNlxTZY07FsjmFZeML5UML5SHp5E4Ou25JGld8b9pR7+CK9/Tgdd1mC88zpbCtKeuyLauek0KdqPinVu1jfNlxm1n3sn7ZAZjV2FLgm4X5h8sKpIe4G1hedhC29pwU6sfFwCYVZT8qTD8PXF2x/ImaRtQNRMQy4LKy4+gpIuJvwN/KjqOjSVof6B0Rb5YdS81FhB91+gCi8JjSwjr/DFwDPAu8AbwJzAZ+CezZzPrjKrbbB7ggq78SaASuADZpZ6wfBe4AXs628wYwF7gH+CGwczN13k9KdM8Ar2exzwJ+AmzTzPrjC3HPqVg2p7BsfKF8aMXrPbmw7OSKZTsCXwFmZLEsBn4HbN3Caz4RmJatuyhbd2hrcbbxHq72GoBhwE3Ztt8EHgFOaqbelJa+J8DBFa/x4Fa+C72Bc7PPYEVL34X2bLOi3kDSzs8MYBnwdvYePwlcB3yptdcFbAZcmcW1EniO1ApUK9/J/wJeytZfBkwFvgH0q+L934P0nV5S+Tq786P0APxo5cNpIykApwFvVaxXfLwNnF5Rp/IfwV9aqPsYsFGVcX6ulRjW+Gec1Tk1+6G2tP5S4ICKOuMLy+dULFvtB10oH9pSHKyZFP7aQixPA30qnu/8FtZdBNzfUpxtvI/F1/Aw8EoLz/HdinpTWvqe0L6k8N/VfBfas81CeR/g8Ta+I5WfafF1PUNqLTdX78KKeiLtKLX2XDOBLVp5/6eTusGafZ3d+eHuoy5K0gdJe9lNJwssBn4LvAt8AdiC1D14laTHI+K+FjZ1KGkP9+/AUcBeWflw4N+Br1cRzlcL07NIe2dvAUNIrYH9K2Lfl/SjbYr9cdIemYATgJ1Ie5W3SRoWEa9WEUNH+BAwidT9MZq0pwiwazZ/E4CkvYDvFeq9AfyKtHc9BvhgB8TSAPyD9D71AU4BNs6WXSjpvyPi0Q54nqIjWffvQksOIbVqAd4jfVdnkT7n7YAD26i/C+n9vZrUajod2DBb9nVJ34+It7P5fwW+XKj7B+ABYDDpt7EJ6bO9jtSaaM4I0m/p+izOfyK1Zru/srOSHy0/aKWlANxSWPYOsGth2TBSK6Fp+R2FZeMqtntBYVkfUjdS07JlwPpVxDmjUOeEZpYPoLBXBtxcWH8GsEFh2SDSj75p+VmFZeML5XMqnmNOYdn4QvnQitd7cmHZyRXLbiXrisjieKew7MeFer+oqPexwrJdKurNaev9a+E1vAXsVFh2SMVz/qKwbEor35ODK+odvK7fhfZss1A+ulD+NM10+RRfbzOvK4BjCsvOrFi2R1beC1jY3PuULT+8ot5eLbz/AYwu+39AGQ+fktp1FfesHoiIZ5pmIuI5oNgyOKCV7Uwo1FsJ3FhYtjGwcxWx/LUwPV7S/0r6paRzJI0C3oyIhYV1PlSY3hNYWTivfQnQt7C8rT3IjnR1ZP8dImIpqfXVZGBheu/C9MsR8aemmYiYxerv/dq6LyL+XtjuPaS+8SYNHfAclTriu9CSh0nJHlLL6++SbpX0I0ljJG1ffL3NmBcRdxTmZ1Usb/p8diG1CJqcXnHdxP9U1Gvp+/VERNzeSjzdlruPuq5Bhel/NLO8WDawmeVNFrQx31rdJueTugCOJu1hHpQ98lgkfSYi7s/mB1G9wW2v0mHmVMyvLEwXd6A2LUzPb2Y7zX0e7VX5OTSVbZtNt/S5qGK+zzo859p8F5oVES9LOgm4CngfsEP2yFeRdB0wpikxV5hTMb+yYr7p82nPdwta/n4900J5t+ek0HUtJR03gPQjq1Qs+79WtrMl6Syh4nzRK20FEhHLgdGStgT2I3VfDSP1S2+VxfJb0tk9lbE/SurHbkljW8/fgd6umG/unxOs/p5s0czy5j6P9qr8HCrLijG8V5jekNUNa+dzrtN3oTURcaukO4APkPr0dwJGAh8jJbPPk058+E0z1av9bJZWzN8MPNRKWA+0UN4zjh80w0mh67of+GQ2vb+kXZu6kCQNY/Vm8f2VlQvGkB00ldSHdKC3yWus2Uxfg6R/Bp6LiAWkA8ZN5X8iHfsA2EHSZhGxhNS98qmsfGvguoj4R8U2ewGjSKfX1puprOq+2U7SgZEdyJe0Cx3T5XWgpJ2aulQkHcKqVgKsfhHeK4XpXSRtGhGvSNoEGNuO51zn70JLJG0KDIqI50nv39TCspmsOqi/N80nhWrNIp0B1tQCGARcERHvVMSzIXBcofVqGSeFruvHpIN3AtYD7pX0G9Je4xdY9dlGtm5L/k3Srqw646S4Z/mryh9TCy4BPiRpMmlPcwHp4PKJhXWarl2AdDHZaFKTf0vgcUk3Z3X7kfqcP0z6YR8CvFBFDJ3pGtL1DE1dFr+X9GvS3uwY0uexrnoD90n6LbAB8MXCsgCuLcw/xKodhAHAo5Kmko4lbdOO5+yI70JL/gl4WNJjpOst5pO+D3uxKiHAmnv67RIR70m6DLg0KzqU9P26i3S8ahDpbKqDSK2qCc1uqAdzUuiiIuJ+SWOBn5E+x81Z85TBd4GzI+KvlfULfg98tpnyJ4DvtiOkAaR/9C35SWRXg0bEA5JOI53FswEp9q+047lKFRGPSbqAdCEWpNd+Zja9FHiQ1I0Gq3fttMcDpAO732xm2fciYnph/lek0zCb9o6HZg9In++RVT7nFDrmu9CaPbNHcxaxerJbWz8iJbQvZfO7Zg+rgs8+6sIi4mpS/+wvSXt3K0h75C+QTt/cOyKubGMznyIdKH6WdBrkPNJVowdFGiKiGj8GLid1C80lnWXyNmlv8A+k01TPq4j9l6Q9titJV7S+nsU+l3SdwCWkPd3WElppIuL7pH+g00lxLyVdn7EP6fTNJq0dz2nNs6SulBtIZ0GtJJ2+OyYiLqyIZRFpz/cuUjfPG6T38CjaN8TH4cCFpC67tf0utOQ54GxgIumU1CWknZblpOtUfgKMiIiXWtxClSL5MnAY6QyqOaT3b3kWx92kq5p3Wdfn6o6azsm2HkLSONIPH4CIqDxbxaogacNoZhwcSduR9qybLjT7j4g4vcptzgG2z2YnRMTJHRCqWbu4+8hs7XxX0oeB20nDL7xL6qIYy6qE8A5pT9usy3BSMFs7Ig3fsX8Ly98AvhgRT3VeSGbrzknBbO3cRTqzZ1/SGVT9WdVnPYnUbTSntOjM1pKPKZiZWc5nH5mZWa5Ldx9tvvnmMXTo0LLDMDPrUh555JHFEdHsuE9dOikMHTqUadOmlR2GmVmXIunFlpa5+8jMzHJOCmZmlnNSMDOzXJc+pmBm9entt9+msbGRFStWlB1Kj9a3b1+GDBlC7969q67jpGBmHa6xsZGNN96YoUOHInl4rTJEBEuWLKGxsZEddtih7QoZdx+ZWYdbsWIFm222mRNCiSSx2Wabtbu15qRgZjXhhFC+tfkMnBTMzCznYwrtMPTc35cdQk3NuaTaG3SZtU9H/3aq+a4uWLCAs88+mwcffJCBAweywQYb8K1vfYuBAwdy2WWXcdddd7VYd9y4cWy00UZ84xvfqDqmjTbaiOXLlze77L333uOss85i8uTJSKJv375MnDix1b7+gw8+mMsuu4yGhoYW16kFJwUz63YigtGjRzNmzBh+97vfAfDiiy9y5513MnDgwE6P56abbmLevHnMnDmTXr160djYSP/+/Ts9jmq4+8jMup3JkyezwQYb8JWvrLr19/bbb89Xv/rV1dZbunQpo0ePZvjw4ey3337MnDkzX/bYY49x6KGHMmzYMP7zP/8TgOXLlzNq1ChGjhzJHnvswR133FFVPPPnz2errbaiV6/0L3fIkCF5cjr99NNpaGhg991358ILL2y2/t13383+++/PyJEjOfbYY/MWybnnnstuu+3G8OHD29WqaY1bCmbW7Tz55JOMHDmyzfUuvPBCRowYwe23387kyZP5whe+wIwZMwCYOXMmDz74IK+//jojRozgyCOPZIsttuC2225jwIABLF68mP3224+jjz66zQO6xx13HAceeCD33nsvo0aN4qSTTmLEiBEAXHzxxQwaNIh3332XUaNGMXPmTIYPH57XXbx4MRdddBF/+ctf6N+/P5deeimXX345Z5xxBrfddhvPPPMMknjllVfW+v0qckvBzLq9sWPHsueee7L33nuvVn7ffffx+c9/HoBDDz2UJUuW8OqrrwJwzDHHsOGGG7L55ptzyCGHMHXqVCKC888/n+HDh3PYYYfx8ssvs2DBgjaff8iQIcyaNYsf/OAH9OrVi1GjRjFp0iQAJk6cyMiRIxkxYgRPPvkkTz21+s36HnzwQZ566ikOOOAA9tprLyZMmMCLL77IgAED6Nu3L1/60pe49dZb6devX0e8VW4pmFn3s/vuu3PLLbfk81dddRWLFy9e46BtczcZa9rrr9z7l8T111/PokWLeOSRR+jduzdDhw6t+jqAPn36cPjhh3P44Yez5ZZbcvvtt7Pjjjty2WWX8fDDDzNw4EBOPvnkNbYXEXzkIx/hhhtuWGObU6dOZdKkSdx44438/Oc/Z/LkyVXF0hq3FMys2zn00ENZsWIFV199dV72xhtvrLHeQQcdxPXXXw/AlClT2HzzzRkwYAAAd9xxBytWrGDJkiVMmTKFvffem1dffZUtttiC3r17c8899/Diiy2OQL2a6dOnM2/ePCCdiTRz5ky23357li1bRv/+/dlkk01YsGABf/jDH9aou99++3H//fcze/bs/HU8++yzLF++nFdffZUjjjiCK664Iu/2WlduKZhZzXX26c6SuP322zn77LP54Q9/yODBg/P++KJx48ZxyimnMHz4cPr168eECRPyZfvssw9HHnkkc+fO5YILLmDrrbfmc5/7HEcddRQNDQ3stdde7LrrrlXFs3DhQr785S+zcuXKfNtnnHEGffv2ZcSIEey+++7suOOOHHDAAWvUHTx4MOPHj+fEE0/M61900UVsvPHGHHPMMaxYsYKI4Cc/+cnavl2r6dL3aG5oaIjOvMmOr1Po2vz5dZ6nn36a97///WWHYTT/WUh6JCKavQDC3UdmZpZz95GZWQd5/PHH87OZmvTp04eHHnqopIjaz0nBzKyD7LHHHh12wLcs7j4ys5royscru4u1+QycFMysw/Xt25clS5Y4MZSo6SY7ffv2bVc9dx+ZWYcbMmQIjY2NLFq0qOxQerSm23G2h5OCmXW43r17t+sWkFY/3H1kZma5miYFSWdLelLSE5JukNRX0iBJf5b0XPZ3YGH98yTNljRL0sdqGZuZma2pZklB0jbA14CGiPhnYD3gBOBcYFJEDAMmZfNI2i1bvjvwceAXktarVXxmZramWncfrQ9sKGl9oB8wDzgGaBpgZAIwOps+BrgxIlZGxAvAbGCfGsdnZmYFNUsKEfEycBkwF5gPvBoRdwNbRsT8bJ35wBZZlW2AlwqbaMzKzMysk9Sy+2ggae9/B2BroL+kk1qr0kzZGic5SzpN0jRJ03y6m5lZx6pl99FhwAsRsSgi3gZuBT4ILJC0FUD2d2G2fiOwbaH+EFJ302oi4pqIaIiIhsGDB9cwfDOznqeWSWEusJ+kfkq3MBoFPA3cCYzJ1hkDNN35+k7gBEl9JO0ADAOm1jA+MzOrULOL1yLiIUk3A9OBd4BHgWuAjYCJkk4lJY5js/WflDQReCpbf2xEvFur+MzMbE01vaI5Ii4ELqwoXklqNTS3/sXAxbWMyczMWuYrms3MLOekYGZmOScFMzPLOSmYmVnOScHMzHJOCmZmlnNSMDOznJOCmZnlnBTMzCznpGBmZjknBTMzyzkpmJlZzknBzMxyTgpmZpZzUjAzs5yTgpmZ5ZwUzMws56RgZmY5JwUzM8s5KZiZWc5JwczMck4KZmaWc1IwM7Ock4KZmeWcFMzMLOekYGZmOScFMzPLOSmYmVnOScHMzHJOCmZmlnNSMDOznJOCmZnlnBTMzCznpGBmZjknBTMzyzkpmJlZzknBzMxyTgpmZparaVKQtKmkmyU9I+lpSftLGiTpz5Key/4OLKx/nqTZkmZJ+lgtYzMzszW1KylIGiBpSDuq/BT4Y0TsCuwJPA2cC0yKiGHApGweSbsBJwC7Ax8HfiFpvfbEZ2Zm66bNpCDpekk/lbQz8DLwoqRvV1FvAHAQ8EuAiHgrIl4BjgEmZKtNAEZn08cAN0bEyoh4AZgN7NO+l2NmZuuimpbCR4Bngc8AC4F7gX+pot6OwCLg15IelXStpP7AlhExHyD7u0W2/jbAS4X6jVmZmZl1kmqSwsbAW8AI4CbgWmCzKuqtD4wEro6IEcDrZF1FLVAzZbHGStJpkqZJmrZo0aIqwjAzs2pVkxSeBX5M6ub5G/A+YEEV9RqBxoh4KJu/mZQkFkjaCiD7u7Cw/raF+kOAeZUbjYhrIqIhIhoGDx5cRRhmZlatapLC6cA9wBXA74E+wH+0VSki/gG8JGmXrGgU8BRwJzAmKxsD3JFN3wmcIKmPpB2AYcDU6l6GmZl1hPXbWiEi/ibpWGA3YEBEXNyO7X8VuF7SBsDzwCmkRDRR0qnAXODY7HmelDSRlDjeAcZGxLvtejVmZrZO2kwKkkaQ9ua3Bj4u6WfA/RHx5bbqRsQMoKGZRaNaWP9ioD1Jx8zMOlA13Uc/B94gHQh+D7geOKyWQZmZWTmqSQp7AuML8/NYdRqpmZl1I212H5HOCvpwNj0cOBGYU6uAzMysPNUkhR+Srk0AuDz7e3JNojEzs1JVc/bRryT9HTiSdFzhroj435pHZmZmna7FpCBpZGH2NeDG4rKImF7LwMzMrPO11lKYRjPDTBR4BFMz6xRDz/192SHU1JxLjiw7hFxrSeE3tJ4UzMysm2kxKUTEyZ0Yh5mZ1YFqrmjuD3wN2APomxVHRHy6loGZmVnnq+aU1GuB40ldSU3DW7tbycysG6rmiubDSENdQEoONwNt3nnNzMy6nmqSwkbATFIrYVPgYWBsDWMyM7OSVDvMxUbA34GrScnhpVZrmJlZl1RNUvgKsByYAVySlZ1Xq4DMzKw81QxzMakwu18NYzEzs5K1eExB0omSvppNbyvpAUmvSbpf0m6dF6KZmXWW1g40XwDsmE1fBOwLvE26k9rPW6pkZmZdV2tJYTvgsWz6SGAFsBPwHeADNY7LzMxK0FpSeAv4J0mHAoOAByLi/4Bl+OI1M7NuqbWk8BfgfODPpCRwQ1b+QdLpqWZm1s20dvbRaaRrFHYB7o2IayX1BvqQrlcwM7NuprVRUl8Bvl5R9jZwQo1jMjOzklQzzIWZmfUQTgpmZpZzUjAzs1yLxxQkjWytYkRM7/hwzMysTK2dfTSN1q9HWK+DYzEzs5K1lhR+gy9SMzPrUVo7JfXkTozDzMzqQJtDZ0vqD3wN2APomxVHRHy6loGZmVnnq+YmO9eS7s0cpLuugbuVzMy6pWpOST2MVUNlHw/cDHy7ZhGZmVlpqkkKGwEzSa2ETYGHgbE1jMnMzEpSTfdRIykx/J00EJ6Al2oZlJmZlaOapPAVYDkwA7gkKzuvVgGZmVl52kwKETEpGzJ7F+BLwKxstFQzM+tm2jymIOkQYA7p1pyPAc9LOrimUZmZWSmqOdD8S9IxhetJd18bkJVVRdJ6kh6VdFc2P0jSnyU9l/0dWFj3PEmzJc2S9LH2vRQzM1tX1SQFAedGxBci4iTS8YRqjkU0ORN4ujB/LjApIoYBk7J5JO1GuoHP7sDHgV9I8vhKZmadqMWkIGlkNlLqzcDxkg7OupKOJY2L1CZJQ4AjSRfANTkGmJBNTwBGF8pvjIiVEfECMBvYpx2vxczM1lG1o6SKtFffNH0QcEEV278C+BawcaFsy4iYDxAR8yVtkZVvAzxYWK8xK1uNpNNI949mu+22qyIEMzOrVs1GSZX0CWBhRDxS5YFpNVO2xvNHxDXANQANDQ0ebsPMrANVPUqqpH5Z+RtVbvsA4GhJR5AG0hsg6TpggaStslbCVsDCbP1GYNtC/SHAvCqfy8zMOkA1p6RuI2kK8BrwmqTJktbo1qkUEedFxJCIGEo6gDw5O1B9JzAmW20McEc2fSdwgqQ+knYAhgFT2/uCzMxs7VVzFtFVwIHAA9n8QcCVwKfW8jkvASZKOhWYSzpwTUQ8KWki8BTwDjA2It5dy+cwM7O1UE1S+DDw7Yi4FEDSOcA57XmSiJgCTMmmlwCjWljvYuDi9mzbzMw6TjVJ4Q1gZ0nrkw4G7wy8WdOozMysFNVcvDYROIWUCN4ATgZuqmFMZmZWkmpaCueQDjIfQTpF9PfA92sZlJmZlaOaUVLfAr6bPczMrBtrMSlIWtZKvYiITWoQj5mZlai1lsJS1uGKZjMz63pau6J5aCfGYWZmdaC17qMhwHbAI6SzlL5ZWPz7iHikxrGZmVkna6376OfAdhExUtJmwDhWdSftDhxf49jMzKyTtZYU9iENfV30PWAr0k1wzMysm2nt4rXNgFey6eXA2aSb5TwEbFnbsMzMrAytJYX5wHGSlN0N7acR0UgawG5hK/XMzKyLaq376BZS62CmpD+TjieMAvZgzW4lMzPrBlpLChcAHyANlb17oXwK1d2K08zMupjWrlN4AzhY0qGk5AAwLSLu6ZTIzMys01Uz9tFkYHInxGJmZiWrZuhsMzPrIZwUzMws56RgZmY5JwUzM8s5KZiZWc5JwczMck4KZmaWc1IwM7Ock4KZmeWcFMzMLOekYGZmOScFMzPLOSmYmVnOScHMzHJOCmZmlnNSMDOznJOCmZnlnBTMzCznpGBmZjknBTMzyzkpmJlZrmZJQdK2ku6R9LSkJyWdmZUPkvRnSc9lfwcW6pwnabakWZI+VqvYzMysebVsKbwD/GtEvB/YDxgraTfgXGBSRAwDJmXzZMtOAHYHPg78QtJ6NYzPzMwq1CwpRMT8iJieTb8GPA1sAxwDTMhWmwCMzqaPAW6MiJUR8QIwG9inVvGZmdmaOuWYgqShwAjgIWDLiJgPKXEAW2SrbQO8VKjWmJWZmVknqXlSkLQRcAtwVkQsa23VZsqime2dJmmapGmLFi3qqDDNzIwaJwVJvUkJ4fqIuDUrXiBpq2z5VsDCrLwR2LZQfQgwr3KbEXFNRDRERMPgwYNrF7yZWQ9Uy7OPBPwSeDoiLi8suhMYk02PAe4olJ8gqY+kHYBhwNRaxWdmZmtav4bbPgD4PPC4pBlZ2fnAJcBESacCc4FjASLiSUkTgadIZy6NjYh3axifmZlVqFlSiIj7aP44AcCoFupcDFxcq5jMzKx1vqLZzMxyTgpmZpZzUjAzs5yTgpmZ5ZwUzMws56RgZmY5JwUzM8s5KZiZWc5JwczMck4KZmaWc1IwM7Ock4KZmeWcFMzMLOekYGZmOScFMzPLOSmYmVnOScHMzHJOCmZmlnNSMDOznJOCmZnlnBTMzCznpGBmZjknBTMzyzkpmJlZzknBzMxyTgpmZpZzUjAzs5yTgpmZ5ZwUzMws56RgZmY5JwUzM8s5KZiZWc5JwczMck4KZmaWc1IwM7Ock4KZmeWcFMzMLOekYGZmubpLCpI+LmmWpNmSzi07HjOznqSukoKk9YCrgMOB3YATJe1WblRmZj1HXSUFYB9gdkQ8HxFvATcCx5Qck5lZj7F+2QFU2AZ4qTDfCOxbXEHSacBp2exySbM6KbYybA4s7qwn06Wd9Uw9hj+/rqu7f3bbt7Sg3pKCmimL1WYirgGu6ZxwyiVpWkQ0lB2HrR1/fl1XT/7s6q37qBHYtjA/BJhXUixmZj1OvSWFh4FhknaQtAFwAnBnyTGZmfUYddV9FBHvSDoD+BOwHvCriHiy5LDK1CO6yboxf35dV4/97BQRba9lZmY9Qr11H5mZWYmcFMzMLOekYGZmOSeFOiLph5IGSOotaZKkxZJOKjsuM+s5nBTqy0cjYhnwCdI1GzsD3yw3JGsPSUMk3SZpkaQFkm6RNKTsuKxtkj4o6bOSvtD0KDumMtTVKalG7+zvEcANEbFUau4ib6tjvwZ+BxybzZ+UlX2ktIisTZJ+C+wEzADezYoD+E1ZMZXFSaG+/LekZ4A3gX+RNBhYUXJM1j6DI+LXhfnxks4qKxirWgOwW/gcfXcf1ZkLgf2Bhoh4G3gDOLrckKydFks6SdJ62eMkYEnZQVmbngDeV3YQ9cAXr9URSdMjYmRbZVa/JG0H/JyU3AP4G3BmRLxYamDWKkn3AHsBU4GVTeUR0eN2ytx9VAckvY80bPiGkkawarTYAUC/0gKzdouIubh11xWNKzuAeuGWQh2QNAY4mdSv+TCrksIyYEJE3FpSaFYlSVdSMcx7UUR8rRPDsbUgaUtg72x2akQsLDOesjgp1AlJvYATI+L6smOx9ssSO8ABpFvJ3pTNHws8EhFnlxKYVUXSccCPgCmknbIPAd+MiJvLjKsMTgp1RNJfI+KgsuOwtZf1TX80O1EASb2BuyPikHIjs9ZIegz4SFPrIDvz7y8RsWe5kXU+n31UX/4s6RuStpU0qOlRdlDWLlsDGxfmN8rKrL71quguWkIP/f/oA8315YvZ37GFsgB2LCEWWzuXAI9mLQaAD+ODmF3BHyX9Cbghmz8e+J8S4ymNu4/qnKQNIuKtsuOw6mVnk+2bzT4UEf8oMx6rjqRPk44JCfhrRNxWckilcFKoQ0pjWxwCfBY4KiK2LDkkawdJ2wDbU2iJR8Rfy4vIrHruPqojkvYlJYJPAoNI3UgeEK8LkXQpqevhSeC9rDgAJ4U6JOm+iDhQ0musfkqxgIiIASWFVhq3FOqApIuB44C5pD7N24BpEbFDqYFZu0maBQyPiJVtrmxWh3rk0fU6dBqwALgauC4iltDKhVBW155n1Wi31kVI2klSn2z6YElfk7RpyWGVwi2FOiBpPeCjwInAocA9wGHAthHxTpmxWftIugXYE5jE6mPo+IrmOiZpBmlEgaHAn4A7gV0i4ogSwyqFjynUgYh4F/gD8AdJfUk32ekHvCxpUkR8ttQArT3uzB7WtbwXEe9I+iRwRURcKenRsoMqg5NCnYmIFcDNwM2SBpAOOlsXERETJG0IbBcRs8qOx6r2tqQTgTHAUVlZj+wG9DGFOhYRyyJiQtlxWPUkHUW6e9cfs/m9JLnlUP9OIQ13fnFEvCBpB+C6kmMqhY8pmHUgSY+QjgtNiYgRWdnjEbFHuZGZVcfdR2Yd652IeLXi3tre86pTkiZGxHGSHqeZzykihpcQVqmcFOqIpLHA9RHxSjY/kDSc9i9KDcza4wlJnwXWkzQM+Brp7mtWn87M/n6i1CjqiLuP6oikGRGxV0XZo03dEFb/JPUDvk06xRjS6Y3f88Vs9U3S2cDEiHi57FjK5gPN9aWXCv0O2fULG5QYj7XfkRHx7YjYO3t8B9+esysYANwt6V5JY7O7sPVIbinUEUk/Il088x+k/s2vAC9FxL+WGZdVT9L0iBjZVpnVJ0nDSWNXfRpojIjDSg6p0/mYQn05B/h/wOmkAbnuBq4tNSKriqTDgSOAbST9rLBoAOCr0ruOhcA/SDfZ2aLkWErhloJZB5C0J7AX8O/AdwuLXgPuiYj/KyMuq46k00kthMGki0dvioinyo2qHE4KdcCnxXUfkno33Z/Zug5JlwA3RsSMsmMpm5NCHZC0VUTMl7R9c8sj4sXOjsnWjqQDSLffbLrJTtO4/L6lah2SNCAilrV0L/SIWNrZMZXNScGsA0l6BjgbeAR4t6k8Gw7d6oykuyLiE5JeILXSi1cd9shk7qRQRyR9CriUdIBL9OC7P3VVkh6KiH3bXtOsPjkp1BFJs0n3ZH667Fhs7WR90+sBt7L6/RSmlxaUtSkbon5UW2U9gU9JrS8LnBC6vKZWQkOhLEiD5Fmdye5f0g/YPBtWpqn7aACwdWmBlchJob5Mk3QTcDur72XeWlpE1i4RcUjZMVi7/D/gLFICeIRVSWEZcFVJMZXK3Ud1RNKvmymOiPhipwdj7SLppIi4TtLXm1seEZd3dkxWPUlfjYgry46jHrilUEci4pSyY7C11j/7u3GpUdjaek/Sph6h2C2FuiJpCHAlcACpH/o+4MyIaCw1MLNuziMUr+KWQn35NfA74Nhs/qSs7COlRWRVkfTdVhZHRHyv04KxtdFLkiLbS+7JIxS7pVBHWthbWaPM6o+k5kay7Q+cCmwWERt1ckjWDi2MUDw3Ir5RZlxlcEuhviyWdBJwQzZ/Imm0RqtzEfHjpmlJG5Pu6HUKcCPw45bqWd04BziNVSMUPwpsVWpEJfFNdurLF4HjSEP3zgc+k5VZFyBpkKSLgJmkHa6REXFORCwsOTRrQ0S8BzwIPE+6xmQU0COvGXJLoU5kfZjfjwjfpasLyrofPgVcA+wREctLDsmqIGln4ARWtcpvgp59vYmPKdQRSX8iDXPxVtmxWPtIeo90weE7rD78ucevqmPZ53YvcGpEzM7Knu+JA+E1cUuhvswB7pd0J/B6U6EvfKp/EeGu2K7p06SWwj2S/kg6BqTWq3RvTgr1ZV726MWqi6DclDOrkYi4DbhNUn9gNGnY8y0lXQ3cFhF3lxlfGdx9VEckHRsR/9VWmZnVTnbDnWOB4yOixw1k6KRQRyRNj4iRbZWZmdWKu4/qgKTDgSOAbST9rLBoAOnApZlZp3BSqA/zgGnA0aThe5u8RurjNDPrFO4+qiOSBgCvR8S72fx6QJ+IeKPcyMysp/BpdPXlbmDDwvyGwF9KisXMeiAnhfrSt3glbDbdr8R4zKyHcVKoL69Lys80kvQB4M0S4zGzHsYHmuvLWcB/SZqXzW8FHF9eOGbW0/hAc52R1BvYhXSp/TMR8XbJIZlZD+LuozoiqR9pXPczI+JxYKikT5Qclpn1IE4K9eXXwFvA/tl8I3BReeGYWU/jpFBfdoqIHwJvA0TEm/TwERvNrHM5KdSXtyRtSDYyqqSdSGP0m5l1Cp99VF8uBP4IbCvpeuAA4ORSIzKzHsVnH9UZSZsB+5G6jR6MiMUlh2RmPYiTQh0oXrDWnIiY3lmxmFnP5qRQByTd08ri6Ik3+jCzcjgpmJlZzmcf1QFJ3ypMH1ux7PudH5GZ9VROCvXhhML0eRXLPt6ZgZhZz+akUB/UwnRz82ZmNeOkUB+ihenm5s3MasYHmuuApHeB10mtgg2BpttvinTjnd5lxWZmPYuTgpmZ5dx9ZGZmOScFMzPLOSmYmVnOScF6HElDJUXhsVTSjdlghK3Vm5Ktv3kzy8Zlyz6TzYekJ9rY3vhsvYZ1e0VmHcdDZ1tP9ijwI+AzwPGkM8BO7aBtnwi80kHbapWk9SPinc54Luv+3FKwnmxeRNwAfCeb37e4hy/pM9n8uIp6Z0maL+kJScNb2PYNwGXZdkZLek7SSknzJP24Yt1PSpor6SVJH8rqbCLpV5IWSlos6ZrsHt7FFstPJS0GfB9v6zBOCtaT9ZY0GBidzc+tst5uwOXArsD4Ktb/N9L1J/9CShSvVyw/BLgGGAKMy8quAD6fbf9aUgvm3yvqjQDOAWZVGbdZm9x9ZD3ZR4GF2fTLwPnA4VXU+2ZE/F3S0cCBkjZpY/3ngGHAKGA6KQEUjYuIuyV9BxialX2C9Pv8ZkW8RWdExMwq4jWrmpOC9WQPAd8GlgJPRcRKSe+x6nexaRv1m8alausK0M8BnwIaSP/kzyK1Cposzf6+A6xXKP8HqbXQpPJ+3fPaeF6zdnNSsJ5scURMqiibA+wg6bPAGS3U+5GkB0i3TZ0eEcukVsct/AHwIvAYaW9/Z0lt/fbuIt2f++is3geA94B726hntk58TMFsdecAy4CLgGktrDMD+AapL/+LVWxzA9KQ6NcCG5O6fdo6W+isbP3jgJ+SEtD9VTyX2Trx2EdmZpZzS8HMzHJOCmZmlnNSMDOznJOCmZnlnBTMzCznpGBmZjknBTMzyzkpmJlZ7v8D9A7aM3XCc1AAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "project.groupby(['Publisher'])[['Global_Sales']].sum().sort_values('Global_Sales',ascending=False).iloc[0:3].plot(kind='bar');\n",
    "plt.title('Top selling publisher',fontsize = 20,weight='bold',color='black');\n",
    "plt.xlabel('Publisher',fontsize = 10,weight='bold',color='black');\n",
    "plt.ylabel('Global Sales',fontsize = 10,weight='bold',color='black');"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 657,
   "id": "2f9dd8c8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2697.8900000000003"
      ]
     },
     "execution_count": 657,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "project.Global_Sales.sum() - project.NA_Sales.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 658,
   "id": "54e0579f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1152.5700000000002"
      ]
     },
     "execution_count": 658,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "project.NA_Sales.sum() - project.EU_Sales.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 659,
   "id": "1498fb93",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5074.27"
      ]
     },
     "execution_count": 659,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "project.Global_Sales.sum() - project.JP_Sales.sum()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}