CODEWITHSUNDEEP
rdataframejoin
Timothy_Goodman
Timothy_Goodman

Reputation: 421

Join two data frames

I have two data frames:

  customer material Freq
1  1       12       1
2  1       10       1
3  1        8       1
4  1        4       1
5  1        3       1
6  1        2       1

and the second one:

  material class
1 12       A
2 10       B
3 3        C
4 4        D
5 5        E
6 6        F

Now I want to merge the two data frames. I tried it with:

e <- left_join(A, B, by="material")

But then I have all materials multiple times. How can I solve this problem?

Upvotes: 1

Views: 74

Answers (3)

DeduciveR
DeduciveR

Reputation: 1702

If I understand the end result correctly then you could use base merge:

df3 <- merge(df1, df2, by = "material")

You can also use in pipes with :

df3 <- df1 %>% 
  merge(df2, by = "material")

Upvotes: 1

NelsonGon
NelsonGon

Reputation: 13319

Try this: You can reclass.

library(tidyverse)
#df1$material<-as.factor(df1$material)
#df2$material<-as.factor(df2$material)
#df2$class<-as.character(df2$class)
df1 %>% 
  left_join(df2,by="material")

Upvotes: 1

arg0naut91
arg0naut91

Reputation: 14774

You could try:

left_join(A, B %>% distinct(), by="material")

Here I presume that you have some duplicate values in B. With the data you provided the code runs fine; I cannot see any material mentioned multiple times.

Upvotes: 1

Related Questions