aggregate() maybe? It isn't entirely clear to me what you want (or how the United States has 51 states, assuming amerika == US); a reproducible example including a bit of your data provided with dput() would be the most useful thing, as long as it includes a clear statement of your desired resutls.
Sarah On Mon, Oct 15, 2012 at 6:49 AM, EvaR <eva.raet...@gmail.com> wrote: > hey There > I've been trying to match 2 lists in R I have an excel sheet containing all > the 51states of amerika devided by zipcode. the columns are : zip,city, > state, latitude,longitude,count so now I want R to make a new table that I > could use to draw a map. The table should consist the name of the state plus > the count. Like I said I have all the zipcodes and the count for the > zipcodes, so now I would like to calculate the numbers from the zipcodes of > one state. .can anyone help me?I've been trying and seraching trough other > blogs and pages but I fail to find something that helps me. > Thanks a lot > > > -- Sarah Goslee http://www.functionaldiversity.org ______________________________________________ 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.