Difference between revisions of "Data.table"

From kogic.kr
(Created page with "<p>YalPak_Rtip</p> <h1>Convert a molten data table into an data table (array type)</h1> <h3>Input</h3> <p>                &nbs...")
 
Line 1: Line 1:
−
<p>[[YalPak_Rtip]]</p>
+
<p><span style="font-family:courier new,courier,monospace">[[YalPak_Rtip]]</span></p>
  
−
<h1>Convert a molten data table into an data table (array type)</h1>
+
<h1><span style="font-family:courier new,courier,monospace">Convert a molten data table into an data table (array type)</span></h1>
  
−
<h3>Input</h3>
+
<h3><span style="font-family:courier new,courier,monospace">Input</span></h3>
  
−
<p>&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Species &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ID &nbsp; &nbsp; &nbsp; Var1 Var2 &nbsp; &nbsp; &nbsp; &nbsp; Val &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Group &nbsp; &nbsp; &nbsp;Print_name<br />
+
<div style="background:#eee;border:1px solid #ccc;padding:5px 10px;"><span style="font-family:courier new,courier,monospace">&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Species &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ID &nbsp; &nbsp; &nbsp; Var1 Var2 &nbsp; &nbsp; &nbsp; &nbsp; Val &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Group &nbsp; &nbsp; &nbsp;Print_name<br />
 
&nbsp; &nbsp; 1: Dendronephthya_gigantea g30906.t1.cds@g30906@000029F CDS_length Full 2.01600e+03 Non-symbiotic_cnidarian Carnation_coral<br />
 
&nbsp; &nbsp; 1: Dendronephthya_gigantea g30906.t1.cds@g30906@000029F CDS_length Full 2.01600e+03 Non-symbiotic_cnidarian Carnation_coral<br />
 
&nbsp; &nbsp; 2: Dendronephthya_gigantea g14782.t1.cds@g14782@000108F CDS_length Full 4.02000e+02 Non-symbiotic_cnidarian Carnation_coral<br />
 
&nbsp; &nbsp; 2: Dendronephthya_gigantea g14782.t1.cds@g14782@000108F CDS_length Full 4.02000e+02 Non-symbiotic_cnidarian Carnation_coral<br />
 
&nbsp; &nbsp; 3: Dendronephthya_gigantea &nbsp; g9986.t1.cds@g9986@000064F CDS_length Full 8.40000e+02 Non-symbiotic_cnidarian Carnation_coral<br />
 
&nbsp; &nbsp; 3: Dendronephthya_gigantea &nbsp; g9986.t1.cds@g9986@000064F CDS_length Full 8.40000e+02 Non-symbiotic_cnidarian Carnation_coral<br />
 
&nbsp; &nbsp; 4: Dendronephthya_gigantea &nbsp; g1279.t1.cds@g1279@000024F CDS_length Full 8.58000e+02 Non-symbiotic_cnidarian Carnation_coral<br />
 
&nbsp; &nbsp; 4: Dendronephthya_gigantea &nbsp; g1279.t1.cds@g1279@000024F CDS_length Full 8.58000e+02 Non-symbiotic_cnidarian Carnation_coral<br />
−
&nbsp; &nbsp; 5: Dendronephthya_gigantea &nbsp; g9325.t1.cds@g9325@000042F CDS_length Full 8.61000e+02 Non-symbiotic_cnidarian Carnation_coral</p>
+
&nbsp; &nbsp; 5: Dendronephthya_gigantea &nbsp; g9325.t1.cds@g9325@000042F CDS_length Full 8.61000e+02 Non-symbiotic_cnidarian Carnation_coral</span></div>
  
−
<h3>Code</h3>
+
<h3><span style="font-family:courier new,courier,monospace">Code</span></h3>
  
−
<p><big>dcast(dt, ID ~ Var1, value.var = &quot;Val&quot;)</big></p>
+
<div style="background:#eee;border:1px solid #ccc;padding:5px 10px;"><span style="font-family:courier new,courier,monospace"><big>dcast(dt, ID ~ Var1, value.var = &quot;Val&quot;)</big></span></div>
  
