search for: mangalani

Displaying 16 results from an estimated 16 matches for "mangalani".

2017 Jul 11
1
dplyr help
...larly since in spite 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.c...
2017 Jul 11
1
dplyr help
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 gav...
2017 Aug 11
1
Package sqldf in R and dates manipulation
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 exp...
2017 Jul 10
1
dplyr help
...pe chain there is 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, >...
2017 Jul 12
2
Importing Big data to R
...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 (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 del...
2017 Sep 11
1
Case statement in sqldf
> 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. >...
2017 Sep 11
1
Case statement in sqldf
...e used: library(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...
2017 Sep 11
2
Case statement in sqldf
...e between '2017-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/P...
2017 Jul 10
2
dplyr help
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 versio...
2009 Nov 08
2
Scheffe test
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:&...
2017 Aug 11
1
Package sqldf in R and dates manipulation
...ave 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, 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)...
2017 Jul 10
1
dplyr help
...quot;, "420", "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....
2009 Nov 08
0
Recall: Scheffe test
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]]
2017 Aug 11
0
Fwd: RE: Package sqldf in R and dates manipulation
...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, ? 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...
2010 Sep 13
0
Adding dummy variable "zero/one" in ARIMA model in R
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
2010 Dec 24
1
GLS 95% CI
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