Dear R forum
I have two datafarmes with category and cat_val forming one dataframe and cust
and cust_category forming another dataframe.
category = c("C", "D", "B", "A")
cat_val = c(0.10, 0.25, 0.40, 0.54)
cust = c("cust_1", "cust_2", "cust_3", "cust_4", "cust_5", "cust_6", "cust_7",
"cust_8", "cust_9", "cust_10")
cust_category = c("C", "A", "A", "A", "A", "C", "D", "B", "B", "D")
Thus, I have
> category
[1] "C" "D" "B" "A"
> cat_val
[1] 0.10 0.25 0.40 0.54
> cust
[1] "cust_1" "cust_2" "cust_3" "cust_4" "cust_5"
[6] "cust_6" "cust_7" "cust_8" "cust_9" "cust_10"
> cust_category
[1] "C" "A" "A" "A" "A" "C" "D" "B" "B" "D"
My problem is to match 'cust_category' with 'category' and accordingly selct
the value assigned to this category value. In other words, 1st element of
cust_category is "C", so it should select the value 0.10, the second element is
"A", so it should assign value 0.54 against this. So effectively I should get
cust cust_category cat_val
cust_1 C 0.10
cust_2 A 0.54
cust_3 A 0.54
............................................
cust_10 D 0.25
Kindly guide
Regards
Vincy
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
