Analysis Video Games Sales - AWS Service and Python

Group Project: Yanjun Liu, Rayna Liu, Zheyue Wang

Introduction

Video games are a billion-dollar business and have been for many years since the first games emerged in the 1970s. During the COVID-19 pandemic, gaming has become entertainment and time filling for many people. Especially, the Nintendo games, Playstation games, and PC games. As a result, there is an increased interest in gaming and video game sales have increased due to COVID-19-related lockdown measures. In this project, we are going to analyze the sales trends from more than 16,500 popular video games.

Dataset

This dataset contains a list of video games with sales greater than 100,000 copies form Kaggle.

AWS Service

  • AWS S3
  • AWS Athena
  • AWS Host a Static Website
  • AWS Polly

Table of Contents:

Our repoistory contain:

  • vgsales.csv
    • Video Games Sales
  • VG_Sales_Python_Visualization.html
    • HTML file of python analysis of the video games sales
  • Athena Query Result and Python Visualization Code
    • Question 1.csv
    • Question 2.csv
    • Question 3-1.csv
    • Question 3-2.csv
    • Question 3-3.csv
    • Question 3-4.csv
    • Question 4.csv
    • VG_Sales_Python_Visualization.ipynb -- python file
  • Demo
    • Demo Instruction.docx
    • Demo Speech Notes.docx
  • CC Group 8 Final Project Presentation.pptx
    • Presentation of final project

How It Works

  1. Look at the powerpoint CC Group 8 Final Project Presentation.pptx.
  2. If you have any issue to play Demo video, click Here.
  3. Check python code click Github Pages.

If any problem in code, going to Zheyue Wang GitHub click Here and Yanjun Liu GitHub click Here.