[R] Trouble with FAILDATE when using the aggregate() and ts() functions

2023-09-30 Thread Paul Bernal
Dear friends, First of all, the following is the R version I am working with: [64-bit] C:\Program Files\R\R-4.3.1 The packages I am using are the following: library("dplyr") library("lubridate") library("tidyverse") library("readxl") library("stats") #reading data for distribution fitting

Re: [R] Grouping by Date and showing count of failures by date

2023-09-30 Thread Duncan Murdoch
There's a package called "pivottabler" which exports PivotTable: http://pivottabler.org.uk/reference/PivotTable.html . Duncan Murdoch On 30/09/2023 7:11 a.m., John Kane wrote: To follow up on Rui Barradas's post, I do not think PivotTable is an R command. You may be thinking og the

Re: [R] Grouping by Date and showing count of failures by date

2023-09-30 Thread Ebert,Timothy Aaron
In this sort of post it would help if we knew the package that was being used for the example. I found one option. https://cran.r-project.org/web/packages/pivottabler/vignettes/v00-vignettes.html There may be a way to create a custom data type that would be a date but restricted to a -mm

Re: [R] Grouping by Date and showing count of failures by date

2023-09-30 Thread John Kane
To follow up on Rui Barradas's post, I do not think PivotTable is an R command. You may be thinking og the "pivot_longer" and "pivot_wider" functions in the {tidyr} package which is part of {tidyverse}. On Sat, 30 Sept 2023 at 07:03, Rui Barradas wrote: > Às 21:29 de 29/09/2023, Paul Bernal

Re: [R] Grouping by Date and showing count of failures by date

2023-09-30 Thread Rui Barradas
Às 21:29 de 29/09/2023, Paul Bernal escreveu: Dear friends, Hope you are doing great. I am attaching the dataset I am working with because, when I tried to dput() it, I was not able to copy the entire result from dput(), so I apologize in advance for that. I am interested in creating a column

[R] Grouping by Date and showing count of failures by date

2023-09-30 Thread Paul Bernal
Dear friends, Hope you are doing great. I am attaching the dataset I am working with because, when I tried to dput() it, I was not able to copy the entire result from dput(), so I apologize in advance for that. I am interested in creating a column named Failure_Date_Period that has the FAILDATE