cool. :) yea, the argument names are by.x and by.y, so your by.etc were
ignored in the black hole of "arguments passed to other methods"
on 06/06/2008 09:11 AM Michael Pearmain said the following:
Thanks
Works perfectly.
Was the problem due to me putting by.survey and by.etc rather than by.y
and by.x?
I think when i was playing around i tried the all. command in that setup
as well
Mike
On Fri, Jun 6, 2008 at 2:07 PM, Daniel Folkinshteyn <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
try this:
FullData <- merge(ETC, SURVEY, by.x = "ord", by.y = "uid", all.x =
T, all.y = F)
on 06/06/2008 07:30 AM Michael Pearmain said the following:
Hi All,
Newbie question for you all but i have been looking at the
archieves and the
help dtuff to get a rough idea of what i want to do
I would like to merge two dataframes together based on a keyed
variable in
one dataframe linking to the other dataframe. Only some of the
cases will
match but i would like to keep the others as well.
My dataframes have 67 and 28 cases respectively and i would like
ot end uip
with one file 67 cases long (all 28 are matched cases).
I can use the merge command to merge two datasets together this
but i still
get some
odd results, i'm using the code below;
ETC <- read.csv(file="CSV_Data2.csv",head=TRUE,sep=",")
'SURVEY <- read.csv(file="survey.csv",head=TRUE,sep=",")
'FullData <- merge(ETC, SURVEY, by.SURVEY = "uid", by.ETC = "ord")
The merged file seems to have 1800 cases while the ETC data file
only
has 67 and the SURVEY file only has 28. (Reading the help it
looks as if it
merges 1 case with all cases in the other file, which is not
what i want)
The matching variables fields are the 'ord' field and the 'uid'
field
Can anyone advise please?
--
Michael Pearmain
Senior Statistical Analyst
1st Floor, 180 Great Portland St. London W1W 5QZ
t +44 (0) 2032191684
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Doubleclick is a part of the Google group of companies
______________________________________________
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.