[R] moving data from one frame to another

[Rui Barradas]

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.