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]]

