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.
