Re: [R] merged files

2010-04-29 Thread Alex Jameson
Hi, i have two files (file1.txt and file2.txt) which i would like to merge, based on certain criteria, i.e. it combines data based on matching geneID and exons. i have used the merge option, but it does not give me the desired outcome. merged.txt shows the result i would like. *File1. txt* **

[R] merge on criteria

2010-04-29 Thread Alex Jameson
Hi, i have two files (file1.txt and file2.txt) which i would like to merge, based on certain criteria, i.e. it combines data based on matching geneID and exons. i have used the merge option, but it does not give me the desired outcome. merged.txt shows the result i would like. *File1. txt* *

Re: [R] Merging files

2010-04-27 Thread Alex Jameson
lder mydata i would expect a file to be created, which is not happening Thank you Alex On Tue, Apr 27, 2010 at 4:41 PM, David Winsemius wrote: > > On Apr 27, 2010, at 4:23 PM, Alex Jameson wrote: > > Hi David, >> >> I have executed >> >> data1 <- read.table(

Re: [R] Merging files

2010-04-27 Thread Alex Jameson
ical IDs, and i would need to eliminate some column names (fields) which are not required Alex On Tue, Apr 27, 2010 at 2:51 PM, David Winsemius wrote: > > On Apr 27, 2010, at 1:19 PM, Alex Jameson wrote: > > This is a more detailed description of the problem, >> >> I

Re: [R] Merging files

2010-04-27 Thread Alex Jameson
mon i would like to create file3.txt with the merged data fields, i hope this is clear, and i thank everyone, who has responded so far. Alex Jameson Student, University of Colorado [[alternative HTML version deleted]] __ R-help@r-project.or

Re: [R] Merging files

2010-04-27 Thread Alex Jameson
Stephen, ?merge and ?intersect have been suggested, unfortunately, i have browsed through the documentation, and there is no live example to demonstrate how this can be used. The documentation is not very descriptive. Am quite new to R, although i have used SPSS and SAS before. thanks Alex On

Re: [R] Merging files

2010-04-27 Thread Alex Jameson
mon i would like to create file3.txt with the merged data fields, i hope this is clear, and i thank everyone, who has responded so far. Alex Jameson Student, University of Colorado [[alternative HTML version deleted]] __ R-help@r-project.or

[R] Merging files

2010-04-27 Thread Alex Jameson
Hi, any one with experience in merging files i have different files, some of the files, have the same fields, so i would like to merge them *File 1:* field a,b,c,d,e,f *File 2:* field a, c, e, m, n *merged file* field a, c, e (ie only the common fields) thanks Alex [[alternative