R语言 如何合并多个数据框架
在这篇文章中,我们将讨论如何在R编程语言中合并多个数据框。数据框架可以从行和列两方面进行合并,我们可以使用 cbind() 函数合并列,使用 rbind( )函数合并行。
按列合并
cbind() 是用来按列合并数据框的。
语法
cbind(data1,data2,………….., data n)
参数
其中data1和data2是数据框。
例1 :
# vector with student details
names1=c("sravan","bobby","ojaswi")
# vector with marks
marks1=c(90,89,78)
# pass these vectors to the
# dataframe 1
data1=data.frame(names1=names1,marks1=marks1)
print(data1)
# vector with student details
names2=c("gnanesh","rohith","divya")
# vector with marks
marks2=c(68,99,79)
# pass these vectors to the dataframe 2
data2=data.frame(names2=names2,marks2=marks2)
print(data2)
print("-------------------------------\
-------------------------------")
# merging these two dataframes using cbind
print(cbind(data1,data2))
输出
例2 :
我们也可以通过使用$操作符来合并每个数据框中的特定列,我们可以访问数据框中的列
语法:
dataframe_name$columnname
# vector with student details
names1=c("sravan","bobby","ojaswi")
# vector with marks
marks1=c(90,89,78)
# pass these vectors to the
# dataframe 1
data1=data.frame(names1=names1,marks1=marks1)
print(data1)
# vector with student details
names2=c("gnanesh","rohith","divya")
# vector with marks
marks2=c(68,99,79)
# pass these vectors to the dataframe 2
data2=data.frame(names2=names2,marks2=marks2)
print(data2)
print("---------------------------------
\-----------------------------")
# merging these two data frames marks
# column using cbind
print(cbind(data1marks1,data2marks2))
输出
例3 :
# vector with student details
names1=c("sravan","bobby","ojaswi")
# vector with marks
marks1=c(90,89,78)
# pass these vectors to the
# dataframe 1
data1=data.frame(names1=names1,marks1=marks1)
print(data1)
# vector with student details
names2=c("gnanesh","rohith","divya")
# vector with marks
marks2=c(68,99,79)
# pass these vectors to the dataframe 2
data2=data.frame(names2=names2,marks2=marks2)
print(data2)
# vector with student details
names3=c("bhavya","harsha","navya")
# vector with marks
marks3=c(68,99,79)
# pass these vectors to the dataframe 3
data3=data.frame(names3=names3,marks3=marks3)
print(data3)
print("-----------------------------------\
---------------------------")
# merging these three data frames
print(cbind(data1,data2,data3))
输出
按行合并
我们可以使用rbind()函数合并数据框之间的行。
语法
rbind(dataframe1,dataframe2)
例1 :
# create vectors
x=c(1,2,3,4,3,4,5)
y=c(4,5,6,7,2,3,4)
# pass these vectors to the
# input of dataframe1(a)
a=data.frame(x,y)
# create vectors
x=c(10,20,30,40,50,60,70)
y=c(40,50,60,40,50,60,70)
# pass these vectors to the
# input of dataframe1(a)
b=data.frame(x,y)
# apply rbind function to
# merge rows
print(rbind(a,b))
输出
例2 :
# create vectors
x=c(1,2,3,4,3,4,5)
y=c(4,5,6,7,2,3,4)
# pass these vectors to the
# input of dataframe1(a)
a=data.frame(x,y)
# display dataframe
print(a)
print("---------------------")
# create vectors
x=c("sravan","bobby")
y=c("Eswar","sai")
# pass these vectors to the
# input of dataframe1(a)
b=data.frame(x,y)
# display dataframe
print(b)
# apply rbind function to merge rows
print(rbind(a,b))
输出