Displaying 3 results from an estimated 3 matches for "tmstmp".
2012 Sep 09
1
Sum of column from another df based of row values of df1
...some way.
> dput(CALL)
structure(list(NAME = c("STK", "STK", "STK", "STK", "STK",
"STK"), EXPDATE = structure(c(15029, 15029, 15029, 15029, 15029,
15029), class = "Date"), STRIKE = c(6300L, 6300L, 6300L, 6300L,
6300L, 6300L), TMSTMP = c("14:18:36", "15:23:42", "15:22:30",
"15:24:13", "15:22:07", "15:22:27"), PRICE = c(107, 102.05, 101.3,
101.5, 101.2, 101.2), QUANT = c(1850L, 2000L, 2000L, 1700L, 2000L,
2000L), DATE = structure(c(14977, 14977, 14977, 14977, 14977,
149...
2012 May 09
2
Problem with SQLDF - Error in sqliteExecStatement(con, statement, bind.data) : RS-DBI driver: (error in statement: no such table:
...ect * from lessliq")
This works fine.
But on many other dataframes it is not working. I have a dataframe
'testeq'. dput given below:
> dput(head(testeq))
structure(list(NAME = c("DLF", "DLF", "DLF", "DLF", "DLF", "DLF"
), TMSTMP = c("09:07:07", "09:15:03", "09:15:03", "09:15:03",
"09:15:03", "09:15:04"), PRICE = c(295, 294.5, 293.9, 294.9,
295, 294.5), DATE = structure(c(1L, 1L, 1L, 1L, 1L, 1L), .Label =
c("2011-01-03",
"2011-01-04", "2011...
2012 May 12
1
Query regarding date as argument in functions - and about sqldf
...ataset named 'dlfhead':
structure(list(NAME = c("DLF", "DLF", "DLF", "DLF", "DLF", "DLF"
), EXPDATE = structure(c(15001, 15001, 15001, 15001, 15001, 15001
), class = "Date"), STRIKE = c(280, 280, 280, 280, 280, 280),
TMSTMP = c("14:54:17", "14:42:38", "14:09:04", "14:20:25",
"12:27:26", "11:59:36"), PRICE = c(22, 23, 23, 23, 23, 23.2
), DATE = structure(c(14977, 14977, 14977, 14977, 14977,
14977), class = "Date"), TTE = c(24, 24, 24, 24,...