group data

Hi,
You could do this:
dat1<- read.table(text="
ID? Value
AL1? 1
AL2? 2
CA1? 3
CA4? 4
",sep="",header=TRUE,stringsAsFactors=FALSE)
?lst1<-split(dat1,gsub("\\d+","",dat1$ID))
res<-do.call(rbind,lapply(seq_along(lst1),function(i) {x1<-lst1[[i]]; x1$group<- paste0("Key",i);x1}))
?res
#?? ID Value group
#1 AL1???? 1? Key1
#2 AL2???? 2? Key1
#3 CA1???? 3? Key2
#4 CA4???? 4? Key2
A.K.



----- Original Message -----
From: Ye Lin <yelin at lbl.gov>
To: Rui Barradas <ruipbarradas at sapo.pt>
Cc: R help <r-help at r-project.org>
Sent: Monday, April 15, 2013 11:50 AM
Subject: Re: [R] group data

What if more generally that the group name doest have anything to do with
the ID, eg. for ID=AL1 and AL2, I want to name the group as "Key1", how can
I approach that?

Thanks,

Hello,

Try the following.


dat <- read.table(text = "

ID? Value
AL1? 1
AL2? 2
CA1? 3
CA4? 4
", header = TRUE, stringsAsFactors = FALSE)

dat$State <- substr(dat$ID, 1, 2)


Note that this dependes on having State being defined by the first two
characters of ID.

Hope this helps,

Rui Barradas


Em 11-04-2013 19:37, Ye Lin escreveu:

Hey,

I have a dataset and I want to identify the records by groups for further
use in ggplot.

Here is a sample data:

ID? Value
AL1? 1
AL2? 2
CA1? 3
CA4? 4

I want to identify all the records that in the same state (AL1 AND A2),
group them as "AL", and do the same for CA1 and CA4. How can I have an
output like:

ID? Value State
AL1? 1? ? ?  AL
AL2? 2? ? ? AL
CA1? 3? ? ? CA
CA4? 4? ?  CA

Thanks for your help!

? ? ? ?  [[alternative HTML version deleted]]

______________________________**________________
R-help at r-project.org mailing list
https://stat.ethz.ch/mailman/**listinfo/r-help<https://stat.ethz.ch/mailman/listinfo/r-help>
PLEASE do read the posting guide http://www.R-project.org/**
posting-guide.html <http://www.R-project.org/posting-guide.html>
and provide commented, minimal, self-contained, reproducible code.

??? [[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.