Import data

# excel file
data <- read_excel("../00_data/myData.xlsx")
data
## # A tibble: 1,187 × 19
##    cheese    url   milk  country region family type  fat_content calcium_content
##    <chr>     <chr> <chr> <chr>   <chr>  <chr>  <chr> <chr>       <chr>          
##  1 Aarewass… http… cow   Switze… NA     NA     semi… NA          NA             
##  2 Abbaye d… http… sheep France  Pays … NA     semi… NA          NA             
##  3 Abbaye d… http… cow   France  NA     NA     semi… 40-46%      NA             
##  4 Abbaye d… http… cow   France  Burgu… NA     semi… NA          NA             
##  5 Abbaye d… http… cow   France  Savoie NA     soft… NA          NA             
##  6 Abbaye d… http… cow   France  provi… NA     semi… NA          NA             
##  7 Abbaye d… http… cow   France  Nord-… NA     semi… 50%         NA             
##  8 Abbot’s … http… cow   Englan… North… Chedd… semi… NA          NA             
##  9 Abertam   http… sheep Czech … Karlo… NA     hard… 45%         NA             
## 10 Abondance http… cow   France  NA     NA     semi… NA          NA             
## # ℹ 1,177 more rows
## # ℹ 10 more variables: texture <chr>, rind <chr>, color <chr>, flavor <chr>,
## #   aroma <chr>, vegetarian <chr>, vegan <chr>, synonyms <chr>,
## #   alt_spellings <chr>, producers <chr>

Apply the following dplyr verbs to your data

Filter rows

filter(data, milk == "cow")
## # A tibble: 696 × 19
##    cheese    url   milk  country region family type  fat_content calcium_content
##    <chr>     <chr> <chr> <chr>   <chr>  <chr>  <chr> <chr>       <chr>          
##  1 Aarewass… http… cow   Switze… NA     NA     semi… NA          NA             
##  2 Abbaye d… http… cow   France  NA     NA     semi… 40-46%      NA             
##  3 Abbaye d… http… cow   France  Burgu… NA     semi… NA          NA             
##  4 Abbaye d… http… cow   France  Savoie NA     soft… NA          NA             
##  5 Abbaye d… http… cow   France  provi… NA     semi… NA          NA             
##  6 Abbaye d… http… cow   France  Nord-… NA     semi… 50%         NA             
##  7 Abbot’s … http… cow   Englan… North… Chedd… semi… NA          NA             
##  8 Abondance http… cow   France  NA     NA     semi… NA          NA             
##  9 Adelost   http… cow   Sweden  NA     Blue   semi… 50%         NA             
## 10 ADL Bric… http… cow   Canada  Princ… Chedd… semi… 12%         NA             
## # ℹ 686 more rows
## # ℹ 10 more variables: texture <chr>, rind <chr>, color <chr>, flavor <chr>,
## #   aroma <chr>, vegetarian <chr>, vegan <chr>, synonyms <chr>,
## #   alt_spellings <chr>, producers <chr>
print(data)
## # A tibble: 1,187 × 19
##    cheese    url   milk  country region family type  fat_content calcium_content
##    <chr>     <chr> <chr> <chr>   <chr>  <chr>  <chr> <chr>       <chr>          
##  1 Aarewass… http… cow   Switze… NA     NA     semi… NA          NA             
##  2 Abbaye d… http… sheep France  Pays … NA     semi… NA          NA             
##  3 Abbaye d… http… cow   France  NA     NA     semi… 40-46%      NA             
##  4 Abbaye d… http… cow   France  Burgu… NA     semi… NA          NA             
##  5 Abbaye d… http… cow   France  Savoie NA     soft… NA          NA             
##  6 Abbaye d… http… cow   France  provi… NA     semi… NA          NA             
##  7 Abbaye d… http… cow   France  Nord-… NA     semi… 50%         NA             
##  8 Abbot’s … http… cow   Englan… North… Chedd… semi… NA          NA             
##  9 Abertam   http… sheep Czech … Karlo… NA     hard… 45%         NA             
## 10 Abondance http… cow   France  NA     NA     semi… NA          NA             
## # ℹ 1,177 more rows
## # ℹ 10 more variables: texture <chr>, rind <chr>, color <chr>, flavor <chr>,
## #   aroma <chr>, vegetarian <chr>, vegan <chr>, synonyms <chr>,
## #   alt_spellings <chr>, producers <chr>

Arrange rows

arrange(data, country)
## # A tibble: 1,187 × 19
##    cheese    url   milk  country region family type  fat_content calcium_content
##    <chr>     <chr> <chr> <chr>   <chr>  <chr>  <chr> <chr>       <chr>          
##  1 Serat     http… sheep Afghan… NA     NA     hard  NA          NA             
##  2 Sirene    http… cow,… Albani… Trakia Feta   fres… NA          NA             
##  3 Provoleta http… wate… Argent… NA     Pasta… semi… 45%         316 mg/100g    
##  4 Sardo     http… cow   Argent… NA     NA     hard  NA          NA             
##  5 Armenian… http… cow,… Armenia NA     NA     semi… NA          NA             
##  6 Allium P… http… goat  Austra… South… NA     fres… 45%         NA             
##  7 Barambah… http… cow   Austra… Brisb… Feta   fres… 25.22 g/10… NA             
##  8 Beach Bo… http… cow   Austra… Morni… Brie   arti… NA          NA             
##  9 Bega Pro… http… cow   Austra… NA     Chedd… soft  NA          NA             
## 10 Binnorie… http… cow   Austra… Pokol… Feta   soft… NA          NA             
## # ℹ 1,177 more rows
## # ℹ 10 more variables: texture <chr>, rind <chr>, color <chr>, flavor <chr>,
## #   aroma <chr>, vegetarian <chr>, vegan <chr>, synonyms <chr>,
## #   alt_spellings <chr>, producers <chr>

Select columns

Add columns

Summarize by groups