How to merge two seperate dataframes with uneven rows in R

Question

What is the easiest way to combine two separate data.frames when one data.frame contains more rows than the other? Here is what I have:

Dataframe A
Customer ID      Items sold         Price
1                 20                 2.50
2                 30                 10.00
3                 40                 15.00
4                 NA                 1.00
5                 NA                 1.00

Dataframe B
customer Id       Items bought
1                  10
2                  NA 
3                  3

Putting spaces in column names is a really bad idea. Don't do it. — jlhoward, Dec 13 '14 at 18:29

score 2 · Accepted Answer · answered Dec 13 '14 at 18:05

2

You can try merge

merge(A, B, by.x='Customer.ID', by.y='customer.Id', all=TRUE)

answered Dec 13 '14 at 18:05

akrun

874,273
37
540
662

How to merge two seperate dataframes with uneven rows in R

1 Answers1