I think you are looking for something like aggregate(cbind(VPts, HPts) ~ VTm + HTm, data = NFL, sum)
but you should look at the examples for ?aggregate to tweak it to what you need. Michael On Wed, May 2, 2012 at 7:45 AM, Daniel_55 <serna.da...@gmail.com> wrote: > Hello, > > I'm looking for what I'm sure is a quick answer. I'm working with a data set > that looks like this: > > Week Game.ID VTm VPts HTm HPts > Differential HomeWin > 1 1 NFL_20050908_OAK@NE OAK 20 NE 30 10 > FALSE > 2 1 NFL_20050911_ARI@NYG ARI 19 NYG 42 23 > FALSE > 3 1 NFL_20050911_CHI@WAS CHI 7 WAS 9 2 > FALSE > 4 1 NFL_20050911_CIN@CLE CIN 27 CLE 13 -14 > FALSE > 5 1 NFL_20050911_DAL@SD DAL 28 SD 24 -4 > FALSE > 6 1 NFL_20050911_DEN@MIA DEN 10 MIA 34 24 > FALSE > > NFL data. I want to pair each team with the points they received at home and > away and create another table showing this. I know it's easy to do, but all > the methods I am coming up with involve doing each team individually via a > for loop that searches for [i,5]=="NE", [i,5]=="NYG". I would then use the > same method to pair the same team code ("NYG" or "NE") with VPTs when it's > Visiting. > > Thanks for the help. > > -- > View this message in context: > http://r.789695.n4.nabble.com/scanning-a-data-set-for-strings-tp4602953.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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. ______________________________________________ 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.