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.
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 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-tp4625193p4625227.html
Sent from the R help mailing list archive at Nabble.com.
When I tried doing that, it only merged the averages from column 1 ? ARI ? and did not spread the averages for ARI, ATL, BAL. Any ideas on how I could keep it from making all of the HTms ARI and all of the averages 19.4375? -- View this message in context: http://r.789695.n4.nabble.com/moving-data-from-one-frame-to-another-tp4625193p4625234.html Sent from the R help mailing list archive at Nabble.com.