hi guys..thx for help
i have to perform a calculation
P-B/T-B
where P is the values in pdf and B is the values in bdf and T in tdf


On Thu, Sep 23, 2010 at 7:49 PM, Mike Rennie <mikerennie.r@gmail.com> wrote:

> First, you might want to start by generating a new column to identify your
> 'pdf" and "bdf" or whatever once it's merged.
>
> For the merging, see
>
> ?merge
>
> But as someone's already pointed out, it's not clear what you are trying to
> merge by.
>
> Also, as your example calculations show, you don't need to merge it to to
> the calcuations you want to do...
>
> On Thu, Sep 23, 2010 at 8:53 AM, Steve Lianoglou <
> mailinglist.honeypot@gmail.com> wrote:
>
>> Hi,
>>
>> On Thu, Sep 23, 2010 at 9:04 AM, rasanpreet <rasanpreet.kaur@gmail.com>
>> wrote:
>> >
>> > hi guys
>> > i have multiple data frames which i want to  merge.
>> > there are four of them..eg
>>
>> Can you provide a (correct) example of what you want your merged
>> data.frame to look like?
>> What column do you want to use in your data.frame to merge against?
>> I'm guessing SampleID(?), but then again, these aren't unique in your
>> `pdf` data.frame. For instance, what would the row for "SDM001" look
>> like in your merged data.frame?
>>
>> -steve
>>
>> > 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.
>> >
>> > ______________________________________________
>> > 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<http://www.r-project.org/posting-guide.html>
>> > and provide commented, minimal, self-contained, reproducible code.
>> >
>>
>>
>>
>> --
>> Steve Lianoglou
>> Graduate Student: Computational Systems Biology
>>  | Memorial Sloan-Kettering Cancer Center
>>  | Weill Medical College of Cornell University
>> Contact Info: http://cbio.mskcc.org/~lianos/contact
>>
>> ______________________________________________
>> 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<http://www.r-project.org/posting-guide.html>
>> and provide commented, minimal, self-contained, reproducible code.
>>
>
>


-- 
Rasanpreet Kaur

	[[alternative HTML version deleted]]

