David, merg12
displays the files with this message at the bottom [reached getOption("max.print") -- omitted 321526 rows]] str(merg12) displays the following message 'data.frame' : 329218 obs. of 13 variables $ patientid: $ Name: $ Age: but no file is created in the folder 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 <dwinsem...@comcast.net>wrote: > > On Apr 27, 2010, at 4:23 PM, Alex Jameson wrote: > > Hi David, >> >> I have executed >> >> data1 <- read.table("c:\\mydata\\file1.txt") >> data2 <- read.table("c:\\mydata\\file2.txt") >> >> merg12 <- merge(data1, data2) >> >> but am not sure, if it has merged them, >> ideally, i would want a new file name for the merged data, based on the >> identical IDs, >> > > That is what you should have gotten. what happens when you type > > merg12 > > ?? > > and i would need to eliminate some column names (fields) which are not >> required >> > > That can be don easily. Show us: > > str(merg12) > > > -- David. > > >> >> Alex >> >> >> >> On Tue, Apr 27, 2010 at 2:51 PM, David Winsemius <dwinsem...@comcast.net >> >wrote: >> >> >>> On Apr 27, 2010, at 1:19 PM, Alex Jameson wrote: >>> >>> This is a more detailed description of the problem, >>> >>>> >>>> I have written the following lines of code to read the files >>>> >>>> data1=("c:\\mydata\\file1.txt") >>>> data2=("c:\\mydata\\file2.txt") >>>> >>>> >>> NONONO. Read the manual again. Perhaps: >>> >>> data1 <- read.table("c:\\mydata\\file1.txt") >>> data2 <- read.table("c:\\mydata\\file2.txt") >>> >>> >>> file 1 has fields like patientID, Name which are common in file2, however >>>> not all fields are common >>>> >>>> i would like to create file3.txt with the merged data fields, >>>> >>>> >>> And what might happen happened when you tried: >>> >>> merg12 <- merge(data1, data2) >>> >>> ??? ... by default it would merge on the field names (actually column >>> names in R-parlance) that were shared by the two dataframes. >>> >>> -- >>> David >>> >>> >>>> 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.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<http://www.r-project.org/posting-guide.html> >>>> <http://www.r-project.org/posting-guide.html> >>>> >>>> and provide commented, minimal, self-contained, reproducible code. >>>> >>>> >>> >>> >> [[alternative HTML version deleted]] >> >> ______________________________________________ >> R-help@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<http://www.r-project.org/posting-guide.html> >> and provide commented, minimal, self-contained, reproducible code. >> > > David Winsemius, MD > West Hartford, CT > > [[alternative HTML version deleted]] ______________________________________________ R-help@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.