Re: [R] Problems Structuring My Data

2023-10-04 Thread Jim Lemon
Hello, I am very sad to let you know that my husband Jim died in 18th September. I apologise for not letting you know earlier but I had trouble finding the password for his phone. If you wish to do an obituary please let me know by emailing juelsallybri...@gmail.com, I can send info through. Kind r

Re: [R] Problems Structuring My Data

2023-10-03 Thread Bert Gunter
I'll make an attempt to answer your question, but the results seems extremely wasteful, as there appears to be only one REMNAME for each FAILDATE. This means for my "solution", almost all of the entries are empty (NULL, actually). So I assume I must misunderstand your specification, but maybe showi

Re: [R] Problems Structuring My Data

2023-10-03 Thread Bert Gunter
I won't attempt to answer your post here, but: #I don“t know why R is showing the dates as numbers Please read the Help files! You say FAILDATE has "type" = S3 class, "Date". The first thing ?Dates tells you in the "Details" is: "Dates are represented as the number of days since 1970-01-01, with

[R] Problems Structuring My Data

2023-10-03 Thread Paul Bernal
Dear friends, Hope you are all doing great. I am working with a dataset which is a subset of the original one, that has the following columns: FAILDATE, REM_NAME, and Days_At_Failure. I want to structure the data in such a way that I have the unique FAILDATE in "%Y-%m-%d" format, then a column fo