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 >
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
and provide commented, minimal, self-contained, reproducible code.

David Winsemius, MD
West Hartford, CT

______________________________________________
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.

Reply via email to