Portal Data dplyr Review (solution)

Exercise
Output solution

Attaching package: 'dplyr'
The following objects are masked from 'package:stats':

    filter, lag
The following objects are masked from 'package:base':

    intersect, setdiff, setequal, union
Rows: 35549 Columns: 9
── Column specification ────────────────────────────────────────────────────────
Delimiter: ","
chr (2): species_id, sex
dbl (7): record_id, month, day, year, plot_id, hindfoot_length, weight

ℹ Use `spec()` to retrieve the full column specification for this data.
ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
Rows: 54 Columns: 4
── Column specification ────────────────────────────────────────────────────────
Delimiter: ","
chr (4): species_id, genus, species, taxa

ℹ Use `spec()` to retrieve the full column specification for this data.
ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
Rows: 24 Columns: 2
── Column specification ────────────────────────────────────────────────────────
Delimiter: ","
chr (1): plot_type
dbl (1): plot_id

ℹ Use `spec()` to retrieve the full column specification for this data.
ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
# A tibble: 19,344 × 5
    year genus       species  weight plot_type               
   <dbl> <chr>       <chr>     <dbl> <chr>                   
 1  1977 Dipodomys   merriami     40 Long-term Krat Exclosure
 2  1977 Dipodomys   merriami     29 Control                 
 3  1977 Dipodomys   merriami     46 Control                 
 4  1977 Dipodomys   ordii        52 Control                 
 5  1977 Perognathus flavus        8 Control                 
 6  1977 Onychomys   sp.          22 Long-term Krat Exclosure
 7  1977 Perognathus flavus        7 Control                 
 8  1977 Dipodomys   merriami     22 Control                 
 9  1977 Perognathus flavus        8 Control                 
10  1977 Dipodomys   merriami     41 Control                 
# ℹ 19,334 more rows