Displaying 1 result from an estimated 1 matches for "rd1580".
Did you mean:
rd1500
2013 Jan 15
1
SQLDF column errors
...er values from a small data frame 1, d1 that
have matching hits in data frame 2, d2 (Very big) which involves matching
those hits first. I am trying to use sqldf on the df's in the following
fashion:
df1:
V1
12675
14753
16222
18765
df2: head(df2)
V1 V2
13647 rd1500
14753 rd1580
15987 rd1590
16222 rd2020.....
df1_new<-sqldf("select df1.V1, df2.V2 where rs10.V1 = d10.pos”) - Ideally I
would like to try to use "delete" or not equal to "!=" though I can only
find that delete works with sqldf.
but it returns this error:
Error in sqliteExec...