Thanks! But What if I have a very large data with 1000+rows, anyway to identify all "AL1" and "AL2" under "ID" and mark them as "AL" under new column "State"?
Thanks. On Thu, Apr 11, 2013 at 11:54 AM, Rui Barradas <ruipbarra...@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@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@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.
