[R] group data
ruipbarradas at sapo.pt
Thu Apr 11 20:54:27 CEST 2013
Try the following.
dat <- read.table(text = "
", 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,
Em 11-04-2013 19:37, Ye Lin escreveu:
> 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
> 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