Hi. I am having trouble visualizing how to do the join I want.
I have a table t that looks like this:
Person Commission
====== ==========
Art 10%
Bill 15%
Ed 17%
Sue 20%
I have a data frame df that looks like this:
word1 word2 word3 word4
===== ===== ===== =====
Art sold a book
Sue sold a painting
Bill and Sue sold
I would like to join t and df and get 10% in row 1, 20% in row 2, and it is possible to get both 15% and 20% in row3?
t <- data.frame(Person=c("Art","Bill","Ed","Sue"), Commission=c(10%, 15%, 17%, 20%))
df <- data.frame(word1=c("Art","Sue","Bill"), word2=c("sold","sold","and"), word3=c("a","a","Sue"), word4=c("book","painting","sold"))