Re: [R] how can I convert a long to wide matrix?

Here is a stab in the dark. I agree with Jim that the description of the problem is hard to follow. The original posting being in HTML format did not help. # library(dplyr) #> #> Attaching package: 'dplyr' #> The following objects are masked from 'package:stats': #> #> filter, lag

Re: [R] how can I convert a long to wide matrix?

Hi Marna, This is a condition that the function cannot handle. It would be possible to reformat the result based on the time intervals, but the stretch_df function doesn't try to interpret the values, just stretches them out to a wide format. Jim On Wed, May 2, 2018 at 9:16 AM, Marna Wagley

Re: [R] how can I convert a long to wide matrix?

Hi Jim, The data set is correct. I took two readings from the "SITE A" within a short time interval, therefore I want to take the first value if there are repeated within a same group of "timeGroup". Therefore I wanted following FinalData1 B1B2 id_X "A" "B" id_Y "A" "B"

Re: [R] how can I convert a long to wide matrix?

Hi Marna, I think this is due to having three rows for id_X and only two for id_Y. The function creates a data frame with enough columns to hold the greatest number of values for each ID variable. Notice that the SITE_n columns contain three values for id_X (A, A, B) and two for id_Y (A, B, NA) as

Re: [R] how can I convert a long to wide matrix?

Hi Jim, Thank you very much for your suggestions. I used it but it gave me three sites. But actually I do have only two sites "Id_X" and "Id_y" . In fact "A" is repeated two times for "Id_X". If it is repeated, I would like to take the first one among many repeated values. dat<-structure(list(ID

Re: [R] how can I convert a long to wide matrix?

Hi Marna, Try this: library(prettyR) stretch_df(dat,idvar="ID",to.stretch=c("EventDate","SITE")) Jim On Wed, May 2, 2018 at 8:24 AM, Marna Wagley wrote: > Hi R user, > I was trying to convert a long matrix to wide? I have an example and would > like to get a table