search for: makananisa

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:52 PM To: r-help at r-project.org; Mangalani Peter Makananisa; r-help at r-project.org Cc: Vito Ricci (vito_ricci at yahoo.com) Subject: Re: [R] dplyr help I am pretty sure that this is not a question about dplyr... it is a question about tidyr. Look at the help file ?tidyr::spread. If I understand your question (I may not, because you gave no example of i...

...pite of our efforts 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:...

...017-04-01' and '2018-03-3' + then '2017_18' else 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...

...th 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, 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()...

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 which can be viewed at http://www.sars.gov.za/Pages/Email-disclaimer.aspx [[alternative HTML version deleted]]

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...

...s also the first 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...

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

...,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 (SARS) +2782 456 4669 / +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/Pages/Email-disclaimer.aspx [[alternative HTML version deleted]]

> 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(z...

...rary(zoo) cr <- 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 nul...

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 which can be viewed at http://www.sars.gov.za/...

...;, "480" ), class = "factor")), .Names = c("pokus", "minuty"), row.names = c(NA, -23L), class = "data.frame") Cheers Petr > -----Original Message----- > From: R-help [mailto:r-help-bounces at r-project.org] On Behalf Of Mangalani > Peter Makananisa > Sent: Monday, July 10, 2017 10:30 AM > To: r-help at r-project.org > Cc: Vito Ricci (vito_ricci at yahoo.com) <vito_ricci at yahoo.com> > Subject: [R] dplyr help > > HI all, > > Is it possible to use one column spread on multiple columns values. > > example &gt...

...nd 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 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 which can be viewed at http://www.sars.gov.za/Ema...

...e of the two (any) data set, How do I then retrieve the unmerged data ? let's take A for example, six cases must appear in our results. See the R codes below. Please assist. Looking 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...

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, 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).

...anipulation 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, ? 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(...

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