n*********e 发帖数: 318 | 1 I am trying to translate prod id into prod name
Here is data -
#----------------------
customer_id, product_id, date
11111,634578,11/12/2011
11111,987654,11/12/2011
11111,678978,11/12/2011
11111,678978,12/22/2011
22222,456789,12/24/2011
33333,678978,01/10/2012
33333,678978,01/15/2012
44444,987365,03/30/2012
I also has a reference file -
prod_id, prod_name
634578, 'ice-cream'
987654, 'green beans'
678978, 'beef'
...
------------------------------------------------------------
How can I do it in R so that my data will have an additional column 'prod_
name'?
Thanks. | t*****i 发帖数: 426 | | n*********e 发帖数: 318 | 3 what is the thing in R which would be equivalent to -
'map' in Java
'dictionary' in Python
'PROC FORMAT' in SAS
? | t******g 发帖数: 372 | 4 datanew<-cbind(data, as.character(ref[match(data[, 'prod_id'], ref[,'prod_id
']),'prod_name']))
【在 n*********e 的大作中提到】![](/moin_static193/solenoid/img/up.png) : I am trying to translate prod id into prod name : Here is data - : #---------------------- : customer_id, product_id, date : 11111,634578,11/12/2011 : 11111,987654,11/12/2011 : 11111,678978,11/12/2011 : 11111,678978,12/22/2011 : 22222,456789,12/24/2011 : 33333,678978,01/10/2012
| s*r 发帖数: 2757 | 5 R vector can have names
w <- 1:3
names(w) <- c('s','i','r')
w['i']
【在 n*********e 的大作中提到】![](/moin_static193/solenoid/img/up.png) : what is the thing in R which would be equivalent to - : 'map' in Java : 'dictionary' in Python : 'PROC FORMAT' in SAS : ?
|
|