Sent from Samsung tablet.
I recently read the book “ R data preperation and manipulation using sqldf
package” by Djoni Darmawikarta
However, I have a problem with manipulation of dates using this package, I do
not get the expected results. Do I need to install some packages to be able to
subset the data by dates in sqldf?
I am not getting Djoni Darmawikarta email address.
Please see the practice data attached and advise,
Mangalani Peter Makananisa (0005786)
South African Revenue Service (SARS)
Specialist: Statistical Support
TCEI_OR (Head Office)
Tell: +2712 422 7357, Cell: +2782 456 4669
product = read.csv('D:/Users/S1033067/Desktop/sqldf prac/sqlprac.csv',
na.strings = '', header = T)
> sqldf("select * from product
+ where (date(Launch_dt) >= date('01-01-2003'))
 P_Code P_Name Launch_dt Price
<0 rows> (or 0-length row.names)
DisclaimerPlease Note: This email and its contents are subject to our email
legal notice which can be viewed at
[[alternative HTML version deleted]]
Rfirstname.lastname@example.org mailing list -- To UNSUBSCRIBE and more, see
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.