How to convert list to dataframe in r

Question

I have a dataframe with 50 columns in that 25 columns are of type list. How can I convert them to final single dataframe with type as integer

I am doing it with

df_list=names(which(sapply(df,is.list))
df_list=df[df_list]
do.call("rbind",df_list)

But it does not do the conversion. How can I do it?

akrun · Accepted Answer · 2017-01-10 07:01:28Z

1

We can unlist the list columns by looping over the columns specified by 'df_list' and assign the output back

df[df_list] <- lapply(df[df_list], unlist)

df <- data.frame(col1 = 1:5, col2 = I(as.list(1:5)), col3 = I(as.list(6:10)))
df_list <- sapply(df, is.list)

answered Jan 10, 2017 at 7:01

akrun

891k38 gold badges590 silver badges700 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

0

df_list=df[df_list]
library(data.table)
rbindlist(df_list, idcol=TRUE)

CommunityBot

11 silver badge

answered May 2, 2017 at 5:44

Yi Li

494 bronze badges