In [1]:
require 'daru/view'
Install the spreadsheet gem version ~>1.1.1 for using spreadsheet functions.

Install the mechanize gem version ~>2.7.5 for using mechanize functions.
Out[1]:
true
In [2]:
# used for creating table and charts
Daru::View.plotting_library = :googlecharts
Out[2]:
:googlecharts

Using Daru DataFrame

In [3]:
df = Daru::DataFrame.new({b: [11,12,13,14,15], a: [1,2,3,4,5],
      c: [11,22,33,44,55]},
      order: [:a, :b, :c],
      index: [:one, :two, :three, :four, :five])
Out[3]:
Daru::DataFrame(5x3)
a b c
one 1 11 11
two 2 12 22
three 3 13 33
four 4 14 44
five 5 15 55
In [4]:
t1 = Daru::View::Table.new(df)
Out[4]:
#<Daru::View::Table:0x000000017ac8c0 @data=#<Daru::DataFrame(5x3)>
           a     b     c
   one     1    11    11
   two     2    12    22
 three     3    13    33
  four     4    14    44
  five     5    15    55, @options={}, @adapter=Daru::View::Adapter::GooglechartsAdapter, @table=#<GoogleVisualr::DataTable:0x000000017ac848 @cols=[{:type=>"number", :label=>:a}, {:type=>"number", :label=>:b}, {:type=>"number", :label=>:c}], @rows=[[#<GoogleVisualr::DataTable::Cell:0x000000017822a0 @v=1, @type="number">, #<GoogleVisualr::DataTable::Cell:0x00000001782048 @v=11, @type="number">, #<GoogleVisualr::DataTable::Cell:0x00000001781f58 @v=11, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x00000001781af8 @v=2, @type="number">, #<GoogleVisualr::DataTable::Cell:0x000000017818f0 @v=12, @type="number">, #<GoogleVisualr::DataTable::Cell:0x000000017816e8 @v=22, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x000000017814b8 @v=3, @type="number">, #<GoogleVisualr::DataTable::Cell:0x000000017813f0 @v=13, @type="number">, #<GoogleVisualr::DataTable::Cell:0x00000001781328 @v=33, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x000000017810a8 @v=4, @type="number">, #<GoogleVisualr::DataTable::Cell:0x00000001780fb8 @v=14, @type="number">, #<GoogleVisualr::DataTable::Cell:0x00000001780ef0 @v=44, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x00000001780d38 @v=5, @type="number">, #<GoogleVisualr::DataTable::Cell:0x00000001780bd0 @v=15, @type="number">, #<GoogleVisualr::DataTable::Cell:0x00000001780b58 @v=55, @type="number">]], @options={}>>
In [5]:
t1.table.class
Out[5]:
GoogleVisualr::DataTable
In [6]:
t1.table.cols
Out[6]:
[{:type=>"number", :label=>:a}, {:type=>"number", :label=>:b}, {:type=>"number", :label=>:c}]
In [7]:
t1.class
Out[7]:
Daru::View::Table
In [8]:
t1.show_in_iruby
Out[8]:
In [9]:
t1.div
Out[9]:
"<div id='ed8cda0e-179f-4794-9ce1-212429c40c60'></div>\n<script>\n\n  google.load('visualization', 1.0, \n {packages: ['table'], callback:\n draw_ed8cda0e_179f_4794_9ce1_212429c40c60});\n  function draw_ed8cda0e_179f_4794_9ce1_212429c40c60() {\n    var data_table = new google.visualization.DataTable();data_table.addColumn({\"type\":\"number\",\"label\":\"a\"});data_table.addColumn({\"type\":\"number\",\"label\":\"b\"});data_table.addColumn({\"type\":\"number\",\"label\":\"c\"});data_table.addRow([{v: 1}, {v: 11}, {v: 11}]);data_table.addRow([{v: 2}, {v: 12}, {v: 22}]);data_table.addRow([{v: 3}, {v: 13}, {v: 33}]);data_table.addRow([{v: 4}, {v: 14}, {v: 44}]);data_table.addRow([{v: 5}, {v: 15}, {v: 55}]);\n    var table = new google.visualization.Table(\n    document.getElementById('ed8cda0e-179f-4794-9ce1-212429c40c60'));\n    table.draw(data_table, {}); \n  };\n</script>\n"
In [10]:
IRuby.html t1.div
Out[10]:
In [11]:
rows = [
  ['Mike',  {v: 10000, f: '$10,000'}, true],
  ['Jim',   {v:8000,   f: '$8,000'},  false],
  ['Alice', {v: 12500, f: '$12,500'}, true],
  ['Bob',   {v: 7000,  f: '$7,000'},  true]
]

