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