[R] Dividing Two Dataframes

Greg Snow Greg.Snow at imail.org
Wed May 14 15:57:41 CEST 2008


SDF3 <- SDF1/SDF2[ rep(1:12,12), ]


-----Original Message-----
From: "Bert Jacobs" <b.jacobs at pandora.be>
To: "'Henrique Dallazuanna'" <wwwhsd at gmail.com>
Cc: "r-help at r-project.org" <r-help at r-project.org>
Sent: 5/14/08 7:41 AM
Subject: Re: [R] Dividing Two Dataframes


Hi Henrique,



I think I understand your formula, but your final result is a 12x160
data.frame, while it should be a 144x160 data.frame



divide rows 1:12 with SDF2 (=12 rows)

divide rows 13:24 with SDF2 (=12 rows)

divide rows 25:36 with SDF2 (=12 rows)

…

divide rows 133:144 with SDF2 (=12 rows)



Is it easy to adapt your formula to get this result?



Thx,

Bert



  _____

From: Henrique Dallazuanna [mailto:wwwhsd at gmail.com]
Sent: 14 May 2008 13:34
To: Bert Jacobs
Cc: r-help at r-project.org
Subject: Re: [R] Dividing Two Dataframes



Try this:

DFS <- lapply(split(seq(1, 144, by = 1), rep(1:12, each = 12)),
function(x)SDF1[x,]/SDF2)

On Wed, May 14, 2008 at 5:02 AM, Bert Jacobs <b.jacobs at pandora.be> wrote:

Hi,



I have two dataframes one with 144 rows and 160 columns (SDF1) and one with
12 rows and 160 columns (SDF2).

Now I'm trying to divide rows 1:12 with SDF2, rows 13:24 with SDF2, rows
25:36 with SDF 2, .

In S-Plus the following code works fine:



DFS = SDF1[1:144,1:60] / as.vector(SDF2[1:12,1:160])



but in R when I try to implement the formula I get  the following error:

"/ only defined for equally-sized data frames"



Can someone help me out on this one. Thx in advance.

Bert


       [[alternative HTML version deleted]]

______________________________________________
R-help at 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.




--
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O


        [[alternative HTML version deleted]]



More information about the R-help mailing list