[R] moving data from one frame to another
Daniel_55
serna.danny at gmail.com
Fri May 11 03:24:00 CEST 2012
Hello,
I am working with two different data frames, and I'd like to move data from
one to the other. Here is the first frame:
> head(five)
Week Game.ID VTm VPts HTm HPts HDifferential VDifferential
1 1 NFL_20050908_OAK at NE OAK 20 NE 30 10 -10
2 1 NFL_20050911_ARI at NYG ARI 19 NYG 42 23 -23
3 1 NFL_20050911_CHI at WAS CHI 7 WAS 9 2 -2
4 1 NFL_20050911_CIN at CLE CIN 27 CLE 13 -14 14
5 1 NFL_20050911_DAL at SD DAL 28 SD 24 -4 4
6 1 NFL_20050911_DEN at MIA DEN 10 MIA 34 24 -24
VTm.f HTm.f average
1 OAK NE 19.4375
2 ARI NYG 19.4375
3 CHI WAS 19.4375
4 CIN CLE 19.4375
5 DAL SD 19.4375
6 DEN MIA 19.4375
and here is the other (aggregated means from the first frame).
> head(fiveINFO)
HTm HPts VPts average
1 ARI 19.87500 19.00000 19.43750
2 ATL 24.75000 19.12500 21.93750
3 BAL 19.37500 13.75000 16.56250
4 BUF 16.50000 17.37500 16.93750
5 CAR 25.12500 23.27273 24.19886
6 CHI 18.77778 14.00000 16.38889
For reference, this data is looking at NFL scores. I want to take the
averages in fiveINFO, frame two, and move them to the corresponding team in
the first frame. five is 266 rows long, while fiveINFO is 32 rows — fiveINFO
contains each HTm only once, while five contains each one 8-10 times,
depending on the number of home games each team plays.
I'm imagining I'll need to use some kind of for loop for this, but
everything I'm doing is striking out. Help?
--
View this message in context: http://r.789695.n4.nabble.com/moving-data-from-one-frame-to-another-tp4625193.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help
mailing list