Displaying 2 results from an estimated 2 matches for "ruitime".
Did you mean:
ruijie
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$data1 - data$mous...
2010 Jul 22
1
Updating a Data Frame
..."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]]