Data Exploration: Video Game Sales
844 words · 5 minutes
This dataset (obtained from Kaggle) contains a list of video games with sales greater than 100,000 copies. It was generated by a scrape of vgchartz.com.
- Rank - Ranking of overall sales
- Name - The games name
- Platform - Platform of the games release (i.e. PC,PS4, etc.)
- Year - Year of the game's release
- Genre - Genre of the game
- Publisher - Publisher of the game
- NA_Sales - Sales in North America (in millions)
- EU_Sales - Sales in Europe (in millions)
- JP_Sales - Sales in Japan (in millions)
- Other_Sales - Sales in the rest of the world (in millions)
- Global_Sales - Total worldwide sales.
There are 16,598 records. 2 records were dropped due to incomplete information.
Import the Data
# Import the Python libraries we will be using ; # Load the file using the path to the downloaded file = r =
Explore the Data
# With the description function, we can see the basic stats. For example, we can also see that the 'Year' column has some incomplete values.
# This function shows the rows and columns of NaN values. For example, df[179,3] = nan
Visualize the Data
# This function plots the global sales by platform
# This function plots the global sales by genre
# This function plots the global sales by year
# This function plots four different lines to show sales from different regions. # The global sales plot line is commented-out, but can be included for comparison = = = = = = # e = df2['Global_Sales'] , = # ax.plot(years, e, label='Global_Sales')
# Find the game with the highest sales in North America 1 2006 41.49 29.02 3.77 8.46 82.74 : 0, : # Explore statistics in the year 2006 (highest selling year) =
# Plot the results of the previous dataframe (games from 2006) - we can see the year's results were largely carried by Wii Sports
# We can see 4 outliers in the graph above, so let's get the top 5 games from that dataframe # The results below show that Nintendo had all top 5 games (3 on the Wii and 2 on the DS)
The purpose of exploring datasets is to ask questions, answer questions, and discover intelligence that can be used to inform decision-making. So, what have we found in this dataset?
Today, we simply explored a publicly-available dataset to see what kind of information it contained. During that exploration, we found that video game sales peaked in 2006. That peak was largely due to Nintendo, who sold the top 5 games in 2006 and has a number of games in the top 10 list for the years 1980-2020. Additionally, the top four platforms by global sales (Wii, NES, GB, DS) are owned by Nintendo.
We didn't explore everything this dataset has to offer, but we can tell from a brief analysis that Nintendo seems to rule sales in the video gaming world. Further analysis could provide insight into which genres, regions, publishers, or world events are correlated with sales.