exercise-bar-charts-and-heatmaps.ipynb

{"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"pygments_lexer":"ipython3","nbconvert_exporter":"python","version":"3.6.4","file_extension":".py","codemirror_mode":{"name":"ipython","version":3},"name":"python","mimetype":"text/x-python"}},"nbformat_minor":4,"nbformat":4,"cells":[{"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":{}},{"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\")","metadata":{"execution":{"iopub.status.busy":"2022-01-31T13:43:07.026063Z","iopub.execute_input":"2022-01-31T13:43:07.026515Z","iopub.status.idle":"2022-01-31T13:43:07.033063Z","shell.execute_reply.started":"2022-01-31T13:43:07.026482Z","shell.execute_reply":"2022-01-31T13:43:07.032371Z"},"trusted":true},"execution_count":null,"outputs":[]},{"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":{}},{"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\")","metadata":{"execution":{"iopub.status.busy":"2022-01-31T13:43:11.76181Z","iopub.execute_input":"2022-01-31T13:43:11.762148Z","iopub.status.idle":"2022-01-31T13:43:11.824496Z","shell.execute_reply.started":"2022-01-31T13:43:11.762117Z","shell.execute_reply":"2022-01-31T13:43:11.823807Z"},"trusted":true},"execution_count":null,"outputs":[]},{"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":{}},{"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()","metadata":{"execution":{"iopub.status.busy":"2022-01-31T13:47:24.30348Z","iopub.execute_input":"2022-01-31T13:47:24.303722Z","iopub.status.idle":"2022-01-31T13:47:24.313788Z","shell.execute_reply.started":"2022-01-31T13:47:24.3037Z","shell.execute_reply":"2022-01-31T13:47:24.313205Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# Lines below will give you a hint or solution code\nstep_1.hint()\nstep_1.solution()","metadata":{"execution":{"iopub.status.busy":"2022-01-31T13:47:42.041393Z","iopub.execute_input":"2022-01-31T13:47:42.04163Z","iopub.status.idle":"2022-01-31T13:47:42.052449Z","shell.execute_reply.started":"2022-01-31T13:47:42.041607Z","shell.execute_reply":"2022-01-31T13:47:42.051584Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"markdown","source":"## Step 2: Review the data\n\nUse a Python command to print the entire dataset.","metadata":{}},{"cell_type":"code","source":"# Print the data\nprint(ign_data) # Your code here","metadata":{"execution":{"iopub.status.busy":"2022-01-31T13:47:45.316353Z","iopub.execute_input":"2022-01-31T13:47:45.316579Z","iopub.status.idle":"2022-01-31T13:47:45.331518Z","shell.execute_reply.started":"2022-01-31T13:47:45.316542Z","shell.execute_reply":"2022-01-31T13:47:45.330866Z"},"trusted":true},"execution_count":null,"outputs":[]},{"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":{}},{"cell_type":"code","source":"# Fill in the line below: What is the highest average score received by PC games,\n# for any genre?\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()","metadata":{"execution":{"iopub.status.busy":"2022-01-31T13:52:07.165447Z","iopub.execute_input":"2022-01-31T13:52:07.165783Z","iopub.status.idle":"2022-01-31T13:52:07.173678Z","shell.execute_reply.started":"2022-01-31T13:52:07.16576Z","shell.execute_reply":"2022-01-31T13:52:07.17309Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# Lines below will give you a hint or solution code\nstep_2.hint()\nstep_2.solution()","metadata":{"execution":{"iopub.status.busy":"2022-01-31T13:51:40.399159Z","iopub.execute_input":"2022-01-31T13:51:40.399375Z","iopub.status.idle":"2022-01-31T13:51:40.409621Z","shell.execute_reply.started":"2022-01-31T13:51:40.399353Z","shell.execute_reply":"2022-01-31T13:51:40.408621Z"},"trusted":true},"execution_count":null,"outputs":[]},{"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":{}},{"cell_type":"code","source":"# Bar chart showing average score for racing games by platform\nplt.figure(figsize=(8,6)) # Your code here\nsns.barplot(x=ign_data['Racing'],y=ign_data.index)\nplt.xlabel(\"\")\nplt.title(\"Here is the Average Score for Racing Games, by Platform\")\n# Check your answer\nstep_3.a.check()","metadata":{"execution":{"iopub.status.busy":"2022-01-31T13:55:24.096862Z","iopub.execute_input":"2022-01-31T13:55:24.097092Z","iopub.status.idle":"2022-01-31T13:55:24.363047Z","shell.execute_reply.started":"2022-01-31T13:55:24.097068Z","shell.execute_reply":"2022-01-31T13:55:24.361862Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# Lines below will give you a hint or solution code\nstep_3.a.hint()\nstep_3.a.solution_plot()","metadata":{"execution":{"iopub.status.busy":"2022-01-31T13:52:19.674514Z","iopub.execute_input":"2022-01-31T13:52:19.674763Z","iopub.status.idle":"2022-01-31T13:52:19.978595Z","shell.execute_reply.started":"2022-01-31T13:52:19.674743Z","shell.execute_reply":"2022-01-31T13:52:19.977633Z"},"trusted":true},"execution_count":null,"outputs":[]},{"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":{}},{"cell_type":"code","source":"step_3.b.hint()","metadata":{},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# Check your answer (Run this code cell to receive credit!)\nstep_3.b.solution()","metadata":{"execution":{"iopub.status.busy":"2022-01-31T13:55:52.463734Z","iopub.execute_input":"2022-01-31T13:55:52.46396Z","iopub.status.idle":"2022-01-31T13:55:52.471445Z","shell.execute_reply.started":"2022-01-31T13:55:52.463938Z","shell.execute_reply":"2022-01-31T13:55:52.470772Z"},"trusted":true},"execution_count":null,"outputs":[]},{"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":{}},{"cell_type":"code","source":"# Heatmap showing average game score by platform and genre\nplt.figure(figsize=(10,10))\nsns.heatmap(ign_data, annot=True)\nplt.xlabel(\"Genere\")\nplt.title(\"Average Game Score, by Platform and Genere\")# Your code here\n\n# Check your answer\nstep_4.a.check()","metadata":{"execution":{"iopub.status.busy":"2022-01-31T14:09:35.283592Z","iopub.execute_input":"2022-01-31T14:09:35.283832Z","iopub.status.idle":"2022-01-31T14:09:36.31205Z","shell.execute_reply.started":"2022-01-31T14:09:35.283799Z","shell.execute_reply":"2022-01-31T14:09:36.310955Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# Lines below will give you a hint or solution code\nstep_4.a.hint()\nstep_4.a.solution_plot()","metadata":{"execution":{"iopub.status.busy":"2022-01-31T14:06:46.678891Z","iopub.execute_input":"2022-01-31T14:06:46.679114Z","iopub.status.idle":"2022-01-31T14:06:47.712673Z","shell.execute_reply.started":"2022-01-31T14:06:46.679088Z","shell.execute_reply":"2022-01-31T14:06:47.711681Z"},"trusted":true},"execution_count":null,"outputs":[]},{"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":{}},{"cell_type":"code","source":"step_4.b.hint()","metadata":{"execution":{"iopub.status.busy":"2022-01-31T14:20:48.854705Z","iopub.execute_input":"2022-01-31T14:20:48.854928Z","iopub.status.idle":"2022-01-31T14:20:48.862972Z","shell.execute_reply.started":"2022-01-31T14:20:48.854904Z","shell.execute_reply":"2022-01-31T14:20:48.861726Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"# Check your answer (Run this code cell to receive credit!)\nstep_4.b.solution()","metadata":{"execution":{"iopub.status.busy":"2022-01-31T14:21:00.154241Z","iopub.execute_input":"2022-01-31T14:21:00.154494Z","iopub.status.idle":"2022-01-31T14:21:00.162645Z","shell.execute_reply.started":"2022-01-31T14:21:00.154469Z","shell.execute_reply":"2022-01-31T14:21:00.161485Z"},"trusted":true},"execution_count":null,"outputs":[]},{"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 [course discussion forum](https://www.kaggle.com/learn/data-visualization/discussion) to chat with other learners.*","metadata":{}}]}