Hello all, thank you for your help. The task I need to perform is difficult
to explain so I apologize a head of time for any confusion.
I have a data frame with these colnames() Reference_Position,
Reference_Allele, Variant_Allele, Variant_Frequency, AAC_Variant. If a
value is duplicated in the "Reference_Position" column, I would both of
their "Variant_Frequency" values multiplied and inserted into a new data
frame.
example below: reference position 64 is repeated, multiple 94.155381 by
92.947658 and insert value into "Value".
Because I do not know how to best explain this or phrase it into a logical
questions, here is a before and after. Also, if you could explain the code a
bit, that would be appreciated as well- teach and person to fish!
Before
>dat
[Reference_Position] [Reference_Allele] [Variant_Allele] [Variant_Frequency]
[AAC_Variant]
16 G A 91.833811
Val6Met,Met
52 G A 93.969466
Val18Ile
64 G T 94.155381
Val22Phe
73 C A 94.293478
Gln25Lys
131 G A 94.268168
Arg44Lys
64 G A 92.947658
Ser48Asn
After
>dat
[Reference_Position] [Variant_Frequency] [Value]
16 91.833811
NA
52 93.969466
NA
64 94.155381
85.152215
73 94.293478 NA
131 94.268168 NA
64 92.947658
85.152215
--
View this message in context:
http://r.789695.n4.nabble.com/Performing-multiplication-on-duplicate-values-tp4647772.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.
