Nothing
as_tidy_tables_traits <- function(tbl_json) {
tbl_json2 <-
tbl_json %>%
tidyjson::gather_array()
tidy_traits_tables <- unwrap_traits2(tbl_json2)
return(tidy_traits_tables)
}
# unwrap_traits_tbl <- function(tbl_json) {
#
# tbl_json %>%
# tidyjson::spread_values(
# efo_id = tidyjson::jstring(id),
# trait = tidyjson::jstring(label),
# description = tidyjson::jstring(description),
# url = tidyjson::jstring(url)
# ) %>%
# tidyjson::as_tibble()
# }
unwrap_traits <- function(tbl_json) {
traits <- unwrap_efotrait(tbl_json)
pgs_ids <- tbl_json %>%
tidyjson::spread_values(efo_id = tidyjson::jstring('id')) %>%
tidyjson::enter_object('associated_pgs_ids') %>%
tidyjson::gather_array(column.name = 'associated_pgs_ids_id') %>%
dplyr::select(-'associated_pgs_ids_id') %>%
tidyjson::append_values_string('pgs_id') %>%
tidyjson::as_tibble()
child_pgs_ids <- tbl_json %>%
tidyjson::spread_values(efo_id = tidyjson::jstring('id')) %>%
tidyjson::enter_object('child_associated_pgs_ids') %>%
tidyjson::gather_array(column.name = 'child_associated_pgs_ids_id') %>%
dplyr::select(-'child_associated_pgs_ids_id') %>%
tidyjson::append_values_string('child_pgs_id') %>%
tidyjson::as_tibble()
trait_categories <- tbl_json %>%
tidyjson::spread_values(efo_id = tidyjson::jstring('id')) %>%
tidyjson::enter_object('trait_categories') %>%
tidyjson::gather_array(column.name = 'trait_categories_id') %>%
dplyr::select(-'trait_categories_id') %>%
tidyjson::append_values_string('trait_categories') %>%
tidyjson::as_tibble()
trait_synonyms <- tbl_json %>%
tidyjson::spread_values(efo_id = tidyjson::jstring('id')) %>%
tidyjson::enter_object('trait_synonyms') %>%
tidyjson::gather_array(column.name = 'trait_synonyms_id') %>%
dplyr::select(-'trait_synonyms_id') %>%
tidyjson::append_values_string('trait_synonyms') %>%
tidyjson::as_tibble()
trait_mapped_terms <- tbl_json %>%
tidyjson::spread_values(efo_id = tidyjson::jstring('id')) %>%
tidyjson::enter_object('trait_mapped_terms') %>%
tidyjson::gather_array(column.name = 'trait_mapped_terms_id') %>%
dplyr::select(-'trait_mapped_terms_id') %>%
tidyjson::append_values_string('trait_mapped_terms') %>%
tidyjson::as_tibble()
list(traits = traits,
pgs_ids = pgs_ids,
child_pgs_ids = child_pgs_ids,
trait_categories = trait_categories,
trait_synonyms = trait_synonyms,
trait_mapped_terms = trait_mapped_terms
)
}
unwrap_traits2 <- function(tbl_json) {
lst_tbl1 <-
tbl_json %>%
tibble::add_column(parent_efo_id = NA_character_,
is_child = FALSE) %>%
unwrap_traits()
lst_tbl2 <-
tbl_json %>%
tidyjson::spread_values(parent_efo_id = tidyjson::jstring('id')) %>%
tibble::add_column(is_child = TRUE) %>%
tidyjson::enter_object('child_traits') %>%
tidyjson::gather_array(column.name = 'child_traits_id') %>%
dplyr::select(-'child_traits_id') %>%
unwrap_traits()
# list(lst_tbl1, lst_tbl2)
purrr::pmap(list(lst_tbl1, lst_tbl2), dplyr::bind_rows) %>%
purrr::map(dplyr::relocate, c('efo_id', 'parent_efo_id', 'is_child'), .before = 1L) %>%
purrr::map(~ dplyr::select(., -'array.index')) %>%
relocate_metadata_cols()
}
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.