how to MERGE two datasets to have one dataset having 14 records by ID and VISIT

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

DATA1 = structure(list(ID = c(1301, 1301, 1301, 1301, 1301, 1301, 1301,
1301, 1301, 1301, 1301, 1301, 1301, 1301), VISIT = c(2L, 2L,
2L, 2L, 2L, 2L, 2L, 3L, 3L, 3L, 3L, 3L, 3L, 3L), SID = c(13L,
13L, 13L, 13L, 13L, 13L, 13L, 13L, 13L, 13L, 13L, 13L, 13L, 13L
), SUBJID = c(1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L,
1L, 1L), NTIME = c(0, 0.5, 1, 2, 4, 8, 12, 0, 0.5, 1, 2, 4, 8,
12), DV = c("<LLOQ<(0.500)", "23.9", "30.1", "20.5", "14.3",
"6.53", "4.95", "10.8", "25.2", "24.5", "21.6", "13.5", "8.19",
"6.10")), .Names = c("ID", "VISIT", "SID", "SUBJID", "NTIME",
"DV"), row.names = c(NA, 14L), class = "data.frame")

DATA2 = structure(list(ID = c(1301L, 1301L, 1301L, 1301L, 1301L, 1301L,
1301L, 1301L, 1301L, 1301L, 1301L, 1301L, 1301L, 1301L), DATE = c("1/27/2012 12:00:00 AM",
"1/27/2012 12:00:00 AM", "1/27/2012 12:00:00 AM", "1/27/2012 12:00:00 AM",
"1/27/2012 12:00:00 AM", "1/27/2012 12:00:00 AM", "1/27/2012 12:00:00 AM",
"3-2-12 0:00", "3-2-12 0:00", "3-2-12 0:00", "3-2-12 0:00", "3-2-12 0:00",
"3-2-12 0:00", "3-2-12 0:00"), CTIME = c("7:55", "8:40", "9:10",
"10:10", "12:15", "16:20", "20:10", "7:55", "8:30", "9:00", "10:00",
"12:00", "16:00", "20:00"), VISIT = c(2, 2, 2, 2, 2, 2, 2, 3,
3, 3, 3, 3, 3, 3)), .Names = c("ID", "DATE", "CTIME", "VISIT"
), row.names = c("1", "2", "3", "4", "5", "6", "7", "1100", "2100",
"310", "410", "510", "610", "710"), class = "data.frame")

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：datasets dataset RECORDS having Record

X3=cbind(DATA1,DATA2[2:3])
X2=cbind(DATA1,DATA2)
#pls select your answer if you want