[R] Reformatting a table

David Winsemius dwinsemius at comcast.net
Thu Nov 20 21:57:22 CET 2008


 > txt <- "ID CA1 CA3 CA2 MA2 MA1 MA3
+ 1 14 15 13 7 12 3
+ 2 19 7 12 10 14 5
+ 3 21 12 19 6 8 9 "

 > dta <- read.table(textConnection(txt), header=TRUE)
 > dta
   ID CA1 CA3 CA2 MA2 MA1 MA3
1  1  14  15  13   7  12   3
2  2  19   7  12  10  14   5
3  3  21  12  19   6   8   9
 >
# use [ <row> , <col> ] with a vector of column names in the order  
desired
# and leave the row entry blank

 > dta[ , c("ID","CA1" ,"CA2" ,"CA3" ,"MA1" ,"MA2" ,"MA3") ]
   ID CA1 CA2 CA3 MA1 MA2 MA3
1  1  14  13  15  12   7   3
2  2  19  12   7  14  10   5
3  3  21  19  12   8   6   9

-- 
David Winsemius, MD
Heritage Labs

On Nov 20, 2008, at 3:28 PM, Tul Gan wrote:

> Hi !
>            I am new to R. Can somebody help me in reformatting huge  
> output files ,i.e, rearranging sets of columns in specific order.
> For example: I have data for three compunds 1, 2 and 3
> file1:
> ID CA1 CA3 CA2 MA2 MA1 MA3
> 1 14 15 13 7 12 3
> 2 19 7 12 10 14 5
> 3 21 12 19 6 8 9
>
> to
> File 2:
>
> ID CA1 CA2 CA3 MA1 MA2 MA3
> 1 14 13 15 12 7 3
> 2 19 12 7 14 10 5
> 3 21 19 12 8 6 9
>
> or File3:
> ID CA1 MA1 CA2 MA2 CA3 MA3
> 1 14 12 13 7 15 3
> 2 19 14 12 10 7 5
> 3 21 8 19 6 12 9
>
> Thanks for your help,
> Tul Gan
>
>
>       
> __________________________________________________________________
> Ask a question on any topic and get answers from real people. Go to  
> Yahoo! Answers and share what you know at http://ca.answers.yahoo.com
> 	[[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.



More information about the R-help mailing list