search for: tobiitim

Displaying 3 results from an estimated 3 matches for "tobiitim".

Did you mean: 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$d...
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 an...
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]]