How to merge multiple data tables with the same columns…

In R language, you can use the merge() function to combine multiple data tables based on the same column. Below is an example code:

# 创建数据表1
df1 <- data.frame(ID = c(1, 2, 3),
                  Name = c("Alice", "Bob", "Charlie"))

# 创建数据表2
df2 <- data.frame(ID = c(2, 3, 4),
                  Age = c(25, 30, 35))

# 合并数据表1和数据表2
merged_df <- merge(df1, df2, by = "ID")

# 打印合并后的数据表
print(merged_df)

After running the above code, the merged data table will appear as follows:

  ID   Name Age
1  2    Bob  25
2  3 Charlie  30

In the merge() function, the parameter by specifies which column to merge by. In the example above, we chose the “ID” column as the basis for merging. If both tables have columns with the same name, you can use the by.x and by.y parameters to specify the corresponding column names in table 1 and table 2, respectively.