[R] group data

Rui Barradas ruipbarradas at sapo.pt
Thu Apr 11 20:54:27 CEST 2013


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
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>



More information about the R-help mailing list