Tidy nested and count columns

This function unnests any neseted columns and converts any wide columns containing count information into a tidy data frame

tidy_column_relations(
  data,
  column_keys = c("idCIK", "nameEntity"),
  bind_to_original_df = FALSE,
  clean_column_formats = TRUE
)

Arguments

data	data frame
column_keys	column keys
bind_to_original_df	TRUE bind results to the original data frame in a nested column
clean_column_formats	TRUE clean the columns

Value

tibble

See also

Other utility function: drop_na_columns(), get_class_df(), tidy_column_formats()

Examples

library(fundManageR)
library(dplyr)
get_data_sec_filer(entity_names = "8VC")
dataFilerRelatedParties %>%
tidy_column_relations()