library(tidyverse); library(readxl) ; library(taxize) # read in the list of beetle families floc <- "path/to/your/data/Copy of number of native species by beetle family in regions2.xlsx" beetle_fams <- read_excel(floc, trim_ws = TRUE, col_types = "text" ) bfams_list <- beetle_fams$Family
beetle_accepted <- lapply(bfams_list, get_accepted_families) # make dataframe suppressMessages( b_acc_df <- beetle_accepted %>% purrr::reduce(full_join) %>% select(-genus, -genuskey) )
readr::write_csv(b_acc_df, "path/to/your/data/Coleoptera_accepted_taxonomy.csv")
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.