Displaying 3 results from an estimated 3 matches for "tobiitime".
2010 Jul 25
1
Left Outer Join 2 DF's on Multiple Conditions
Hi,
I am trying to execute the following SQL statement using two data frames:
tab1, tab2 : Two Tables
Select tab1.*, tab2.*, tab1.tobiiTime - tab2.ruiTime as timeDiff,
IFNULL(n-m, -9999999) as alwaysIncrement
FROM tab1
LEFT OUTER JOIN tab2 On tab1.data1 - tab2.mouseX = 0 And tab1.data2 -
tab2.mouseY = 0
I am trying to do the following in R:-
*#Getting error here:*
data <- merge(tab1,tab2, all.x=TRUE, by=(data$da...
2010 Jul 20
1
Error using sqldf
Hi,
I am running a query using sqldf() [package : sqldf]. The query is:-
userid <- 5
taskid <- 5
tab1 <- fn$sqldf("SELECT tobiiEvents.data1, tobiiEvents.data2,
events.`timestamp` as tobiiTime
FROM tobiiEvents
INNER JOIN events ON events.eventid = tobiiEvents.eventid
WHERE tobiiEvents.subtype = 'MOUSE' AND tobiiEvents.userid = 5 AND
tobiiEvents.taskid = 5
ORDER BY events.`timestamp`")
This runs fine when I am using constants.
However, when I pass in variables (userid and...
2010 Jul 22
1
Updating a Data Frame
...vents[events$eventid == eventid, "timeDiff"] <<- timeDiff
}
I call this function like:
# dataF is a subset of events
if(doUpdate == 1){
if(!is.null(dataF) && nrow(dataF) > 0){
len <- nrow(dataF)
for(i in 1:len){
updateDB(dataF[i,"eventid"], dataF[i,"tobiiTime"], dataF[i,"ruiTime"])
}
}
}
However, this particular update functionality is performing very slow
updates.
Is there a better and more efficient way to update multiple fields in a
data-frame efficiently.
Thanks in advance.
Harsh Yadav
[[alternative HTML version deleted]]