require 'daru/view'
true
# used for creating table and charts
Daru::View.plotting_library = :googlecharts
:googlecharts
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])
| a | b | c | |
|---|---|---|---|
| one | 1 | 11 | 11 |
| two | 2 | 12 | 22 |
| three | 3 | 13 | 33 |
| four | 4 | 14 | 44 |
| five | 5 | 15 | 55 |
t1 = Daru::View::Table.new(df)
#<Daru::View::Table:0x00005570bc87f910 @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={}, @user_options={}, @adapter=Daru::View::Adapter::GooglechartsAdapter, @table=#<GoogleVisualr::DataTable:0x00005570bc87f7d0 @cols=[{:type=>"number", :label=>:a}, {:type=>"number", :label=>:b}, {:type=>"number", :label=>:c}], @rows=[[#<GoogleVisualr::DataTable::Cell:0x00005570bd50e640 @v=1, @type="number">, #<GoogleVisualr::DataTable::Cell:0x00005570bd50e5c8 @v=11, @type="number">, #<GoogleVisualr::DataTable::Cell:0x00005570bd50e550 @v=11, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x00005570bd50e460 @v=2, @type="number">, #<GoogleVisualr::DataTable::Cell:0x00005570bd50e3e8 @v=12, @type="number">, #<GoogleVisualr::DataTable::Cell:0x00005570bd50e370 @v=22, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x00005570bd50e280 @v=3, @type="number">, #<GoogleVisualr::DataTable::Cell:0x00005570bd50e208 @v=13, @type="number">, #<GoogleVisualr::DataTable::Cell:0x00005570bd50e190 @v=33, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x00005570bd50e0a0 @v=4, @type="number">, #<GoogleVisualr::DataTable::Cell:0x00005570bd50e028 @v=14, @type="number">, #<GoogleVisualr::DataTable::Cell:0x00005570bd50dfb0 @v=44, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x00005570bd50dec0 @v=5, @type="number">, #<GoogleVisualr::DataTable::Cell:0x00005570bd50de48 @v=15, @type="number">, #<GoogleVisualr::DataTable::Cell:0x00005570bd50ddd0 @v=55, @type="number">]], @listeners=[], @options={}, @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, @user_options={}>>
t1.table.class
GoogleVisualr::DataTable
t1.table.cols
[{:type=>"number", :label=>:a}, {:type=>"number", :label=>:b}, {:type=>"number", :label=>:c}]
t1.class
Daru::View::Table
t1.show_in_iruby
t1.div
"\n<div id='0f5f25f2-14be-4279-b286-14cf2665e7a1'></div>\n<script>\n\n google.load('visualization', 1.0, {packages: ['table'], callback: draw_0f5f25f2_14be_4279_b286_14cf2665e7a1});\n function draw_0f5f25f2_14be_4279_b286_14cf2665e7a1() {\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(document.getElementById('0f5f25f2-14be-4279-b286-14cf2665e7a1'));\n table.draw(data_table, {}); \n };\n</script>\n"
IRuby.html t1.div
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)
| 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 |
t2 = Daru::View::Table.new(df2)
#<Daru::View::Table:0x00005570bd6c9368 @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={}, @user_options={}, @adapter=Daru::View::Adapter::GooglechartsAdapter, @table=#<GoogleVisualr::DataTable:0x00005570bd6c92f0 @cols=[{:type=>"string", :label=>"0"}, {:type=>"number", :label=>"1"}, {:type=>"boolean", :label=>"2"}], @rows=[[#<GoogleVisualr::DataTable::Cell:0x00005570bd6dabb8 @v="Mike", @type="string">, #<GoogleVisualr::DataTable::Cell:0x00005570bd6dab40 @v=10000, @type="number", @f="$10,000", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00005570bd6daaa0 @v=true, @type="boolean">], [#<GoogleVisualr::DataTable::Cell:0x00005570bd6da9d8 @v="Jim", @type="string">, #<GoogleVisualr::DataTable::Cell:0x00005570bd6da960 @v=8000, @type="number", @f="$8,000", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00005570bd6da8c0 @v=false, @type="boolean">], [#<GoogleVisualr::DataTable::Cell:0x00005570bd6da7f8 @v="Alice", @type="string">, #<GoogleVisualr::DataTable::Cell:0x00005570bd6da780 @v=12500, @type="number", @f="$12,500", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00005570bd6da6e0 @v=true, @type="boolean">], [#<GoogleVisualr::DataTable::Cell:0x00005570bd6da618 @v="Bob", @type="string">, #<GoogleVisualr::DataTable::Cell:0x00005570bd6da5a0 @v=7000, @type="number", @f="$7,000", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00005570bd6da500 @v=true, @type="boolean">]], @listeners=[], @options={}, @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, @user_options={}>>
t2.show_in_iruby
# adding pagination
opts_pagination = {
showRowNumber: true, width: '100%', height: '100%' ,
page: 'enable',
pageSize: 2,
pagingSymbols: {
prev: 'prev',
next: 'next'
},
pagingButtonsConfiguration: 'auto'}
{:showRowNumber=>true, :width=>"100%", :height=>"100%", :page=>"enable", :pageSize=>2, :pagingSymbols=>{:prev=>"prev", :next=>"next"}, :pagingButtonsConfiguration=>"auto"}
t3 = Daru::View::Table.new(df2,opts_pagination)
#<Daru::View::Table:0x00005570bd7937a8 @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"}, @user_options={}, @adapter=Daru::View::Adapter::GooglechartsAdapter, @table=#<GoogleVisualr::DataTable:0x00005570bd793758 @cols=[{:type=>"string", :label=>"0"}, {:type=>"number", :label=>"1"}, {:type=>"boolean", :label=>"2"}], @rows=[[#<GoogleVisualr::DataTable::Cell:0x00005570bd790bc0 @v="Mike", @type="string">, #<GoogleVisualr::DataTable::Cell:0x00005570bd790b48 @v=10000, @type="number", @f="$10,000", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00005570bd790aa8 @v=true, @type="boolean">], [#<GoogleVisualr::DataTable::Cell:0x00005570bd7909e0 @v="Jim", @type="string">, #<GoogleVisualr::DataTable::Cell:0x00005570bd790968 @v=8000, @type="number", @f="$8,000", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00005570bd7908c8 @v=false, @type="boolean">], [#<GoogleVisualr::DataTable::Cell:0x00005570bd790800 @v="Alice", @type="string">, #<GoogleVisualr::DataTable::Cell:0x00005570bd790788 @v=12500, @type="number", @f="$12,500", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00005570bd7906e8 @v=true, @type="boolean">], [#<GoogleVisualr::DataTable::Cell:0x00005570bd790620 @v="Bob", @type="string">, #<GoogleVisualr::DataTable::Cell:0x00005570bd7905a8 @v=7000, @type="number", @f="$7,000", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00005570bd790508 @v=true, @type="boolean">]], @listeners=[], @options={:showRowNumber=>true, :width=>"100%", :height=>"100%", :page=>"enable", :pageSize=>2, :pagingSymbols=>{:prev=>"prev", :next=>"next"}, :pagingButtonsConfiguration=>"auto"}, @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, @user_options={}>>
t3.show_in_iruby
t3.class
Daru::View::Table
t4 = Daru::View::Table.new([],opts_pagination)
#<Daru::View::Table:0x00005570bd7da180 @data=[], @options={:showRowNumber=>true, :width=>"100%", :height=>"100%", :page=>"enable", :pageSize=>2, :pagingSymbols=>{:prev=>"prev", :next=>"next"}, :pagingButtonsConfiguration=>"auto"}, @user_options={}, @adapter=Daru::View::Adapter::GooglechartsAdapter, @table=#<GoogleVisualr::DataTable:0x00005570bd7da130 @cols=[], @rows=[], @listeners=[], @options={:showRowNumber=>true, :width=>"100%", :height=>"100%", :page=>"enable", :pageSize=>2, :pagingSymbols=>{:prev=>"prev", :next=>"next"}, :pagingButtonsConfiguration=>"auto"}, @data=[], @user_options={}>>
# 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]
])
[["2004", 1000, 400, 1111], ["2005", 1170, 460, 2111], ["2006", 660, 1120, 3111], ["2007", 1030, 540, 1112]]
t4.show_in_iruby
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'}
]}
]
}
{: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"}]}]}
t_ops = Daru::View::Table.new([],opts)
#<Daru::View::Table:0x00005570bd6ca498 @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"}]}]}, @user_options={}, @adapter=Daru::View::Adapter::GooglechartsAdapter, @table=#<GoogleVisualr::DataTable:0x00005570bd6ca448 @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:0x00005570bd6ca218 @v="a", @type="string", @f=nil, @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00005570bd6ca1a0 @v=1.0, @type="number", @f="One", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00005570bd6ca088 @v=#<Date: 2008-01-28 ((2454494j,0s,0n),+0s,2299161j)>, @type="date", @f="2/28/08 12:31 AM", @p=nil>], [#<GoogleVisualr::DataTable::Cell:0x00005570bd6c9fc0 @v="b", @type="string", @f=nil, @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00005570bd6c9f48 @v=2.0, @type="number", @f="Two", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00005570bd6c9e30 @v=#<Date: 2008-02-12 ((2454509j,0s,0n),+0s,2299161j)>, @type="date", @f="3/30/08 12:31 AM", @p=nil>], [#<GoogleVisualr::DataTable::Cell:0x00005570bd6c9d68 @v="c", @type="string", @f=nil, @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00005570bd6c9cf0 @v=3.0, @type="number", @f="Three", @p=nil>, #<GoogleVisualr::DataTable::Cell:0x00005570bd6c9bd8 @v=#<Date: 2008-03-30 ((2454556j,0s,0n),+0s,2299161j)>, @type="date", @f="4/30/08 12:31 AM", @p=nil>]], @listeners=[], @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"}]}]}, @data=[], @user_options={}>>
t_ops.show_in_iruby # or t_ops.table
t_update = Daru::View::Table.new
#<Daru::View::Table:0x00005570bd62fdf8 @data=[], @options={}, @user_options={}, @adapter=Daru::View::Adapter::GooglechartsAdapter, @table=#<GoogleVisualr::DataTable:0x00005570bd62fd58 @cols=[], @rows=[], @listeners=[], @options={}, @data=[], @user_options={}>>
t_update.table.new_column(type= 'string', 'Employee Name');
t_update.table.new_column(type= 'date', 'Start Date');
[{:type=>"string", :label=>"Employee Name"}, {:type=>"date", :label=>"Start Date"}]
t_update.table
t_update.table.add_rows(6)
6
t_update.table.set_cell(0, 0, 'Mike');
#<GoogleVisualr::DataTable::Cell:0x00005570bd51c290 @v="Mike", @type="string">
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'));
#<GoogleVisualr::DataTable::Cell:0x00005570bd4e0268 @v=#<Date: 2007-09-02 ((2454346j,0s,0n),+0s,2299161j)>, @type="date">
t_update.table
t_update.table.get_column(0)
["Mike", "Bob", "Alice", "Frank", "Floyd", "Fritz"]
t_update.table.get_row(0)
["Mike", #<Date: 2008-01-28 ((2454494j,0s,0n),+0s,2299161j)>]
t_update.table.get_cell(3,0)
"Frank"
dv = Daru::Vector.new [43934, 52503, 57177, 69658, 97031, 119931, 137133, 154175]
t_vec = Daru::View::Table.new(dv)
#<Daru::View::Table:0x00005570bd0ba490 @data=#<Daru::Vector(8)>
0 43934
1 52503
2 57177
3 69658
4 97031
5 119931
6 137133
7 154175, @options={}, @user_options={}, @adapter=Daru::View::Adapter::GooglechartsAdapter, @table=#<GoogleVisualr::DataTable:0x00005570bd0ba418 @cols=[{:type=>"number", :label=>"Series"}], @rows=[[#<GoogleVisualr::DataTable::Cell:0x00005570bd0b9f90 @v=43934, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x00005570bd0b9ea0 @v=52503, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x00005570bd0b9d88 @v=57177, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x00005570bd0b9c98 @v=69658, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x00005570bd0b9ab8 @v=97031, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x00005570bd0b98d8 @v=119931, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x00005570bd0b97e8 @v=137133, @type="number">], [#<GoogleVisualr::DataTable::Cell:0x00005570bd0b96f8 @v=154175, @type="number">]], @listeners=[], @options={}, @data=#<Daru::Vector(8)>
0 43934
1 52503
2 57177
3 69658
4 97031
5 119931
6 137133
7 154175, @user_options={}>>
t_vec.table
t_vec.table.options
{}
# set new options in the table. This feature is not present in the basic google_visualr
t_vec.table.options = opts_pagination
{:showRowNumber=>true, :width=>"100%", :height=>"100%", :page=>"enable", :pageSize=>2, :pagingSymbols=>{:prev=>"prev", :next=>"next"}, :pagingButtonsConfiguration=>"auto"}
t_vec.table
# 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};
{: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"}}
t_vec.table.options = opts_css
{: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"}}
# FixMe: css is not working. May be there is other way to pass cssClassName
t_vec.table
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
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