[R] export/import matrix

jim holtman jholtman at gmail.com
Mon Aug 1 14:44:39 CEST 2011


If you are just exporting it so you can read it back into R later, it
is better to use save/load since it keep the data in the internal
format so it will look the same.

Can you describe what you are going to be doing with the data that you
'export'; that might help us come up with a solution to your problem.

On Sun, Jul 31, 2011 at 7:54 PM, Rosario Garcia Gil
<M.Rosario.Garcia at slu.se> wrote:
> Hello
>
> I have a problem on keeping the format when I export a matrix file with the write.table() function.
>
> When I import the data volcano from rgl package it looks like this in R:
>
>
>> data[1:5,]
>     [,1] [,2] [,3] [,4] [,5] [,6] [,7] [,8] [,9] [,10] [,11] [,12] [,13] [,14]
> [1,]  100  100  101  101  101  101  101  100  100   100   101   101   102   102
> [2,]  101  101  102  102  102  102  102  101  101   101   102   102   103   103
> [3,]  102  102  103  103  103  103  103  102  102   102   103   103   104   104
> [4,]  103  103  104  104  104  104  104  103  103   103   103   104   104   104
> [5,]  104  104  105  105  105  105  105  104  104   103   104   104   105   105
>
> I use this data to represent a 3D map with the follwing script and it works PEFECT!
>
>> y<- 2*data
>> x <- 10* (1:nrow(y))
>> z <- 10* (1:ncol(y))
>> ylim <- range(y)
>> ylen <-ylim[2] - ylim[1] + 1
>> colorlut <- terrain.colors(ylen)
>> col <- colorlut[y-ylim[1] + 1]
>> rgl.open()
>> rgl.surface(x,z,y, color=col, back="lines")
>
>
> Then I export it as write.table(data, file="datam.txt", row.names=TRUE, col.names=TRUE),
>
> when I import it back into R again with read.table("datam.txt") it looks like this in R:
>
>
>   V1  V2  V3  V4  V5  V6  V7  V8  V9 V10 V11 V12 V13 V14 V15 V16 V17 V18 V19
> 1 100 100 101 101 101 101 101 100 100 100 101 101 102 102 102 102 103 104 103
> 2 101 101 102 102 102 102 102 101 101 101 102 102 103 103 103 103 104 105 104
> 3 102 102 103 103 103 103 103 102 102 102 103 103 104 104 104 104 105 106 105
> 4 103 103 104 104 104 104 104 103 103 103 103 104 104 104 105 105 106 107 106
> 5 104 104 105 105 105 105 105 104 104 103 104 104 105 105 105 106 107 108 108
>
> The script I mention before does not anymore work on it, if I converted to matrix with as.matrix still does not work.
>
> I have read the pdf on import/export of R and searched by googleling but I have not found any answer to my problem.
>
> I am sorry if the answer is very obvious but I have tried for more than a week.
>
> Any help is really wellcome, thanks in advance.
> Rosario
> ______________________________________________
> 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.
>



-- 
Jim Holtman
Data Munger Guru

What is the problem that you are trying to solve?



More information about the R-help mailing list