[R] reshape matrix entities to columns

[David Winsemius]

On Sep 12, 2010, at 10:45 AM, Natasha Asar wrote:

> Greeting R helpers J
> I am not familiar with R but I have to use it to analyze data set  
> that I have
> (30,000 20,000)
> I want to change the structure of the dataset and I am wondering how  
> that might
> be possible in R
> A main data looks like this:  some entities are empty
> Age        No.         Age        No.         Age        No.
> Center1     5              2              8           7
>
> Center2      10           7              20
> 9              4              10
> But what I want the data to look like is
> Age                        1              2              3
> 4              5              6              7              8
> 9              10 …       20
> Center1
> 2                                              7
> Center2
> 10
>  7              9
>
> It should read the entities one by one
> when j is in age column take its value and consider it as the column  
> number for
> new matrix
> then go to next entity (j No. columns) and put that entity under the  
> columns
> number identified in previous step.
> In other word
> it should get the each element in No. columns (one by one) and place  
> them in a
> new matrix under the column number which are equal to entity of age  
> columns of
> first matrix
> i have tired ncol, and cbind and things like that but I guess im on  
> the wrong
> path because it is not working.  I am reading this fine with  
> read.csv and
> writing back the same way.
> do you know how I can make this work?? Is it even possible to do  
> something like
> this?
> Thank you in advance
> Natasha
>
>
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.

David Winsemius, MD
West Hartford, CT