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