−
<h3>Output</h3>
+
<h3><span style="font-family:courier new,courier,monospace">Output</span></h3>
  
−
<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ID CDS_length &nbsp; &nbsp; &nbsp;FPKM<br />
+
<div style="background:#eee;border:1px solid #ccc;padding:5px 10px;"><span style="font-family:courier new,courier,monospace">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ID CDS_length &nbsp; &nbsp; &nbsp;FPKM<br />
 
&nbsp; &nbsp; 1: &nbsp; &nbsp; &nbsp; g10.t1.cds@g10@000002F &nbsp; &nbsp; &nbsp; 1185 30.363500<br />
 
&nbsp; &nbsp; 1: &nbsp; &nbsp; &nbsp; g10.t1.cds@g10@000002F &nbsp; &nbsp; &nbsp; 1185 30.363500<br />
 
&nbsp; &nbsp; 2: &nbsp; &nbsp; g100.t1.cds@g100@000002F &nbsp; &nbsp; &nbsp; &nbsp;696 &nbsp;0.959006<br />
 
&nbsp; &nbsp; 2: &nbsp; &nbsp; g100.t1.cds@g100@000002F &nbsp; &nbsp; &nbsp; &nbsp;696 &nbsp;0.959006<br />
 
&nbsp; &nbsp; 3: &nbsp; g1000.t1.cds@g1000@000011F &nbsp; &nbsp; &nbsp; &nbsp;660 &nbsp;0.000000<br />
 
&nbsp; &nbsp; 3: &nbsp; g1000.t1.cds@g1000@000011F &nbsp; &nbsp; &nbsp; &nbsp;660 &nbsp;0.000000<br />
 
&nbsp; &nbsp; 4: g10000.t1.cds@g10000@000064F &nbsp; &nbsp; &nbsp; 1074 &nbsp;0.278465<br />
 
&nbsp; &nbsp; 4: g10000.t1.cds@g10000@000064F &nbsp; &nbsp; &nbsp; 1074 &nbsp;0.278465<br />
−
&nbsp; &nbsp; 5: g10001.t1.cds@g10001@000064F &nbsp; &nbsp; &nbsp; &nbsp;522 &nbsp;0.962268&nbsp; &nbsp;&nbsp;</p>
+
&nbsp; &nbsp; 5: g10001.t1.cds@g10001@000064F &nbsp; &nbsp; &nbsp; &nbsp;522 &nbsp;0.962268&nbsp; &nbsp;&nbsp;</span></div>

Revision as of 13:08, 27 November 2018

YalPak_Rtip

Convert a molten data table into an data table (array type)

Input

                       Species                           ID       Var1 Var2         Val                   Group      Print_name

    1: Dendronephthya_gigantea g30906.t1.cds@g30906@000029F CDS_length Full 2.01600e+03 Non-symbiotic_cnidarian Carnation_coral
    2: Dendronephthya_gigantea g14782.t1.cds@g14782@000108F CDS_length Full 4.02000e+02 Non-symbiotic_cnidarian Carnation_coral
    3: Dendronephthya_gigantea   g9986.t1.cds@g9986@000064F CDS_length Full 8.40000e+02 Non-symbiotic_cnidarian Carnation_coral
    4: Dendronephthya_gigantea   g1279.t1.cds@g1279@000024F CDS_length Full 8.58000e+02 Non-symbiotic_cnidarian Carnation_coral

    5: Dendronephthya_gigantea   g9325.t1.cds@g9325@000042F CDS_length Full 8.61000e+02 Non-symbiotic_cnidarian Carnation_coral

Code

dcast(dt, ID ~ Var1, value.var = "Val")

Output

                                 ID CDS_length      FPKM

    1:       g10.t1.cds@g10@000002F       1185 30.363500
    2:     g100.t1.cds@g100@000002F        696  0.959006
    3:   g1000.t1.cds@g1000@000011F        660  0.000000
    4: g10000.t1.cds@g10000@000064F       1074  0.278465

    5: g10001.t1.cds@g10001@000064F        522  0.962268    
Retrieved from "http://kogic.kr/index.php?title=Data.table&oldid=5211"