Re: [R] Help with transpose please.

2018-06-26 Thread Bill Poling
-project.org) Subject: Re: [R] Help with transpose please. On 6/22/2018 4:43 AM, Bill Poling wrote: > Good morning. > > > I have data in the form: > > head(Edit041IA, n=25) > ClaimServiceID ClaimID DiagnosisCode > 1 183056004 78044473 C562 > 2 183056004 78044473 C778 >

Re: [R] Help with transpose please.

2018-06-26 Thread Bill Poling
Thank you Dan, that was very helpful. Sorry for the delayed response. Cheers WHP From: Daniel Nordlund [mailto:djnordl...@gmail.com] Sent: Saturday, June 23, 2018 6:04 AM To: Bill Poling ; r-help (r-help@r-project.org) Subject: Re: [R] Help with transpose please. On 6/22/2018 4:43 AM, Bill

Re: [R] Help with transpose please.

2018-06-23 Thread Daniel Nordlund
On 6/22/2018 4:43 AM, Bill Poling wrote: Good morning. I have data in the form: head(Edit041IA, n=25) ClaimServiceID ClaimID DiagnosisCode 1 183056004 78044473 C562 2 183056004 78044473 C778 3 183056004 78044473 C784 4 183056004 78044473

Re: [R] Help with transpose please.

2018-06-22 Thread Bill Poling
Thank you Ramesh, I will investigate, appreciate your response Sir! WHP From: Ramesh YAPALPARVI [mailto:ramesh.yapalpa...@icloud.com] Sent: Friday, June 22, 2018 7:47 AM To: Bill Poling Cc: r-help (r-help@r-project.org) Subject: Re: [R] Help with transpose please. Please check out tidyr

Re: [R] Help with transpose please.

2018-06-22 Thread Bill Poling
you suggest and report back thank you again Sir! WHP From: Bert Gunter [mailto:bgunter.4...@gmail.com] Sent: Friday, June 22, 2018 11:54 AM To: Bill Poling Cc: r-help (r-help@r-project.org) Subject: Re: [R] Help with transpose please. 1. "The max number of columns based on this transpo

Re: [R] Help with transpose please.

2018-06-22 Thread Bert Gunter
1. "The max number of columns based on this transpose of the DiagnosisCode column (in this dataset) is 12 if that is important to know." I count about 20 different DX codes in the data you show, so I don't know what this means. 2. I was not able to unambiguously parse your request (I admit that I

Re: [R] Help with transpose please.

2018-06-22 Thread Ramesh YAPALPARVI
Please check out tidyr package and use commands like spread/ gather which would make data wide or long > On Jun 22, 2018, at 07:43, Bill Poling wrote: > > Good morning. > > > I have data in the form: > > head(Edit041IA, n=25) > ClaimServiceID ClaimID DiagnosisCode > 1 183056004 78

[R] Help with transpose please.

2018-06-22 Thread Bill Poling
Good morning. I have data in the form: head(Edit041IA, n=25) ClaimServiceID ClaimID DiagnosisCode 1 183056004 78044473 C562 2 183056004 78044473 C778 3 183056004 78044473 C784 4 183056004 78044473 C786 5 183056004 78044473