[R] Combine list element by column name to make a dataframe

[Mohammad Tanvir Ahamed]

Hi , 

I have a example list like follow 


############################################

lst<-list(setNames(c(1,10,50,60,70,80),c("id","id1","math","phy","che","bio")),setNames(c(2,20,45),c("id","id1","phy")),setNames(c(3,30,75),c("id","id1","bio")))


My expected outcome : 

---------------------------------------------------------------------

df<-rbind(c(1,10,50,60,70,80),c(2,20,NA,45,NA,NA),c(3,30,NA,NA,NA,75))

colnames(df)<-c("id","id1","math","phy","che","bio")

row.names(df) <- NULL

df

############################################


Any suggestion will be appreciated . 

Thanks in advance.

 

Best regards


........................... 

Tanvir Ahamed

Göteborg, Sweden




	[[alternative HTML version deleted]]