R语言中两个表做关联查询怎么做哈？ R语言中写sql是不是不能写join on啊，碰到表连接怎么处理？

Question

如题所述

Answer 1

dplyr包包含了各种关联查询的函数，如inner_join,left_join,full_join,rigth_join......
library(dplyr)
library("nycflights13")
# Drop unimportant variables so it's easier to understand the join results.
flights2 <-
flights %>%
select(year:day,tailnum, carrier)

flights2 %>%
left_join(airlines,by= "carrier")