[R] How to load load multiple text files and order by id

[Kingsley G. Morse Jr.]

Hi Richard,

If you haven't tried it already, maybe you could
read the files into separate data frames with
read.table(), and then combine them with merge().

Type

    ?merge

to learn more.

Good luck,
Kingsley

On 03/05/11 18:39, Richard Green wrote:
> Hello R users,
> I am fairly new to R and was hoping you could point me in the right
> direction I have a set of text files (36).
> Each file has only two columns (id and count) , I am trying to figure out a
> way to load all the files together and
> then have them ordered by id into a matrix data frame. For example
> 
> If each txt file has :
> ID           count
> id_00002 20
> id_00003 3
> 
> A Merged File:
> ID           count_file1 count_file2 count_file3 count_file4
> id_00002 20         8              12               5             19 26
> id_00003 3 0 2 0 0 0
> id_00004 75 84 241 149 271 257
> 
> Is there a relatively simply way to do that in R? I was trying with <-
> read.table
> and then <- cbind but that does not appear to be working.  Any suggestions
> folks have are appreciated.
> Thanks
> -Rich
> 
> 	[[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.