exercise-bar-charts-and-heatmaps.ipynb

{"cells":[{"metadata":{},"cell_type":"markdown","source":"**This notebook is an exercise in the [Data Visualization](https://www.kaggle.com/learn/data-visualization) course.  You can reference the tutorial at [this link](https://www.kaggle.com/alexisbcook/bar-charts-and-heatmaps).**\n\n---\n"},{"metadata":{},"cell_type":"markdown","source":"In this exercise, you will use your new knowledge to propose a solution to a real-world scenario.  To succeed, you will need to import data into Python, answer questions using the data, and generate **bar charts** and **heatmaps** to understand patterns in the data.\n\n## Scenario\n\nYou've recently decided to create your very own video game!  As an avid reader of [IGN Game Reviews](https://www.ign.com/reviews/games), you hear about all of the most recent game releases, along with the ranking they've received from experts, ranging from 0 (_Disaster_) to 10 (_Masterpiece_).\n\n![ex2_ign](https://i.imgur.com/Oh06Fu1.png)\n\nYou're interested in using [IGN reviews](https://www.ign.com/reviews/games) to guide the design of your upcoming game.  Thankfully, someone has summarized the rankings in a really useful CSV file that you can use to guide your analysis.\n\n## Setup\n\nRun the next cell to import and configure the Python libraries that you need to complete the exercise."},{"metadata":{"trusted":true},"cell_type":"code","source":"import pandas as pd\npd.plotting.register_matplotlib_converters()\nimport matplotlib.pyplot as plt\n%matplotlib inline\nimport seaborn as sns\nprint(\"Setup Complete\")","execution_count":3,"outputs":[{"output_type":"stream","text":"Setup Complete\n","name":"stdout"}]},{"metadata":{},"cell_type":"markdown","source":"The questions below will give you feedback on your work. Run the following cell to set up our feedback system."},{"metadata":{"trusted":true},"cell_type":"code","source":"# Set up code checking\nimport os\nif not os.path.exists(\"../input/ign_scores.csv\"):\n    os.symlink(\"../input/data-for-datavis/ign_scores.csv\", \"../input/ign_scores.csv\") \nfrom learntools.core import binder\nbinder.bind(globals())\nfrom learntools.data_viz_to_coder.ex3 import *\nprint(\"Setup Complete\")","execution_count":4,"outputs":[{"output_type":"stream","text":"Setup Complete\n","name":"stdout"}]},{"metadata":{},"cell_type":"markdown","source":"## Step 1: Load the data\n\nRead the IGN data file into `ign_data`.  Use the `\"Platform\"` column to label the rows."},{"metadata":{"trusted":true},"cell_type":"code","source":"# Path of the file to read\nign_filepath = \"../input/ign_scores.csv\"\n\n# Fill in the line below to read the file into a variable ign_data\nign_data = pd.read_csv(ign_filepath, index_col=\"Platform\")\n\n# Run the line below with no changes to check that you've loaded the data correctly\nstep_1.check()","execution_count":6,"outputs":[{"output_type":"display_data","data":{"text/plain":"<IPython.core.display.Javascript object>","application/javascript":"parent.postMessage({\"jupyterEvent\": \"custom.exercise_interaction\", \"data\": {\"outcomeType\": 1, \"valueTowardsCompletion\": 0.5, \"interactionType\": 1, \"questionType\": 1, \"questionId\": \"1_LoadIGNData\", \"learnToolsVersion\": \"0.3.4\", \"failureMessage\": \"\", \"exceptionClass\": \"\", \"trace\": \"\"}}, \"*\")"},"metadata":{}},{"output_type":"display_data","data":{"text/plain":"Correct","text/markdown":"<span style=\"color:#33cc33\">Correct</span>"},"metadata":{}}]},{"metadata":{"trusted":false},"cell_type":"code","source":"# Lines below will give you a hint or solution code\n#step_1.hint()\n#step_1.solution()","execution_count":null,"outputs":[]},{"metadata":{},"cell_type":"markdown","source":"## Step 2: Review the data\n\nUse a Python command to print the entire dataset."},{"metadata":{"trusted":true},"cell_type":"code","source":"# Print the data\nprint(ign_data) # Your code here","execution_count":7,"outputs":[{"output_type":"stream","text":"                        Action  Action, Adventure  Adventure  Fighting  \\\nPlatform                                                                 \nDreamcast             6.882857           7.511111   6.281818  8.200000   \nGame Boy Advance      6.373077           7.507692   6.057143  6.226316   \nGame Boy Color        6.272727           8.166667   5.307692  4.500000   \nGameCube              6.532584           7.608333   6.753846  7.422222   \nNintendo 3DS          6.670833           7.481818   7.414286  6.614286   \nNintendo 64           6.649057           8.250000   7.000000  5.681250   \nNintendo DS           5.903608           7.240000   6.259804  6.320000   \nNintendo DSi          6.827027           8.500000   6.090909  7.500000   \nPC                    6.805791           7.334746   7.136798  7.166667   \nPlayStation           6.016406           7.933333   6.313725  6.553731   \nPlayStation 2         6.467361           7.250000   6.315152  7.306349   \nPlayStation 3         6.853819           7.306154   6.820988  7.710938   \nPlayStation 4         7.550000           7.835294   7.388571  7.280000   \nPlayStation Portable  6.467797           7.000000   6.938095  6.822222   \nPlayStation Vita      7.173077           6.133333   8.057143  7.527273   \nWii                   6.262718           7.294643   6.234043  6.733333   \nWireless              7.041699           7.312500   6.972414  6.740000   \nXbox                  6.819512           7.479032   6.821429  7.029630   \nXbox 360              6.719048           7.137838   6.857353  7.552239   \nXbox One              7.702857           7.566667   7.254545  7.171429   \niPhone                6.865445           7.764286   7.745833  6.087500   \n\n                      Platformer    Puzzle       RPG    Racing   Shooter  \\\nPlatform                                                                   \nDreamcast               8.340000  8.088889  7.700000  7.042500  7.616667   \nGame Boy Advance        6.970588  6.532143  7.542857  6.657143  6.444444   \nGame Boy Color          6.352941  6.583333  7.285714  5.897436  4.500000   \nGameCube                6.665714  6.133333  7.890909  6.852632  6.981818   \nNintendo 3DS            7.503448  8.000000  7.719231  6.900000  7.033333   \nNintendo 64             6.889655  7.461538  6.050000  6.939623  8.042857   \nNintendo DS             6.840000  6.604615  7.222619  6.038636  6.965217   \nNintendo DSi            7.250000  6.810526  7.166667  6.563636  6.500000   \nPC                      7.410938  6.924706  7.759930  7.032418  7.084878   \nPlayStation             6.579070  6.757895  7.910000  6.773387  6.424000   \nPlayStation 2           7.068421  6.354545  7.473077  6.585065  6.641667   \nPlayStation 3           7.735714  7.350000  7.436111  6.978571  7.219553   \nPlayStation 4           8.390909  7.400000  7.944000  7.590000  7.804444   \nPlayStation Portable    7.194737  6.726667  6.817778  6.401961  7.071053   \nPlayStation Vita        8.568750  8.250000  7.337500  6.300000  7.660000   \nWii                     7.054255  6.426984  7.410345  5.011667  6.479798   \nWireless                7.509091  7.360550  8.260000  6.898305  6.906780   \nXbox                    7.303448  5.125000  8.277778  7.021591  7.485417   \nXbox 360                7.559574  7.141026  7.650000  6.996154  7.338153   \nXbox One                6.733333  8.100000  8.291667  8.163636  8.020000   \niPhone                  7.471930  7.810784  7.185185  7.315789  6.995588   \n\n                      Simulation    Sports  Strategy  \nPlatform                                              \nDreamcast               7.628571  7.272222  6.433333  \nGame Boy Advance        6.928571  6.694444  7.175000  \nGame Boy Color          5.900000  5.790698  7.400000  \nGameCube                8.028571  7.481319  7.116667  \nNintendo 3DS            7.700000  6.388889  7.900000  \nNintendo 64             5.675000  6.967857  6.900000  \nNintendo DS             5.874359  5.936667  6.644737  \nNintendo DSi            5.195652  5.644444  6.566667  \nPC                      7.104889  6.902424  7.310207  \nPlayStation             6.918182  6.751220  6.496875  \nPlayStation 2           7.152632  7.197826  7.238889  \nPlayStation 3           7.142857  7.485816  7.355172  \nPlayStation 4           9.250000  7.430000  6.566667  \nPlayStation Portable    6.761538  6.956790  6.550000  \nPlayStation Vita        5.725000  7.130000  8.900000  \nWii                     6.327027  5.966901  6.975000  \nWireless                7.802857  7.417699  7.542857  \nXbox                    7.155556  7.884397  7.313333  \nXbox 360                7.325000  7.317857  7.112245  \nXbox One                7.733333  7.331818  8.500000  \niPhone                  7.328571  7.152174  7.534921  \n","name":"stdout"}]},{"metadata":{},"cell_type":"markdown","source":"The dataset that you've just printed shows the average score, by platform and genre.  Use the data to answer the questions below."},{"metadata":{"trusted":true},"cell_type":"code","source":"# Fill in the line below: What is the highest average score received by PC games,\n# for any platform?\nhigh_score = 7.759930\n\n# Fill in the line below: On the Playstation Vita platform, which genre has the \n# lowest average score? Please provide the name of the column, and put your answer \n# in single quotes (e.g., 'Action', 'Adventure', 'Fighting', etc.)\nworst_genre = 'Simulation'\n\n# Check your answers\nstep_2.check()","execution_count":8,"outputs":[{"output_type":"display_data","data":{"text/plain":"<IPython.core.display.Javascript object>","application/javascript":"parent.postMessage({\"jupyterEvent\": \"custom.exercise_interaction\", \"data\": {\"outcomeType\": 1, \"valueTowardsCompletion\": 0.5, \"interactionType\": 1, \"questionType\": 1, \"questionId\": \"2_ReviewData\", \"learnToolsVersion\": \"0.3.4\", \"failureMessage\": \"\", \"exceptionClass\": \"\", \"trace\": \"\"}}, \"*\")"},"metadata":{}},{"output_type":"display_data","data":{"text/plain":"Correct","text/markdown":"<span style=\"color:#33cc33\">Correct</span>"},"metadata":{}}]},{"metadata":{"trusted":false},"cell_type":"code","source":"# Lines below will give you a hint or solution code\n#step_2.hint()\n#step_2.solution()","execution_count":null,"outputs":[]},{"metadata":{},"cell_type":"markdown","source":"## Step 3: Which platform is best?\n\nSince you can remember, your favorite video game has been [**Mario Kart Wii**](https://www.ign.com/games/mario-kart-wii), a racing game released for the Wii platform in 2008.  And, IGN agrees with you that it is a great game -- their rating for this game is a whopping 8.9!  Inspired by the success of this game, you're considering creating your very own racing game for the Wii platform.\n\n#### Part A\n\nCreate a bar chart that shows the average score for **racing** games, for each platform.  Your chart should have one bar for each platform. "},{"metadata":{"trusted":true},"cell_type":"code","source":"# Bar chart showing average score for racing games by platform\nsns.barplot(x=ign_data.index, y=ign_data['Racing']) # Your code here\n\n# Check your answer\nstep_3.a.check()","execution_count":9,"outputs":[{"output_type":"display_data","data":{"text/plain":"<IPython.core.display.Javascript object>","application/javascript":"parent.postMessage({\"jupyterEvent\": \"custom.exercise_interaction\", \"data\": {\"outcomeType\": 1, \"valueTowardsCompletion\": 0.5, \"interactionType\": 1, \"questionType\": 2, \"questionId\": \"3.1_PlotRacing\", \"learnToolsVersion\": \"0.3.4\", \"failureMessage\": \"\", \"exceptionClass\": \"\", \"trace\": \"\"}}, \"*\")"},"metadata":{}},{"output_type":"display_data","data":{"text/plain":"Correct","text/markdown":"<span style=\"color:#33cc33\">Correct</span>"},"metadata":{}},{"output_type":"display_data","data":{"text/plain":"<Figure size 432x288 with 1 Axes>","image/png":"iVBORw0KGgoAAAANSUhEUgAAAYEAAAEGCAYAAACD7ClEAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/Il7ecAAAACXBIWXMAAAsTAAALEwEAmpwYAAAhAUlEQVR4nO3deZwdVZn/8c+TdAIJyKJpUITQLowbCmi7IwOCCsoICsiqgqNRFJBhXMCZUfQ344j+XGZ+jEgUUDQoEkAUxaAgCrJIBxpCSEJICAkJSToh+97dz++P56m5l04n3bdDdZb6vl+vfvW9devUOXXq1HlOLbeuuTsiIlJNQ7Z2AUREZOtREBARqTAFARGRClMQEBGpMAUBEZEKa9raBag3atQob2lp2drFEBHZbkycOHGRuzcPNP02FQRaWlpoa2vb2sUQEdlumNmTW5Jep4NERCpMQUBEpMIUBEREKkxBQESkwhQEREQqTEFARKTCFARERCpMQUBEpMIUBEREKmyb+sawiMj2asH37m84zd7nv7GEkjSm1CMBM/snM5tsZo+Y2c/NbOcy8xMRkcaUFgTM7MXAeUCrux8IDAVOKSs/ERFpXNnXBJqAEWbWBIwE5pWcn4iINKC0IODuc4H/C8wGngaWufutPeczszFm1mZmbR0dHWUVR0REelHm6aA9geOAlwD7ALuY2Rk953P3se7e6u6tzc0DfiS2iIgMQJmng44CnnD3DnffANwAvK3E/EREpEFlBoHZwFvMbKSZGXAkMKXE/EREpEFlXhO4DxgPPABMyrzGlpWfiIg0rtQvi7n7V4CvlJmHiIgMnB4bISJSYQoCIiIVpiAgIlJhCgIiIhWmp4iKbCOOGz+h4TQ3nfieEkoiVaIjARGRClMQEBGpMAUBEZEKUxAQEakwBQERkQpTEBARqTDdIioisg1YeGnjtwjvdc6W3yKsIwERkQpTEBARqTAFARGRClMQEBGpsDJ/aP4VZtZe97fczM4vKz8REWlcaXcHufs04GAAMxsKzAVuLCs/ERFp3GDdInokMMPdn+xrxo7LftbwwpvPPmMgZZJt0Ht/dWFD8//u+G+UVBKRahisIHAK8PPePjCzMcAYgNGjRw9ScURkR/PI5QsaTnPgJ/f+39fzv9XnGHUjL/z8/g2n2daUHgTMbDjwfuCi3j5397HAWIDW1lYvuzwiZTp2/HUNzX/ziSeVVBKR/hmMI4FjgAfcvfEwLQ274up3N5zmHz9yawklEZHtwWAEgVPZxKkg2divrjym4TTHf+yWEkoiMrhuu6aj4TRHntZcQkmqpdQgYGYjgXcBnywzn23JnT88tuE07/jEzSWURESkb6UGAXdfDbygzDxERGTg9BRR2aG874bvNTT/bz94finlENle6LERIiIVpiAgIlJhO9zpoAWXfb3hNHuf/aUSSiIisu3TkYCISIXtcEcCsnWddePRDae56gO/L6EkA3Ps9Vc1NP/NJ5xVUklEBoeOBEREKkxBQESkwhQEREQqTNcERHYQJ1x/f8Nprj/hjSWURLYnOhIQEakwBQERkQrT6SARAeC8G+c0nOa/P7BfCSWRwaQjARGRClMQEBGpMAUBEZEKKzUImNkeZjbezKaa2RQze2uZ+YmISGPKvjD8X8Dv3f1EMxsOjCw5PxERaUBpQcDMdgMOA84EcPf1wPqy8hMRkcaVeSTwUqADuMrMDgImAp9191Ul5ilb6JJfvKfhNF88ZUIJJRGRwVDmNYEm4PXAZe5+CLAKuLDnTGY2xszazKyto6OjxOKIiEhPZQaBp4Cn3P2+fD+eCArP4u5j3b3V3Vubm5tLLI6IiPRU2ukgd59vZnPM7BXuPg04Eni0rPyeK9MvPa7hNAecc1MJJRERKV/ZdwedC4zLO4NmAvoZJhGRbUipQcDd24HWMvMQEZGB0zeGRUQqTEFARKTCFARERCpMQUBEpMIUBEREKkxBQESkwhQEREQqTEFARKTCFARERCpMQUBEpMIUBEREKkxBQESkwhQEREQqTEFARKTCFARERCpMQUBEpMIUBEREKqzUXxYzs1nACqAL6HR3/cqYiMg2pOzfGAY4wt0XDUI+IiLSIJ0OEhGpsLKPBBy41cwcuNzdx/acwczGAGMARo8eXXJxRKQsP7mho+E0H/1gcwklkUaUfSTwdnd/PXAM8BkzO6znDO4+1t1b3b21uVkNQkRkMJUaBNx9Xv5fCNwIvKnM/EREpDGlBQEz28XMnle8Bt4NPFJWfiIi0rgyrwnsDdxoZkU+17j770vMT0REGtSvIGBmK4iLvPWWAW3AP7v7zJ5pctpBW1xCEREpTX+PBL4DzAOuAQw4BXghMA24Eji8jMKJiEi5+ntN4Gh3v9zdV7j78rzV873ufi2wZ4nlExGREvU3CHSb2YfMbEj+fajus56niUREZDvR3yBwOvBhYCGwIF+fYWYjgHNKKpuIiJSsX9cE8iLvP2zi47ueu+KIiMhg6u/dQc3AJ4CW+jTu/rFyiiUiIoOhv3cH3QTcCfyReCy0iIjsAPobBEa6+xdLLYmIiAy6/l4YvtnM3ltqSUREZND1Nwh8lggEa8xsuZmtMLPlZRZMRETK19+7g55XdkFERGTwbTYImNkr3X2qmb2+t8/d/YFyiiUiIoOhryOBC4hf/fp2L5858M7nvEQiIjJoNhsE3H1M/j9icIojIiKDqV8Xhs3sM2a2R937Pc3s06WVSkREBkV/7w76hLsvLd64+xLiG8QiIrId628QGGL5E2EAZjYUGN6fhGY21MweNLObB1JAEREpT3+/MTwB+KWZ/YC4IPwpoL8/FflZYAqwW+PFExGRMvX3SOCLwO3A2cBngNuAL/SVyMz2Bd4H/GigBRQRkfL098ti3cBl+deI7xHBYpNfNjOzMcRtqIwePbrBxYuIyJbo791BB5jZeDN71MxmFn99pDkWWOjuEzc3n7uPdfdWd29tbm5uoOgiIrKl+ns66CriKKATOAK4GvhpH2neDrzfzGYBvwDeaWY/G2A5RUSkBP0NAiPc/TbA3P1Jd7+YPr4t7O4Xufu+7t4CnALc7u5nbFFpRUTkOdXfu4PWmtkQYLqZnQPMBfYqr1giIjIY+nskcD4wEjgPeAPxQ/Mf6W8m7n6Hux/bcOlERKRU/b076P58uRI4y8yagJOB+8oqmIiIlG+zRwJmtpuZXWRml5rZuy2cAzwOfGhwiigiImXp60jgp8AS4B7g48DnicdFHO/u7eUWTUREytZXEHipu78WwMx+BCwCRrv7itJLJiIipevrwvCG4oW7dwFPKACIiOw4+joSOKjuB+UNGJHvDXB310PhRES2Y339stjQwSqIiIgMvv5+T0BERHZACgIiIhWmICAiUmEKAiIiFaYgICJSYQoCIiIVpiAgIlJhCgIiIhWmICAiUmEKAiIiFVZaEDCznc3sb2b2kJlNNrOvlpWXiIgMTH9/Y3gg1gHvdPeVZjYMuMvMbnH3e0vMU0REGlBaEHB3J36OEmBY/nlZ+YmISONKvSZgZkPNrB1YCPzB3Tf6TWIzG2NmbWbW1tHRUWZxRESkh1KDgLt3ufvBwL7Am8zswF7mGevure7e2tzcXGZxRESkh0G5O8jdlwJ3AEcPRn4iItI/Zd4d1Gxme+TrEcBRwNSy8hMRkcaVeXfQi4CfmNlQItj80t1vLjE/ERFpUJl3Bz0MHFLW8kVEZMvpG8MiIhWmICAiUmEKAiIiFaYgICJSYQoCIiIVpiAgIlJhCgIiIhWmICAiUmEKAiIiFaYgICJSYQoCIiIVpiAgIlJhCgIiIhWmICAiUmEKAiIiFaYgICJSYWX+vOR+ZvYnM5tiZpPN7LNl5SUiIgNT5s9LdgL/7O4PmNnzgIlm9gd3f7TEPEVEpAGlHQm4+9Pu/kC+XgFMAV5cVn4iItK4QbkmYGYtxO8N39fLZ2PMrM3M2jo6OgajOCIikkoPAma2K3A9cL67L+/5ubuPdfdWd29tbm4uuzgiIlKn1CBgZsOIADDO3W8oMy8REWlcmXcHGXAFMMXdv1NWPiIiMnBlHgm8Hfgw8E4za8+/95aYn4iINKi0W0Td/S7Aylq+iIhsOX1jWESkwhQEREQqTEFARKTCFARERCpMQUBEpMIUBEREKkxBQESkwhQEREQqTEFARKTCFARERCpMQUBEpMIUBEREKkxBQESkwhQEREQqTEFARKTCFARERCqszJ+XvNLMFprZI2XlISIiW6bMI4EfA0eXuHwREdlCpQUBd/8L8ExZyxcRkS231a8JmNkYM2szs7aOjo6tXRwRkUrZ6kHA3ce6e6u7tzY3N2/t4oiIVMpWDwIiIrL1KAiIiFRYmbeI/hy4B3iFmT1lZv9YVl4iIjIwTWUt2N1PLWvZIiLy3NDpIBGRClMQEBGpMAUBEZEKUxAQEakwBQERkQpTEBARqTAFARGRClMQEBGpMAUBEZEKUxAQEakwBQERkQpTEBARqTAFARGRClMQEBGpMAUBEZEKUxAQEakwBQERkQorNQiY2dFmNs3MHjezC8vMS0REGlfmbwwPBf4HOAZ4NXCqmb26rPxERKRxZR4JvAl43N1nuvt64BfAcSXmJyIiDTJ3L2fBZicCR7v7x/P9h4E3u/s5PeYbA4zJt68Apm1msaOARQMs0pakVXqlV3ql31b7nv3dvXmgC28aaMJ+sF6mbRRx3H0sMLZfCzRrc/fWARVmC9IqvdIrvdJvr31PX8o8HfQUsF/d+32BeSXmJyIiDSozCNwPHGBmLzGz4cApwK9LzE9ERBpU2ukgd+80s3OACcBQ4Ep3n7yFi+3XaaMS0iq90iu90m+PefeptAvDIiKy7dM3hkVEKkxBQESkyty933/A3sA1wExgInAP0AW0A5OBh4ALgCGNLLeP5X+g7vPDgWWZ38PAH4G9BpJXL3kuBFYRt7E+Ub/8nPZtoAV4BPgccHGm/xTwkT7yOBj4N6ANmJLLW5WvpwJ39FwecDHwubr1vjlfO/BX4Df5vs+yEF/S81zHyZnmc5lHF/AMsKLn9gNGAuOAScDjmXbXujK1A3OBuT3yGwo8WJS5x2dnAh3Ak1mm5cAM4LrM7y05fQ2wNvMcCXQDnVnebmAlcDewKpf7FuC+XPZaYAFxc8LHgQszTXtuv+uAXYD/zuVNynlfAnwJ+FJdee/OeYoyLQNuyPRdPdJPzDRf6qM9DMm8V2dZV2fdO3EH3aqsl0nAjcDKXpbRWznvztf/h2i/7VnPU+vXcXNlBH5MtP924g4/B0bV57OJdN8Fzs9yfTfz/FF+NiHz/3Jui9/n9ri2Lv2o3HZXA9NyWgtwWt08FxPtdr8s4/Nz+p7A7Ew/oW7aE8D+1O0/myh7b8vbbNr8bCK1vu9TdZ8Z8B/AY8Q+fl5uHwOuynVfm+1pKTAduGJzZSzzr5HO0ohOuX5l9wfW1b3fi+g4v9pL+qYBLv/cuvfP2iDAf/aW10DWCbiL6AxXAl+pX35usCeAQ+gRBPqZz78QnccrgQOzESzJht8EXN9zeWw6CKwlOuzJ+b7ozDdZv8Cudevw9cy7SLeS6Jgv7bn9gIuA7+TrM4GfATsBewCPAqNz+hU98ruACKybCgKX5v/1wBHAfOA3mW4a4Dnv0Lrpa4Gnc1uNA75PfIFmbc47DfgiMD7r9NXEbcl75udeV4ZxwE9z3pU5bV9i519Jj063flqmnZjpvWf6Yv4+2sOpRMDqJALCvsBrinyIzuGaXO9LgPW9LGOjctZ9tltdPu3AD/pbRiIInEh0jG30CAKbWaeTgF9muT5E7Ev35PpNJNrsm3Pev+VyR9al/xTREf4EOHET+/vF1PaJLwBj8/XlRFv9AfBk/bTelrOJ8m+0vM2lBYYDO9XtX7OAffL9WUQwKwZTe+X/9xIDvslEgJ0K/IW4c/I+YNJA+7It+WukwzwS+HNvjTH/twB3Ep1kJ/A2Yke/A1hMjMymEyOUGcRoZxbwskz7KLCB2gj57bkB/pyNayYxkl2d88zIir6UiLLziFHZBmAOMfJYBqzLyr6A6GzXZnlm5t/jRKMvOte1xKi9JZe5gNoo+hmi41qbf7OIHXY8MXJbk8tYmfkuy/royvdLcxndRIc2Lz9fnOXurCvvM5nv0zmtm9qItFjPlbmuxWddWd7jst5/m8tZlfP8JdN0EoFgRaZZlK8fzDrpqsvzqdxuy4mRVntuk8VZto78O44I2o9l2ZbltvpmXVs5i+jw5wI/JDs34L+ynIsybREEds266Mj1XpzTf0u0ta/l9viPzGtGbqdJwHE5701ZR07tSODaLP/CXNcx1HZkz78VRIe/vq5uFxHbfV2m96yjhflXvPfc1kWbepLoCJfmtphbrGeWaVwRqOrSb8h8VlM7ClmU6dfWlfOZXN91uW2Lgc3KumXcSu3IrSOnFWmLvH+VZVxCdKbjiYDgufyJ1Nry+ZnP5dT2p9lZtq4sa3e+n19XV9cSwXtpfv4M8ACxH8yt2z5riaOFNXXrPpW4S2Zmpnkklz8n/7+W6KOKfbM7lzuE6IfWUDuKfDSnfyDXbVIuv5PY92cDt+U6fjC3we8y3Q+ode6nZtopxP6xTy5zGfBy4EXE/vDC3B6XA+fmul5NDFz+HxGATstyjye28wxiH55J9HEPZl5/Jo7o2om29bWsj0nAK7NcuwBX5nwPkvvCcxEEzgO+u5kgMBLYOV8Xp2zOJBrdsqyQS3LDf5UYTS7MFRxJNLJrgQOIQDGFaLhLM+0e1A71H80N9gwRXdcD92aFzAV+nvlfROwQn8/l/Etu3DupHaZ9P8u8BPhWVuwaovObRq1RLqTW8a/L+f49Xz+eG3tu5tOUG3AaEXjm5DJnZrk2EDvGnJyvm3jY3mO5Xv9KHJk40fBn5+v7c12LgHFvvp4OnEGMMBbmcv5C7EgziSBXBI7unL4E+GYub3Hmt0fdfOflOnZnPqtzXV5ENPj2rMOVwJ8yz99lfk8RpwTmEx3gfpluNrETfJ84pVUEgfuJNnI2cfrD8/9ngFtyehEgm4hObTZwfE6fAXyDZ3eyS4kjt89R66CH5Ly/I9rKLGqd+5HAbtRG448TnUB9x3Z7vp6eyy867XXACZnu/py+Gngp0bmsJzqIefnZ8dQC0xLiqOKQfF8cCSwEPk20VydOVRXlPTDnc+BQYsDSldNOzPLMIoJ0EVBuyjItz+3RRbTtQ3MbFKdCfkrsZ5cTo3vPuplEdC4rqZ1SvDPX/5jcHnOoneZYQgT3BcRRzeys598QbdOBFZlnMXAcRgSeLuBVOf2+rPeTiTZ3Yaa5mziydaJN3U70F0UQfQ/RLk8ktrcDrbkOzxB90T65fS8kBhazcr53EUe95xD9x/rclkOBP+Qy9yHa2eSs12nA8Vm2dbmeS7PMB2S93ZxpFwGfzfJNzvo7PPN+JdE/riCOkl+c9fHqrJM5wAWZz3Lg6nz9aWqn374OnJGv9yD2zV021bcP+MKwmf2PmT0EjMhJw4AfmtkkYlT1dzm9Dfibuz9NNKadiKh3R91KDwNeR+xIDxONfD8imlmmdWIjdBEbpZPa6QGAnYkGNIMILC8gRgevyUrdjdjYLyMebrdf5rnOzPbO9XgjtR27ODp4VZZvFNEJ7k50bOQ8HcR1heKc9oJ8fSix8d9HnGYZSjT+bqIzGp7zH0ZtVLiQ6HjWEo0OIsjtk+n2oja6W0fs/EPz/w+JZy+NyrrYOeu+CHpGnOqZBLwj62l1ph9OXLe4I8u2PvO+Kcv1zZz3H3IbzSNGOt1EQzyM2ObvyLq5hWjwzycC9v7Am3P5RWC5Fmgys3bg9cQOcwVxKgFih70kl/npunK2EzvcY1lHRox2/o34MuLSzHc3omNozvqE6LxfkOtuWXYDnkec57+aaAcjiJ1vb2rBY2dipxxCnL//bS5zA9EOxxEdzCE5vSnrbE7O8zBxusmJ4PhyagHlRGKER+a9U84/itj2EMFkvyzvr6jtdwe5+6y6cp6WdfA1d39R1tfizHs4MN3di6PH+UTbATgv9+f3Zb5HEkdITmy7G919Vc57Q873a+L0yy1Z/hlZhiVEJ70m6/bY/L87cQrx7lzuTma2W9bDanffkPU2hBgEvIpoB28jBka7AyeZ2WTiGlAL0Q9cSAwyyDpfB3wsy3kotSPeI7M+byI6+jcSnfW5RBuZTgSFA3PaReQA0+NBmF3EAPPQTHubu78mt+Uw4OgswwZin7iNGGxcmdOLR+nsQQxMW4G7sv7IdZmbdfMo0QZH5fosz/KPAL6c+80Iov+BGES35Ot3AxfmPHcQbXc0m9BIEJhM7KwAuPtnslDFiv0T0QEeTzTC4Tm9OHwm530EONXdDyai+9pM20VE3ecB3e6+a04fVrf8TuLQpzWndxAdudeVoxiZ7QQcRIxw/0ztYuLLiI7go0SAOCXL0URs/Cai0r5JdJjFKLDY+XalFiieyenDiBHwSKKh/okY2c4jdrQ2YmRZjKIsp52ZZZ5GjA66N6r1ODpZmZ973fQ1RGfXnfVwMDECWO3uo4mdoRg9d2Warixb0dEUHgTac5t0Eo14ORkM3P0GYnQ/B3gDtQuXHyRG4NOIkc3QrPOTiU5xGBGIiy8l1pcfoDPzXEd0MkXwwd33I45GhgNHZZm6gGPd/Vwi6J2cdXklcHquUwvRhpy4CPd6YoeCqPPTiGB+BNGRrCba3URitLUm/xYQ7WAote19P9EmLqW2rbqJ9r4wXxdf7FmZ6e/O9V9PBK6VxBFzcbrt+0QAezjTrcltMCvXrzgFeDrRQXQCn8z5oBYMOjOf1+R8hSeINvt7Yhs+v6ji/N9kZodnHb+VGKh0ZZoDsn4/TwS4esX+tqpu2lSiT9mFGAi8JutgBhHI1xNB+a85/1Li9Mm+REddv9yTcnm3uPvO7v5aYoCxgggKi3O+l2V530l0xkYMJI4mOuCdiG22JOtsAnF6pugzipsOXkps/58Tfc1BOf35bNxu6/sb3H0esa+/OCcVN5nsTfQZr8vpTxHBagExQJlHXOcgp3e6e1EPRUC0zK94fStwe+43c4nrlmQdFPuZASe4+8H5N9rdp7AJjQSB24Gdzezsumkj617vTnQMlxEd79BeljGB2OCFl9elLUaMVwJDzexgnt1R7U5UDMCHs+x7EhW5iOh0T8/P30bsbMuIDXlLlmd+pilOC5xNjBjPJ055/Dux0z5NbLjhRJAqAtp5xMZtITqPcVmu9cQdGUuJDTGXiMAvyHTXE41sD6JTN2LEuILY2Q/Mz0bWrePS/L+WaMB7ZTmG1ZVrYa7XWmLkcggwz8yK0WjhJXWvd6J2uD0iXx8CYGbFkwgfzP+HUAvgXVnGvxI70Yast5OpjZj/SJzTvJo4KptPjEQhDusPJzqIIcROjpn9fb5/Oue7pK6sxWi5eILiUCJok9PekK8nEB2YE53M6bnMFmrXfyBGbxOIbdad62NEMHgRUZ/FUdn+deXozvleRxzh7k50moUmam21GJEW7ewJYps152e7EI9TeXcutymXu3OmK4LdKVkX6zPv+cQotolaYIDaPlwEgd1zWSeb2VFE5ziECNS7UAsexTqRaZa4e3H9oRs4xd1b8vWHgHeZWbG/f4AYQR8L/9tuDiOOgIfkOtyV9Q3R9p8g2vfziaBruW4XEAHnobr17yb2id2AF5vZQWY2jNhey/NvVwB3n03sUz+iNmicRATWXYnB12JiX7wry30YcVqnjThtdHbWrRNHsN8m9tnTiMDztnz8zRCivd9FnN463MxGmdkLiH3lD2bWROxXPyFOlxaneSGOnE4g9u0jo/j+tJmNIPqWGWxsaq7T/sSRxbHEgAVqNxX0NAE418wMoJf+4NkauoocjfgXxAb9GzGqLG69m040sCeJ6FTcdXIjtTtbRhCd9uPEEcE9WekHECPkxdQuei0kOqPitrsDqF3cWZD5LibOhd9KnPdbnp8/TnQQ9+W08dTOoT9G7SJbO1H5q3OZxQWzWdRGhNOoXXgtzu86EeyKzu/ezGdKLvMxYkOtz7+pmccGYjRQLG99XZ4bct27iAb215z+FLURoOff1CzvKmqj/U5qo9KbydtOiVHrVzPdskz7WM67oi7v4ohnNTHinUPtQviknHdxrt9lxNFHcW1iVebZQgTzRbn+f8zph/e4MLye2sXeCcSOcTsxGp5P7YJpey6vLcvXmeuwnmhf84ENuewbqB31dOY8vwQ+kXVQBJNxRId9P7WLrquITuFeIhgV2+FX1C6ke67/KiKofJ1nX8Qt1mdNXb0sJ9r5opw+O5fxBWJ/KdKvIzoNJzr+4gJmcUus53ZdltOmEZ1mdy53HLULwd+gdm2pO//mEvvsQuB3WV8Tc13uyfq4Jet/FrEvFttsGbX2vKkLw5OIznEotdOV11A7mtxABIhl1K4DdFI7VbYS+FhO/zG1C8OPUbtG9TTRCc7L+p+ey3iIaCNLs3wLqV2UX00MPMbm+6I+JxEd6JeJfuOpLNtiYnD0FWL/+nvifP0qelwYJk4nzaZ2K3Nxa+qXiY7/t1mPa4izI8VF+6uzfoo6nUb0V1dR6ycvJgLNmfn+iVzWJKLPfSi31TrgPTlPK3BHXT97ec7/CH3cGVWJx0aYWStxUfsd2+PyZWM5KnsAOMndpz9X8z7X6evSDifu0mg4/wbzGdA6SnUN+MLw9iJ/2/h64iLPdrd82Vj+TOnjxIW5vgJAv+d9rtNn2ieJI6RbSgwAW7SOUm2VOBIQEZHe7fBHAiIismkKAiIiFaYgICJSYQoCskMysy4zazezR8zsuuIedzNb2Ue6Pczs0z2mfcvMJpvZt8oss8jWoAvDskMys5X5rXPMbBzxfZPv1E/fRLoW4r7qA+umLQea81u+/cm7yd07t2wNRAZHU9+ziGz37qT21X0AzGxX4hkyexLfyPxXd7+J+LLVy/K5K38gnse0C3Cfmf0n8YWyK4lvAHcAZ7n7bDP7MfHlukOAB/JbpGuIZ2PtT3xR7qPEN5vvc/czS1xfkX5TEJAdWn6N/xjiG6j11hI/WLTczEYB95rZr4mHkR2Yz2YplrGyeG9mvyGe3PgTM/sY8eMwx+esfwcc5e5dGRT2JB7b8H7icQVvJ37k5n4zO9jd25/7NRZpjK4JyI5qRI7m24iv91/R43MDvm5mDxOPtyieGtqXtxKPRIB47PKhdZ9dl0+aLPzG43zrJGCBu09y927iEQAtja2OSDl0JCA7qjX1o/lenE6c0nmDu28ws1nUHuLWiPqLaqt6fFZcQ+iue128174n2wQdCUhV7Q4szABwBLWnhq4gHkW9KXdTe5Lp6cSDvkS2WwoCUlXjgFYzayM686kA7r4Y+GveWtrbLaHnAWflaaQPE7+jILLd0i2iIiIVpiMBEZEKUxAQEakwBQERkQpTEBARqTAFARGRClMQEBGpMAUBEZEK+/+Nzo6pLpkoEgAAAABJRU5ErkJggg==\n"},"metadata":{"needs_background":"light"}}]},{"metadata":{"trusted":false},"cell_type":"code","source":"# Lines below will give you a hint or solution code\n#step_3.a.hint()\n#step_3.a.solution_plot()","execution_count":null,"outputs":[]},{"metadata":{},"cell_type":"markdown","source":"#### Part B\n\nBased on the bar chart, do you expect a racing game for the **Wii** platform to receive a high rating?  If not, what gaming platform seems to be the best alternative?"},{"metadata":{"trusted":false},"cell_type":"code","source":"#step_3.b.hint()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"# Check your answer (Run this code cell to receive credit!)\nstep_3.b.solution()","execution_count":10,"outputs":[{"output_type":"display_data","data":{"text/plain":"<IPython.core.display.Javascript object>","application/javascript":"parent.postMessage({\"jupyterEvent\": \"custom.exercise_interaction\", \"data\": {\"interactionType\": 3, \"questionType\": 4, \"questionId\": \"3.2_ThinkRacing\", \"learnToolsVersion\": \"0.3.4\", \"valueTowardsCompletion\": 0.0, \"failureMessage\": \"\", \"exceptionClass\": \"\", \"trace\": \"\", \"outcomeType\": 4}}, \"*\")"},"metadata":{}},{"output_type":"display_data","data":{"text/plain":"Solution: Based on the data, we should not expect a racing game for the Wii platform to receive a high rating.  In fact, on average, racing games for Wii score lower than any other platform.  Xbox One seems to be the best alternative, since it has the highest average ratings.","text/markdown":"<span style=\"color:#33cc99\">Solution:</span> Based on the data, we should not expect a racing game for the Wii platform to receive a high rating.  In fact, on average, racing games for Wii score lower than any other platform.  Xbox One seems to be the best alternative, since it has the highest average ratings."},"metadata":{}}]},{"metadata":{},"cell_type":"markdown","source":"## Step 4: All possible combinations!\n\nEventually, you decide against creating a racing game for Wii, but you're still committed to creating your own video game!  Since your gaming interests are pretty broad (_... you generally love most video games_), you decide to use the IGN data to inform your new choice of genre and platform.\n\n#### Part A\n\nUse the data to create a heatmap of average score by genre and platform.  "},{"metadata":{"trusted":true},"cell_type":"code","source":"# Heatmap showing average game score by platform and genre\nsns.heatmap(data=ign_data, annot=True) # Your code here\n\n# Check your answer\nstep_4.a.check()","execution_count":11,"outputs":[{"output_type":"error","ename":"NameError","evalue":"name 'heatmap' is not defined","traceback":["\u001b[0;31m---------------------------------------------------------------------------\u001b[0m","\u001b[0;31mNameError\u001b[0m                                 Traceback (most recent call last)","\u001b[0;32m<ipython-input-11-19a012e9a05e>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m      1\u001b[0m \u001b[0;31m# Heatmap showing average game score by platform and genre\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 2\u001b[0;31m \u001b[0msns\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mheatmap\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdata\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mign_data\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mannot\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mTrue\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;31m# Your code here\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      3\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      4\u001b[0m \u001b[0;31m# Check your answer\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      5\u001b[0m \u001b[0mstep_4\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0ma\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcheck\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n","\u001b[0;31mNameError\u001b[0m: name 'heatmap' is not defined"]}]},{"metadata":{"trusted":false},"cell_type":"code","source":"# Lines below will give you a hint or solution code\n#step_4.a.hint()\n#step_4.a.solution_plot()","execution_count":null,"outputs":[]},{"metadata":{},"cell_type":"markdown","source":"#### Part B\n\nWhich combination of genre and platform receives the highest average ratings?  Which combination receives the lowest average rankings?"},{"metadata":{"trusted":false},"cell_type":"code","source":"#step_4.b.hint()","execution_count":null,"outputs":[]},{"metadata":{"trusted":false},"cell_type":"code","source":"# Check your answer (Run this code cell to receive credit!)\nstep_4.b.solution()","execution_count":null,"outputs":[]},{"metadata":{},"cell_type":"markdown","source":"# Keep going\n\nMove on to learn all about **[scatter plots](https://www.kaggle.com/alexisbcook/scatter-plots)**!"},{"metadata":{},"cell_type":"markdown","source":"---\n\n\n\n\n*Have questions or comments? Visit the [Learn Discussion forum](https://www.kaggle.com/learn-forum/161291) to chat with other Learners.*"}],"metadata":{"kernelspec":{"name":"python3","display_name":"Python 3","language":"python"},"language_info":{"name":"python","version":"3.7.9","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"}},"nbformat":4,"nbformat_minor":2}