similar to: dplyr help

Displaying 20 results from an estimated 3000 matches similar to: "dplyr help"

2017 Jul 10
0
dplyr help
Hi something like dcast(temp2, minuty~pokus) ? > dput(temp2) structure(list(pokus = structure(c(1L, 1L, 1L, 2L, 2L, 2L, 2L, 2L, 3L, 3L, 3L, 3L, 4L, 4L, 4L, 5L, 5L, 6L, 6L, 7L, 7L, 8L, 8L ), .Label = c("T42", "T43", "T44", "T45", "T46", "T47", "T48", "T49"), class = "factor"), minuty = structure(c(2L,
2017 Jul 11
2
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
2017 Jul 11
0
dplyr help
A better thanks would be to post the solution that met your needs... particularly 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
2017 Jul 10
0
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 input/output data), the answer is no, the column names come from the column named by the key parameter and the values that fill those columns come from the column named by the value parameter.
2017 Aug 11
2
Package sqldf in R and dates manipulation
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
2017 Aug 11
0
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 expected results.
2017 Sep 11
4
Case statement in sqldf
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
2010 Aug 25
4
Merging two data set in R,
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
2017 Jul 12
2
Importing Big data to R
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
2017 Nov 21
0
mystery "158"
Your data frame fam contains factors. Turn it into character strings using fam$Family = as.character(fam$Family) and try again. It may be helpful if you read up on R's factors, see ?factor. HTH, Peter On Tue, Nov 21, 2017 at 2:14 PM, Glen Forister <gforister at gmail.com> wrote: > This is a simple problem, but a mystery to me. > I'm trying to grab $Family
2017 Nov 22
1
mystery "158"
Well, ?factor does not say anything about this behaviour (assigning numeric code instead of level of factor). And actually if you do assignment for whole vector the result is different (vector in data frame is changed to factor). > temp2$fff[1]<-vec[1] > head(temp2,2) pokus minuty fff 1 T42 240 3 2 T42 300 <NA> > temp2$fff<-vec > head(temp2,2) pokus
2017 Nov 21
2
mystery "158"
This is a simple problem, but a mystery to me. I'm trying to grab $Family "Scelionidae" from one dataframe and put it into another dataframe occupied with NA in $Family. The result is a "158" ends up there instead of Scelionidae. Simply put fam$Family[1] <- least$Family[1] If I have made a mistake here, can somebody point it out. I've included the simple
2017 Sep 11
0
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. > > library(zoo) > library(lubridate) >
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
2017 Sep 11
0
Case statement in sqldf
2018-03-3 in your code should be 2018-03-31. The line then'201415' needs to be fixed. When posting please provide minimal self-contained examples. There was no input provided and library statements not relevant to the posted code were included. Fixing the invalid date and bad line, getting rid of those library statements that are unnecessary and providing some test input, it works
2009 Nov 06
1
GARCH Models in R
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
2010 Aug 18
1
Controlling the dates in R;
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).
2010 Jul 21
1
Obtaining the unmerged cases from one of the two data set
Dear "R Gurus", I am having two dummy csv data sets A and B containing 19 and 15 cases/observations respectively. From the two data set 13 cases are intersection. From one 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
2017 Oct 18
2
creating tables with replacement
Hi R User, I am new in R and trying to create tables with selecting rows randomly (but with replacement) for each group but each group should have same number as original. Is it possible to create it using the following example data set? Your help is highly appreciated. dat1<-structure(list(RegionA = structure(c(1L, 1L, 2L, 3L, 3L, 4L, 5L, 5L, 6L, 6L, 6L, 6L, 6L, 6L, 6L, 6L, 6L, 6L, 6L),
2010 Aug 13
26
DO NOT REPLY [Bug 7618] New: symlinks and --link-dest
https://bugzilla.samba.org/show_bug.cgi?id=7618 Summary: symlinks and --link-dest Product: rsync Version: 3.0.7 Platform: Other OS/Version: Linux Status: NEW Severity: normal Priority: P3 Component: core AssignedTo: wayned at samba.org ReportedBy: the_majkl at seznam.cz QAContact: