Changes

From kogic.kr

Data.table

2,006 bytes added, 12:39, 24 January 2019
no edit summary
10: &nbsp; 9 &nbsp; &nbsp; &nbsp; &nbsp;9.941699 5.4668993</span></span></div>
<h1><span style="font-family:courier new,courier,monospace">Data table aggregation with &#39;by&#39;row-wise calculation</span></h1>
<h3 style="color:#aaa; font-style:italic"><span style="font-family:courier new,courier,monospace">Input (head)</span></h3>
<div style="background:#eee;border:1px solid #ccc;padding:5px 10px;"><span style="font-family:courier new,courier,monospace"><span style="font-size:11px">&nbsp; &nbsp;Description &nbsp; &nbsp; &nbsp; ID Anolis_carolinensis Balaena_mysticetus Balaenoptera_acutorostrata_scammoni<br />1: &nbsp; &nbsp;OG000001 OG000001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 126 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;103 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ID CDS_length &nbsp; &nbsp; &nbsp;FPKM &nbsp; ord bin107<br />2: &nbsp; &nbsp;OG000002 OG000002 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;70 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 19 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1: &nbsp; &nbsp; &nbsp; g10.t1.cds@g10@000002F &nbsp;10.210671 4.9242662 10665 &nbsp; 848<br />3: &nbsp; &nbsp;OG000003 OG000003 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;27 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 29 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2: g10002.t1.cds@g10002@000064F &nbsp;12.039262 2.3361320 &nbsp;3975 &nbsp; 325<br />4: &nbsp; &nbsp;OG000004 OG000004 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;39 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 36 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3: g10008.t1.cds@g10008@000073F &nbsp; 9.162391 0.6201266 &nbsp; 856 &nbsp; 147<br />5: &nbsp; &nbsp;OG000005 OG000005 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4: g10011.t1.cds@g10011@000073F &nbsp; 9.942515 1.9781956 &nbsp;3149 &nbsp; 3<br />&nbsp; &nbsp; 5: g10012.t1.cds@g10012@000073F &nbsp;10.762382 0.5596289 &nbsp; 785 &nbsp; 1&nbsp; 11 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3</span></span></div>
<h3 style="color:#aaa; font-style:italic"><span style="font-family:courier new,courier,monospace">Code</span></h3>
<div style="background:#eee;border:1px solid #ccc;padding:5px 10px;"><span style="font-family:courier new,courier,monospace"><big>dt[, Sum := rowSums(.(Mean_CDS_length SD, na.rm= mean(CDS_lengthT), Mean_FPKM .SDcols = mean3:5]</big></span></div> <div style="background:#eee;border:1px solid #ccc;padding:5px 10px;"><span style="font-family:courier new,courier,monospace"><big>dt[,Mean&nbsp;:= rowMeans(FPKM).SD, na.rm=T), by.SDcols =bin3:5]</big></span></div>
<h3 style="color:#aaa; font-style:italic"><span style="font-family:courier new,courier,monospace">Output</span></h3>
<div style="background:#eee;border:1px solid #ccc;padding:5px 10px;"><span style="font-family:courier new,courier,monospace"><span style="font-size:11px">&nbsp; &nbsp; bin Mean_CDS_length Mean_FPKMDescription &nbsp; &nbsp; &nbsp; ID Anolis_carolinensis Balaena_mysticetus Balaenoptera_acutorostrata_scammoni Sum &nbsp; &nbsp; &nbsp; Avg<br />1: &nbsp; &nbsp;OG000001 OG000001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 126 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;103 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1: &nbsp; 8 &nbsp; &nbsp; &nbsp; 10107 336 112.187520 4.704495100000<br />2: &nbsp; &nbsp;OG000002 OG000002 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;70 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 19 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2: &nbsp; 3 &nbsp; &nbsp; 48 137 &nbsp; 10.590668 245.083116866667<br />3: &nbsp; &nbsp;OG000003 OG000003 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;27 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 29 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3: &nbsp; 1 &nbsp; 25 &nbsp; 81 &nbsp; 10.488467 027.490432500000<br />4: &nbsp; &nbsp;OG000004 OG000004 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;39 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 36 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4: &nbsp; 4 &nbsp; &nbsp; 47 122 &nbsp; 10.550280 240.641226766667<br />5: &nbsp; &nbsp;OG000005 OG000005 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5: &nbsp; 2 &nbsp; &nbsp; &nbsp; 10.541246 1.3801430<br />&nbsp;6: &nbsp; 7 &nbsp; &nbsp; &nbsp; 10.344120 4.1326888<br />&nbsp;7: &nbsp; 6 &nbsp; 11 &nbsp; &nbsp; &nbsp; 10.377043 3.6221557<br />&nbsp;8: &nbsp;10 &nbsp; &nbsp; &nbsp; &nbsp;9.563917 7.4570552<br />&nbsp;9: &nbsp; 5 &nbsp; &nbsp; &nbsp; 10.509382 3.1425986<br />10: &nbsp; 9 &nbsp; &nbsp; 3 &nbsp; 15 &nbsp;9.941699 5.466899300000</span></span></div>
1,007
edits

Navigation menu