[R] merging multiple data frames
rasanpreet
rasanpreet.kaur at gmail.com
Thu Sep 23 15:04:39 CEST 2010
hi guys
i have multiple data frames which i want to merge.
there are four of them..eg
pdf
SampleID UVDose_J RepairHours Day_0 Day_45 Day_90
1 SDM001 1.0 3 485.612 465.142 490.873
2 SDM001 1.0 3 503.658 457.863 487.783
3 SDM001 1.0 2 533.193 451.044 456.973
4 SDM001 1.0 2 538.334 452.887 474.915
5 SDM001 1.0 1 526.034 481.123 477.801
6 SDM001 1.0 1 546.543 472.322 481.546
7 SDM001 1.0 0 NA NA NA
8 SDM001 1.0 0 NA NA NA
9 SDM001 0.5 3 432.134 457.245 497.975
10 SDM001 0.5 3 432.605 450.184 489.468
11 SDM001 0.5 2 450.335 496.520 488.784
12 SDM001 0.5 2 439.590 474.371 470.182
13 SDM001 0.5 1 510.480 489.561 525.029
14 SDM001 0.5 1 487.934 467.258 488.784
15 SDM001 0.5 0 NA NA NA
16 SDM001 0.5 0 NA NA NA
20 SDM002 1.0 3 465.549 528.715 501.374
21 SDM002 1.0 3 458.168 505.480 489.244
22 SDM002 1.0 2 447.317 464.009 478.058
23 SDM002 1.0 2 452.020 438.446 470.996
24 SDM002 1.0 1 441.718 458.760 499.221
25 SDM002 1.0 1 447.017 402.616 548.797
26 SDM002 1.0 0 NA NA NA
27 SDM002 1.0 0 NA NA NA
28 SDM002 0.5 3 421.409 448.870 476.392
29 SDM002 0.5 3 404.089 446.413 477.080
30 SDM002 0.5 2 399.775 432.678 465.015
31 SDM002 0.5 2 427.157 443.418 477.048
32 SDM002 0.5 1 389.674 449.353 482.264
33 SDM002 0.5 1 418.147 455.983 495.486
34 SDM002 0.5 0 NA NA NA
35 SDM002 0.5 0 NA NA NA
39 SDM005 1.0 3 579.836 441.040 476.382
40 SDM005 1.0 3 578.525 443.875 472.867
41 SDM005 1.0 2 564.266 432.116 469.416
42 SDM005 1.0 2 571.045 447.658 458.233
43 SDM005 1.0 1 564.664 427.673 524.122
44 SDM005 1.0 1 568.182 458.039 477.237
45 SDM005 1.0 0 NA NA NA
46 SDM005 1.0 0 NA NA NA
47 SDM005 0.5 3 556.534 424.786 501.658
48 SDM005 0.5 3 474.027 441.418 507.635
49 SDM005 0.5 2 481.355 430.346 468.021
50 SDM005 0.5 2 478.922 466.933 471.025
51 SDM005 0.5 1 505.539 937.759 460.985
52 SDM005 0.5 1 497.913 457.932 493.152
53 SDM005 0.5 0 NA NA NA
54 SDM005 0.5 0 NA NA NA
58 SDM006 1.0 3 589.164 459.578 509.565
59 SDM006 1.0 3 608.477 480.233 519.785
60 SDM006 1.0 2 598.354 449.266 487.058
61 SDM006 1.0 2 617.823 456.908 507.467
62 SDM006 1.0 1 566.477 500.189 526.744
63 SDM006 1.0 1 622.170 462.463 550.675
64 SDM006 1.0 0 NA NA NA
65 SDM006 1.0 0 NA NA NA
66 SDM006 0.5 3 546.472 457.880 468.129
67 SDM006 0.5 3 525.069 444.575 505.154
68 SDM006 0.5 2 569.068 446.196 473.739
69 SDM006 0.5 2 534.205 470.366 476.570
bdf
SampleID UVDose_J RepairHours Day_0 Day_45 Day_90
17 SDM001 0.5 B 88.6145 388.3575 198.467
36 SDM002 0.5 B 100.0760 384.9505 234.740
55 SDM005 0.5 B 121.9595 300.3650 241.832
74 SDM006 0.5 B 174.7005 378.3435 291.272
93 SDM007 0.5 B 319.7750 335.4390 110.306
112 SDM008 0.5 B 292.8400 323.0370 172.615
131 SDM010 0.5 B 112.0225 281.0390 562.459
150 SDM011 0.5 B 125.0440 331.4650 230.026
169 SDM012 0.5 B 229.1310 264.5580 234.231
188 SDM013 0.5 B 212.9690 524.0240 420.211
207 SDM014 0.5 B 366.3350 225.0610 203.588
226 SDM016 0.5 B 305.6080 381.5770 155.052
245 SDM017 0.5 B 223.6260 281.7830 182.374
264 SDM018 0.5 B 200.7720 401.6350 193.573
283 SDM019 0.5 B 164.2360 156.9960 175.896
302 SDM023 0.5 B 198.8900 210.0600 215.629
321 SDM024 0.5 B 351.8460 100.0980 185.388
340 SDM026 0.5 B 190.4560 132.8970 160.213
359 SDM028 0.5 B 252.9760 158.2910 120.425
378 SDM029 0.5 B 411.0690 134.1060 138.528
tdf
SampleID UVDose_J RepairHours Day_0 Day_45 Day_90
19 SDM001 0.5 T 642.3255 579.6635 537.581
38 SDM002 0.5 T 531.2000 581.0030 557.537
57 SDM005 0.5 T 619.5420 539.9010 548.100
76 SDM006 0.5 T 707.0940 563.1125 575.318
95 SDM007 0.5 T 679.3480 794.3410 332.972
114 SDM008 0.5 T 535.6860 759.0300 452.312
133 SDM010 0.5 T 756.8055 549.2960 916.447
152 SDM011 0.5 T 530.1690 557.1600 564.988
171 SDM012 0.5 T 570.6130 586.7140 643.590
190 SDM013 0.5 T 801.2055 711.1110 846.603
209 SDM014 0.5 T 681.6570 579.3980 464.721
228 SDM016 0.5 T 646.3070 796.6570 461.541
247 SDM017 0.5 T 598.1090 600.5710 380.724
266 SDM018 0.5 T 478.8850 763.9780 487.901
285 SDM019 0.5 T 551.8080 393.5920 427.805
304 SDM023 0.5 T 540.6330 432.2220 521.390
323 SDM024 0.5 T 907.8530 423.7630 606.219
342 SDM026 0.5 T 491.7560 351.3230 397.250
361 SDM028 0.5 T 856.5920 433.1750 521.138
380 SDM029 0.5 T 1016.0070 402.5070 530.783
udf
SampleID UVDose_J RepairHours Day_0 Day_45 Day_90
18 SDM001 0.5 U 550.8855 526.7340 529.872
37 SDM002 0.5 U 412.3365 509.4620 550.017
56 SDM005 0.5 U 480.2640 483.4895 542.689
75 SDM006 0.5 U 540.4710 511.0770 560.678
94 SDM007 0.5 U 570.0560 681.3420 319.796
113 SDM008 0.5 U 519.8770 645.7330 388.029
132 SDM010 0.5 U 585.8030 500.4690 807.349
151 SDM011 0.5 U 478.6695 551.5200 558.238
170 SDM012 0.5 U 511.4090 559.7340 616.184
189 SDM013 0.5 U 600.0280 640.7730 742.612
208 SDM014 0.5 U 678.5090 533.0730 437.730
227 SDM016 0.5 U 590.0480 753.8820 439.535
246 SDM017 0.5 U 541.5020 596.2840 358.916
265 SDM018 0.5 U 472.7440 633.3910 475.366
284 SDM019 0.5 U 463.6920 371.9310 395.282
303 SDM023 0.5 U 475.2470 429.0660 447.901
322 SDM024 0.5 U 829.9080 409.1480 542.602
341 SDM026 0.5 U 451.6500 347.2890 352.653
360 SDM028 0.5 U 697.7690 384.7120 520.445
379 SDM029 0.5 U 943.3400 351.4490 527.495
now i want to merge all these data frames and perform calculation like
(pdf$Day_0-bdf$Day_0)/(tdf$Day_0-bdf$Day_0)
(udf$Day_0-bdf$Day_0)/(tdf$Day_0-bdf$Day_0)
please note the Repair hours and UV dose is different
please help....really urgent
--
View this message in context: http://r.789695.n4.nabble.com/merging-multiple-data-frames-tp2551995p2551995.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help
mailing list