Hello,
Maybe
merge(five, fiveINFO[, c("HTm", "average")])
Hope this helps,
Rui Barradas
Daniel_55 wrote
>
> 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@NE OAK 20 NE 30 10 -10
> 2 1 NFL_20050911_ARI@NYG ARI 19 NYG 42 23 -23
> 3 1 NFL_20050911_CHI@WAS CHI 7 WAS 9 2 -2
> 4 1 NFL_20050911_CIN@CLE CIN 27 CLE 13 -14 14
> 5 1 NFL_20050911_DAL@SD DAL 28 SD 24 -4 4
> 6 1 NFL_20050911_DEN@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-tp4625193p4625227.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.
