[R] Merging files

[Abhishek Pratap]

Hi Alex

merge wont write a file automatically. You need to use something which
can direct the output to a file.

write.table(merge12, file = "output.data" ) should do the trick.

Read more at ?write.table

-Abhi


On Tue, Apr 27, 2010 at 5:23 PM, Alex Jameson <ajameson75 at gmail.com> wrote:
> 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 <dwinsemius at 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 <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>
>>>>> <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<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 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.
>