Transform the sheet to have one species, method, or language per row

When entering species, method, and programming languages into the spreadsheet, sometimes one paper or dataset has multiple of those, and those are separated by a semicolon. This function unnests that and returns a data frame with one row per category of interest.

unnest_cat(sheet, col_use, other_cols = NULL)

Arguments

sheet

The tibble for the spreadsheet.

col_use

Column to unnest. Tidyeval is supported.

other_cols

Character vector of other columns to include.

Value

A data frame with one row per category of interest. NAs are removed.