df2 = Daru::DataFrame.rows(rows)
Out[11]:
Daru::DataFrame(4x3)
0 1 2
0 Mike {:v=>10000, :f=>"$10,000"} true
1 Jim {:v=>8000, :f=>"$8,000"} false
2 Alice {:v=>12500, :f=>"$12,500"} true
3 Bob {:v=>7000, :f=>"$7,000"} true
In [12]:
t2 = Daru::View::Table.new(df2)
Out[12]:
#<Daru::View::Table:0x0000000232f9e0 @data=#<Daru::DataFrame(4x3)>
                     0          1          2
          0       Mike {:v=>10000       true
          1        Jim {:v=>8000,      false
          2      Alice {:v=>12500       true
          3        Bob {:v=>7000,       true, @options={}, @adapter=Daru::View::Adapter::GooglechartsAdapter, @table=#<GoogleVisualr::DataTable:0x0000000232f940 @cols=[{:type=>"string", :label=>"0"}, {:type=>"number", :label=>"1"}, {:type=>"boolean", :label=>"2"}], @rows=[[#<GoogleVisualr::DataTable::Cell:0x000000023221a0 @v="Mike", @type="string">, #<GoogleVisualr::DataTable::Cell:0x00000002322128 @v=10000, @type="number", @f="$10,000", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00000002322088 @v=true, @type="boolean">], [#<GoogleVisualr::DataTable::Cell:0x00000002321f48 @v="Jim", @type="string">, #<GoogleVisualr::DataTable::Cell:0x00000002321ea8 @v=8000, @type="number", @f="$8,000", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00000002321d40 @v=false, @type="boolean">], [#<GoogleVisualr::DataTable::Cell:0x00000002321c28 @v="Alice", @type="string">, #<GoogleVisualr::DataTable::Cell:0x00000002321b88 @v=12500, @type="number", @f="$12,500", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x000000023219d0 @v=true, @type="boolean">], [#<GoogleVisualr::DataTable::Cell:0x00000002321908 @v="Bob", @type="string">, #<GoogleVisualr::DataTable::Cell:0x00000002321890 @v=7000, @type="number", @f="$7,000", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00000002321728 @v=true, @type="boolean">]], @options={}>>
In [13]:
t2.show_in_iruby
Out[13]:
In [14]:
# adding pagination
opts_pagination = {
  showRowNumber: true, width: '100%', height: '100%' ,
  page: 'enable',
  pageSize: 2,
  pagingSymbols: {
    prev: 'prev',
    next: 'next'
  },
  pagingButtonsConfiguration: 'auto'}
Out[14]:
{:showRowNumber=>true, :width=>"100%", :height=>"100%", :page=>"enable", :pageSize=>2, :pagingSymbols=>{:prev=>"prev", :next=>"next"}, :pagingButtonsConfiguration=>"auto"}
In [15]:
t3 = Daru::View::Table.new(df2,opts_pagination)
Out[15]:
#<Daru::View::Table:0x0000000222aba8 @data=#<Daru::DataFrame(4x3)>
                     0          1          2
          0       Mike {:v=>10000       true
          1        Jim {:v=>8000,      false
          2      Alice {:v=>12500       true
          3        Bob {:v=>7000,       true, @options={:showRowNumber=>true, :width=>"100%", :height=>"100%", :page=>"enable", :pageSize=>2, :pagingSymbols=>{:prev=>"prev", :next=>"next"}, :pagingButtonsConfiguration=>"auto"}, @adapter=Daru::View::Adapter::GooglechartsAdapter, @table=#<GoogleVisualr::DataTable:0x0000000222ab80 @cols=[{:type=>"string", :label=>"0"}, {:type=>"number", :label=>"1"}, {:type=>"boolean", :label=>"2"}], @rows=[[#<GoogleVisualr::DataTable::Cell:0x00000002226288 @v="Mike", @type="string">, #<GoogleVisualr::DataTable::Cell:0x00000002226210 @v=10000, @type="number", @f="$10,000", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00000002226170 @v=true, @type="boolean">], [#<GoogleVisualr::DataTable::Cell:0x000000022260a8 @v="Jim", @type="string">, #<GoogleVisualr::DataTable::Cell:0x00000002226030 @v=8000, @type="number", @f="$8,000", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00000002225f90 @v=false, @type="boolean">], [#<GoogleVisualr::DataTable::Cell:0x00000002225ec8 @v="Alice", @type="string">, #<GoogleVisualr::DataTable::Cell:0x00000002225e50 @v=12500, @type="number", @f="$12,500", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00000002225db0 @v=true, @type="boolean">], [#<GoogleVisualr::DataTable::Cell:0x00000002225cc0 @v="Bob", @type="string">, #<GoogleVisualr::DataTable::Cell:0x00000002225c20 @v=7000, @type="number", @f="$7,000", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00000002225b58 @v=true, @type="boolean">]], @options={:showRowNumber=>true, :width=>"100%", :height=>"100%", :page=>"enable", :pageSize=>2, :pagingSymbols=>{:prev=>"prev", :next=>"next"}, :pagingButtonsConfiguration=>"auto"}>>
In [16]:
t3.show_in_iruby
Out[16]:
In [17]:
t3.class
Out[17]:
Daru::View::Table
In [18]:
t4 = Daru::View::Table.new([],opts_pagination)
Out[18]:
#<Daru::View::Table:0x0000000214d820 @data=[], @options={:showRowNumber=>true, :width=>"100%", :height=>"100%", :page=>"enable", :pageSize=>2, :pagingSymbols=>{:prev=>"prev", :next=>"next"}, :pagingButtonsConfiguration=>"auto"}, @adapter=Daru::View::Adapter::GooglechartsAdapter, @table=#<GoogleVisualr::DataTable:0x0000000214d7f8 @cols=[], @rows=[], @options={:showRowNumber=>true, :width=>"100%", :height=>"100%", :page=>"enable", :pageSize=>2, :pagingSymbols=>{:prev=>"prev", :next=>"next"}, :pagingButtonsConfiguration=>"auto"}>>
In [19]:
# users are free to use the Google charts features, by accessing the google chart table using `#table`
# Add Column Headers
t4.table.new_column('string', 'Year' )
t4.table.new_column('number', 'Sales')
t4.table.new_column('number', 'Expenses')
t4.table.new_column('number', 'Expenses2')

    # Add Rows and Values
t4.table.add_rows([
      ['2004', 1000, 400, 1111],
      ['2005', 1170, 460, 2111],
      ['2006', 660, 1120, 3111],
      ['2007', 1030, 540, 1112]
    ])
Out[19]:
[["2004", 1000, 400, 1111], ["2005", 1170, 460, 2111], ["2006", 660, 1120, 3111], ["2007", 1030, 540, 1112]]
In [20]:
t4.show_in_iruby
Out[20]:
In [21]:
opts = {
  cols: [
    {id: 'A', label: 'NEW A', type: 'string'},
    {id: 'B', label: 'B-label', type: 'number'},
    {id: 'C', label: 'C-label', type: 'date'}  
  ],
  rows: [
    {c:[
      {v: 'a'},
      {v: 1.0, f: 'One'},
      {:v => Date.parse('2008-1-28 00:31:26'), f: '2/28/08 12:31 AM'}
    ]},
    {c:[
      {v: 'b'},
      {v: 2.0, f: 'Two'},
      {:v =>Date.parse('2008-2-12 00:31:27'), f: '3/30/08 12:31 AM'}
    ]},
    {c:[
      {v: 'c'},
      {v: 3.0, f: 'Three'},
      {v: Date.parse('2008-3-30 00:31:26'), f: '4/30/08 12:31 AM'}
    ]}
  ]
}
Out[21]:
{:cols=>[{:id=>"A", :label=>"NEW A", :type=>"string"}, {:id=>"B", :label=>"B-label", :type=>"number"}, {:id=>"C", :label=>"C-label", :type=>"date"}], :rows=>[{:c=>[{:v=>"a"}, {:v=>1.0, :f=>"One"}, {:v=>#<Date: 2008-01-28 ((2454494j,0s,0n),+0s,2299161j)>, :f=>"2/28/08 12:31 AM"}]}, {:c=>[{:v=>"b"}, {:v=>2.0, :f=>"Two"}, {:v=>#<Date: 2008-02-12 ((2454509j,0s,0n),+0s,2299161j)>, :f=>"3/30/08 12:31 AM"}]}, {:c=>[{:v=>"c"}, {:v=>3.0, :f=>"Three"}, {:v=>#<Date: 2008-03-30 ((2454556j,0s,0n),+0s,2299161j)>, :f=>"4/30/08 12:31 AM"}]}]}
In [22]:
t_ops = Daru::View::Table.new([],opts)
Out[22]:
#<Daru::View::Table:0x000000016f0468 @data=[], @options={:cols=>[{:id=>"A", :label=>"NEW A", :type=>"string"}, {:id=>"B", :label=>"B-label", :type=>"number"}, {:id=>"C", :label=>"C-label", :type=>"date"}], :rows=>[{:c=>[{:v=>"a"}, {:v=>1.0, :f=>"One"}, {:v=>#<Date: 2008-01-28 ((2454494j,0s,0n),+0s,2299161j)>, :f=>"2/28/08 12:31 AM"}]}, {:c=>[{:v=>"b"}, {:v=>2.0, :f=>"Two"}, {:v=>#<Date: 2008-02-12 ((2454509j,0s,0n),+0s,2299161j)>, :f=>"3/30/08 12:31 AM"}]}, {:c=>[{:v=>"c"}, {:v=>3.0, :f=>"Three"}, {:v=>#<Date: 2008-03-30 ((2454556j,0s,0n),+0s,2299161j)>, :f=>"4/30/08 12:31 AM"}]}]}, @adapter=Daru::View::Adapter::GooglechartsAdapter, @table=#<GoogleVisualr::DataTable:0x000000016f0440 @cols=[{:type=>"string", :label=>"NEW A", :id=>"A"}, {:type=>"number", :label=>"B-label", :id=>"B"}, {:type=>"date", :label=>"C-label", :id=>"C"}], @rows=[[#<GoogleVisualr::DataTable::Cell:0x000000016eb9b8 @v="a", @type="string", @f=nil, @p=nil>, #<GoogleVisualr::DataTable::Cell:0x000000016eb800 @v=1.0, @type="number", @f="One", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x000000016eb558 @v=#<Date: 2008-01-28 ((2454494j,0s,0n),+0s,2299161j)>, @type="date", @f="2/28/08 12:31 AM", @p=nil>], [#<GoogleVisualr::DataTable::Cell:0x000000016eb288 @v="b", @type="string", @f=nil, @p=nil>, #<GoogleVisualr::DataTable::Cell:0x000000016eae78 @v=2.0, @type="number", @f="Two", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x000000016eabd0 @v=#<Date: 2008-02-12 ((2454509j,0s,0n),+0s,2299161j)>, @type="date", @f="3/30/08 12:31 AM", @p=nil>], [#<GoogleVisualr::DataTable::Cell:0x000000016ea6a8 @v="c", @type="string", @f=nil, @p=nil>, #<GoogleVisualr::DataTable::Cell:0x000000016ea608 @v=3.0, @type="number", @f="Three", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x000000016ea220 @v=#<Date: 2008-03-30 ((2454556j,0s,0n),+0s,2299161j)>, @type="date", @f="4/30/08 12:31 AM", @p=nil>]], @options={:cols=>[{:id=>"A", :label=>"NEW A", :type=>"string"}, {:id=>"B", :label=>"B-label", :type=>"number"}, {:id=>"C", :label=>"C-label", :type=>"date"}], :rows=>[{:c=>[{:v=>"a"}, {:v=>1.0, :f=>"One"}, {:v=>#<Date: 2008-01-28 ((2454494j,0s,0n),+0s,2299161j)>, :f=>"2/28/08 12:31 AM"}]}, {:c=>[{:v=>"b"}, {:v=>2.0, :f=>"Two"}, {:v=>#<Date: 2008-02-12 ((2454509j,0s,0n),+0s,2299161j)>, :f=>"3/30/08 12:31 AM"}]}, {:c=>[{:v=>"c"}, {:v=>3.0, :f=>"Three"}, {:v=>#<Date: 2008-03-30 ((2454556j,0s,0n),+0s,2299161j)>, :f=>"4/30/08 12:31 AM"}]}]}>>
In [23]:
t_ops.show_in_iruby # or t_ops.table
Out[23]:
In [24]:
t_update = Daru::View::Table.new
Out[24]:
#<Daru::View::Table:0x0000000113c3c8 @data=[], @options={}, @adapter=Daru::View::Adapter::GooglechartsAdapter, @table=#<GoogleVisualr::DataTable:0x0000000113c288 @cols=[], @rows=[], @options={}>>
In [25]:
t_update.table.new_column(type= 'string', 'Employee Name');
t_update.table.new_column(type= 'date', 'Start Date');
Out[25]:
[{:type=>"string", :label=>"Employee Name"}, {:type=>"date", :label=>"Start Date"}]
In [26]:
t_update.table
Out[26]:
In [27]:
t_update.table.add_rows(6)
Out[27]:
6
In [28]:
t_update.table.set_cell(0, 0, 'Mike');
Out[28]:
#<GoogleVisualr::DataTable::Cell:0x0000000243fb28 @v="Mike", @type="string">
In [29]:
t_update.table.set_cell(0, 1, Date.parse('2008-1-28'));
t_update.table.set_cell(1, 0, 'Bob');
t_update.table.set_cell(1, 1, Date.parse('2007-5-1'));
t_update.table.set_cell(2, 0, 'Alice');
t_update.table.set_cell(2, 1, Date.parse('2006-7-16'));
t_update.table.set_cell(3, 0, 'Frank');
t_update.table.set_cell(3, 1, Date.parse('2007-11-28'));
t_update.table.set_cell(4, 0, 'Floyd');
t_update.table.set_cell(4, 1, Date.parse('2005-3-13'));
t_update.table.set_cell(5, 0, 'Fritz');
t_update.table.set_cell(5, 1, Date.parse('2007-9-2'));
Out[29]:
#<GoogleVisualr::DataTable::Cell:0x000000023cce70 @v=#<Date: 2007-09-02 ((2454346j,0s,0n),+0s,2299161j)>, @type="date">
In [30]:
t_update.table
Out[30]:
In [31]:
t_update.table.get_column(0)
Out[31]:
["Mike", "Bob", "Alice", "Frank", "Floyd", "Fritz"]
In [32]:
t_update.table.get_row(0)
Out[32]:
["Mike", #<Date: 2008-01-28 ((2454494j,0s,0n),+0s,2299161j)>]
In [33]:
t_update.table.get_cell(3,0)
Out[33]:
"Frank"

Using Daru Vector

In [34]:
dv = Daru::Vector.new [43934, 52503, 57177, 69658, 97031, 119931, 137133, 154175]
t_vec = Daru::View::Table.new(dv)
Out[34]:
#<Daru::View::Table:0x00000002232768 @data=#<Daru::Vector(8)>
      0  43934
      1  52503
      2  57177
      3  69658
      4  97031
      5 119931
      6 137133
      7 154175, @options={}, @adapter=Daru::View::Adapter::GooglechartsAdapter, @table=#<GoogleVisualr::DataTable:0x00000002232718 @cols=[{:type=>"number", :label=>"Series"}], @rows=[[#<GoogleVisualr::DataTable::Cell:0x000000022321c8 @v=43934, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x000000022320d8 @v=52503, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x00000002231f20 @v=57177, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x00000002231c00 @v=69658, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x00000002231980 @v=97031, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x000000022317c8 @v=119931, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x00000002231660 @v=137133, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x00000002231368 @v=154175, @type="number">]], @options={}>>
In [35]:
t_vec.table
Out[35]:
In [36]:
t_vec.table.options
Out[36]:
{}
In [37]:
# set new options in the table. This feature is not present in the basic google_visualr
t_vec.table.options = opts_pagination
Out[37]:
{:showRowNumber=>true, :width=>"100%", :height=>"100%", :page=>"enable", :pageSize=>2, :pagingSymbols=>{:prev=>"prev", :next=>"next"}, :pagingButtonsConfiguration=>"auto"}
In [38]:
t_vec.table
Out[38]:
In [39]:
# css styling
cssClassNames = {
    'headerRow': 'italic-darkblue-font large-font bold-font',
    'tableRow': '',
    'oddTableRow': 'beige-background',
    'selectedTableRow': 'orange-background large-font',
    'hoverTableRow': '',
    'headerCell': 'gold-border',
    'tableCell': '',
    'rowNumberCell': 'underline-blue-font'
  };
opts_css = {'showRowNumber': true, pageSize: 5, 'allowHtml': true, 'cssClassNames': cssClassNames};
Out[39]:
{:showRowNumber=>true, :pageSize=>5, :allowHtml=>true, :cssClassNames=>{:headerRow=>"italic-darkblue-font large-font bold-font", :tableRow=>"", :oddTableRow=>"beige-background", :selectedTableRow=>"orange-background large-font", :hoverTableRow=>"", :headerCell=>"gold-border", :tableCell=>"", :rowNumberCell=>"underline-blue-font"}}
In [40]:
t_vec.table.options = opts_css
Out[40]:
{:showRowNumber=>true, :pageSize=>5, :allowHtml=>true, :cssClassNames=>{:headerRow=>"italic-darkblue-font large-font bold-font", :tableRow=>"", :oddTableRow=>"beige-background", :selectedTableRow=>"orange-background large-font", :hoverTableRow=>"", :headerCell=>"gold-border", :tableCell=>"", :rowNumberCell=>"underline-blue-font"}}
In [41]:
# FixMe: css is not working. May be there is other way to pass cssClassName
t_vec.table
Out[41]:

Using option Hash

In [42]:
data = {
  cols: [{id: 'Name', label: 'Name', type: 'string'},
          {id: 'Salary', label: 'Salary', type: 'number'},
          {type: 'boolean', label: 'Full Time Employee' },
        ],
  rows: [
    {c:[{v: 'Mike'}, {v: 10000, f: '$10,000'}, {v: true}]},
    {c:[{v: 'Jim'}, {v:8000,   f: '$8,000'}, {v: false}]},
    {c:[{v: 'Alice'}, {v: 12500, f: '$12,500'}, {v: true}]},
    {c:[{v: 'Bob'}, {v: 7000,  f: '$7,000'}, {v: true}]},
    ]
  }
table = Daru::View::Table.new(data, height: 300, width: 200)
table.show_in_iruby
Out[42]:

From Data Array (First row should be column vector for google data table)

In [43]:
data = [
  ['Galaxy', 'Distance', 'Brightness'],
          ['Canis Major Dwarf', 8000, 230.3],
          ['Sagittarius Dwarf', 24000, 4000.5],
          ['Ursa Major II Dwarf', 30000, 1412.3],
          ['Lg. Magellanic Cloud', 50000, 120.9],
          ['Bootes I', 60000, 1223.1]
  ]
table = Daru::View::Table.new(data)
table.show_in_iruby
Out[43]: