Displaying 6 results from an estimated 6 matches for "tcei_or".
2017 Aug 11
2
Package sqldf in R and dates manipulation
...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,
Kind regards,
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)
head(product)
library(sqldf)
sqldf()
# out-put
> sqldf("select * from product
+ where (date(Launch...
2017 Sep 11
4
Case statement in sqldf
...lse null
+ end as FY
+ from cr
+ where ReportDate >= '2012-04-01'
+ ")
Thanking you in advance
Kind regards,
Mangalani Peter Makananisa (0005786)
South African Revenue Service (SARS)
Specialist: Statistical Support
TCEI_OR (Head Office)
Tell: +272 422 7357, Cell: +2782 456 4669
Please Note: This email and its contents are subject to our email legal notice which can be viewed at http://www.sars.gov.za/Pages/Email-disclaimer.aspx
[[alternative HTML version deleted]]
2017 Aug 11
0
Package sqldf in R and dates manipulation
...data by dates in sqldf?
>
> I am not getting Djoni Darmawikarta email address.
>
> Please see the practice data attached and advise,
>
> Kind regards,
>
> 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)
> head(product)
> library(sqldf)
> sqldf()
>
> # out-put
>
>> sqldf("select *...
2017 Sep 11
0
Case statement in sqldf
...$ FY : chr "2012_13" "2013_14" "201415" "2015_16" ...
>
>
> Thanking you in advance
>
> Kind regards,
>
> Mangalani Peter Makananisa (0005786)
> South African Revenue Service (SARS)
> Specialist: Statistical Support
> TCEI_OR (Head Office)
> Tell: +272 422 7357, Cell: +2782 456 4669
>
> Please Note: This email and its contents are subject to our email legal notice which can be viewed at http://www.sars.gov.za/Pages/Email-disclaimer.aspx
>
> [[alternative HTML version deleted]]
>
> ______________...
2017 Sep 11
0
Case statement in sqldf
...te a new variable called Fiscal Year (FY) using case
> expression in sqldf and I am getting a null FY , see the code below .
>
>
>> + then '2017_18' else null>> South African Revenue Service (SARS)>> Specialist: Statistical Support>> TCEI_OR (Head Office)>> Tell: +272 422 7357, Cell: +2782 456 4669>> http://www.sars.gov.za/Pages/Email-disclaimer.aspxemail: ggrothendieck at gmail.with
> Please advise me as to how I can do this mutation.
>
>
>
> library(zoo)
>
> library(lubridate)
>
> library(...
2017 Aug 11
0
Fwd: RE: Package sqldf in R and dates manipulation
...nstall 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,
?
Kind regards,
?
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)
head(product)
library(sqldf)
sqldf()
?
# out-put
?
> sqldf("select * from product
+???????????????? where (date(L...