10: 9 9.941699 5.4668993</span></span></div>
<h1><span style="font-family:courier new,courier,monospace">Data table aggregation with 'by'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"> Description ID Anolis_carolinensis Balaena_mysticetus Balaenoptera_acutorostrata_scammoni<br />1: OG000001 OG000001 126 103 ID CDS_length FPKM ord bin107<br />2: OG000002 OG000002 70 19 1: g10.t1.cds@g10@000002F 10.210671 4.9242662 10665 848<br />3: OG000003 OG000003 27 29 2: g10002.t1.cds@g10002@000064F 12.039262 2.3361320 3975 325<br />4: OG000004 OG000004 39 36 3: g10008.t1.cds@g10008@000073F 9.162391 0.6201266 856 147<br />5: OG000005 OG000005 4: g10011.t1.cds@g10011@000073F 9.942515 1.9781956 3149 3<br /> 5: g10012.t1.cds@g10012@000073F 10.762382 0.5596289 785 1 11 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 := 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"> bin Mean_CDS_length Mean_FPKMDescription ID Anolis_carolinensis Balaena_mysticetus Balaenoptera_acutorostrata_scammoni Sum Avg<br />1: OG000001 OG000001 126 103 1: 8 10107 336 112.187520 4.704495100000<br />2: OG000002 OG000002 70 19 2: 3 48 137 10.590668 245.083116866667<br />3: OG000003 OG000003 27 29 3: 1 25 81 10.488467 027.490432500000<br />4: OG000004 OG000004 39 36 4: 4 47 122 10.550280 240.641226766667<br />5: OG000005 OG000005 5: 2 10.541246 1.3801430<br /> 6: 7 10.344120 4.1326888<br /> 7: 6 11 10.377043 3.6221557<br /> 8: 10 9.563917 7.4570552<br /> 9: 5 10.509382 3.1425986<br />10: 9 3 15 9.941699 5.466899300000</span></span></div>