In this specific case I'm going to do another select, from a different
table with the where clause being based on the start_time and end_time.
select * from table_name where time >= start_time and time <= end_time;
On Dec 31, 2009, at 3:57 PM, John Kane wrote:
Uh what do you want to do to it/them?
Here are a couple of R-type commands on a data.frame.
mydata <- data.frame(vec1 = seq(19,109, by=10),
vec2 =seq(30,120, by=10))
mydata[,1]+mydata[,2]
apply(mydata, 2, mean)
--- On Thu, 12/31/09, donahc...@me.com <donahc...@me.com> wrote:
From: donahc...@me.com <donahc...@me.com>
Subject: [R] iterating over a data frame the R way?
To: r-help@r-project.org
Received: Thursday, December 31, 2009, 2:44 PM
Hi,
I have a data frame that was create by issuing a select
against my sqlite database. I want to get each row
from the data frame and use the each of the column
values. The data frame looks like this:
start_time end_time
09:30:00 10:00:00
10:00:01 10:30:00
etc
Can a point me to a tutorial/example of doing this? I
the other programming languages I'm familiar with I would
just loop over the frame and access the elements, but I
believe that's not the R way and can't find examples of
doing this.
Thanks!
______________________________________________
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.
__________________________________________________________________
Make your browsing faster, safer, and easier with the new Internet
Explorer® 8. Optimized for Yahoo! Get it Now for Free! at http://downloads.yahoo.com/ca/internetexplorer/
______________________________________________
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.
