[R] Merging files

[David Winsemius]

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 <dwinsemius at 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 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<http://www.r-project.org/posting-guide.html 
>>> >
>>> and provide commented, minimal, self-contained, reproducible code.
>>>
>>
>>
>
> 	[[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.

David Winsemius, MD
West Hartford, CT