在R中,可以使用merge()
函数根据不同的连接条件合并两个数据帧(data.frame)
以下是一些示例:
# 创建两个数据帧
df1 <- data.frame(ID = c(1, 2, 3, 4),
Name = c("Alice", "Bob", "Charlie", "David"))
df2 <- data.frame(ID = c(1, 2, 3, 5),
Age = c(25, 30, 35, 40))
# 根据ID列进行内部连接
merged_df <- merge(df1, df2, by = "ID")
print(merged_df)
# 创建两个数据帧
df1 <- data.frame(ID = c(1, 2, 3, 4),
Name = c("Alice", "Bob", "Charlie", "David"))
df2 <- data.frame(ID = c(1, 2, 3, 5),
Age = c(25, 30, 35, 40))
# 根据ID列进行左连接
merged_df <- merge(df1, df2, by = "ID", all.x = TRUE)
print(merged_df)
# 创建两个数据帧
df1 <- data.frame(ID = c(1, 2, 3, 4),
Name = c("Alice", "Bob", "Charlie", "David"))
df2 <- data.frame(ID = c(1, 2, 3, 5),
Age = c(25, 30, 35, 40))
# 根据ID列进行右连接
merged_df <- merge(df1, df2, by = "ID", all.y = TRUE)
print(merged_df)
# 创建两个数据帧
df1 <- data.frame(ID = c(1, 2, 3, 4),
Name = c("Alice", "Bob", "Charlie", "David"))
df2 <- data.frame(ID = c(1, 2, 3, 5),
Age = c(25, 30, 35, 40))
# 根据ID列进行全连接
merged_df <- merge(df1, df2, by = "ID", all = TRUE)
print(merged_df)
注意:merge()
函数默认执行内部连接。要执行其他类型的连接,请使用all.x
,all.y
或all
参数。
领取专属 10元无门槛券
手把手带您无忧上云