On Jul 6, 2011, at 7:36 AM, Silvano wrote:
----- Original Message ----- From: "Silvano" <silv...@uel.br>
To: <r-help@r-project.org>
Sent: Thursday, June 30, 2011 9:07 AM
Subject: Tables and merge
I have 21 files which is common variable CODE.
Each file refers to a question.
I would like to join the 21 files into one, to construct
tables for each question by CODE.
I tried the command (8 files only):
require(foreign)
q1 = read.epiinfo('Dados/Q1.rec')
q2 = read.epiinfo('Dados/Q2.rec')
q3 = read.epiinfo('Dados/Q3.rec')
q4 = read.epiinfo('Dados/Q4.rec')
q5 = read.epiinfo('Dados/Q5.rec')
q6 = read.epiinfo('Dados/Q6.rec')
q7 = read.epiinfo('Dados/Q7.rec')
q8 = read.epiinfo('Dados/Q8.rec')
juntos = merge(q1,q2,q3,q4,q5,q6,q7,q8)
But it didn't work. Any suggestions?
Suggestion # 1: Read the Posting Guide. In there you are advised to
report the verbatim text from error messages. Reading error messages
is often informative.
Suggestion # 2: Report the results of `str` on all of those "q"
objects. We need to see whether there are the necessary common column
names that would support a merge operation.
Suggestion #3 : read the ?merge page and pay particular attention to
number ("two") in the title.
consider this possibility after further reading of ?merge and a bit of
testing.
merge(x=q1, y=list(q2,q3,q4,q5,q6,q7,q8) )
# Your error occurred because of positional matching. The q3 object is
being assigned to the third argument , "by= ", and that is what your
unreported error message was telling you.
That construction seemed to work without error on a test I did with a
slight modification of the first example on ?merge. After making the
author column have the same name = `name`, I also got success with:
do.call("merge", list(x=authors, y=list(books, books)))
The non-do,call simplification above was not entirely predictably
correct (to me anyway) , since the ?merge page does not say that a
list object holding dataframes would be an acceptable "y" argument.
But I see that as.data.frame(list(books, books)) does produce a
data.frame and coercion with as.data.frame on that list object is
probably what happened in the merge() call.
--
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.
