-3

I have two dataframes in my program, one of which stores the information about purchases (including product IDs), the other stores information about products, (product IDs and brand names(as factor)) I want to add to 1st dataframe column with brand names for each product. I want something like:

purchases$brand <- products[purchases$product_id == products$id,]$brand
Sandy
  • 892
  • 7
  • 13
artem zholus
  • 169
  • 2
  • 9
  • Please read the info about [how to ask a good question](http://stackoverflow.com/help/how-to-ask) and how to give a [reproducible example](http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example/5963610). This will make it much easier for others to help you. – Jaap Jun 05 '16 at 20:03
  • You may benefit by looking at this: http://stackoverflow.com/questions/1299871/how-to-join-merge-data-frames-inner-outer-left-right – Gopala Jun 05 '16 at 20:26

1 Answers1

1

Use %in% operator, below command will add new column Brand to purchases data frame based on the matching product$id and purchases$product_id 

 purchases$brand <- products$brand[products$id %in% purchases$product_id]
Sowmya S. Manian
  • 3,621
  • 3
  • 17
  • 28