> Hi all,
> I am trying to read and summarize a big data frame( >10M records)
> Here is the sample of my data
> I want get the total count by state, and the the number of cities
> by state. The x variable is either 100 or 200 and count each
> The result should look like as follows.
> At the present I am doing it in several steps and taking too long
> Is there an efficient way of doing this?
> [hidden email] mailing list -- To UNSUBSCRIBE and more, see
> 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.