-
Notifications
You must be signed in to change notification settings - Fork 0
/
README- VIDEOGAME SALES ANALYSIS QUESTIONS.txt
119 lines (84 loc) · 2.63 KB
/
README- VIDEOGAME SALES ANALYSIS QUESTIONS.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
VIDEO GAME SALES ANALYSIS
==============================
Skills:
SQL
Python
Matplotlib
Seaborn
numpy
Tableau
Excel
==============================
Description: Data analysis of the videogame sales, using the
questions are provided in kaggle.com as guide. To answer each question, a python script
was used to retrieve the information from the sqlite database created and plot the
results with Seaborn (matplotlib) and save them into a txt file as well.
The sqlite relational database (created in the previous step using the cleaned Excel
csv file) will be used as data source to analyze the data and answer the questions.
Results will be also plotted in Tableau using the cleaned csv Excel file as source.
Note: each question was answered using a separate python code for each one, but all
questions could have been answered all together in one python code. For practicity,
separace scripts were done, to keep the scripts simple and short.
==============================
SOURCE:
https://www.kaggle.com/datasets/gregorut/videogamesales?select=vgsales.csv
==============================
Running the code:
-From windows command prompt, execute the .py file by writing "python filename.py"
==============================
Requirements:
-Python 3.7.1 or superior installed
==============================
Output:
-Plot done with Python matplotlib.
-Txt file with results
==============================
ANALYSIS QUESTIONS (see answers in separate files and folders)
1. What genre games have been made the most
2. Which year had the most game release
4. Which year had the highest sales worldwide
5. Which genre game has been released the most in a single year
10. Sales comparison by genre
==============================
Python scripts:
1. vgsales01genregames.py
2. vgsales02yeargames.py
3. vgsales04salesyear.py
5. vgsales05gamesgenreyear.py
10. vgsales10genresales.py
==============================
Skills by question:
1. What genre games have been made the most
SQL
Python
Matplotlib
Seaborn
2. Which year had the most game release
SQL
Python
Matplotlib
Seaborn
4. Which year had the highest sales worldwide
SQL
Python
Matplotlib
Seaborn
5. Which genre game has been released the most in a single year
SQL
Python
Matplotlib (horizontal bars)
Seaborn
10. vgsales10genresales.py
SQL
Python
Matplotlib (grouped bar plot)
Seaborn
Numpy
==============================
Files uploaded (per question):
-Python script
-Txt file with results
-Plots done with matplotlib
-Tableau plots (optional)
-Windows command prompt screenshot
-SQL query (optional)