Displaying 4 results from an estimated 4 matches for "s1033067".
2010 Jul 21
1
Obtaining the unmerged cases from one of the two data set
...ical Analyst
South African Revenue Service (SARS)
Segmentation and Research : Data Modelling
Tel: +27 12 422 7357, Cell: +27 82 456 4669, Fax:+27 12 422 6579
E-Mail : pmakananisa at sars.gov.za <mailto:pmakananisa at sars.gov.za>
> A = read.csv("C:/Documents and Settings/S1033067/Desktop/A.csv",
header = TRUE, dec =",", sep = ",")
> names(A)
[1] "NAME" "SALARY"
> dim(A)[1]
[1] 19
> B = read.csv("C:/Documents and Settings/S1033067/Desktop/B.csv",
header = TRUE, dec =",", sep = ",")
&g...
2017 Aug 11
2
Package sqldf in R and dates manipulation
...armawikarta 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_dt) >= date('01-01-2003'))
+ ")
[1] P_Code P_Name Launch_dt Price
<0 r...
2017 Aug 11
0
Package sqldf in R and dates manipulation
...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_dt) >= date('01-01-2003'))
> + ")
>...
2017 Aug 11
0
Fwd: RE: Package sqldf in R and dates manipulation
...ikarta?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_dt) >= date('01-01-2003'))
+????? ")
[1] P_Code??? P_Name??? Launch_dt Price???...