R语言中的横向数据合并merge及纵向数据合并rbind的使用
我们经常会遇到两个数据框拥有相同的时间或观测值,但这些列却不尽相同。处理的办法就是使用 merge(x, y ,by.x = ,by.y = ,all = ) 函数。
#合并 ID<-c(1,2,3,4) name<-c("A","B","C","D") score<-c(60,70,80,90) student1<-data.frame(ID,name) student2<-data.frame(ID,score) total_student1<-merge(student1,student2,by="ID") total_student1
#横向追加
ID<-c(1,2,3,4) name<-c("A","B","C","D") score<-c(60,70,80,90) sex<-c("M","F","M","M") student1<-data.frame(ID,name) student2<-data.frame(score,sex) total_student2<-cbind(student1,student2) total_student2
#纵向追加
ID<-c(1,2,3,4) name<-c("A","B","C","D") student1<-data.frame(ID,name) ID<-c(5,6,7,8) name<-c("E","F","G","H") student2<-data.frame(ID,name) total_student3<-rbind(student1,student2) total_student3
|
请发表评论