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.