4: g10000.t1.cds@g10000@000064F 1074 0.278465<br />
5: g10001.t1.cds@g10001@000064F 522 0.962268 </span></span></div>
<h1><span style="font-family:courier new,courier,monospace">Fast melt for Data table</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-size:11px"><span style="font-family:courier new,courier,monospace"> Position G4-SV40 G4-SV40-OHT<br />
1: 101488764 52 51<br />
2: 101488765 52 50<br />
3: 101488766 52 49<br />
4: 101488767 53 49<br />
5: 101488768 54 49</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;"><big><span style="font-family:courier new,courier,monospace">melt(SeqDepth_dt, id.vars = "Position")</span></big></div>
<h3 style="color:#aaa; font-style:italic"><span style="font-family:courier new,courier,monospace">Output (head)</span></h3>
<div style="background:#eee;border:1px solid #ccc;padding:5px 10px;"><span style="font-size:11px"><span style="font-family:courier new,courier,monospace"> Position variable value<br />
1: 101488764 G4-SV40 52<br />
2: 101488765 G4-SV40 52<br />
3: 101488766 G4-SV40 52<br />
4: 101488767 G4-SV40 53<br />
5: 101488768 G4-SV40 54</span></span></div>
<h1><span style="font-family:courier new,courier,monospace">Data table aggregation with 'by'</span></h1>
10: 9 9.941699 5.4668993</span></span></div>
<ph1><span style="font-family:courier new,courier,monospace">Data table 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 107<br />2: OG000002 OG000002 70 19 48<br />3: OG000003 OG000003 27 29 25<br />4: OG000004 OG000004 39 36 47<br />5: OG000005 OG000005 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(.SD, na.rm=T), .SDcols = 3: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(.SD, na.rm=T), .SDcols = 3: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"> Description ID Anolis_carolinensis Balaena_mysticetus Balaenoptera_acutorostrata_scammoni Sum Avg<br />1: OG000001 OG000001 126 103 107 336 112.00000<br />2: OG000002 OG000002 70 19 48 137 45.66667<br />3: OG000003 OG000003 27 29 25 81 27.00000<br />4: OG000004 OG000004 39 36 47 122 40.66667<br />5: OG000005 OG000005 1 11 3 15 5.00000</span></span></pdiv>