library(dplyr)
df1 <- data.frame(TeamID = c(1,4,6,11),
                  TeamName = c("new york knicks","los angeles lakers","milwaukee bucks","boston celtics"),
                  Championships = c(2,17,1,17))

df2 <- data.frame(TeamID = c(1,2,11,8),
                  TeamName = c("new york knicks","philadelphia 76ers","boston celtics","los angeles clippers"),
                  Championships = c(2,3,17,0))

df1

df2
df1 %>% inner_join(df2)
full_join(df1,df2)
left_join(df1,df2)
right_join(df1,df2)


arc2r/book documentation built on March 5, 2021, 2:10 p.m.