[R] Recode of text variables

[Bill.Venables at csiro.au]

Oh ALRIGHT!  

But as he didn't express the question completely, you had to view my response as a *strategy* that could be used rather than a full answer to an incomplete question.

Still, I never did make any claim to infalibility, and nor will I ever do.  I'm always happy, indeed grateful, to be corrected.  At least my response was *fast*, that has to count for something... :-)

(A faster response would have been: "Well use Microsoft Access, mate", but I did resist it for quite a while, anyway.  :-)

W.


Bill Venables
http://www.cmis.csiro.au/bill.venables/ 


-----Original Message-----
From: Rolf Turner [mailto:r.turner at auckland.ac.nz] 
Sent: Thursday, 2 April 2009 9:49 AM
To: Venables, Bill (CMIS, Cleveland)
Cc: Andrew.McFadden at maf.govt.nz; r-help at r-project.org
Subject: Re: [R] Recode of text variables



Uhhh, Bill, he wanted E to be recoded as ``Treat 3''.
And he didn't say ***what*** he wanted to happen to D.

Fancy.  A chance to ``correct'' Bill Venables for a second time
in two days! :-)

	cheers,

		Rolf

On 2/04/2009, at 12:39 PM, Bill.Venables at csiro.au wrote:

> Here is one way
>
>> x <- c("A", "B", "C", "D", "E", "A")
>> x
> [1] "A" "B" "C" "D" "E" "A"
>> f <- factor(x)
>> levels(f)
> [1] "A" "B" "C" "D" "E"
>> levels(f) <- c(rep("Treat1",2), rep("Treat2", 3))
>> f
> [1] Treat1 Treat1 Treat2 Treat2 Treat2 Treat1
> Levels: Treat1 Treat2
>>
>
> If you really want the charactre variable you can put
>
>> x <- as.character(f)
>
> _____
>
> That's fascinating about Microsoft Access, but, uh... never mind.

	Yeah.  ***Absolutely fascinating***. :-)

	Remind me to tell you sometime the story about the girl
	who went to finishing school in Switzerland ....

		R.

> Bill Venables
> http://www.cmis.csiro.au/bill.venables/
>
>
> -----Original Message-----
> From: r-help-bounces at r-project.org [mailto:r-help-bounces at r- 
> project.org] On Behalf Of Andrew McFadden
> Sent: Thursday, 2 April 2009 9:23 AM
> To: r-help at r-project.org
> Subject: [R] Recode of text variables
>
> Hi all
>
> I am trying to do a simple recode which I am stumbling on. I figure
> there must be any easy way but haven't come across it.
>
> Given data of A","B","C","D","E","A" it would be nice to recode this
> into say three categories ie A and B becomes "Treat1", C becomes  
> "Treat
> 2" and E becomes "Treat 3".
>
> I tried the car library but it didn't seem to like text. Also it seems
> you can only recode into two categories.
>
>
> library(car)
>
> x<-c("A","B","C","D","E","A")
> x
> recode(x, "c(A,B)='Treat 1'; else='Treat 2'")
> recode(x, "1:2='A'; 3='B'")
>
> In Microsoft access a simple way of recoding is to join two tables  
> in a
> query any simple way of doing the same in R?
>
>
>
> Kind regards
>
> Andy
>
> Andrew McFadden MVS BVSc
> Incursion Investigator
> Investigation & Diagnostic Centres - Wallaceville Biosecurity New
> Zealand Ministry of Agriculture and Forestry
>
> Phone 04 894 5600 Fax 04 894 4973 Mobile 029 894 5611 Postal address:
> Investigation and Diagnostic Centre- Wallaceville Box 40742 Ward St
> Upper Hutt
>
>
> ###################################################################### 
> ##
> This email message and any attachment(s) is intended solely for the
> addressee(s) named above. The information it contains is confidential
> and may be legally privileged.  Unauthorised use of the message, or  
> the
> information it contains, may be unlawful. If you have received this
> message by mistake please call the sender immediately on 64 4 8940100
> or notify us by return email and erase the original message and
> attachments. Thank you.
>
> The Ministry of Agriculture and Forestry accepts no responsibility for
> changes made to this email or to any attachments after transmission  
> from
> the office.
> ###################################################################### 
> ##
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at 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.
>
> ______________________________________________
> R-help at 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.


######################################################################
Attention: 
This e-mail message is privileged and confidential. If you are not the 
intended recipient please delete the message and notify the sender. 
Any views or opinions presented are solely those of the author.

This e-mail has been scanned and cleared by MailMarshal 
www.marshalsoftware.com
######################################################################