[R] Combining files

[Laurent Gautier]

Would the following make it ?


frame1 _ read.table("file1", sep=",")
n1 _ length(frame1)
m1 _ rep(F, n1)
m1[1] _ T

frame2 _ read.table("file2", sep=",")
## might a more elegant way to do the following: I remember
## discussions about it in this list
frame2 _ frame2[,1:2]
m2 _ c(T,F)

my.data.frame _ merge(frame1, frame2, m1, m2, all.x=T)

x


Laurent


Laurent Gautier			CBS, Building 208, DTU
PhD. Student			D-2800 Lyngby,Denmark	
tel: +45 45 25 24 85		http://www.cbs.dtu.dk/laurent

On Wed, 2 Jan 2002, Jean-Pierre Gattuso wrote:

> Hi:
> 
> I am a very recent user of R 1.40 for MacOSX and went through the 
> help files but did not not find the function that I am looking for.
> 
> 
> I have two comma separated files which I want to partly combine.
> 
> File 1 has 49670 lines and 26 columns (separated by commas) and looks 
> like this:
> 
> ...
> 86020,-10.25,30.25,19.24,19.18,6.19,22.6,16.41,.4,1.58,36.36,36.47,36.18,,3,3,4,116.44,3.03,98.83,126.97,116.03,5.44,0,0,-1
> 86021,-9.75,30.25,19.06,18.97,6.24,22.41,16.17,.42,1.58,36.36,36.47,36.18,.01,3,3,4,146.15,5.33,131.7,153.38,145.6,9.46,0,0,-1
> 86022,-9.25,30.25,,,,,,,,,,,,3,,,,,,,,,0,0,-1
> 86023,-8.75,30.25,,,,,,,,,,,,,,,,,,,,,0,0,-1
> 86071,15.25,30.25,,,,,,,,,,,,3,,,,,,,,,0,0,-1
> ....
> 
> File 2 has 259201 lines and 8 columns (separated by commas) and looks 
> like this:
> 
> ...
> 86020,Oceanic I,-1,-10.25,30.25,7,2670.172,207.249
> 86021,Coastal,0,-9.75,30.25,7,2670.172,207.249
> 86022,Terrestrial,1,-9.25,30.25,7,2670.172,207.249
> 86023,Terrestrial,1,-8.75,30.25,7,2670.172,207.249
> 86024,Not Selected,-9999,-8.25,30.25,7,2670.172,207.249
> ...
> 
> Column 1 in both files is the cell id and colum 2 in file 2 provides 
> the nature of the cell (oceanic, terrestrial...).
> 
> What I want to do is to add the nature of the cell to each line of 
> file 1. In other words, I want to add column 2 of file 2 (e.g. 
> "oceanic") to file 1, using columns 1 of both files as matching 
> variables (i.e. add column 2 o
> 
> Thanks in advance for your help,
> jp
> -- 
> 
> ____________________________________________________________________
> Jean-Pierre Gattuso
> Laboratoire d'Océanographie de Villefranche, UMR 7093 CNRS-UPMC
> B. P. 28, F-06234 Villefranche-sur-mer Cedex - France
> Voice: +33 (0)493763859 - Fax: +33 (0)493763834 - US fax: +1 (978) 477-8302
> <mailto:gattuso at obs-vlfr.fr> - http://www.obs-vlfr.fr/~gattuso
> -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
> r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
> Send "info", "help", or "[un]subscribe"
> (in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
> _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
> 

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._