Import data

Apply the following dplyr verbs to your data

Filter rows

## # A tibble: 1,992 × 29
##    spec_name            acc_genus acc_species palm_tribe palm_subfamily climbing
##    <chr>                <chr>     <chr>       <chr>      <chr>          <chr>   
##  1 Acanthophoenix crin… Acanthop… crinita     Areceae    Arecoideae     climbing
##  2 Acanthophoenix rous… Acanthop… rousselii   Areceae    Arecoideae     climbing
##  3 Acanthophoenix rubra Acanthop… rubra       Areceae    Arecoideae     climbing
##  4 Acoelorrhaphe wrigh… Acoelorr… wrightii    Trachycar… Coryphoideae   climbing
##  5 Acrocomia aculeata   Acrocomia aculeata    Cocoseae   Arecoideae     climbing
##  6 Acrocomia crispa     Acrocomia crispa      Cocoseae   Arecoideae     climbing
##  7 Acrocomia emensis    Acrocomia emensis     Cocoseae   Arecoideae     climbing
##  8 Acrocomia hassleri   Acrocomia hassleri    Cocoseae   Arecoideae     climbing
##  9 Acrocomia intumesce… Acrocomia intumescens Cocoseae   Arecoideae     climbing
## 10 Acrocomia totai      Acrocomia totai       Cocoseae   Arecoideae     climbing
## # ℹ 1,982 more rows
## # ℹ 23 more variables: acaulescent <chr>, erect <chr>, stem_solitary <chr>,
## #   stem_armed <chr>, leaves_armed <chr>, max_stem_height_m <chr>,
## #   max_stem_dia_cm <chr>, understorey_canopy <chr>, max_leaf_number <dbl>,
## #   max__blade__length_m <chr>, max__rachis__length_m <chr>,
## #   max__petiole_length_m <chr>, average_fruit_length_cm <dbl>,
## #   min_fruit_length_cm <chr>, max_fruit_length_cm <chr>, …

Arrange rows

## # A tibble: 2,557 × 29
##    spec_name            acc_genus acc_species palm_tribe palm_subfamily climbing
##    <chr>                <chr>     <chr>       <chr>      <chr>          <chr>   
##  1 Arenga mindorensis   Arenga    mindorensis Caryoteae  Coryphoideae   climbing
##  2 Chamaedorea binderi  Chamaedo… binderi     Chamaedor… Arecoideae     climbing
##  3 Chamaedorea denever… Chamaedo… deneversia… Chamaedor… Arecoideae     climbing
##  4 Chamaedorea keelero… Chamaedo… keelerorum  Chamaedor… Arecoideae     climbing
##  5 Chamaedorea recurva… Chamaedo… recurvata   Chamaedor… Arecoideae     climbing
##  6 Dypsis bonsai        Dypsis    bonsai      Areceae    Arecoideae     climbing
##  7 Dypsis coursii       Dypsis    coursii     Areceae    Arecoideae     climbing
##  8 Dypsis pumila        Dypsis    pumila      Areceae    Arecoideae     climbing
##  9 Syagrus gouveiana    Syagrus   gouveiana   Cocoseae   Arecoideae     climbing
## 10 Syagrus procumbens   Syagrus   procumbens  Cocoseae   Arecoideae     climbing
## # ℹ 2,547 more rows
## # ℹ 23 more variables: acaulescent <chr>, erect <chr>, stem_solitary <chr>,
## #   stem_armed <chr>, leaves_armed <chr>, max_stem_height_m <chr>,
## #   max_stem_dia_cm <chr>, understorey_canopy <chr>, max_leaf_number <dbl>,
## #   max__blade__length_m <chr>, max__rachis__length_m <chr>,
## #   max__petiole_length_m <chr>, average_fruit_length_cm <dbl>,
## #   min_fruit_length_cm <chr>, max_fruit_length_cm <chr>, …

Select columns

## # A tibble: 2,557 × 2
##    climbing erect    
##    <chr>    <chr>    
##  1 climbing non-erect
##  2 climbing non-erect
##  3 climbing non-erect
##  4 climbing non-erect
##  5 climbing non-erect
##  6 climbing non-erect
##  7 climbing erect    
##  8 climbing non-erect
##  9 climbing erect    
## 10 climbing non-erect
## # ℹ 2,547 more rows

Add columns

## # A tibble: 1,190 × 3
##    spec_name                 est_fruit_volume max_leaf_number
##    <chr>                                <dbl>           <dbl>
##  1 Acanthophoenix crinita               0.325              15
##  2 Acanthophoenix rubra                 0.7                20
##  3 Acoelorrhaphe wrightii               0.49               25
##  4 Acrocomia aculeata                  19.5                30
##  5 Acrocomia crispa                     4.5                15
##  6 Acrocomia hassleri                   5.06                6
##  7 Actinokentia divaricata              2.86                7
##  8 Actinokentia huerlimannii            3.9                10
##  9 Actinorhytis calapparia             55                  13
## 10 Adonidia merrillii                   3.25               17
## # ℹ 1,180 more rows

Summarize by groups

## # A tibble: 29 × 2
##    palm_tribe       stemWidth
##    <chr>                <dbl>
##  1 Areceae                 NA
##  2 Borasseae               NA
##  3 Calameae                NA
##  4 Caryoteae               NA
##  5 Ceroxyleae              NA
##  6 Chamaedoreeae           NA
##  7 Chuniophoeniceae        NA
##  8 Cocoseae                NA
##  9 Corypheae               NA
## 10 Cryosophileae           NA
## # ℹ 19 more rows