[R] group data

[arun]

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,


On Thu, Apr 11, 2013 at 11:54 AM, Rui Barradas <ruipbarradas at sapo.pt> wrote:

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