06. Data Visualization/exercise/03. exercise-bar-charts-and-heatmaps.ipynb

{"metadata":{"kernelspec":{"display_name":"Python 3","language":"python","name":"python3"},"language_info":{"name":"python","version":"3.7.12","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"}},"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-07-07T17:55:00.521937Z","iopub.execute_input":"2022-07-07T17:55:00.522473Z","iopub.status.idle":"2022-07-07T17:55:01.892000Z","shell.execute_reply.started":"2022-07-07T17:55:00.522428Z","shell.execute_reply":"2022-07-07T17:55:01.889765Z"},"trusted":true},"execution_count":2,"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-07-07T17:55:01.896155Z","iopub.execute_input":"2022-07-07T17:55:01.896943Z","iopub.status.idle":"2022-07-07T17:55:01.980217Z","shell.execute_reply.started":"2022-07-07T17:55:01.896835Z","shell.execute_reply":"2022-07-07T17:55:01.978553Z"},"trusted":true},"execution_count":3,"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-07-07T17:55:29.821737Z","iopub.execute_input":"2022-07-07T17:55:29.822128Z","iopub.status.idle":"2022-07-07T17:55:29.836450Z","shell.execute_reply.started":"2022-07-07T17:55:29.822096Z","shell.execute_reply":"2022-07-07T17:55:29.834982Z"},"trusted":true},"execution_count":5,"outputs":[]},{"cell_type":"code","source":"# Lines below will give you a hint or solution code\n#step_1.hint()\n#step_1.solution()","metadata":{},"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\nign_data # Your code here","metadata":{"execution":{"iopub.status.busy":"2022-07-07T17:55:41.285598Z","iopub.execute_input":"2022-07-07T17:55:41.286015Z","iopub.status.idle":"2022-07-07T17:55:41.322104Z","shell.execute_reply.started":"2022-07-07T17:55:41.285980Z","shell.execute_reply":"2022-07-07T17:55:41.320951Z"},"trusted":true},"execution_count":6,"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-07-07T17:56:05.781510Z","iopub.execute_input":"2022-07-07T17:56:05.782612Z","iopub.status.idle":"2022-07-07T17:56:05.791545Z","shell.execute_reply.started":"2022-07-07T17:56:05.782568Z","shell.execute_reply":"2022-07-07T17:56:05.790590Z"},"trusted":true},"execution_count":9,"outputs":[]},{"cell_type":"code","source":"# Lines below will give you a hint or solution code\n#step_2.hint()\n#step_2.solution()","metadata":{"execution":{"iopub.status.busy":"2022-07-07T17:56:04.595233Z","iopub.execute_input":"2022-07-07T17:56:04.595682Z","iopub.status.idle":"2022-07-07T17:56:04.600528Z","shell.execute_reply.started":"2022-07-07T17:56:04.595645Z","shell.execute_reply":"2022-07-07T17:56:04.599568Z"},"trusted":true},"execution_count":8,"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=(20, 6))\n\nsns.barplot(x=ign_data.index, y=ign_data['Racing'])\n\n# Check your answer\nstep_3.a.check()","metadata":{"execution":{"iopub.status.busy":"2022-07-07T17:58:07.198616Z","iopub.execute_input":"2022-07-07T17:58:07.199158Z","iopub.status.idle":"2022-07-07T17:58:07.561741Z","shell.execute_reply.started":"2022-07-07T17:58:07.199112Z","shell.execute_reply":"2022-07-07T17:58:07.560564Z"},"trusted":true},"execution_count":12,"outputs":[]},{"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()","metadata":{},"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-07-07T17:58:22.677771Z","iopub.execute_input":"2022-07-07T17:58:22.678178Z","iopub.status.idle":"2022-07-07T17:58:22.688935Z","shell.execute_reply.started":"2022-07-07T17:58:22.678142Z","shell.execute_reply":"2022-07-07T17:58:22.687618Z"},"trusted":true},"execution_count":13,"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=(16, 16))\n\nsns.heatmap(data=ign_data, annot=True)\n\n# Check your answer\nstep_4.a.check()","metadata":{"execution":{"iopub.status.busy":"2022-07-07T17:59:25.171997Z","iopub.execute_input":"2022-07-07T17:59:25.172432Z","iopub.status.idle":"2022-07-07T17:59:26.813943Z","shell.execute_reply.started":"2022-07-07T17:59:25.172393Z","shell.execute_reply":"2022-07-07T17:59:26.812820Z"},"trusted":true},"execution_count":14,"outputs":[]},{"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()","metadata":{},"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_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-07-07T18:00:19.250149Z","iopub.execute_input":"2022-07-07T18:00:19.250587Z","iopub.status.idle":"2022-07-07T18:00:19.259310Z","shell.execute_reply.started":"2022-07-07T18:00:19.250542Z","shell.execute_reply":"2022-07-07T18:00:19.258110Z"},"trusted":true},"execution_count":15,"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":{}}]}