Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PLEASE HELP ME IN PYTHON PLEASE Description In this project, you are responsible for analyzing different datasets that have statistics about 1095 video games. At
PLEASE HELP ME IN PYTHON PLEASE
Description In this project, you are responsible for analyzing different datasets that have statistics about 1095 video games. At the end of this project, you have to submit a report that meets the following requirements: 1- Description of the dataset(s) and the specific files used in this project. This includes what the data is, the number of fields (columns), the number of entries (rows), and the description of each field. 2- Numerous plots that show meaningful information related to the datasets. The displayed data should include some dynamic data that is computed using different fields and cannot be concluded from the data fields easily (for instance, the percentage of action video games that have been sold in Japan) You must choose the plot type that presents your data most meaningfully. Every plot must be clear and done with proper titles, labels, legends, etc. For each plot you have to include the following: a) The code used to generate the plot. b) A brief and informative description of each plot. Dataset Resources You are required to use different datasets in this project to visualize and make sense of them. You have three files in the project assignment. These files are Excel files. They have information about 1095 video games with around with different information such as developer producer, genre, release date, sales in different countries, console type, etc. You have to use these three files, but you can download as many files as you can that are related to the project subject to analyze the data in a proper way to cover all aspects of this study. Try to get dynamic data using different files to enhance your study. \begin{tabular}{|c|c|c|c|} \hline P54 & Spelunky 2 Review - Snake & Great & B \\ \hline PC & Mafia: Definitive Edition ReI & Fair & 6 \\ \hline PC & Surgeon Simulator 2 Review & Fair & 6 \\ \hline PC, NS & Hades Review - The Long, t & - superb & 9 \\ \hline P54 & 13 Sentinels: Aegis Rim Revi & superb & 9 \\ \hline NS & Super Mario 3D All-5tars Re & Great & B \\ \hline PC & Road To Guangdong Review & Terrible & 2 \\ \hline PC, PS4, XONE, NS & Vampire: The Masquerade. & Fair & 6 \\ \hline P54 & Othercide Review - Mother & Great & B \\ \hline PC & Marvel's Avengers Review - & - Good & 7 \\ \hline XONE, PC & Tell Me Why Review & Good & 7 \\ \hline NS & Moon Review - The Bright 5 & Great & B \\ \hline PC & Star Renegades Review - Tr & Great & B \\ \hline NS & The Last Campfire Review - & Great & B \\ \hline P54, XONE & Tony Hawk's Pro Skater 1+ & Superb & 9 \\ \hline PC, NS & Paradise Killer Review & Superb & 9 \\ \hline PC, P54, N5 & Evergate Review - Ever Gre & Great & B \\ \hline P54 & Madden 21 Review - Feels & Fair & 6 \\ \hline PC, N5 & A short Hike Review & Superb & 9 \\ \hline P54, PC, XONE & Project Cars 3 Review - Into & Good & 7 \\ \hline PC & Control AWE DLC Review - + & Fair & 6 \\ \hline P54 & Windbound Review - Again: & Mediocre & 5 \\ \hline PC & Thousand Threads Review - & Mediocre & 5 \\ \hline PC & Spiritfarer Review - Purrrga1 & 1 Superb & 9 \\ \hline PC, NS & No Straight Roads Review - & Good & 7 \\ \hline PC & Microsoft Flight Simulator R & superb & 9 \\ \hline 105 & Next Stop Nowhere Review - & - Bad & 3 \\ \hline P54 & PGA Tour 2 K21 Review - Fo & Great & B \\ \hline PC & Dead By Daylight Review [ 2 ] & superb & 9 \\ \hline PC & Mortal Shell Review - Stone & Great & B \\ \hline PC & Skater XL Review - Too Littli & Mediocre & 5 \\ \hline PC & Battletoads Review - Middli & Fair & 6 \\ \hline PC, XONE & Hyper Scape Review - 'Scaf & Fair & 6 \\ \hline PC & A Total War Saga: Troy Revi & Good & 7 \\ \hline PC & Risk of Rain 2 Review & Great & B \\ \hline PC, P54 & Fall Guys: Ultimate Knockou & Good & 7 \\ \hline PC & skully Review & Mediocre & 5 \\ \hline PC & Umurangi Generation Revie & Superb & 9 \\ \hline PC & Littlewood Review - Big Hea & Great & B \\ \hline P54 & Horizon Zero Dawn Review & superb & 9 \\ \hline XONE, PC & Grounded Early Access Revi & Early Access & 6 \\ \hline PC & Desperados 3 Review - Revc & superb & 9 \\ \hline PC & Rock of Ages 3: Make \& Bri & Good & 7 \\ \hline PC, 105 & Beyond A Steel Sky Review & Mediocre & 5 \\ \hline NS & Panzer Paladin Review & Great & B \\ \hline XONE & Maid of Sker Review - Back & Poor & 4 \\ \hline XONE & Destroy All Humans Review & Fair & 6 \\ \hline PC, XONE, NS & Carrion Review & Good & 7 \\ \hline PC & Necrobarista Review & Good & 7 \\ \hline XONE, PC & Ooblets Early Access Reviev & Early Access & 7 \\ \hline PC & Fight Crab Review - Battle O & Fair & 6 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline XONE, PC & Ooblets Early Access Reviev & Early Access & 7 \\ \hline PC & Fight Crab Review - Battle 0 & Fair & 6 \\ \hline PC & Rocket Arena Review & Fair & 6 \\ \hline PC, PS4, NS, XONE & Superliminal Review - We N & Great & B \\ \hline NS & Paper Mario: The Origami K & Great & B \\ \hline NS & Bloodstained: Curse Of The & Great & B \\ \hline P54 & Ghost of Tsushima Review - & - Good & 7 \\ \hline NS & Story Of Seasons: Friends O & Mediocre & 5 \\ \hline P54 & Superhot: Mind Control Dele & Good & 7 \\ \hline P54 & Death Stranding Review & Superb & 9 \\ \hline P54 & CrossCode Review - A Lot of & Hair & 6 \\ \hline NS & Deadly Premonition 2: A Ble & Mediocre & 5 \\ \hline P54 & Marvel's Iron Man VR Revie & Fair & 6 \\ \hline NS & Ninjala Review - Gum Up Th & Fair & 6 \\ \hline NS & Mr. Driller Drill Land Review & Great & B \\ \hline PC & West of Dead Review - Rog & Mediocre & 5 \\ \hline NS & Pokemon Sword And Shield & Great & B \\ \hline 105 & Slay The Spire Review - Trer & Superb & 9 \\ \hline NS & Death Come True Review - + & Fair & 6 \\ \hline PC & Crucible Review & Mediocre & 5 \\ \hline P54 & The Last Of Us Part 2 Spoile: & Great & B \\ \hline P54 & The Last of Us Part 25 poiler & Great & B \\ \hline P54 & SpongeBob SquarePants: B: & Terrible & 2 \\ \hline PC & Valorant Review - A Valiant & Good & 7 \\ \hline P54 & Skelattack Review - Bone-D & Mediocre & 5 \\ \hline P54 & Project Warlock Review - W & Fair & 6 \\ \hline PC & Disintegration Review - First & Good & 7 \\ \hline NS & xCOM 2 Collection For Ninte & Fair & 6 \\ \hline NS & The Outer Worlds For Nintel & Fair & 6 \\ \hline NS & Liberated Review & Poor & 4 \\ \hline PC & Resolutiion Review - Do The & Fair & 6 \\ \hline PC & Those Who Remain Review & Bad & 3 \\ \hline PC & Sea Of Thieves Review [ 202 & Great & B \\ \hline NS & Xenoblade Chronicles: Defin & superb & 9 \\ \hline XONE & Minecraft Dungeons Review & Good & 7 \\ \hline P54 & Maneater Review - Fish Are & Good & 7 \\ \hline P54 & Mortal Kombat 11: Afterma & Good & 7 \\ \hline PC & If Found Review - Call Me B) & superb & 9 \\ \hline NS & What The Golf Switch Revie & superb & 9 \\ \hline PC,105 & What The Golf Review & Great & B \\ \hline NS & The Wonderful 101 Remast: & Poor & 4 \\ \hline WIIU & The Wonderful 101 Review & Great & B \\ \hline NS & Hatsune Miku: Project DIVA & Great & B \\ \hline PC & Rainbow Six Siege Review [i & Essential & 1 \\ \hline PC & Legends of Runeterra Revie & superb & 9 \\ \hline P54 & Predator: Hunting Grounds F & Poor & 4 \\ \hline P54 & Sakura Wars Review & Good & 7 \\ \hline PC & xcom: Chimera Squad Revi & i Great & B \\ \hline PC & Cloudpunk Review - Time Tc & Good & 7 \\ \hline P54 & Streets Of Rage 4 Review - 1 & 1 Great & B \\ \hline XONE, PC, P54 & Rainbow six Siege Review (: & Great & B \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline PC & Gears Tactics Review - Plan ' & - Great & B \\ \hline PC & Fallout 76: Wastelanders Re & Mediocre & 5 \\ \hline NS & Trials Of Mana Review - Tria & Eair & 6 \\ \hline NS & Treachery In Beatdown City & Great & B \\ \hline PC & In Other Waters Review & Superb & 9 \\ \hline XONE & Bleeding Edge Review - Und & Fair & 6 \\ \hline P54 & Final Fantasy 7 Remake Rev & Essential & 1 \\ \hline NS & Animal Crossing: New Horizu & superb & 9 \\ \hline P54 & Persona 5 Royal Review - He & Essential & 1 \\ \hline P54 & Resident Evil 3 Remake Revi & Fair & 6 \\ \hline NS & Good Job Review - Office Sp & Good & 7 \\ \hline PC & Corruption 2029 Review & Fair & 6 \\ \hline P54 & MLB The Show 20 Review & Great & B \\ \hline PC, P54, XONE & Call of Duty Warzone Revie & Good & 7 \\ \hline PC & Half-Life: Alyx Review - Catc & Superb & 9 \\ \hline PC, NS, XONE, PS4 & Doom Eternal Review - Intel & | Great & 8 \\ \hline P54 & Nioh 2 Review & Great & B \\ \hline XONE & Ori And The Will of The Wis & Great & B \\ \hline PC & Mindseize Review - Familiat & I Fair & 6 \\ \hline LNX, MAC, AND, PC & Dota Underlords Review & Superb & 9 \\ \hline NS & Pokemon Mystery Dungeor & Great & B \\ \hline PC & Wolcen: Lords Of Mayhem & Poor & 4 \\ \hline P54 & Bloodroots Review & Great & 8 \\ \hline NS & Snack World Review & Poor & 4 \\ \hline P54 & Dreams Review & Superb & 9 \\ \hline P54 & Granblue Fantasy Versus Re & Good & 7 \\ \hline PC & The Pedestrian Review - Wa & Good & 7 \\ \hline PC & Through The Darkest of Tir & Great & B \\ \hline NS & Kunai Review - Throwing Kni & Good & 7 \\ \hline NS & Kentucky Route Zero Reviev & superb & 9 \\ \hline P54 & Kingdom Hearts 3 Re:Mind I & I Poor & 4 \\ \hline PC & Lenna's Inception Review - F & Good & 7 \\ \hline PC, P54 & Journey To The Savage Plar & Good & 7 \\ \hline PC & Frostpunk: The Last Autumr & Great & B \\ \hline XONE, P54 & Dragon Ball Z: Kakarot Revie & Good & 7 \\ \hline PC & Unity of Command 2 Revier & Great & 8 \\ \hline PC, NS, IOS & Overland Review - Road Trip & Great & B \\ \hline P54, PC, XONE & Ace Combat 7: 5kies Unkno & Great & B \\ \hline P54, XONE, PC & The Outer Worlds Review - 4 & superb & 9 \\ \hline PC, P54, XONE & Draugen Review - Mystery I & 1 Good & 7 \\ \hline P54 & Wattam Review - Forever W & Good & 7 \\ \hline PC & Supermash Review - Flop Ja & Bad & 3 \\ \hline NS & The Touryst Review - Life's b & Great & B \\ \hline PC & Phoenix Point Review - The 1 & 1 Great & B \\ \hline PC & Darksiders: Genesis Review & Good & 7 \\ \hline PC & Shovel Knight: King of Card: & Great & 8 \\ \hline P54, PC, XONE & Life is Strange 2: Episode 51 & Great & B \\ \hline P54 & Audica Review - Electronic G & Fair & 6 \\ \hline P54 & Shenmue 3 Review - From A & Mediocre & 5 \\ \hline PC & Blacksad: Under The 5kin Re & Mediocre & 5 \\ \hline PC & Planet Zoo Review - 5 pread: & Good & 7 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline & & D & & D \\ \hline 178 & PC & Planet Zoo Review - 5 pread: & Good & 7 \\ \hline 179 & NS & Sparklite Review - Shine A Li & Fair & 6 \\ \hline 180 & P54, P54 & Star Wars Jedi: Fallen Order & Great & B \\ \hline 181 & NS & Pokemon Sword \& Shield Re & Superb & 9 \\ \hline 182 & NS & Layton's Mystery Journey: & Good & 7 \\ \hline 183 & P54 & Need For Speed Heat Reviel & Good & 7 \\ \hline 184 & NS & Mario \& Sonic At The Olymy & Good & 7 \\ \hline 185 & PC, P54 & Call of Duty: Modern Warfa & Good & 7 \\ \hline 185 & P54, XONE & Red Dead Redemption 2 Rev & superb & 9 \\ \hline 187 & AND, 105 & Call of Duty Mobile Review & Great & B \\ \hline 18B & PC & Disco Elysium Review - Pure & Essential & 1 \\ \hline 189 & PC & Afterparty Review - Drink, D & Good & 7 \\ \hline 190 & NS & Luigi's Mansion 3 Review - N & Great & B \\ \hline 191 & P54 & WWE 2K2O Review: Botchat & Terrible & 2 \\ \hline 192 & P54 & Super Monkey Ball Banana & Mediocre & 5 \\ \hline 193 & PC,105 & Manifold Garden Review - 5 & superb & 9 \\ \hline 194 & P54 & Medievil Review - Bones 'n I & Mediocre & 5 \\ \hline 195 & NS & Felix The Reaper Review - Fi & Mediocre & 5 \\ \hline 196 & NS & Little Town Hero Review - Br & Mediocre & 5 \\ \hline 197 & NS & The Witcher 3 Nintendo 5 wi & superb & 9 \\ \hline 198 & NS & Killer Queen Black Review - & Great & B \\ \hline 199 & PC, XONE, PS4 & Ghost Recon Breakpoint Rev & Poor & 4 \\ \hline 200 & PC & John Wick Hex Review - Tick & Great & B \\ \hline 201 & P54 & Concrete Genie Review - Rul & Good & 7 \\ \hline 202 & PC & Indivisible Review - Moving & Good & 7 \\ \hline 203 & PC, N5, 105 & Neo Cab Review - Taxi Cab C & Good & 7 \\ \hline 204 & PC, P54, P54 & Destiny 2 Shadowkeep Revi & i Great & B \\ \hline 205 & NS & Yooka-Laylee And The Impc & Fair & 6 \\ \hline 206 & NS & Sayonara Wild Hearts Revie & Fair & 6 \\ \hline 207 & PC, P54 & Code Vein Review - There W & Fair & 6 \\ \hline 208 & PC, NS & Untitled Goose Game Reviel & Great & B \\ \hline 209 & PC & The Surge 2 Review - Out 0 & Great & B \\ \hline 210 & IOS, PC, NS & Bo Days Review - A Man An & Great & B \\ \hline 211 & P54 & FIFA 20 Review - Premier Le & Great & B \\ \hline 212 & N5, P54 & Dragon Quest XI Review - N & superb & 9 \\ \hline 213 & PC & Blasphemous Review - Dark & Good & 7 \\ \hline 214 & PC & Greedfall Review - Lost In At & Mediocre & 5 \\ \hline 215 & XONE & NHL 20 Review - 5 mashed & superb & 9 \\ \hline 216 & NS & The Legend of Zelda: Link's & Great & B \\ \hline 217 & P54 & No Man's sky Beyond Revie & superb & 9 \\ \hline 218 & PC & Children of Morta Review & Great & B \\ \hline 219 & P54 & Al: The Somnium Files Revia & Great & B \\ \hline 220 & PC & Borderlands 3 Review - six s & Great & B \\ \hline 221 & P54 & eFootball PES 2020 Review & superb & 9 \\ \hline 222 & NS & Daemon X Machina Review & Good & 7 \\ \hline 223 & XONE, PC & Gears 5 Review - A Beneficia & Good & 7 \\ \hline 224 & PC, P54, N5 & Divinity: Original sin2 Revie & Essential & 1 \\ \hline 225 & PC & Creature In The Well Review & Great & B \\ \hline 226 & P54 & Monster Hunter World: Icek & superb & 9 \\ \hline 227 & P54, PC & Knights And Bikes Review - 1 & 1 Great & B \\ \hline 228 & P54 & Erica Review - Movie Night & Great & B \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline VITA & Disgaea 3: Absence of Dete & Good & 7 \\ \hline PC & Blacklight: Retribution Revie & Fair & 6 \\ \hline P53 & Wheels of Destruction: Wor & Poor & 4 \\ \hline X360 & The Splatters Review & Good & 7 \\ \hline P53 & I Am Alive Review & Great & B \\ \hline P53 & Devil May Cry HD Collection & Good & 7 \\ \hline P53 & Closure Review & Great & B \\ \hline D5 & Inazuma Eleven 2: Blizzard | & Mediocre & 5 \\ \hline D5 & Inazuma Eleven 2 Review & Mediocre & 5 \\ \hline X360 & Diabolical Pitch Review & Bad & 3 \\ \hline X360 & Kinect Star Wars Review & Mediocre & 5 \\ \hline P53 & Tiger Woods PGA Tour 13 Ri & Good & 7 \\ \hline X360 & South Park: Tenorman's Rer & Bad & 3 \\ \hline X360 & Tiger Woods PGA Tour 13 Ri & Fair & 6 \\ \hline PC & Yesterday Review & Fair & 6 \\ \hline X360 & Ridge Racer Unbounded Rev & Great & 8 \\ \hline P53 & Ridge Racer Unbounded Rev & Great & 8 \\ \hline x360 & Sine Mora Review & Great & 8 \\ \hline VITA & Sumioni: Demon Arts Revier & Mediocre & 5 \\ \hline & Kid Icarus: Uprising Review & Great & B \\ \hline P53 & Ninja Gaiden 3 Review & Mediocre & 5 \\ \hline AND & Angry Birds Space Review & Great & B \\ \hline 105 & Angry Birds Space Review & Great & B \\ \hline PC & Starpoint Gemini Review & Poor & 4 \\ \hline P53 & Armored Core V Review & Fair & 6 \\ \hline X360 & Armored Core V Review & Fair & 6 \\ \hline P53 & Yakuza: Dead Souls Review & Mediocre & 5 \\ \hline PC & Warp Review & Fair & 6 \\ \hline P53 & Shoot Many Robots Review & Good & 7 \\ \hline X360 & Shoot Many Robots Review & Good & 7 \\ \hline X360 & Ninja Gaiden 3 Review & Mediocre & 5 \\ \hline X360 & Resident Evil: Operation Rac & Poor & 4 \\ \hline P53 & Resident Evil: Operation Rac & Poor & 4 \\ \hline P53 & Naruto Shippuden: Ultimate & Good & 7 \\ \hline X360 & Naruto Shippuden: Ultimate & Good & 7 \\ \hline P53 & FIFA Street Review & Great & B \\ \hline X360 & Blades of Time Review & Fair & 6 \\ \hline P53 & Blades of Time Review & Fair & 6 \\ \hline PC & Stacking Review & Great & B \\ \hline P53 & FIFA Street 3 Review & Fair & 6 \\ \hline X360 & FIFA Street Review & Great & B \\ \hline X360 & Silent Hill: Downpour Reviev & Good & 7 \\ \hline VITA & Shinobido 2: Revenge of Zer & I Bad & 3 \\ \hline PC & Deep Black: Reloaded Revie & Bad & 3 \\ \hline PC & Microsoft Flight - Hawaiian, & Fair & 6 \\ \hline PC & Microsoft Flight Review & Good & 7 \\ \hline VITA & MLB 12: The Show Review & Fair & 6 \\ \hline WII & Mario Party 9 Review & Fair & 6 \\ \hline P53 & Silent Hill: Downpour Reviev & Good & 7 \\ \hline X360 & Major League Baseball 2K1; & Mediocre & 5 \\ \hline P53 & Major League Baseball 2K1: & Mediocre & 5 \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started