dplyr/merge-join one to many using two data frames

[jfca283]

Hello,
I recently found out that dplyr is able to merge/join data.
My doubt is how do I need to declare a one to many kind of merge.
I don't know the terminology of inner join, left join, semi join, etc ( I come from the stata world)
Thanks for your time and interest.

[Matthias]

This may help!?

13 Relational data | R for Data Science

[FJCC]

Is this the sort of thing you are looking for?

library(dplyr)

DF1 <- data.frame(Name = c("A", "B"), Value = 1:2)
DF1
#>   Name Value
#> 1    A     1
#> 2    B     2
DF2 <- data.frame(Name = rep(c("A", "B"), 4), Value2 = 11:18)
DF2
#>   Name Value2
#> 1    A     11
#> 2    B     12
#> 3    A     13
#> 4    B     14
#> 5    A     15
#> 6    B     16
#> 7    A     17
#> 8    B     18
NewDF = inner_join(DF1, DF2, by = "Name")
NewDF
#>   Name Value Value2
#> 1    A     1     11
#> 2    A     1     13
#> 3    A     1     15
#> 4    A     1     17
#> 5    B     2     12
#> 6    B     2     14
#> 7    B     2     16
#> 8    B     2     18

^{Created on 2020-01-17 by the reprex package (v0.3.0)}

[jfca283]

Yes. But it seems that dplyr doesn't do the job completely. I was wrong about that issue.

[11rchitwood]

@jfca283 maybe try creating a reprex?

FAQ: What's a reproducible example (`reprex`) and how do I create one?

Why reprex? Getting unstuck is hard. Your first step here is usually to create a reprex, or reproducible example. The goal of a reprex is to package your code, and information about your problem so that others can run it and feel your pain. Then, hopefully, folks can more easily provide a solution. What's in a Reproducible Example? Parts of a reproducible example: background information - Describe what you are trying to do. What have you already done? complete set up - include any library() calls and data to reproduce your issue. data for a reprex: Here's a discussion on setting up data for a reprex make it run - include the minimal code required to reproduce your error on the data…