using CSV, DataFrames, StatsPlotsign_filepath = "data//archive//ign_scores.csv""data//archive//ign_scores.csv"
ign_data = CSV.read(ign_filepath, DataFrame)| Platform | Action | Action, Adventure | Adventure | Fighting | Platformer | Puzzle | RPG | Racing | Shooter | Simulation | Sports | Strategy | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | "Dreamcast" | 6.88286 | 7.51111 | 6.28182 | 8.2 | 8.34 | 8.08889 | 7.7 | 7.0425 | 7.61667 | 7.62857 | 7.27222 | 6.43333 |
| 2 | "Game Boy Advance" | 6.37308 | 7.50769 | 6.05714 | 6.22632 | 6.97059 | 6.53214 | 7.54286 | 6.65714 | 6.44444 | 6.92857 | 6.69444 | 7.175 |
| 3 | "Game Boy Color" | 6.27273 | 8.16667 | 5.30769 | 4.5 | 6.35294 | 6.58333 | 7.28571 | 5.89744 | 4.5 | 5.9 | 5.7907 | 7.4 |
| 4 | "GameCube" | 6.53258 | 7.60833 | 6.75385 | 7.42222 | 6.66571 | 6.13333 | 7.89091 | 6.85263 | 6.98182 | 8.02857 | 7.48132 | 7.11667 |
| 5 | "Nintendo 3DS" | 6.67083 | 7.48182 | 7.41429 | 6.61429 | 7.50345 | 8.0 | 7.71923 | 6.9 | 7.03333 | 7.7 | 6.38889 | 7.9 |
| 6 | "Nintendo 64" | 6.64906 | 8.25 | 7.0 | 5.68125 | 6.88966 | 7.46154 | 6.05 | 6.93962 | 8.04286 | 5.675 | 6.96786 | 6.9 |
| 7 | "Nintendo DS" | 5.90361 | 7.24 | 6.2598 | 6.32 | 6.84 | 6.60462 | 7.22262 | 6.03864 | 6.96522 | 5.87436 | 5.93667 | 6.64474 |
| 8 | "Nintendo DSi" | 6.82703 | 8.5 | 6.09091 | 7.5 | 7.25 | 6.81053 | 7.16667 | 6.56364 | 6.5 | 5.19565 | 5.64444 | 6.56667 |
| 9 | "PC" | 6.80579 | 7.33475 | 7.1368 | 7.16667 | 7.41094 | 6.92471 | 7.75993 | 7.03242 | 7.08488 | 7.10489 | 6.90242 | 7.31021 |
| 10 | "PlayStation" | 6.01641 | 7.93333 | 6.31373 | 6.55373 | 6.57907 | 6.75789 | 7.91 | 6.77339 | 6.424 | 6.91818 | 6.75122 | 6.49688 |
| ... | |||||||||||||
| 21 | "iPhone" | 6.86545 | 7.76429 | 7.74583 | 6.0875 | 7.47193 | 7.81078 | 7.18519 | 7.31579 | 6.99559 | 7.32857 | 7.15217 | 7.53492 |
size(ign_data)(21, 13)
# What is the highest average score received by PC games, for any genre?
high_score = 7.7599307.75993
# On the Playstation Vita platform, which genre has the
# lowest average score? Please provide the name of the column, and put your answer
# in single quotes (e.g., 'Action', 'Adventure', 'Fighting', etc.)
worst_genre = "Simulation""Simulation"
@df ign_data plot(:Racing, group=:Platform,
st=:bar, title="Average Score for Racing Games, by Platform",
#label=false,
yticks=1:8,
xticks=(1:20, ign_data.Platform), ylabel="Platform",
permute=(:x,:y))
plot(ign_data.Racing, group=ign_data.Platform, st=:bar, yticks=1:8, xticks=(1:21, ign_data.Platform), permute=(:x,:y), #label=false,
)
bar(ign_data.Racing, group=ign_data.Platform, permute=(:x,:y), xticks=(1:20, ign_data.Platform))
@df ign_data plot(2:13, 1:21, cols(2:13), st=:heatmap,
title="Average Game Score, by Platform and Genre",
xticks=(2:13,names(ign_data)[2:13]), xrotation=90, xlabel="Genre",
yticks=(1:21, ign_data.Platform), ylabel="Platform"
)
Which combination of genre and platform receives the highest average ratings? Which combination receives the lowest average rankings?
sol = light colored cells i.e Simulation games for Playstation 4. dark colored cells i.e Fighting and Shooting games for Game Boy Color
Built with Julia 1.9.1 and
CSV 0.10.11DataFrames 1.5.0
StatsPlots 0.15.5
To run this tutorial locally, download [this file](/tutorials/barchartsandHeatmaps03x03.jl) and open it with Pluto.jl.