Import the Rolling Stone Magazine’s 500 Greatest Albums of All Time (1955-2011)
I first imported the top_albums dataset using read_csv.
Top Albums Data Set and Variables
I then used the glimpse() command to show the variables in the Top Albums data set.
## Rows: 500
## Columns: 6
## $ Number <dbl> 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18…
## $ Year <dbl> 1967, 1966, 1966, 1965, 1965, 1971, 1972, 1979, 1966, 1968, 1…
## $ Album <chr> "Sgt. Pepper's Lonely Hearts Club Band", "Pet Sounds", "Revol…
## $ Artist <chr> "The Beatles", "The Beach Boys", "The Beatles", "Bob Dylan", …
## $ Genre <chr> "Rock", "Rock", "Rock", "Rock", "Rock, Pop", "Funk / Soul", "…
## $ Subgenre <chr> "Rock & Roll, Psychedelic Rock", "Pop Rock, Psychedelic Rock"…
Create a Chart Showing a Relationship Between Categorical Variables
I then decided that I would look at a subset of the top_albums data set, so I filtered down only include albums in the Blues genre. I then created a chart showing the top Blues albums in the data set by Artist.
I thought it was interesting that only 8 of the top 500 albums were in the Blues genre. I found it even more interesting that of those 8, Howlin’ Wolf and B.B. King each had two of the top 500 albums.
I then decided that I wanted to look at another subset of the top_albums data set, so I filtered the data set down to the top 100 albums and only included albums in the Rock genre. I then created a chart showing artists with rock albums in the top 100, and put them in order by the number of albums they have in the top 100.
I was not surprised to see that The Beatles, Led Zeppelin, and The Rolling Stones were the 3 artists with the most top 100 rock albums.