Zeruda no Densetsu

Problem to Solve

You’ve just been hired as a game historian for Nintendo, the Japanese multinational video game company. Your first job is to organize an old data file that details the history of Zeruda no Densetsu (The Legend of Zelda), one of the company’s most popular game series.

In a file called zelda.R, in a folder called zelda, tidy up some data on the history of The Legend of Zelda and use it to answer questions about the series.

Distribution Code

For this problem, you’ll need to download several .R files and zelda.csv.

>

getwd()

download.file("https://cdn.cs50.net/r/2024/x/psets/4/zelda.zip", "zelda.zip")

unzip("zelda.zip")

file.remove("zelda.zip")

setwd("zelda")

zelda/

list.files()

Schema

Before jumping in, it will be helpful to get a sense for the “schema” (i.e., organization!) of the data you’re given.

Specification

In this problem, you’ll use each of the included .R files to take one step in your analysis of the given data.

1.R

In 1.R, organize the data in zelda.csv to get it ready for analysis. Save the cleaned data as a tibble named zelda in zelda.RData.

Make sure the tibble follows these tidy data rules:

• Each row should be one release of a The Legend of Zelda game.
  • Keep in mind, a single game is often released multiple times on different systems.
• Each column should be one way a release can differ.
  • For example, releases can differ based on release year, system, or the people involved in making it.
• Each cell should be a single piece of information.

The first few rows of the tibble should look like the below. The tibble should include only the following columns. Capitalization of column names does matter!

Notice how the tibble follows the principles of tidy data:

• Each row is a release.
• Each column is information about a release.
• Each cell is a single piece of information.

A list of names can count as “a single piece of information” for this problem’s purposes.

Save the resulting zelda tibble, using save, in a file named zelda.RData. You’ll use this tibble in the remaining .R files.

2.R

Your first assignment is to summarize the number of Zelda releases in each year.

In 2.R, load the tidied zelda tibble from zelda.RData with load. Update the tibble by summarizing the number of releases in each year. Sort the rows by the number of releases in a given year, most to least.

The tibble should have two columns:

Save the resulting zelda tibble, using save, in a file named 2.RData.

3.R

Your next assignment is to identify the original (first) release for each Zelda title.

In 3.R, load the tidied zelda tibble from zelda.RData with load. Update the tibble so that it includes only the first release(s) for each Zelda title. If a title had two different releases in its first year (perhaps for two different systems), include both.

Sort the releases by year, from oldest to newest. If any two releases have the same year, sort them alphabetically by title, followed by system.

Save the resulting zelda tibble, using save, in a file named 3.RData.

4.R

Your next assignment is to help commemorate the work of Shigeru Miyamoto, one of the original creators of the Zelda series.

In 4.R, load the tidied zelda tibble from zelda.RData with load. Update the tibble so that that it includes only the original releases for all titles on which Shigeru Miyamoto was a producer. If any title had two different releases in its first year (perhaps for two different systems), include both.

Sort the releases by year, from oldest to newest. If any two releases have the same year, sort them alphabetically by title, followed by system.

Save the resulting zelda tibble, using save, in a file named 4.RData.

5.R

As Nintendo expands its leadership team, your final assignment is to identify the original releases for all titles with more than 1 producer.

In 5.R, load the tidied zelda tibble from zelda.RData with load. Update the tibble to include only the first release(s) for each title with more than 1 producer. If such a title had two different releases in its first year (perhaps for two different systems), include both.

Sort the releases by year, from oldest to newest. If any two releases have the same year, sort them alphabetically by title, followed by system.

Save the resulting zelda tibble, using save, in a file named 5.RData.

Usage

Assuming your .R files are in your working directory, execute each file individually to test your work:

source("1.R")

How to Test

Here’s how to test your code manually:

• Executing 1.R should create a tibble named zelda with 71 rows and 10 columns
• Executing 2.R should create a tibble named zelda with 27 rows and 2 columns
• Executing 3.R should create a tibble named zelda with 22 rows for 10 columns
• Executing 4.R should create a tibble named zelda with 10 rows and 10 columns
• Executing 5.R should create a tibble named zelda with 3 rows and 10 columns

check50

You can also check your code using check50, a program that CS50 will use to test your code when you submit. But be sure to test it yourself as well!

Run the following command in the RStudio console:

check50("cs50/problems/2024/r/zelda")

Green smilies mean your program has passed a test! Red frownies will indicate your program output something unexpected. Visit the URL that check50 outputs to see the input check50 handed to your program, what output it expected, and what output your program actually gave.

How to Submit

You can submit your code using submit50.

Keeping in mind the course’s policy on academic honesty, run the following command in the RStudio console:

submit50("cs50/problems/2024/r/zelda")

Acknowledgements

Data compiled from Wikipedia. Cover image retrieved from cdn.famiwiki.net/5/58/The_Hyrule_Fantasy_Zelda_no_Densetsu_FDS_Box_Art.png.