search for: pmakananisa

Dear R Gurus, I am currently working on the two dataset ( A and B), they both have the same fields: ID , REGION, OFFICE, CSTART, CEND, NCYCLE, STATUS and CB. I want to merge the two data set by ID. The problem I have is that the in data A, the ID's are unique. However in the data set B, the ID's are not unique, thus some repeat themselves. How do I the merge or retrieve the

...st argument, the data frame that is being reshaped. Please post using plain text in the future... this is a plain text mailing list, and HTML email is what-you-see-is-not-what-we-see. -- Sent from my phone. Please excuse my brevity. On July 10, 2017 1:29:41 AM PDT, Mangalani Peter Makananisa <pmakananisa at sars.gov.za> wrote: >HI all, > >Is it possible to use one column spread on multiple columns values. > >example >spread( Key_col, value1:value7) > >spreading Key_col to variable value1, value2, ....... Value7 > >Please advise, > >Kind regards > >Mangal...

...orts it appears we may not have understood your problem. A small sample data set generated with dput along with your code would be helpful in making sure others learn along with you. -- Sent from my phone. Please excuse my brevity. On July 11, 2017 12:56:45 AM PDT, Mangalani Peter Makananisa <pmakananisa at sars.gov.za> wrote: >Thank you very much for the support. I have just used the reshape >library and my problem was solved. > >Kind regards, > >Peter > >-----Original Message----- >From: Jeff Newmiller [mailto:jdnewmil at dcn.davis.ca.us] >Sent: 10 July 2017 03:...

...ing forward to hearing from the group sooner and thanking you in advance Kind regards Mangalani Peter Makananisa Statistical 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...

Hi all, I am trying to create a new variable called Fiscal Year (FY) using case expression in sqldf and I am getting a null FY , see the code below . Please advise me as to how I can do this mutation. library(zoo) library(lubridate) library(stringr) library(RH2) library(sqldf) cr$ReportDate = as.Date(cr$ReportDate, format ='%Y-%m-%d') > cr2 = sqldf(" select

See FAQ #4 on the sqldf github home page. On Fri, Aug 11, 2017 at 9:21 AM, Mangalani Peter Makananisa <pmakananisa at sars.gov.za> wrote: > Dear all, > > 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 insta...

...t argument, the data frame that is being reshaped. Please post using plain text in the future... this is a plain text mailing list, and HTML email is what-you-see-is-not-what-we-see. -- Sent from my phone. Please excuse my brevity. On July 10, 2017 1:29:41 AM PDT, Mangalani Peter Makananisa <pmakananisa at sars.gov.za> wrote: >HI all, > >Is it possible to use one column spread on multiple columns values. > >example >spread( Key_col, value1:value7) > >spreading Key_col to variable value1, value2, ....... Value7 > >Please advise, > >Kind regards > >Mangal...

Dear R-Gurus, I am trying to read in data with 24,349,113 rows to R-3.3.3 (64 bit) and have used the library "data.table" and It managed to read 23,347,070 rows and the remainder was 2,043 rows only. Could you please advise me as to which library/R-commands is suitable to read the full data in to R? Kind regards, Mangalani Peter Makananisa (5786) South African Revenue Service

Dear all, 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

> On Sep 11, 2017, at 1:05 AM, Mangalani Peter Makananisa <pmakananisa at sars.gov.za> wrote: > > Hi all, > > I am trying to create a new variable called Fiscal Year (FY) using case expression in sqldf and I am getting a null FY , see the code below . > > Please advise me as to how I can do this mutation. > > library(zoo) > librar...

...t;- data.frame(ReportDate = as.Date("2017-09-11")) # input fy <- as.integer(as.yearqtr(cr$ReportDate) + 3/4) transform(cr, FY = paste0(fy-1, "_", fy %% 100)) giving: ReportDate FY 1 2017-09-11 2017_18 On Mon, Sep 11, 2017 at 4:05 AM, Mangalani Peter Makananisa <pmakananisa at sars.gov.za> wrote: > Hi all, > > > > I am trying to create 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...

Dear all, I'm using garchFit from fSeries package and I am not getting the desired results (error message : could not find function "garchFit" ). Would you please advise as to how I can build an ARIMA(p, d, q) - GARCH(p,q) model using R see the attached data and R-output. Thanking you in advance Kind regards Mangalani Peter Makananisa Statistical Analyst South

Dear R gurus, I am currently using the chron package for date manipulation in R and I am able to control the date which take the format - 1998/07/03, and - 2006-09-15 (date without time) Library(chron) As.Date(2006-09-15, format = '%Y-%m-%d') However I have a problem with the date containing only the year and month (i.e. 2006-09, 2007/08, 200609).

HI all, Is it possible to use one column spread on multiple columns values. example spread( Key_col, value1:value7) spreading Key_col to variable value1, value2, ....... Value7 Please advise, Kind regards Mangalani Peter Makananisa (5786) South African Revenue Service (SARS) - HO +2782 456 4669 / +2712 422 7357 Please Note: This email and its contents are subject to our email legal notice

Dear all, Please help me with the R code which compute SCHEFFE TEST Thanking you in advance Kind regards Mangalani Peter Makananisa Statistical Analyst South African Revenue Service (SARS) Segmentation and Research : Data Modelling Tel: +2712 422 7357 Cell: +2782 456 4669 Fax:+2712 422 6579 Please Note: This email and its contents are subject to our email legal notice

Mangalani Peter Makananisa would like to recall the message, "Scheffe test". Please Note: This email and its contents are subject to our email legal notice which can be viewed at http://www.sars.gov.za/Email_Disclaimer.pdf [[alternative HTML version deleted]]

Dear R gurus, How do I add dummy variable zero/ one in the ARIMA model " both in the in-sample and outside the sample(forecasts)? Regards Peter South Africa Tell: +2712 422 7357 Please Note: This email and its contents are subject to our email legal notice which can be viewed at http://www.sars.gov.za/Email_Disclaimer.pdf [[alternative HTML version deleted]]

Dear all, I have just constructed the GLS model in R . How do I print the 95% confidence intervals for the vector of predicted values "R code/s for GLS CI"? See the model below: Please advice Regards Peter South Africa +2712 422 7357 +2782 456 4669 Generalized least squares fit by maximum likelihood Model: log(y) ~ log(x) + d1 + d3 Data: NULL

Dear R Gurus, How do I generate/obtain the 95% CI of the predicted values from the GLS model? "Not plot.Predict" Currently I know how to get the 95% CI for the GLS model parameters. Please advice Regards Peter South Africa Please Note: This email and its contents are subject to our email legal notice which can be viewed at http://www.sars.gov.za/Email_Disclaimer.pdf