DataFrame demo

In [1]:

    

require 'nyaplot'


    

    
Out[1]:











    
Out[1]:





true

In [2]:

    

df1 = Nyaplot::DataFrame.new({a:[1,2,3], b:[10,8,9]})


    

    
Out[2]:




a
b
1
10
2
8
3
9

In [3]:

    

path = File.expand_path("../data/first.tab", __FILE__)
df2 = Nyaplot::DataFrame.from_csv(path, ' ')


    

    
Out[3]:




mutation
blood
set1
set2
set3
set12
set21
set31
G>A
0.0
0.019230769230769232
0.0
0.48214285714285715
0.0
0.0
0.4782608695652174
C>T
0.0
0.42592592592592593
0.0
0.0
0.375
0.0
0.0
C>G
0.0
0.0
0.0
0.0
0.0
0.525
0.0
C>A
0.0
0.0
0.1935483870967742
0.0
0.0
0.4666666666666667
0.0
C>A
0.0
0.0
0.08333333333333333
0.0
0.0
0.5161290322580645
0.0
G>T
0.0
0.0
0.0
0.0
0.4444444444444444
0.0
0.0
C>G
0.0
0.0
0.0
0.0
0.0
0.0
0.4
C>A
0.0
0.0
0.03333333333333333
0.0
0.0
0.42857142857142855
0.0
A>C
0.0
0.6153846153846154
0.0
0.0
0.5925925925925926
0.0
0.0
C>A
0.0
0.0
0.0
0.0
0.0
0.32
0.0
C>A
0.0
0.0
0.0
0.0
0.0
0.4230769230769231
0.0
T>A
0.0
0.525
0.0
0.0
0.5277777777777778
0.0
0.0
C>T
0.0
0.42857142857142855
0.0
0.0
0.6666666666666666
0.0
0.0
G>A
0.0
0.0
0.0
0.0
0.0
0.5
0.03225806451612903
T>C
0.0
0.0
0.0
0.0
0.0
0.0
0.3793103448275862
C>T
0.0
0.0
0.0
0.45714285714285713
0.0
0.0
0.46875
...
...
...
...
...
...
...
...
A>T
0.0
0.4716981132075472
0.0
0.014492753623188406
0.3142857142857143
0.0
0.0

In [4]:

    

df2.row(0)


    

    
Out[4]:





{:mutation=>"G>A", :blood=>0.0, :set1=>0.019230769230769232, :set2=>0.0, :set3=>0.48214285714285715, :set12=>0.0, :set21=>0.0, :set31=>0.4782608695652174}

In [6]:

    

df2.filter {|row| row[:SET1]!=0.0}


    

    
Out[6]:




mutation
BLOOD
SET1
SET2
SET3
SET1.2
SET2.1
SET3.1
G>A
0.0
0.019230769230769232
0.0
0.48214285714285715
0.0
0.0
0.4782608695652174
C>T
0.0
0.42592592592592593
0.0
0.0
0.375
0.0
0.0
A>C
0.0
0.6153846153846154
0.0
0.0
0.5925925925925926
0.0
0.0
T>A
0.0
0.525
0.0
0.0
0.5277777777777778
0.0
0.0
C>T
0.0
0.42857142857142855
0.0
0.0
0.6666666666666666
0.0
0.0
G>A
0.0
0.45652173913043476
0.0
0.0
0.43478260869565216
0.0
0.0
C>T
0.0
0.09803921568627451
0.0
0.0
0.37142857142857144
0.0
0.0
T>A
0.0
0.5769230769230769
0.0
0.0
0.4782608695652174
0.0
0.0
A>G
0.0
0.43859649122807015
0.0
0.0
0.5142857142857142
0.0
0.0
T>C
0.0
0.5806451612903226
0.0
0.0
0.6341463414634146
0.0
0.0
G>A
0.0
0.014705882352941176
0.0
0.0
0.0
0.0
0.41935483870967744
G>A
0.0
0.6666666666666666
0.0
0.0
0.5
0.0
0.0
C>T
0.0
0.532258064516129
0.0
0.0
0.5227272727272727
0.0
0.0
G>A
0.0
0.5652173913043478
0.0
0.0
0.3870967741935484
0.0
0.0
G>A
0.0
0.42857142857142855
0.0
0.0
0.3333333333333333
0.0
0.0
C>A
0.0
0.4888888888888889
0.0
0.0
0.43243243243243246
0.0
0.0
...
...
...
...
...
...
...
...
A>T
0.0
0.4716981132075472
0.0
0.014492753623188406
0.3142857142857143
0.0
0.0

In [ ]: