Support Questions
Find answers, ask questions, and share your expertise

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

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