Please use dput() to post your example data sets.
dput(Adata)
dput(Bdata)
**then copy and paste the results of each so that we can "play" around with
it easily.
Miriam -2 wrote
>
> I have been trying to merge datasets, one of which has a long format
> (Adata) and one has a (different) long format (Bdata):
>
> Adata Bdata
> subject order bpm subject order trial agegroup gender
> 1 1 70.2 1 1 3 2 1
> 1 1 69.5 1 2 1 2 1
> 1 1 68.8 1 3 2 2 1
> 1 2 69.1 2 1 2 1 2
> 1 2 70 2 2 3 1 2
> 1 2 70.5 2 3 1 1 2
> 1 3 70.2 ...
> 1 3
> 1 3
> 2 1
> 2 1
> ... ...
>
> In the end I would like to have a dataset that contains A unchanged with
> the additional information from B added.
>
> subject order bpm trial agegroup gender
> 1 1 70.2 3 2 1
> 1 1 69.5 3 2 1
> 1 1 68.8 3 2 1
> ...
> I have tried:
> newdataframe <- merge(Adata,Bdata, by= c("subject", "order"), sort =
> FALSE)
>
> For some reason, the trial column is not matched to the subject and order
> information, despite them being identified as key-variables for the merge.
> (The same is true for other variables, the actual dataset has more
> variables and trials, but this is essentially the problem.)
> So it results in something like:
> subject order bpm trial agegroup gender
> 1 1 70.2 3 2 1
> 1 1 69.5 2 2 1
> 1 1 68.8 1 2 1
>
> What could be my mistake?
>
> Thank you VERY much.
> Miriam
>
>
> --
>
>
>
>
> --
>
> ______________________________________________
> R-help@ 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.
>
--
View this message in context:
http://r.789695.n4.nabble.com/problem-merging-data-with-different-shapes-tp4157137p4157442.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
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.
