Import data
## # A tibble: 500 × 21
## sort_name clean_name album rank_2003 rank_2012 rank_2020 differential
## <chr> <chr> <chr> <dbl> <dbl> <dbl> <dbl>
## 1 Gaye, Marvin Marvin Ga… What… 6 6 1 5
## 2 Beach Boys The Beach… Pet … 2 2 2 0
## 3 Mitchell, Joni Joni Mitc… Blue 30 30 3 27
## 4 Wonder, Stevie Stevie Wo… Song… 56 57 4 52
## 5 Beatles The Beatl… Abbe… 14 14 5 9
## 6 Nirvana Nirvana Neve… 17 17 6 11
## 7 Fleetwood Mac Fleetwood… Rumo… 25 26 7 18
## 8 Prince and the R… Prince Purp… 72 76 8 64
## 9 Dylan, Bob Bob Dylan Bloo… 16 16 9 7
## 10 Hill, Lauryn Lauryn Hi… The … 312 314 10 302
## # ℹ 490 more rows
## # ℹ 14 more variables: release_year <dbl>, genre <chr>, type <chr>,
## # weeks_on_billboard <dbl>, peak_billboard_position <dbl>,
## # spotify_popularity <dbl>, spotify_url <chr>, artist_member_count <dbl>,
## # artist_gender <chr>, artist_birth_year_sum <dbl>,
## # debut_album_release_year <dbl>, ave_age_at_top_500 <dbl>,
## # years_between <dbl>, album_id <chr>
Apply the following dplyr verbs to your data
Filter rows
## # A tibble: 20 × 6
## clean_name album rank_2003 rank_2012 rank_2020 artist_member_count
## <chr> <chr> <dbl> <dbl> <dbl> <dbl>
## 1 The Beach Boys Pet … 2 2 2 6
## 2 Prince Purp… 72 76 8 6
## 3 Rolling Stones Let … 32 32 41 6
## 4 N.W.A Stra… 144 144 70 6
## 5 The Allman Brothers … At F… 49 49 105 6
## 6 The Cure Disi… 326 326 116 6
## 7 Blondie Para… 140 140 146 6
## 8 Pulp Diff… NA NA 162 6
## 9 Derek and the Dominos Layl… 115 117 226 6
## 10 Massive Attack Blue… 395 397 241 6
## 11 Santana Abra… 205 207 334 6
## 12 Roxy Music For … 394 396 351 6
## 13 The Beach Boys Wild… NA NA 410 6
## 14 Smokey Robinson & th… Goin… 271 273 412 6
## 15 Dire Straits Brot… 351 352 418 6
## 16 Primal Scream Scre… NA NA 437 6
## 17 The Isley Brothers 3 + 3 NA NA 464 6
## 18 Jefferson Airplane Surr… 146 146 471 6
## 19 Rufus Ask … NA NA 499 6
## 20 Arcade Fire Fune… NA 151 500 6
Arrange rows
## # A tibble: 500 × 6
## clean_name album rank_2003 rank_2012 rank_2020 artist_member_count
## <chr> <chr> <dbl> <dbl> <dbl> <dbl>
## 1 Marvin Gaye What's Goi… 6 6 1 1
## 2 Joni Mitchell Blue 30 30 3 1
## 3 Stevie Wonder Songs in t… 56 57 4 1
## 4 Bob Dylan Blood on t… 16 16 9 1
## 5 Lauryn Hill The Misedu… 312 314 10 1
## 6 Michael Jackson Thriller 20 20 12 1
## 7 Aretha Franklin I Never Lo… 83 84 13 1
## 8 Kanye West My Beautif… NA 353 17 1
## 9 Bob Dylan Highway 61… 4 4 18 1
## 10 Kendrick Lamar To Pimp a … NA NA 19 1
## # ℹ 490 more rows
Select columns
## # A tibble: 500 × 7
## clean_name album rank_2003 rank_2012 rank_2020 artist_member_count
## <chr> <chr> <dbl> <dbl> <dbl> <dbl>
## 1 Marvin Gaye What's Goin… 6 6 1 1
## 2 The Beach Boys Pet Sounds 2 2 2 6
## 3 Joni Mitchell Blue 30 30 3 1
## 4 Stevie Wonder Songs in th… 56 57 4 1
## 5 The Beatles Abbey Road 14 14 5 4
## 6 Nirvana Nevermind 17 17 6 3
## 7 Fleetwood Mac Rumours 25 26 7 5
## 8 Prince Purple Rain 72 76 8 6
## 9 Bob Dylan Blood on th… 16 16 9 1
## 10 Lauryn Hill The Miseduc… 312 314 10 1
## # ℹ 490 more rows
## # ℹ 1 more variable: artist_gender <chr>
Add columns
## # A tibble: 500 × 9
## clean_name album rank_2003 rank_2012 rank_2020 artist_member_count
## <chr> <chr> <dbl> <dbl> <dbl> <dbl>
## 1 D'Angelo Voodoo 488 481 28 1
## 2 Jay-Z The Bluepri… 464 252 50 1
## 3 Radiohead Kid A 428 67 20 5
## 4 Hole Live Throug… 466 460 106 4
## 5 Wu-Tang Clan Enter the W… 386 387 27 9
## 6 Nas Illmatic 400 402 44 1
## 7 Funkadelic Maggot Brain 486 479 136 10
## 8 Fugees The Score 477 469 134 3
## 9 George Michael Faith 480 472 151 1
## 10 Cyndi Lauper She's So Un… 494 487 184 1
## # ℹ 490 more rows
## # ℹ 3 more variables: artist_gender <chr>, moved_2003 <dbl>, moved_2012 <dbl>
Summarize by groups
## # A tibble: 1 × 2
## total_albums_male total_albums_female
## <int> <int>
## 1 358 93