Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

create columns in dataframe from nested list of dataframes in a dataframe column

create columns in dataframe from nested list of dataframes in a dataframe column

New Contributor

This is what my dataframe looks like

 str(FBInsightsExpanded) Classes ‘data.table’ and 'data.frame':4 obs. of 3 variables: $ impressions : chr "26580" "5741" "7335" "4123" ... $ date_start : chr "2018-10-14" "2018-10-14" "2018-10-14" "2018-10-14" ... $ action_values :List of 4 ..$ :'data.frame':11 obs. of 2 variables: .. ..$ action_type: chr "app_custom_event.fb_mobile_add_to_cart" "app_custom_event.fb_mobile_add_to_wishlist" "app_custom_event.fb_mobile_content_view" "app_custom_event.fb_mobile_initiated_checkout" ... .. ..$ value : chr "40505.79" "9262.82" "470464" "2319.35" ... ..$ :'data.frame':8 obs. of 2 variables: .. ..$ action_type: chr "app_custom_event.fb_mobile_add_to_cart" "app_custom_event.fb_mobile_add_to_wishlist" "app_custom_event.fb_mobile_content_view" "app_custom_event.fb_mobile_initiated_checkout" ... .. ..$ value : chr "26309.21" "6970.84" "697029" "196.8" ... ..$ :'data.frame':10 obs. of 2 variables: .. ..$ action_type: chr "app_custom_event.fb_mobile_add_to_cart" "app_custom_event.fb_mobile_add_to_wishlist" "app_custom_event.fb_mobile_content_view" "app_custom_event.fb_mobile_initiated_checkout" ... .. ..$ value : chr "42180.84" "4852.95" "282354" "5152.95" ... ..$ :'data.frame':8 obs. of 2 variables: .. ..$ action_type: chr "app_custom_event.fb_mobile_add_to_cart" "app_custom_event.fb_mobile_add_to_wishlist" "app_custom_event.fb_mobile_content_view" "app_custom_event.fb_mobile_initiated_checkout" ... .. ..$ value : chr "253737.97" "44378.59" "575184.59" "5294" ... 

What I need is a dataframe that looks like this;

 impressions date_start fb_mobile_add_to_wishlist fb_mobile_content_view fb_mobile_initiated_checkout
Don't have an account?
Coming from Hortonworks? Activate your account here