WHO

Take CONTROL?

2 UP 003200

CREDITS

An analysis of video games sold in the 90’s and early 2000’s

BY SLIDESGO

1 UP 25000

BY SLIDESGO

CREDITS

1 UP 25000

2 UP 003200

START

Our team analyzed the video game dataset to investigate the correlation between average critic score and average total sales by publisher

Follow the link in the graph to modify its data and then paste the new one here. For more info, click here

Backstory:Original Data

Original data in csv format

Level 1: Data Wrangling

​

• Imported CSV file to JupyterLab then, imported math, numpy, and pandas, and matplotlib packages
• Obtained just the year of release date for every row
• Remove the release date column and then added a new “release date” column
• Replaced the “nan” element with “0” string in TS column and rows
• Removed “m,” that stands for million from stings in TS
• Changing string type in TS to float types

Level 2: Calculating Averages

90’s

2000’s

Average total sales by publisher in the 90’s

Average total sales by publisher in the 2000’s

Level 3: Data Visualization

Top 10 publishers based on average critic score for the early 2000’s

Top 10 publishers based on average total sales for early 2000’s

Top ten publishers w. highest average total sales in 90s data set

Top ten publishers w. highest average critic score in 90s data set

Level 4: Conclusion

• Figure out how to data wrangle
• Had a hard time getting rid of “nan” element
• Figuring out how to remove the “m” in the total sales column

• 0ne of the most successful video games in 90’s influenced by critic score are Guitar Hero (RedOctane) and in the 2000’s Grand Theft (Rockstar Games)

Future goal:

Create a growth model to predict future top 10 video game publishers based on average total sales and critic score

THANKS!

1 UP 25000

DO YOU HAVE ANY QUESTIONS?

​

BY SLIDESGO

CREDITS

2 UP 003200

Please keep this slide for attribution

CREDITS: This presentation template was created by Slidesgo, including icons by Flaticon, infographics & images by Freepik