DATA 607 - Tidyverse CREATE
Eddie Xu
2023-04-12
TIDYVERSE CREATE ASSIGNMENT
This assignment will be create a vignette about one of TIDYVERSE libraries, ggplot. Other libraries of the tidyverse will be used for data wrangling. In this case, a dataset from kaggle (https://www.kaggle.com/datasets/arnabchaki/popular-video-games-1980-2023?resource=download) will be used to demonstrates the capacity of data visualization in R Studio.
Load Packages
library(tidyverse)## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.1.0 ✔ readr 2.1.4
## ✔ forcats 1.0.0 ✔ stringr 1.5.0
## ✔ ggplot2 3.4.1 ✔ tibble 3.2.0
## ✔ lubridate 1.9.2 ✔ tidyr 1.3.0
## ✔ purrr 1.0.1
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the ]8;;http://conflicted.r-lib.org/conflicted package]8;; to force all conflicts to become errorslibrary(lubridate)Load Dataset
The dataset contains popular video games titles from 1980 to 2023.
# read. csv and load the dataset
raw_file <- "https://raw.githubusercontent.com/eddiexunyc/SPRING2023TIDYVERSE/exu/games.csv"
raw_dataset <- read.csv(raw_file)
head(raw_dataset)## X Title Release.Date
## 1 0 Elden Ring Feb 25, 2022
## 2 1 Hades Dec 10, 2019
## 3 2 The Legend of Zelda: Breath of the Wild Mar 03, 2017
## 4 3 Undertale Sep 15, 2015
## 5 4 Hollow Knight Feb 24, 2017
## 6 5 Minecraft Nov 18, 2011
## Team Rating Times.Listed
## 1 ['Bandai Namco Entertainment', 'FromSoftware'] 4.5 3.9K
## 2 ['Supergiant Games'] 4.3 2.9K
## 3 ['Nintendo', 'Nintendo EPD Production Group No. 3'] 4.4 4.3K
## 4 ['tobyfox', '8-4'] 4.2 3.5K
## 5 ['Team Cherry'] 4.4 3K
## 6 ['Mojang Studios'] 4.3 2.3K
## Number.of.Reviews Genres
## 1 3.9K ['Adventure', 'RPG']
## 2 2.9K ['Adventure', 'Brawler', 'Indie', 'RPG']
## 3 4.3K ['Adventure', 'RPG']
## 4 3.5K ['Adventure', 'Indie', 'RPG', 'Turn Based Strategy']
## 5 3K ['Adventure', 'Indie', 'Platform']
## 6 2.3K ['Adventure', 'Simulator']
## Summary
## 1 Elden Ring is a fantasy, action and open world game with RPG elements such as stats, weapons and spells. Rise, Tarnished, and be guided by grace to brandish the power of the Elden Ring and become an Elden Lord in the Lands Between.
## 2 A rogue-lite hack and slash dungeon crawler in which Zagreus, son of Hades the Greek god of the dead, attempts to escape his home and his oppressive father by fighting the souls of the dead through the various layers of the ever-shifting underworld, while getting to know and forging relationships with its inhabitants.
## 3 The Legend of Zelda: Breath of the Wild is the first 3D open-world game in the Zelda series. Link can travel anywhere and be equipped with weapons and armor found throughout the world to grant him various bonuses. Unlike many games in the series, Breath of the Wild does not impose a specific order in which quests or dungeons must be completed. While the game still has environmental obstacles such as weather effects, inhospitable lands, or powerful enemies, many of them can be overcome using the right method. A lot of critics ranked Breath of the Wild as one of the best video games of all time.
## 4 A small child falls into the Underground, where monsters have long been banished by humans and are hunting every human that they find. The player controls the child as they try to make it back to the Surface through hostile environments, all the while engaging with a turn-based combat system with puzzle-solving and bullet hell elements, as well as other unconventional game mechanics.
## 5 A 2D metroidvania with an emphasis on close combat and exploration in which the player enters the once-prosperous now-bleak insect kingdom of Hallownest, travels through its various districts, meets friendly inhabitants, fights hostile ones and uncovers the kingdom's history while improving their combat abilities and movement arsenal by fighting bosses and accessing out-of-the-way areas.
## 6 Minecraft focuses on allowing the player to explore, interact with, and modify a dynamically-generated map made of one-cubic-meter-sized blocks. In addition to blocks, the environment features plants, mobs, and items. Some activities in the game include mining for ore, fighting hostile mobs, and crafting new blocks and tools by gathering various resources found in the game. The game's open-ended model allows players to create structures, creations, and artwork on various multiplayer servers or their single-player maps. Other features include redstone circuits for logic computations and remote actions, minecarts and tracks, and a mysterious underworld called the Nether. A designated but completely optional goal of the game is to travel to a dimension called the End, and defeat the ender dragon.
## Reviews
## 1 ["The first playthrough of elden ring is one of the best eperiences gaming can offer you but after youve explored everything in the open world and you've experienced all of the surprises you lose motivation to go exploring on repeat playthroughs which takes a lot away from the replayability which is a very important thing for from games imo.", 'a replay solidified my love for elden ring. so easily my favorite game of all time. actually beating malenia this time was also an amazing feeling. i just love being in this world man its the greatest of all time', 'The game is absolutely beautiful, with so much to do. The replayability is crazy. And it never gets old with it too.', 'Took everything great about the Soulsborne games and make it 100% better.', 'I play with my overlevelled friend every time and we still fail sometimes (he’s on NG6), insanely difficult game lol\\n \\n gorgeous graphics, animations, everything about this game is so beautiful. deserves all the hype it gets. If you have a powerful enough pc I definitely recommend you play it on there, if you use keyboard, you’ll want to change the keybinds because the defaults are ass.', "Tied as my favorite souls game with Bloodborne, truly one I'll keep coming back too."]
## 2 ['convinced this is a roguelike for people who do not like the genre. The art is technically good but the aesthetic does very little for me, too clean or something. idk wish I liked it but I do not', 'incredible art, a banger soundtrack a surprisingly charming storyline and a big red dog. hades has very smooth gameplay but after playing it for a while it just feels like youre doing the same 3 hit combo ove and over again, which dont get me wrong that combo feels great to do but once i becomes muscle memory you kinda go into autopilot. also i think the boons are cool but i would like to see them change the flow of combat a bit more, there are some cool ones like the grape boon that can change the way you play but most of them are just upgrades that dont really change the gameplay or strategy. other then those 2 small gripes the game is fantastic.', "People tell me this game gets really really good at some point but i've beaten entire games in the amount of time I gave this game.", 'Não sou muito de jogo indie, admito que joguei poucos, mas devo dizer que Hades foi um dos melhores jogos que joguei na vida, facilmente no top 15. Toda sua arte, dublagem, gameplay, carisma dos personagens, é tudo incrivel', "I can't shake the feeling that I am thoroughly bored playing Hades. I've picked up Hades three times over the last few years, and three times I've found myself putting down the controller after a handful of hours, especially after reaching the third stage, and I couldn't figure out why it wasn't working for me. After giving it a few good goes, I've finally managed to pin down what it is that just doesn't click for me about Hades.", 'One of my favorites in the rogue-likes/lites, only being beat by binding of Isaac. I love the characters (Thanatos my beloved) and the writing and the art style and RRRAAAAHHH THIS GAME IS AWESOME']
## 3 ['This game is the game (that is not CS:GO) that I have played the most ever. I have played this game for 400 hours.', "A really good switch game, however didn't really grip me like mario odyssey", "i was very disappointed by the final boss fight, but the rest of the game is so good it makes me not want to even do the final boss fight anyway just so i can play more of the game. i do wish that there were more unique mechanics in combat besides just parrying and link's flurry rush, but the world is really pretty and actually incentivizes exploring it. characters are great, story is great and makes you work for it, and there's tons of hidden secrets and details.", 'em 105 horas de jogo não houve um segundo que eu não tava me divertindo e eu acho que isso diz muito', 'Sencillamente el mejor juego que he tenido el placer de disfrutar, esperé 5 años para poder jugarlo y puedo decir que valió cada segundo la espera. No estoy ni cerca de conseguir el 100%, tengo mas de 100 horas y aún estoy descubriendo cosas nuevas. Va más allá de un simple juego, es una experiencia que lamentablemente solo se puede vivir una vez en la vida y la recomiendo totalmente.', 'em meio a tanto jogo de mundo aberto ruim saindo por aí na última década, acho que da pra entender porque breath of the wild chocou tanto as pessoas no ano em que ele lançou. E realmente eu acho que é o melhor mundo aberto que eu já joguei até hoje, explorar cada pedacinho desse mundo é TÃO GOSTOSO, parece que tudo aqui tá no mapa tem um propósito para estar lá, diferente dos mapas vazios da ubisoft por exemplo. Acho que o unico defeito é esses sistema chatinho de durabilidade das armas, ficar trocando de arma o tempo todo é tão chato, espero que no próximo não tenha.']
## 4 ['soundtrack is tied for #1 with nier automata. a super charming story and characters which have become iconic. and all that made by 1 man. thats it, thats the review i have no criticisms', 'Just play this game, Dont look at any of these reviews, just pick the game up and know nothing else about it if you are one of the lucky ones that didnt get spoiled on the game. It will fucking break you in the best of ways', 'Não há palavras que deem para descrever a experiência que foi esse jogo.', 'CLASSSSSSSSSSSSSSSICCCCCCCCCCCCCCCCCCC', 'whooaa ohh ohhhh ohoohhohh ohhwooaah story of undertale', 'A nice unique take on the RPG indie game format by incorporating really good ideas, funny interactions, an incredibly subtle story, and wonderful music. Definitely a must play if you have not already.']
## 5 ["this games worldbuilding is incredible, with its amazing soundtrack and gorgeous art direction it really makes you feel like you're spiderman. one of the best value in gaming tbh, this game is packed full of content and none of it feels like filler. even the boss rush manages to feel fresh by introducing some surprise bosses/boss variants as rewards for beating tough pantheons. cant wait to play silksong when i turn 80!", "This isn't just a game, this is an entire experience.\\n \\n I was not too much into Metroidvania games and then I tried this without any expectation, it became one of my favorite games of all time and brought me into the genre, now I'm seeking for similar adventures and I can't wait for Silksong.\\n \\n I've done all 112% in my first run and now I'm beating the game again, then I'll aim to master the game on Steam, and this is the first time a game instigated me to do that. Masterpiece.", 'Faz uns 2/3 anos que eu zerei esse jogo, mesmo assim nunca saiu da minha memória.\\n \\n Vou rejogar para fazer uma análise mais aprofundada', 'i like how you can bounce on spikes with your nail. a good casual game that offers additional challenges for people that are socially challenged', 'A rivetting action/adventure game with a stunning design. Extremely rewarding but also gruesomly difficult at times.', 'I\\'d give this game a 4 for each individual aspect (platforming, exploration, combat) but the integration and packaging of the content are so good, it\\'s slightly better that the sum of its parts. Most of the combat and traversal abilities feel useful, and many evoke that Super Metroid-y, gleeful feeling that you\\'ll finally be able to access that new area, grab that item, or beat that boss. The end-game challenges, reminiscent of Wiley\\'s fortress and boss rushes after Megaman has fully self-actualized, were the highlight. Boss rushes in particular were fun to dissect and master. I found uses for some charms I had written off as "not my style" to counter some of the unconventional boss mechanics. My only gripes:\\n \\n -The repeated backtracking. I get it - a fast-travel mechanic that\\'s too liberal can erase the environment, but this was excessive.\\n \\n -Some of the charms seemed worthless, even after strategizing for boss, combat, and platforming rushes.\\n \\n -In the name of decency and civility, make geo-sucking ability automatic.']
## 6 ['Minecraft is what you make of it. Unfortunately theres no reason to do anything.', 'muito bom, vc pode construir, usar sua imaginação, mods, sobreviver, jogar multiplayer e até zerar o jogo! minecraft é um jogo incrível e fica melhor a cada atualização, (nunca zerei mesmo depois de muitos anos)', 'Jogo incrível, muito divertido, e com amigos fica ainda mais legal.', 'baby gammeeee 😭\\n \\n had the most fun playing when it was first released sory\\n \\n still fun for a couple of hours when playing with people tho! 😁', 'Майнкрафт сука это моя жизнь блядь! МАЙНКРААААФТ!!! Ой, мама пришла.', 'E um game maneiro mais jogar ele sem amigos ou sem mods é meio chato']
## Plays Playing Backlogs Wishlist
## 1 17K 3.8K 4.6K 4.8K
## 2 21K 3.2K 6.3K 3.6K
## 3 30K 2.5K 5K 2.6K
## 4 28K 679 4.9K 1.8K
## 5 21K 2.4K 8.3K 2.3K
## 6 33K 1.8K 1.1K 230Data Clean up
By using dplyr package for data wrangling, the data can be cleaned up and be perpared for data visualization.
# Convert "K" into 1000 and the data type to numeric
raw_dataset$Number.of.Reviews <- as.numeric(gsub("K", "e3", raw_dataset$Number.of.Reviews))
# Convert Release Date into date data type through the lubridate package
raw_dataset$Release.Date <- mdy(raw_dataset$Release.Date)## Warning: 3 failed to parse.# sort the data based on the rating
video_game_data <- raw_dataset %>%
arrange(desc(raw_dataset$Rating))
head(video_game_data)## X Title Release.Date
## 1 1252 Elden Ring: Shadow of the Erdtree <NA>
## 2 28 Disco Elysium: The Final Cut 2020-05-01
## 3 43 Outer Wilds 2019-05-28
## 4 139 Disco Elysium 2019-10-15
## 5 252 Umineko: When They Cry Chiru 2009-09-15
## 6 297 Bloodborne: The Old Hunters 2015-11-24
## Team Rating Times.Listed
## 1 ['FromSoftware', 'Bandai Namco Entertainment'] 4.8 18
## 2 ['ZA/UM'] 4.6 1.1K
## 3 ['Mobius Digital', 'Annapurna Interactive'] 4.6 1.8K
## 4 ['ZA/UM'] 4.6 1.1K
## 5 ['07th Expansion'] 4.6 324
## 6 ['FromSoftware', 'Sony Computer Entertainment'] 4.6 266
## Number.of.Reviews Genres
## 1 18 ['Adventure', 'RPG']
## 2 1100 ['Adventure', 'Indie', 'RPG']
## 3 1800 ['Adventure', 'Indie', 'Puzzle', 'Simulator']
## 4 1100 ['Adventure', 'RPG', 'Turn Based Strategy']
## 5 324 ['Adventure', 'Visual Novel']
## 6 266 ['Adventure', 'RPG']
## Summary
## 1 An expansion to Elden Ring setting players on a new adventure in the Lands Between.
## 2 Disco Elysium: The Final Cut is a groundbreaking role playing game. You’re a detective with a unique skill system at your disposal and a whole city to carve your path across. Interrogate unforgettable characters, crack murders or take bribes. Become a hero or an absolute disaster of a human being. The Final Cut adds full voice acting to the game, as well as new quests, more characters and fresh explorable areas.
## 3 Outer Wilds is a critically-acclaimed and award-winning open world mystery about a solar system trapped in an endless time loop. The newest member of the space program in a small village on the planet Timber Hearth, the player navigates a space shuttle and travels across their solar system to get to the bottom of its mysteries by exploring the cosmos and gathering the knowledge hidden within each of the system's planets, left behind by another civilization in the distant past.
## 4 A CRPG in which, waking up in a hotel room a total amnesiac with highly opinionated voices in his head, a middle-aged detective on a murder case inadvertently ends up playing a part in the political dispute between a local labour union and a larger international body, all while struggling to piece together his past, diagnose the nature of the reality around him and come to terms with said reality.
## 5 Umineko no Naku Koro ni Chiru is the second half of the Umineko no Naku Koro ni series, and contains Episodes 5 to 8 of the story. Unlike the second half of Higurashi no Naku Koro ni, Umineko Chiru does not simply present direct solutions to the first four arcs, but instead gradually delves into the core of the story, revealing clues to its mysteries in the process. It is also referred to as When They Cry 4 in the overall When They Cry franchise.
## 6 The Old Hunters is the first Expansion for Bloodborne. It will feature all new Locations, Bosses, Weapons, and Armor.\n \n\n Set in a nightmare world where hunters from the past are trapped forever, explore brand new stages full of dangers, rewards and deadly beasts to overcome. You’ll find multiple new outfits and weapons to add to your arsenal as well as additional magic to wield and add more variety to your combat strategy.\n \n\n With new story details, learn the tale of hunters who once made Yharnam their hunting grounds, meet new NPCs, and discover another side of the history and world of Bloodborne.
## Reviews
## 1 ['I really loved that they integrated Family Guy shorts that plays constantly at the corner of your screen and (lots of people might not know this) , if Peter starts singing your GPU will clock up to 100% and will initiate a complete meltdown of your system.', 'Definitely a good DLC with a good introduction. First zone was insanely hard, and navigating through the city to activate few keypoints to fight a boss was extremely well-thought.', 'its peak']
## 2 ["a captivating journey from start to finish. this uses its characters and dialogue to such great effect, making everything feel intertwined. our protagonist's mind especially was so interesting to delve into and finding out little bits and pieces of his identity was just a joy to do. while the game lets u do things without kitsuragi at times, i never wanted to as he brought much to every scene he was active in. very satisfying resolution and to top it off, its simply hilarious at times as well\\n \\n i love kim kitsuragi sm", 'I love you, Kim Kitsuragi', 'one of the most interesting, politically poignant pieces of art i’ve ever had the pleasure of consuming', "I couldn't finish day 1. Playing this game feels like a chore, which is never a good sign. This was my second attempt at finishing the game and I actually got a lot further than on my first one. I might pick this up again sometime in the future, but I don't think this game is for me.", 'Still unsure whether I like the ending or not and for a game with some of the best worldbuilding I’ve ever seen I wish more of the game had to do with that world - but at the end of the day it’s still the best writing any game has ever had so can’t be too mad', "I was very scared of playing this because I knew it has a lot of text and a crazy big skill tree.\\n \\n First day ingame was horrible, I kept making bad decisions and throws and even got a game-over. Also the game talks about politics in a deep and serious way so I kinda felt like a kid in an adult game haha. I honestly thought I would just abandonned it but at the end of the day there's this discussion you have with Kitsuragi and he's being very nice and comprehensive and it put me in a good mood; So I just decided to go with the fact that I'm playing a pretty bad cop and continue with the game.\\n \\n In the end I really liked it, beautiful art direction and visuals, I loved discovering more about the world. Tho I still probably didn't really understood all the themes and ideas of this game ..."]
## 3 ['Replayed with my girlfriend, still the best game of all time. Nothing compares', "The more I think about this game, the more I love it and realize how unique it is.\\n \\n Such an amazing feeling exploring this solar system, contemplating the infinite dark space with the beautiful score playing. So satisfying to unravel the mysteries and to understand what you need to do, especially when you need to be a little bold. There's a big sense of cohesion in this whole game.\\n \\n The ending is really powerful and you can really feel that you're witnessing something big.\\n \\n It's not my personnal favorite game of all time, yet I feel like it might the best game ever made, if that makes sense.", 'my favorite game ever', 'the most engaging puzzles/riddles ive ever seen in a game. solutions are very clever but not unfair. exploring the planets and their ruins and stumbling on all kinds of crazy shit is a great time, and unraveling the mystery one step at a time so you can piece together the bigger picture is incredibly satisfying. the environment design is also amazing and the concepts in the later portions of the game are so cool and interesting, cant elaborate because of spoilers. the dlc is just okay though ngl, exploring the setting was cool but it felt like a lot of running around doing busy work for very little reward', 'Lo intente en 3 oportunidades y nunca me logró engancharme, está bueno pero medio pelo, para mí', "Fantastic game from start to finish. The curiosity and confusion in the beginning before you experience and realize the loop for the first time is a breath of fresh air. Not much direction, just some input from NPCs about a space mission and before you know it you are uncovering secrets of a fallen race and the death of the universe. The experience is underlined with a fantastic score and the design of the puzzles is great. It's a bit tiresome when you get stuck and feel like you're just too dense to progress, but when things fall in place and DO make sense it's fantastic. When you finally piece everything together, know exactly what you need to do and where is an undescribeable feeling. This is very much as close as you can get to a perfect game"]
## 4 ["I really enjoyed this one. The story is super interesting, most characters are multi-layered and more complex than they initially seem, and how this game handles skills and thoughts is genius. As most reviews for this game have said, it's really great that failing a skill check does not necessarily mean you're now going through a worse version of the game (in some cases it's even a more fun route). The politics and wordbuilding are also super deep and will really please those who enjoy those topics in their media. I personally found myself more engrossed by the game's study of the main character, who was as awful and destructive as he was likeable and relatable. I also found it incredible how the writers have managed to give him his own personality while also allowing a huge amount of his character to be determined by the player. Normally games tend to present one of these two archetypes for their main character, but this mixture of both helps a lot in giving the player a much deeper connection with the character while also allowing the character to serve the main themes of the story.\\n \\n On that note, the amount of choices they give you for customizing him are insane, and they really don't feel overwhelming despite there being multiple methods to change your character. Once again, this contributes heavily into making the player fit into the role-playing aspect of this game more, as their choices contribute to the type of cop they want to be.", 'There is too much you could say about this game. Less of a "game", more of an interactive story with RPG elements - and the story is amazing.', "some of the most human-feeling characters in games. it's well-written, well-acted, and generally very good. well worth a playthrough if it looks at all interesting.", "I really loved this game and how it able to make you feel like Harry through his inner voices. The art style it's so iconic and the music is so good I can't forget them. A little bit short but really worth it, and you can replay it several times", 'ben bilmem kim kitsuragi bilir', "I'm too stupid to get the most out of this game but I absolutely appreciated how they personified the emotions / traits and presented the rpg mechanic in such a visual and eclectic way."]
## 5 ['cried like a little bitch ngl', "God I really wish I hadn't", 'Greatest of all time. Left me in tears after a certain secret tea party. Will forever be my top 1 favorite of all time and will always be in my heart.', "Worse than question arcs, though question arcs a lot of it was good except some glaring pacing problems in episode 4, episode 6 and 8 were a bore to go through it's good but just severely overhyped, decent experience overall", "Do you believe in magic in a young girl's heart?", '-voy a cagar spoilers como un toro así que leer bajo SOLO SI TERMINASTE LA VN-']
## 6 ['HAHA FINALMENTE MATEI O LAWRENCE E O ÓRFÃO DE KOS HAHAHA, 10/10', 'beating orphan of kos means i can do anything', 'Hardest bosses in the entire souls genre and new hunter weapons makes this probably the best from software dlc.', 'An amazing extension of one of the greatest games of all time. Simply put, just pure fun!', 'This has to be the best dlc to accompany a souls game and perhaps one of the best pieces of dlc ever made. In my mind the old hunters and the base game of bloodborne feels inseparable and when rating this im giving both of them a 5. I don’t feel like I can say much more that hasn’t been said but bloodborne feels like a once in a lifetime masterpiece and the old hunters only bolsters it', "Without this piece, bloodborne itself couldn't exist and couldn't fulfill its design to the utmost.\\n \\n An astonishing fact, that this short DLC contains so much content, including the best bosses, which fits to the battle-system really well, enemies, a profound map with calculated connection between locations and, of course, fantastic soundtrack, that surpasses an original OST, in some way."]
## Plays Playing Backlogs Wishlist
## 1 1 0 39 146
## 2 6K 1.2K 5K 2.7K
## 3 7.7K 661 4.8K 3.1K
## 4 4K 478 2.8K 1.9K
## 5 1.7K 108 582 493
## 6 4.4K 68 930 616Data Visualization
With data clean up, the data will be analyzed and presented with a visual for better presentation for audiences.
Top 10
Let start with the top 10 popular games in the past 40 years.
# find the top 10 games based on the rating
top_10_game <- video_game_data %>%
slice_max(video_game_data$Rating, n = 10)
# top 10 lolipop chart
ggplot(top_10_game, aes(x = reorder(`Title`, `Rating`), y = `Rating`)) +
geom_segment(aes(x = reorder(`Title`, `Rating`), xend = reorder(`Title`, `Rating`), y = 0, yend = `Rating`), color = "gray", lwd = 1.5) +
geom_point(size = 7.5, pch = 21, bg = 4, col = 1) +
geom_text(aes(label = `Rating`), color = "white", size = 3) +
xlab("Game Title") +
ylab("Rating") +
coord_flip() +
theme_minimal()
Based on the graph, The game, “Elden Ring: Shadow of the Erdtree”, have the highest rating.
Bottom 10
Now let’s see the bottom 10 games.
# find the top 10 games based on the rating
bottom_10_game <- video_game_data %>%
slice_min(video_game_data$Rating, n = 10)
# bottom 10 lolipop chart
ggplot(bottom_10_game, aes(x = reorder(`Title`, -`Rating`), y = `Rating`)) +
geom_segment(aes(x = reorder(`Title`, -`Rating`), xend = reorder(`Title`, -`Rating`), y = 0, yend = `Rating`), color = "gray", lwd = 1.5) +
geom_point(size = 7.5, pch = 21, bg = 4, col = 1) +
geom_text(aes(label = `Rating`), color = "white", size = 3) +
xlab("Game Title") +
ylab("Rating") +
coord_flip() +
theme_minimal()
On the bottom end, the game with the lowest rating is “Superman: The New Superman Adventures”
Popular Games throughout the Year
With so many popular video games released every year, let’ see how many games were released in every year.
# calculate the total count of popular video games each year
vg_year_count <- video_game_data %>%
mutate(release_year = as.numeric(format(video_game_data$Release.Date, "%Y"))) %>%
drop_na() %>%
group_by(release_year) %>%
summarise(year_count = n())
colnames(vg_year_count) <- c("Release Year", "Year Count")
# line graph
ggplot(vg_year_count, aes(x = `Release Year`, y = `Year Count`)) +
geom_line() +
geom_area(fill = 4,
alpha = 0.5,
color = 1,
lwd = 0.5,
linetype = 1) +
theme_minimal()
As we can see the trend, there are a lot of popular video games released in the 2010s era. From there, we should find out which year have the most popular video games released.
vg_year_count <- vg_year_count %>%
arrange(desc(vg_year_count$`Year Count`))
head(vg_year_count)## # A tibble: 6 × 2
## `Release Year` `Year Count`
## <dbl> <int>
## 1 2022 132
## 2 2021 97
## 3 2019 87
## 4 2018 77
## 5 2016 75
## 6 2020 74# bar graph
ggplot(vg_year_count, aes(reorder(x = `Release Year`, `Year Count`), y = `Year Count`)) +
geom_bar(stat = "identity", fill = "lightgreen") +
geom_text(aes(label = `Year Count`),
vjust = 0.5,
hjust = -0.5,
color = "black",
size = 2) +
coord_flip() +
xlab("Release Year") +
theme_minimal()
It shows that 2022 was the biggest year with 132 video games released.
Compared to other years with the lowest video games released, it is a
hug difference.
Conclusion
With ggplot, we can see how visualizations provide better understanding of the data.