{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "20ff68a8", "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "import seaborn as sns\n", "import matplotlib.pyplot as plt\n", "import datetime\n", "import matplotlib.dates as mdates\n", "from matplotlib.dates import DateFormatter\n", "sns.set()" ] }, { "cell_type": "code", "execution_count": 2, "id": "cae9f407", "metadata": {}, "outputs": [], "source": [ "# Load the dataset\n", "df = pd.read_csv('../data/join_02.csv')" ] }, { "cell_type": "code", "execution_count": 3, "id": "c56d3c48", "metadata": {}, "outputs": [], "source": [ "# date format preparation\n", "df['date'] = pd.to_datetime(df['date'])\n", "df['release_date'] = pd.to_datetime(df['release_date'])" ] }, { "cell_type": "code", "execution_count": 4, "id": "d81c9761", "metadata": { "scrolled": false }, "outputs": [ { "data": { "text/plain": [ "Index(['gamename', 'year', 'month', 'avg', 'gain', 'peak', 'avg_peak_perc',\n", " 'date', 'release_date', 'required_age', 'price', 'dlc_count', 'windows',\n", " 'mac', 'linux', 'metacritic_score', 'positive', 'negative',\n", " 'developers', 'publishers', 'average_playtime_forever',\n", " 'average_playtime_two_weeks', 'median_playtime_forever',\n", " 'median_playtime_two_weeks', 'multi_player', 'pvp', 'co-op',\n", " 'genre_action', 'genre_adventure', 'genre_casual',\n", " 'genre_sexual_content', 'genre_strategy', 'genre_sports',\n", " 'genre_racing', 'genre_rpg', 'genre_simulation', 'indie', 'full_audio',\n", " 'full_controller_support', 'age_0_plus', 'age_13_plus', 'age_18_plus'],\n", " dtype='object')" ] }, "execution_count": 4, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.columns" ] }, { "cell_type": "code", "execution_count": 5, "id": "dafd7c72", "metadata": { "collapsed": true }, "outputs": [ { "data": { "text/plain": [ "array(['F.E.A.R.', 'RIFT', 'Men of War: Assault Squad 2', 'Artifact',\n", " 'Layers of Fear', 'Idle Monster TD', 'Football Manager 2021 Touch',\n", " 'Granado Espada', 'CosmicBreak Universal',\n", " 'Pro Cycling Manager 2020', 'March of Empires', 'YoloMouse',\n", " 'Idle Wizard', 'Game of Thrones Winter is Coming',\n", " 'Idling to Rule the Gods', 'Stream Avatars', 'Soccer Manager 2021',\n", " 'Out of the Park Baseball 21', 'Farm Manager 2018',\n", " 'OVR Advanced Settings', 'Onmyoji', 'Fisher Online',\n", " 'Crusaders of the Lost Idols', 'Curious Expedition 2',\n", " 'Borderless Gaming', 'Lords Mobile', 'Blade Symphony', 'Caster',\n", " 'EVGA Precision X1', 'GRAV', 'Terraforming Mars',\n", " 'Firestone Idle RPG', 'Bloons Monkey City',\n", " 'Robot Roller-Derby Disco Dodgeball', 'Floating Point',\n", " 'Worm.is: The Game', 'Savage Lands', 'BRINK', 'One Way Heroics',\n", " \"Tiny and Big: Grandpa's Leftovers\", 'ArcheAge',\n", " 'Woodle Tree Adventures', \"There's Poop In My Soup\", 'Blameless',\n", " 'Resident Evil 7 Teaser: Beginning Hour',\n", " 'Sniper Elite: Nazi Zombie Army', 'Medieval Engineers',\n", " 'Bless Online', 'Polarity', 'Teeworlds', 'LUFTRAUSERS',\n", " 'Plug & Play', 'Kingdoms Reborn', 'Mad Games Tycoon', 'BEEP',\n", " 'Morphopolis', 'RPG Maker VX Ace', '140', 'Confess My Love',\n", " 'Car Mechanic Simulator 2014', 'Tactical Monsters Rumble Arena',\n", " 'Blockland', 'Freedom Planet', 'Beasts of Bermuda',\n", " \"King Arthur's Gold\", 'Card Hunter', 'Hearts of Iron III',\n", " 'Cortex Command', 'Planet Explorers', 'Reus',\n", " 'Steel Division: Normandy 44', 'Time Clickers', 'SpaceChem',\n", " 'ShareX', 'Defense Grid: The Awakening', 'klocki', 'Atlas Reactor',\n", " 'System Shock 2', 'Lost Lands: Mahjong', 'Owlboy', 'The Cat Lady',\n", " 'Plantera', 'Dead Space', 'Axiom Verge', \"Melody's Escape\",\n", " 'Primal Carnage', 'Lost Lands: A Hidden Object Adventure',\n", " 'Grow Home', 'Blood of Steel', 'PRICE', 'Dungeons of Dredmor',\n", " \"Viscera Cleanup Detail: Santa's Rampage\", 'Zup! 3', 'Home Behind',\n", " 'Hentai Girl', 'Audiosurf 2', '12 is Better Than 6',\n", " 'Boring Man - Online Tactical Stickman Combat', 'Invisible, Inc.',\n", " 'Evoland', \"Alan Wake's American Nightmare\", 'rFactor 2',\n", " 'World of Goo', 'Sword With Sauce', 'The Way of Life Free Edition',\n", " 'Enclave', 'Hexcells', 'Serena', 'Botanicula', 'Knight Online',\n", " 'Steel Division 2', 'Mordheim: City of the Damned',\n", " 'War Trigger 3', 'Cook, Serve, Delicious!', 'HunieCam Studio',\n", " 'Dead Bits', 'Eternal Card Game', 'OLDTV',\n", " 'Trine 3: The Artifacts of Power', 'Meadow', 'Vindictus',\n", " \"Shadowrun: Dragonfall - Director's Cut\", 'The Flame in the Flood',\n", " 'Realm Grinder', 'Endless Sky', 'ibb & obb',\n", " 'SURVIVAL: Postapocalypse Now', 'Mount & Blade',\n", " 'Space Rangers HD: A War Apart', 'Day of Defeat', 'Blockstorm',\n", " 'Home Behind 2', 'The Tiny Bang Story', 'Secrets of Grindea',\n", " 'Art of War: Red Tides', 'Murder Miners', 'Euro Truck Simulator',\n", " 'Soda Dungeon', 'F.E.A.R. 2: Project Origin', 'Catan Universe',\n", " 'Ballistic Overkill', 'Line of Sight', 'Legend of Grimrock',\n", " 'Democracy 3', 'Guacamelee! Gold Edition', 'PGA TOUR 2K21',\n", " 'Torchlight', \"Marie's Room\", 'Digimon Masters Online',\n", " 'Overgrowth', 'Stories: The Path of Destinies', 'DLC Quest',\n", " 'Epistory - Typing Chronicles', 'Hammerwatch',\n", " 'Stronghold Kingdoms', 'Lethal League', 'Faeria', 'SteamWorld Dig',\n", " 'Secret World Legends', 'Team Fortress Classic', 'Valley',\n", " 'Sakura Spirit', 'Binary Domain', \"Jazzpunk: Director's Cut\",\n", " 'Melvor Idle', 'Crawl', 'Train Sim World® 2', 'Race The Sun',\n", " 'RPG Maker MV', 'Super Crate Box',\n", " 'Company of Heroes - Legacy Edition', 'Jet Set Radio',\n", " 'Bit Blaster XL', 'E.Y.E: Divine Cybermancy',\n", " 'Grim Fandango Remastered', 'Comedy Night',\n", " 'War for the Overworld', 'Dark and Light', 'Zup! 2',\n", " 'The Final Station', 'Heat Signature', 'Naval Action', 'Distance',\n", " 'Gremlins, Inc.', 'Blood Bowl 2',\n", " 'Minecraft: Story Mode - A Telltale Games Series',\n", " 'Zombie Panic! Source', 'The Silent Age', 'Broken Age',\n", " 'Death Road to Canada', 'The Surge', 'Gaokao.Love.100Days',\n", " 'Serious Sam HD: The First Encounter', 'Duke Nukem Forever',\n", " 'The Legend of Heroes: Trails in the Sky',\n", " 'Digimon Story Cyber Sleuth: Complete Edition',\n", " 'Jotun: Valhalla Edition', 'Jalopy',\n", " 'Warhammer 40,000: Eternal Crusade',\n", " \"Recettear: An Item Shop's Tale\", 'Slender: The Arrival',\n", " 'NARUTO SHIPPUDEN: Ultimate Ninja STORM Revolution', 'Magicite',\n", " 'Fable - The Lost Chapters', 'Soulworker',\n", " 'Relic Hunters Zero: Remix', 'Gear Up',\n", " 'Never Alone (Kisima Ingitchuna)', 'Cave Story+', 'Rebel Galaxy',\n", " 'Next Day: Survival', 'Hatoful Boyfriend', 'Long Live The Queen',\n", " 'Reigns', 'Nidhogg', 'Risen', 'Late Shift',\n", " 'Amnesia: A Machine for Pigs', 'The Swapper',\n", " \"Baldur's Gate II: Enhanced Edition\", 'METAL SLUG 3', 'MapleStory',\n", " 'WAKFU', 'Saints Row: Gat out of Hell', 'Tales of Zestiria',\n", " 'Elsword', 'Railway Empire', 'Worms Revolution',\n", " \"Five Nights at Freddy's 3\", 'Planetbase', 'Orcs Must Die!',\n", " 'Aura Kingdom', 'Tribes: Ascend', 'Riders of Icarus', 'Downwell',\n", " 'Sniper Ghost Warrior Contracts',\n", " 'Lucy -The Eternity She Wished For-', 'Homefront',\n", " 'GunZ 2: The Second Duel', 'Governor of Poker 3',\n", " 'Styx: Master of Shadows', 'ROMANCE OF THE THREE KINGDOMS XIV',\n", " 'Pyre', 'Her Story', 'Mount Your Friends', 'FINAL FANTASY VIII',\n", " 'GORN', 'Devil Daggers', 'Loading Screen Simulator',\n", " 'DEEP SPACE WAIFU', 'How to Survive 2', 'Cyber Hunter', 'CS2D',\n", " 'CastleMiner Z', 'Carpe Diem', 'Worms Armageddon',\n", " 'The Incredible Adventures of Van Helsing',\n", " 'The Vanishing of Ethan Carter', 'F.E.A.R. 3', 'Viridi', 'Lucius',\n", " 'Life is Feudal: Your Own', 'Subsistence', 'LYNE',\n", " 'Galactic Civilizations III', 'Domina', 'Party Hard', 'Zup!',\n", " 'This Is the Police', 'Stay Out', 'Hidden Folks',\n", " 'The Bureau: XCOM Declassified', 'Kingdom: New Lands',\n", " 'THE KING OF FIGHTERS XIII STEAM EDITION', 'FINAL FANTASY IX',\n", " 'Osiris: New Dawn', 'DDraceNetwork',\n", " 'The Mean Greens - Plastic Warfare', 'SimplePlanes',\n", " 'Age of Empires: Definitive Edition', 'Braid', 'Eco',\n", " 'Crazy Machines 3', 'Octodad: Dadliest Catch', 'Thomas Was Alone',\n", " \"America's Army: Proving Grounds\", 'Half-Life: Source',\n", " 'War Robots', 'Feed and Grow: Fish', 'We Happy Few', 'Titan Souls',\n", " 'Genital Jousting', \"Five Nights at Freddy's: Sister Location\",\n", " 'Ultimate Epic Battle Simulator', 'CPUCores :: Maximize Your FPS',\n", " 'AirMech Strike', 'Transport Fever', 'Road Redemption',\n", " 'Cossacks 3', 'Stonehearth', 'VVVVVV', 'Reign Of Kings',\n", " 'NGU IDLE', 'Door Kickers', 'Gold Rush: The Game',\n", " 'Transmissions: Element 120', 'Punch Club', 'Natural Selection 2',\n", " 'Magicka 2', 'Furi', 'Resident Evil Revelations',\n", " 'Warhammer 40,000: Dawn of War II',\n", " 'DYNASTY WARRIORS 8: Xtreme Legends Complete Edition',\n", " 'Fable Anniversary', 'Age of Wonders III', 'RUINER', '60 Seconds!',\n", " 'Shower With Your Dad Simulator 2015: Do You Still Shower With Your Dad',\n", " 'Book of Demons', 'Little Inferno', 'Hand of Fate',\n", " 'Serious Sam 2', 'Will To Live Online', 'Darksiders III',\n", " 'Half-Life 2: Lost Coast', 'RWBY: Grimm Eclipse',\n", " 'Gothic II: Gold Edition', 'Deponia', 'Turmoil',\n", " 'Supreme Commander 2', 'Stronghold Crusader 2',\n", " 'Warhammer 40,000: Dawn of War III', 'Mitos.is: The Game',\n", " 'Oxenfree', 'Scribblenauts Unlimited', 'Max Payne',\n", " \"Five Nights at Freddy's 4\", 'Tyranny', 'Absolver',\n", " 'Homeworld Remastered Collection', 'Avorion', 'Aragami',\n", " 'Shop Titans', 'Superflight', 'Deadlight', 'BATTALION 1944',\n", " 'Youtubers Life', 'Half-Life 2: Deathmatch', 'Yakuza Kiwami 2',\n", " 'Rabi-Ribi', 'Bomber Crew', 'Hitman: Blood Money',\n", " 'Desperados III', 'DISTRAINT: Deluxe Edition', 'RAGE',\n", " 'Foundation', 'Batman - The Telltale Series', 'Timberman',\n", " 'Metin2', 'Hatred', 'Half-Life: Blue Shift',\n", " 'Workers & Resources: Soviet Republic', 'Double Action: Boogaloo',\n", " 'Machinarium', 'Supreme Commander: Forged Alliance',\n", " 'Planetary Annihilation: TITANS', 'Tropico 5',\n", " 'Yet Another Zombie Defense', 'Devil May Cry 4 Special Edition',\n", " 'WARMODE', 'Star Conflict', 'House Party', 'Contagion',\n", " 'Darksiders Warmastered Edition', 'FAR: Lone Sails',\n", " 'Vampire: The Masquerade - Bloodlines', 'Mr.Mine',\n", " 'Motorsport Manager', 'X4: Foundations', 'Tropico 4',\n", " 'Rise of Nations: Extended Edition', 'UBOAT',\n", " \"Baldur's Gate: Enhanced Edition\",\n", " 'Keep Talking and Nobody Explodes', 'Detention', 'Project CARS',\n", " 'Hyperdimension Neptunia Re;Birth1',\n", " 'Darksiders II Deathinitive Edition', 'Spellbreak', 'Aseprite',\n", " 'Tricky Towers', 'Shadowrun Returns', 'NEKOPARA Vol. 3',\n", " 'Mindustry', 'Clustertruck', 'LEGO® Worlds',\n", " 'Deus Ex: Game of the Year Edition', 'Action Taimanin', 'Fran Bow',\n", " 'Garfield Kart', 'Warhammer 40,000: Inquisitor - Martyr',\n", " 'Moonbase Alpha', 'Touhou Luna Nights', 'Craft The World',\n", " 'Eternal Senia', 'Montaro', 'Gorogoa', 'Child of Light',\n", " 'Overcooked', 'METAL GEAR SOLID V: GROUND ZEROES',\n", " 'RUNNING WITH RIFLES', 'The Awesome Adventures of Captain Spirit',\n", " 'Trailmakers', 'Remember Me', 'CrossCode', 'NEKOPARA Vol. 2',\n", " 'Armello', 'Gunpoint', 'DiRT 4', 'Dead Island Definitive Edition',\n", " 'Block N Load', 'The Witness', \"Spooky's Jump Scare Mansion\",\n", " 'Mini Metro', 'Dawn of Man', 'Pony Island', 'STEINS;GATE',\n", " 'BRAIN / OUT', 'Ironsight', 'Craftopia', 'Sakura Clicker',\n", " 'Darkwood', 'Sanctum 2', '911 Operator', 'FEZ', 'Unrailed!',\n", " 'Farming Simulator 15', 'Dino D-Day',\n", " 'Tree of Savior (English Ver.)', 'ELEX', 'Wasteland 3',\n", " 'The Banner Saga', 'Imperator: Rome', 'Surgeon Simulator',\n", " 'Car Mechanic Simulator 2015', 'Gone Home',\n", " 'Danganronpa V3: Killing Harmony', 'Vampyr', 'X-Plane 11',\n", " 'Night in the Woods', 'Pillars of Eternity II: Deadfire',\n", " 'Gears 5', 'Star Trek Online', 'FINAL FANTASY X/X-2 HD Remaster',\n", " 'Saints Row 2', 'Poly Bridge', 'Zombie Army Trilogy',\n", " 'Guns of Icarus Online', 'Stronghold Crusader HD',\n", " 'S.T.A.L.K.E.R.: Clear Sky', 'War Selection',\n", " 'Counter-Strike: Condition Zero', 'Codename CURE',\n", " 'Cell to Singularity - Evolution Never Ends', 'Finding Paradise',\n", " 'Shovel Knight: Treasure Trove', 'Toribash', 'Project CARS 2',\n", " 'The Escapists', 'Sword Art Online: Fatal Bullet',\n", " 'How to Survive', 'Mountain', 'Fallout 3',\n", " 'Just Cause 2: Multiplayer Mod', 'Psychonauts', 'Post Scriptum',\n", " 'Victoria II', 'Hyper Light Drifter', 'Into the Breach',\n", " 'Call to Arms', 'Dead Frontier 2', 'Half-Life: Opposing Force',\n", " 'Wargame: Red Dragon', \"Five Nights at Freddy's 2\", 'The Room Two',\n", " 'Last Oasis', 'World of Guns: Gun Disassembly',\n", " 'DRAGON BALL XENOVERSE', 'Dungeon Defenders', 'Tower Unite',\n", " 'Wizard of Legend', 'Antichamber',\n", " 'Injustice: Gods Among Us Ultimate Edition', 'Battle Brothers',\n", " 'Salt and Sanctuary', 'Darwin Project', 'Viscera Cleanup Detail',\n", " 'Nuclear Throne', 'Dungeon Defenders II', 'Transport Fever 2',\n", " 'Streets of Rogue', 'Monster Train', 'BLOCKADE 3D',\n", " 'Leaf Blower Revolution - Idle Game', 'Resident Evil',\n", " 'One Finger Death Punch', 'DUSK', 'Tales from the Borderlands',\n", " 'Thief', 'Dungeons 3', 'Refunct',\n", " 'Warhammer: End Times - Vermintide', \"The Beginner's Guide\",\n", " 'NEKOPARA Vol. 0', 'TerraTech', 'Sands of Salzaar',\n", " 'The Darkness II', 'Alien Swarm: Reactive Drop',\n", " 'Mutant Year Zero: Road to Eden', 'NBA 2K21',\n", " 'Yakuza: Like a Dragon', 'Iron Snout', 'Day of Defeat: Source',\n", " 'Dragon Age: Origins - Ultimate Edition', 'Rogue Legacy',\n", " 'Portal Knights', 'DJMAX RESPECT V', 'Farm Together',\n", " 'Return of the Obra Dinn', 'Dust: An Elysian Tail',\n", " 'Orcs Must Die! 2', 'Universe Sandbox',\n", " 'Bendy and the Ink Machine', 'The Outer Worlds',\n", " 'Amazing Cultivation Simulator', 'Resident Evil Revelations 2',\n", " 'Magic Duels', 'The Expendabros', 'Golf It!',\n", " 'TrackMania Nations Forever', 'Kingdom: Classic',\n", " 'Infestation: The New Z', 'Rocksmith® 2014 Edition - Remastered',\n", " 'We Were Here', 'Day of Infamy', 'Holdfast: Nations At War',\n", " 'Paint the Town Red', 'Clone Drone in the Danger Zone',\n", " 'Pillars of Eternity', 'Tropico 6', \"Who's Your Daddy?!\",\n", " 'Move or Die', 'Spiral Knights', 'Surviving Mars',\n", " \"Conqueror's Blade\", 'Sniper Elite 3', 'Shadow Warrior 2',\n", " 'The Evil Within', 'World War 3', 'Alien Swarm', 'ATLAS',\n", " 'Foxhole', 'Quantum Break', 'Crush Crush',\n", " 'Bully: Scholarship Edition',\n", " 'Microsoft Flight Simulator X: Steam Edition', 'Russian Fishing 4',\n", " 'Sonic Mania', 'KARDS - The WWII Card Game', 'Bayonetta',\n", " 'Blackwake', 'DCS World Steam Edition',\n", " 'Danganronpa 2: Goodbye Despair', 'Farming Simulator 17',\n", " 'Assetto Corsa Competizione',\n", " \"Freddy Fazbear's Pizzeria Simulator\", 'Transformice', 'Beholder',\n", " 'Hacknet', 'Arma 2: Operation Arrowhead', 'ICEY',\n", " 'Kingdoms and Castles', 'The Evil Within 2', 'Deadside',\n", " 'The Plan', 'FINAL FANTASY VII', 'theHunter Classic', 'The Room',\n", " 'Half-Life 2: Episode One', 'Chinese Parents',\n", " 'Crypt of the NecroDancer', 'ABZU', 'Miscreated',\n", " 'Resident Evil 4', '100% Orange Juice', 'The Escapists 2',\n", " 'S.T.A.L.K.E.R.: Call of Pripyat', 'Football Manager 2021',\n", " 'BATTLETECH', 'Tricolour Lovestory', 'ORION: Prelude',\n", " 'Age of History II', 'Age of Empires III: Definitive Edition',\n", " 'Serious Sam 3: BFE', 'Shadow Warrior', 'MudRunner',\n", " 'RISK: Global Domination',\n", " \"Deus Ex: Human Revolution - Director's Cut\", 'Super Hexagon',\n", " 'Empyrion - Galactic Survival', 'Total War: SHOGUN 2',\n", " 'Danganronpa: Trigger Happy Havoc', 'APB Reloaded', 'Sven Co-op',\n", " 'Bloons TD Battles', 'Life is Strange 2', 'Total War: ATTILA',\n", " 'Hurtworld', 'L.A. Noire', 'Rivals of Aether', 'Graveyard Keeper',\n", " 'Age of Mythology: Extended Edition', 'Medieval Dynasty',\n", " 'Creativerse', 'Nioh: Complete Edition', 'Unheard',\n", " 'Mafia III: Definitive Edition', 'Skullgirls 2nd Encore',\n", " 'NEKOPARA Vol. 1', 'DiRT Rally 2.0', 'The Talos Principle',\n", " 'Shakes and Fidget', 'Quake Champions', 'Street Fighter V',\n", " 'Brick Rigs', 'Hero Siege', 'For The King', 'Magicka',\n", " 'A Story About My Uncle', 'Resident Evil 5',\n", " 'Titan Quest Anniversary Edition', 'Two Point Hospital',\n", " 'What Remains of Edith Finch', \"Dragon's Dogma: Dark Arisen\",\n", " 'HuniePop', 'Counter-Strike Nexon: Studio',\n", " 'Stormworks: Build and Rescue', 'Risk of Rain',\n", " 'Wolfenstein II: The New Colossus', 'Wreckfest', 'Neverwinter',\n", " 'Ryse: Son of Rome', 'Transistor', 'Emily is Away',\n", " 'Stranded Deep', 'SUPERHOT', 'Blood and Bacon',\n", " 'Age of Empires® III (2007)', 'Ultimate Chicken Horse',\n", " 'The Wolf Among Us', 'Amnesia: The Dark Descent',\n", " 'Control Ultimate Edition', 'Source Filmmaker',\n", " 'Football Manager 2020', 'Temtem', 'ShellShock Live', 'Depth',\n", " 'Barotrauma', 'Hand Simulator',\n", " 'VA-11 Hall-A: Cyberpunk Bartender Action',\n", " 'Half-Life 2: Episode Two', 'S.T.A.L.K.E.R.: Shadow of Chernobyl',\n", " 'OneShot', 'Super Animal Royale', 'Borderlands: The Pre-Sequel',\n", " 'DRAGON BALL XENOVERSE 2', 'Shadow Tactics: Blades of the Shogun',\n", " 'Town of Salem', 'Resident Evil 6', 'Fishing Planet',\n", " 'Fistful of Frags', 'Verdun', 'DRAGON BALL Z: KAKAROT', 'SOMA',\n", " 'Pavlov VR', 'SpeedRunners', \"Five Nights at Freddy's\", 'Grounded',\n", " 'Yu-Gi-Oh! Duel Links', 'A Way Out', 'Duck Game',\n", " 'Skul: The Hero Slayer', 'Outlast 2', 'Gang Beasts',\n", " 'Life is Strange: Before the Storm', 'DiRT Rally', 'Bastion',\n", " 'Alan Wake', 'They Are Billions', 'GTFO', 'Blender',\n", " 'Game Dev Tycoon', 'Banished', 'FINAL FANTASY XV WINDOWS EDITION',\n", " 'My Time At Portia', 'Realm of the Mad God Exalt',\n", " 'Wolcen: Lords of Mayhem', 'Cry of Fear', 'Max Payne 3', 'INSIDE',\n", " 'Prey', 'CODE VEIN', 'Brothers - A Tale of Two Sons', 'Rec Room',\n", " 'Overcooked! 2', 'Mafia: Definitive Edition', 'Torchlight II',\n", " 'Sniper Elite 4', 'Call of Duty: World at War',\n", " 'Total War: WARHAMMER', 'Crossout', 'Mortal Kombat X',\n", " 'The Stanley Parable', 'Red Dead Online',\n", " 'Car Mechanic Simulator 2018', 'Northgard', 'Albion Online',\n", " 'Realm Royale', 'LIMBO', 'A Dance of Fire and Ice', 'Left 4 Dead',\n", " 'Ultimate Custom Night', 'My Summer Car',\n", " 'Hotline Miami 2: Wrong Number', 'Soundpad',\n", " 'PC Building Simulator', 'Green Hell', 'Plague Inc: Evolved',\n", " 'Getting Over It with Bennett Foddy', 'Besiege',\n", " 'Jurassic World Evolution', 'Wolfenstein: The New Order', 'Noita',\n", " 'A Hat in Time', 'Dishonored 2', 'Rising Storm 2: Vietnam',\n", " 'Black Desert', 'Just Cause 2', 'Teardown',\n", " 'CarX Drift Racing Online', 'Sleeping Dogs: Definitive Edition',\n", " 'The Isle', 'Spec Ops: The Line',\n", " 'Star Wars: Battlefront 2 (Classic, 2005)', \"Baldur's Gate 3\",\n", " 'Alien: Isolation', 'Resident Evil 3', 'Golf With Your Friends',\n", " 'Mafia II (Classic)', 'Fallout Shelter', 'AdVenture Capitalist',\n", " 'METAL GEAR RISING: REVENGEANCE', 'Metro: Last Light Redux',\n", " 'XCOM: Enemy Unknown', \"Hellblade: Senua's Sacrifice\", 'Broforce',\n", " 'DRAGON BALL FighterZ', 'Yakuza 0', 'Battlerite', 'Ravenfield',\n", " 'Planet Coaster', 'Tabletop Simulator', 'Papers, Please',\n", " 'Ori and the Blind Forest: Definitive Edition', 'Firewatch',\n", " 'The Binding of Isaac', 'Clicker Heroes',\n", " 'FINAL FANTASY XIV Online', 'Fallout 76', 'Warface', 'Planet Zoo',\n", " 'Minion Masters', 'Goat Simulator',\n", " \"Tom Clancy's Ghost Recon® Wildlands\", 'Friday the 13th: The Game',\n", " 'GRIS', 'Kenshi', 'Chivalry: Medieval Warfare', 'Persona 4 Golden',\n", " 'PlanetSide 2', 'Celeste', 'SCUM', 'Everlasting Summer', 'Portal',\n", " 'TEKKEN 7', 'Prison Architect', 'Metro 2033 Redux',\n", " 'Resident Evil 7 Biohazard', 'Mad Max', 'No More Room in Hell',\n", " 'Farming Simulator 19', 'House Flipper', 'To the Moon',\n", " 'Black Squad', 'Killing Floor', 'Crusader Kings II', 'Beat Saber',\n", " 'Subnautica: Below Zero', 'FTL: Faster Than Light',\n", " 'Dyson Sphere Program', 'NARUTO SHIPPUDEN: Ultimate Ninja STORM 4',\n", " 'Saints Row: The Third', 'Conan Exiles',\n", " 'Totally Accurate Battlegrounds', 'Elite Dangerous',\n", " 'Total War: THREE KINGDOMS', 'Enter the Gungeon', 'Deceit',\n", " 'Hell Let Loose', 'Assetto Corsa', 'Dishonored', 'Saints Row IV',\n", " 'The Witcher 2: Assassins of Kings Enhanced Edition', 'POSTAL 2',\n", " 'Aim Lab', 'METAL GEAR SOLID V: THE PHANTOM PAIN', 'Trove',\n", " 'Gunfire Reborn', 'Crusader Kings III', 'Half-Life: Alyx',\n", " 'Grim Dawn', 'Half-Life', 'Dota Underlords', 'Frostpunk',\n", " 'Warhammer: Vermintide 2', 'Hotline Miami', 'Company of Heroes 2',\n", " 'Ring of Elysium', 'Little Nightmares', 'Devil May Cry 5',\n", " 'Black Mesa', 'Kingdom Come: Deliverance', 'Mirror',\n", " 'This War of Mine', 'Insurgency: Sandstorm', 'MORDHAU',\n", " 'The Long Dark', 'Oxygen Not Included', 'Scrap Mechanic',\n", " 'World of Warships', 'Grand Theft Auto IV: The Complete Edition',\n", " 'Outlast', 'Robocraft', 'Ori and the Will of the Wisps',\n", " 'ASTRONEER', 'Borderlands 3', 'Totally Accurate Battle Simulator',\n", " 'Age of Empires II (2013)', 'Slime Rancher',\n", " 'Stick Fight: The Game', 'World of Tanks Blitz',\n", " 'Europa Universalis IV', 'Heroes & Generals', 'Killing Floor 2',\n", " \"Don't Starve\", 'Squad', 'Satisfactory',\n", " 'Age of Empires II: Definitive Edition', 'Kerbal Space Program',\n", " 'Space Engineers', 'Project Zomboid', 'Darkest Dungeon®',\n", " 'American Truck Simulator', 'Dead Cells', 'Resident Evil 2',\n", " 'Total War: WARHAMMER II', 'Cuphead', 'Hunt: Showdown',\n", " 'Slay the Spire', 'Insurgency', 'Z1 Battle Royale', 'Stellaris',\n", " 'BioShock Infinite', 'VRChat', 'People Playground', 'BeamNG.drive',\n", " 'SCP: Secret Laboratory', 'RimWorld', 'Counter-Strike: Source',\n", " 'Deep Rock Galactic', 'DOOM Eternal', 'Mount & Blade: Warband',\n", " 'Half-Life 2', 'Factorio', 'Starbound', 'Portal 2',\n", " 'Fallout: New Vegas', 'Human: Fall Flat', 'DOOM', 'Path of Exile',\n", " 'Mount & Blade II: Bannerlord', 'Undertale', 'Hearts of Iron IV',\n", " \"No Man's Sky\", 'Geometry Dash', 'Raft', 'Cities: Skylines',\n", " 'Hades', 'Subnautica', 'Bloons TD 6', '7 Days to Die',\n", " 'The Elder Scrolls V: Skyrim Special Edition', 'Counter-Strike',\n", " 'Risk of Rain 2', 'The Binding of Isaac: Rebirth', 'Arma 3',\n", " 'Tomb Raider', 'Sea of Thieves', 'DayZ', 'Fallout 4',\n", " 'Hollow Knight', 'Brawlhalla', 'War Thunder', 'Borderlands 2',\n", " 'The Elder Scrolls V: Skyrim', 'Monster Hunter: World',\n", " 'Dying Light', \"Don't Starve Together\", 'The Forest',\n", " 'Cyberpunk 2077', 'Destiny 2', 'Phasmophobia', 'Warframe',\n", " 'Unturned', 'ARK: Survival Evolved', 'Stardew Valley',\n", " 'Dead by Daylight', 'PAYDAY 2', 'Wallpaper Engine',\n", " 'Euro Truck Simulator 2', 'Left 4 Dead 2', 'Rust', \"Garry's Mod\",\n", " 'Team Fortress 2', 'Terraria', 'Grand Theft Auto V', 'Dota 2',\n", " 'Counter-Strike: Global Offensive'], dtype=object)" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.sort_values('positive').reset_index().positive.unique()\n", "df.sort_values('positive').reset_index().gamename.unique()" ] }, { "cell_type": "code", "execution_count": 6, "id": "ff167d66", "metadata": {}, "outputs": [], "source": [ "gb = df.groupby(['date', 'multi_player']).mean('avg')\n", "gb = gb.reset_index()" ] }, { "cell_type": "code", "execution_count": 232, "id": "9e71dbd9", "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/plain": [ "11535 -250248.99\n", "19830 -132161.46\n", "33997 -99716.06\n", "23425 -99352.39\n", "15670 -98787.12\n", " ... \n", "63570 NaN\n", "63652 NaN\n", "63708 NaN\n", "63772 NaN\n", "63853 NaN\n", "Name: gain, Length: 63854, dtype: float64" ] }, "execution_count": 232, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.sort_values(by=['gain']).gain" ] }, { "cell_type": "code", "execution_count": 231, "id": "fb7a7687", "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/html": [ "
\n", " | gamename | \n", "year | \n", "month | \n", "avg | \n", "gain | \n", "peak | \n", "avg_peak_perc | \n", "date | \n", "release_date | \n", "required_age | \n", "... | \n", "genre_sports | \n", "genre_racing | \n", "genre_rpg | \n", "genre_simulation | \n", "indie | \n", "full_audio | \n", "full_controller_support | \n", "age_0_plus | \n", "age_13_plus | \n", "age_18_plus | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11535 | \n", "Cyberpunk 2077 | \n", "2021 | \n", "January | \n", "82146.66 | \n", "-250248.99 | \n", "225670 | \n", "36.4012% | \n", "2021-01-01 | \n", "2020-12-09 | \n", "17 | \n", "... | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "
19830 | \n", "Fallout 4 | \n", "2015 | \n", "December | \n", "94136.37 | \n", "-132161.46 | \n", "201635 | \n", "46.6865% | \n", "2015-12-01 | \n", "2015-11-09 | \n", "17 | \n", "... | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "
33997 | \n", "Monster Hunter: World | \n", "2018 | \n", "September | \n", "88575.17 | \n", "-99716.06 | \n", "227644 | \n", "38.9095% | \n", "2018-09-01 | \n", "2018-08-09 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
23425 | \n", "Grand Theft Auto V | \n", "2015 | \n", "May | \n", "93361.62 | \n", "-99352.39 | \n", "215966 | \n", "43.2298% | \n", "2015-05-01 | \n", "2015-04-13 | \n", "17 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "
15670 | \n", "Dota 2 | \n", "2015 | \n", "September | \n", "508156.85 | \n", "-98787.12 | \n", "888728 | \n", "57.178% | \n", "2015-09-01 | \n", "2013-07-09 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
63570 | \n", "Zup! 3 | \n", "2017 | \n", "January | \n", "91.49 | \n", "NaN | \n", "687 | \n", "13.3173% | \n", "2017-01-01 | \n", "2017-01-12 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
63652 | \n", "ibb & obb | \n", "2014 | \n", "May | \n", "16.25 | \n", "NaN | \n", "186 | \n", "8.7366% | \n", "2014-05-01 | \n", "2014-05-26 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "0 | \n", "
63708 | \n", "klocki | \n", "2016 | \n", "July | \n", "38.36 | \n", "NaN | \n", "121 | \n", "31.7025% | \n", "2016-07-01 | \n", "2016-07-13 | \n", "0 | \n", "... | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
63772 | \n", "rFactor 2 | \n", "2015 | \n", "November | \n", "112.81 | \n", "NaN | \n", "313 | \n", "36.0415% | \n", "2015-11-01 | \n", "2015-11-12 | \n", "0 | \n", "... | \n", "1 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
63853 | \n", "theHunter Classic | \n", "2014 | \n", "June | \n", "1162.48 | \n", "NaN | \n", "2648 | \n", "43.9003% | \n", "2014-06-01 | \n", "2014-06-03 | \n", "0 | \n", "... | \n", "1 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
63854 rows × 42 columns
\n", "