(no subject)

-----Original Message-----
From: mbhpathak at gmail.com
Sent: Tue, 2 Oct 2012 09:27:57 -0700
To: jrkrideau at inbox.com
Subject: Re: [R] (no subject)

Hello John,
Here is the code, data set and resutls that I got. I want to combine
two data ( set1 and set2) in such a way that it only take common
values by id and response between these two sets. The output (data
combine) is not what I wanted.
Much appreciated any suggestion.



1library(car)
library(rgr)
library(nlme)
set1<-read.table("U:\\Longitudinal Study\\data1.txt",header=T)
set2<-read.table("U:\\Longitudinal Study\\data2.txt",header=T)
combine<-merge(set1,set2, by=c("ID","response"))

set1

? ? ?  ID response? ? v1
1? ds001? ? ? yes 0.200
2? ds001? ? ? yes 0.300
3? ds001? ? ? yes 0.300
4? ds001? ? ? yes 0.400
5? ds001? ? ? yes 0.300
6? ds001? ? ? yes 0.300
7? ds001? ? ? yes 0.300
8? ds001? ? ?  no 0.300
9? ds001? ? ?  no 0.075
10 ds001? ? ?  no 0.300
11 ds001? ? ?  no 0.300
12 ds001? ? ?  no 0.300
13 ds002? ? ? yes 0.300
14 ds002? ? ? yes 0.300
15 ds002? ? ? yes 0.830
16 ds002? ? ? yes 0.300
17 ds002? ? ?  no 0.300
18 ds002? ? ?  no 0.300
19 ds002? ? ?  no 0.300

set2

? ? ?  ID response?  v2
1? ds001? ? ? yes 0.30
2? ds001? ? ? yes 0.20
3? ds001? ? ? yes 0.45
4? ds001? ? ? yes 0.60
5? ds001? ? ?  no 0.30
6? ds001? ? ?  no 0.30
7? ds001? ? ?  no 0.30
8? ds001? ? ?  no 0.30
9? ds001? ? ?  no 0.30
10 ds002? ? ? yes 0.30
11 ds002? ? ? yes 0.30
12 ds002? ? ? yes 0.30
13 ds002? ? ? yes 0.30
14 ds002? ? ?  no 0.30
15 ds002? ? ?  no 0.30
16 ds002? ? ?  no 0.30

combine

? ? ?  ID response? ? v1?  v2
1? ds001? ? ?  no 0.300 0.30
2? ds001? ? ?  no 0.300 0.30
3? ds001? ? ?  no 0.300 0.30
4? ds001? ? ?  no 0.300 0.30
5? ds001? ? ?  no 0.300 0.30
6? ds001? ? ?  no 0.075 0.30
7? ds001? ? ?  no 0.075 0.30
8? ds001? ? ?  no 0.075 0.30
9? ds001? ? ?  no 0.075 0.30
10 ds001? ? ?  no 0.075 0.30
11 ds001? ? ?  no 0.300 0.30
12 ds001? ? ?  no 0.300 0.30
13 ds001? ? ?  no 0.300 0.30
14 ds001? ? ?  no 0.300 0.30
15 ds001? ? ?  no 0.300 0.30
16 ds001? ? ?  no 0.300 0.30
17 ds001? ? ?  no 0.300 0.30
18 ds001? ? ?  no 0.300 0.30
19 ds001? ? ?  no 0.300 0.30
20 ds001? ? ?  no 0.300 0.30
21 ds001? ? ?  no 0.300 0.30
22 ds001? ? ?  no 0.300 0.30
23 ds001? ? ?  no 0.300 0.30
24 ds001? ? ?  no 0.300 0.30
25 ds001? ? ?  no 0.300 0.30
26 ds001? ? ? yes 0.200 0.30
27 ds001? ? ? yes 0.200 0.20
28 ds001? ? ? yes 0.200 0.45
29 ds001? ? ? yes 0.200 0.60
30 ds001? ? ? yes 0.300 0.30
31 ds001? ? ? yes 0.300 0.20
32 ds001? ? ? yes 0.300 0.45
33 ds001? ? ? yes 0.300 0.60
34 ds001? ? ? yes 0.300 0.30
35 ds001? ? ? yes 0.300 0.20
36 ds001? ? ? yes 0.300 0.45
37 ds001? ? ? yes 0.300 0.60
38 ds001? ? ? yes 0.400 0.30
39 ds001? ? ? yes 0.400 0.20
40 ds001? ? ? yes 0.400 0.45
41 ds001? ? ? yes 0.400 0.60
42 ds001? ? ? yes 0.300 0.30
43 ds001? ? ? yes 0.300 0.20
44 ds001? ? ? yes 0.300 0.45
45 ds001? ? ? yes 0.300 0.60
46 ds001? ? ? yes 0.300 0.30
47 ds001? ? ? yes 0.300 0.20
48 ds001? ? ? yes 0.300 0.45
49 ds001? ? ? yes 0.300 0.60
50 ds001? ? ? yes 0.300 0.30
51 ds001? ? ? yes 0.300 0.20
52 ds001? ? ? yes 0.300 0.45
53 ds001? ? ? yes 0.300 0.60
54 ds002? ? ?  no 0.300 0.30
55 ds002? ? ?  no 0.300 0.30
56 ds002? ? ?  no 0.300 0.30
57 ds002? ? ?  no 0.300 0.30
58 ds002? ? ?  no 0.300 0.30
59 ds002? ? ?  no 0.300 0.30
60 ds002? ? ?  no 0.300 0.30
61 ds002? ? ?  no 0.300 0.30
62 ds002? ? ?  no 0.300 0.30
63 ds002? ? ? yes 0.300 0.30
64 ds002? ? ? yes 0.300 0.30
65 ds002? ? ? yes 0.300 0.30
66 ds002? ? ? yes 0.300 0.30
67 ds002? ? ? yes 0.300 0.30
68 ds002? ? ? yes 0.300 0.30
69 ds002? ? ? yes 0.300 0.30
70 ds002? ? ? yes 0.300 0.30
71 ds002? ? ? yes 0.830 0.30
72 ds002? ? ? yes 0.830 0.30
73 ds002? ? ? yes 0.830 0.30
74 ds002? ? ? yes 0.830 0.30
75 ds002? ? ? yes 0.300 0.30
76 ds002? ? ? yes 0.300 0.30
77 ds002? ? ? yes 0.300 0.30
78 ds002? ? ? yes 0.300 0.30

On Tue, Oct 2, 2012 at 6:25 AM, John Kane <jrkrideau at inbox.com> wrote:

It's hard to know what's wrong? since you did not supply your code.

Please supply a small working example and some data.? To supply data use
the dput()
function, see ?dput() for details.

Welcome to R.


John Kane
Kingston ON Canada

-----Original Message-----
From: mbhpathak at gmail.com
Sent: Mon, 1 Oct 2012 14:25:20 -0700
To: r-help at r-project.org
Subject: [R] (no subject)

Hello,
I am a new R -user and request your help for the following problem.
I need to merge two dataset of longitudinal study which has two column
(id and respose) common. when I used merge option to join the datas
side be side,? because of the repeated subject id, I got larger data
set which is not accurate.

? I would like to connect twi data sets by id and response in such a
way that data are connected by same id and response type? and if the
same subject has less data point in one data set, then produce NA.
Sample data sets is attached.

Bibek