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)
data frame
column keys
TRUE
bind results to the original data frame in a nested column
TRUE
clean the columns
data_frame
Other utility function: drop_na_columns
,
get_class_df
,
tidy_column_formats
# NOT RUN {
library(fundManageR)
library(dplyr)
get_data_sec_filer(entity_names = "8VC")
dataFilerRelatedParties %>%
tidy_column_relations()
# }
Run the code above in your browser using DataLab