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]:

Daru::View.plotting_library = :googlecharts

Out[2]:

:googlecharts

In [3]:

idx = Daru::Index.new ['Year', 'Sales']
data_rows = [
          ['2004',  1000],
          ['2005',  1170],
          ['2006',  660],
          ['2007',  1030]
]
df_sale_exp = Daru::DataFrame.rows(data_rows)
df_sale_exp.vectors = idx
df_sale_exp

Out[3]:

Daru::DataFrame(4x2)

	Year	Sales
0	2004	1000
1	2005	1170
2	2006	660
3	2007	1030

In [4]:

# Default chart type is Line.
line_basic_chart = Daru::View::Plot.new(df_sale_exp)
line_basic_chart.show_in_iruby

Out[4]:

In [5]:

line_basic_options = {
  title: 'Company Performance',
   curveType: 'function',
  legend: { position: 'bottom' }
}
# We can pass dataframe/vector/data array/ google datatable or Daru-view Table  as data source
line_basic_chart = Daru::View::Plot.new(df_sale_exp, line_basic_options)
line_basic_chart.show_in_iruby

Out[5]:

In [6]:

# Adding another series
df_sale_exp['Expense'] = [400, 460, 1120, 540]

Out[6]:

[400, 460, 1120, 540]

In [7]:

df_sale_exp

Out[7]:

Daru::DataFrame(4x3)

	Year	Sales	Expense
0	2004	1000	400
1	2005	1170	460
2	2006	660	1120
3	2007	1030	540

In [8]:

line_basic_options = {
  title: 'Company Performance',
   curveType: 'function',
  legend: { position: 'bottom' }
}
# We can pass dataframe/vector/data array/ google datatable or Daru-view Table  as data source
line_basic_chart = Daru::View::Plot.new(df_sale_exp, line_basic_options)
line_basic_chart.show_in_iruby

Out[8]:

TODO: Material Line Charts feature is not present in google_visualr. Add this in daru-view

In [39]:

data = [
        ['Month', 'Average Temperature', 'Average Hours of Daylight'],
        [DateTime.new(2014, 1).to_date,   0.4,  8.7],
        [DateTime.new(2014, 2).to_date,   0.5,   12],
        [DateTime.new(2014, 3).to_date,  2.9, 15.3],
        [DateTime.new(2014, 4).to_date,  6.3, 18.6],
        [DateTime.new(2014, 5).to_date,    9, 20.9],
        [DateTime.new(2014, 6).to_date, 10.6, 19.8],
        [DateTime.new(2014, 7).to_date, 10.3, 16.6],
        [DateTime.new(2014, 8).to_date,  7.4, 13.3],
        [DateTime.new(2014, 9).to_date,  4.4,  9.9],
        [DateTime.new(2014, 10).to_date, 1.1,  6.6],
        [DateTime.new(2014, 11).to_date, -0.2,  4.5]
  ]
temp_table = Daru::View::Table.new(data)
temp_table.show_in_iruby

Out[39]:

In [40]:

DateTime.new(2001,2,3).to_date

Out[40]:

#<Date: 2001-02-03 ((2451944j,0s,0n),+0s,2299161j)>

In [41]:

DateTime.new(2001,2,3)

Out[41]:

#<DateTime: 2001-02-03T00:00:00+00:00 ((2451944j,0s,0n),+0s,2299161j)>

In [42]:

line_dualY_options = {
  title: 'Company Performance',
   curveType: 'function',
  legend: { position: 'bottom' }
}
# We can pass dataframe/vector/data array/ google datatable or Daru-view Table  as data source
line_dualY_chart = Daru::View::Plot.new(temp_table, line_dualY_options)
line_dualY_chart.show_in_iruby

Out[42]:

In [43]:

line_dualY_options = {
title: 'Average Temperatures and Daylight in Iceland Throughout the Year',
        width: 900,
        height: 500,
        # Gives each series an axis that matches the vAxes number below.
        series: {
          0 => {targetAxisIndex: 0},
          1 => {targetAxisIndex: 1}
        },
        vAxes: {
          # Adds titles to each axis.
          0 => {title: 'Temps (Celsius)'},
          1 => {title: 'Daylight'}
        },

        hAxis: {
          ticks: [ DateTime.new(2014, 1) , DateTime.new(2014, 2) , DateTime.new(2014, 3) , DateTime.new(2014, 4) , 
            DateTime.new(2014, 5) , DateTime.new(2014, 6) , DateTime.new(2014, 7) , DateTime.new(2014, 8) , DateTime.new(2014, 9) , 
            DateTime.new(2014, 10) , DateTime.new(2014, 11) , DateTime.new(2014, 12) , 
                 ]
        },
        vAxis: {
          viewWindow: {
            max: 30
          }
        }
}
# We can pass dataframe/vector/data array/ google datatable or Daru-view Table  as data source
line_dualY_chart = Daru::View::Plot.new(temp_table, line_dualY_options)
line_dualY_chart.show_in_iruby

Out[43]:

Top-X Charts¶

In [44]:

data = [
        ['Day', 'Guardians of the Galaxy', 'The Avengers', 'Transformers: Age of Extinction'],
        [1,  37.8, 80.8, 41.8],
        [2,  30.9, 69.5, 32.4],
        [3,  25.4,   57, 25.7],
        [4,  11.7, 18.8, 10.5],
        [5,  11.9, 17.6, 10.4],
        [6,   8.8, 13.6,  7.7],
        [7,   7.6, 12.3,  9.6],
        [8,  12.3, 29.2, 10.6],
        [9,  16.9, 42.9, 14.8],
        [10, 12.8, 30.9, 11.6],
        [11,  5.3,  7.9,  4.7],
        [12,  6.6,  8.4,  5.2],
        [13,  4.8,  6.3,  3.6],
        [14,  4.2,  6.2,  3.4]
  ]
box_office_table = Daru::View::Table.new(data)
box_office_table.show_in_iruby

Out[44]:

In [46]:

line_topX_options = {
  type: :line
}
# We can pass dataframe/vector/data array/ google datatable or Daru-view Table  as data source
line_topX_chart = Daru::View::Plot.new(box_office_table, line_topX_options)
line_topX_chart.show_in_iruby

Out[46]:

In [59]:

line_topX_options = {

          title: 'Box Office Earnings in First Two Weeks of Opening',

        width: 900,
        height: 500,
  # FixMe: might be other syntax for it.
        vAxes: {
            0 => {side: 'top'}
        }
}
# We can pass dataframe/vector/data array/ google datatable or Daru-view Table  as data source
line_topX_chart = Daru::View::Plot.new(box_office_table, line_topX_options)
line_topX_chart.show_in_iruby

Out[59]:

In [64]:

data = [
        ['X', 'Dogs', 'Cats'],
        [0, 0, 0],    [1, 10, 5],   [2, 23, 15],  [3, 17, 9],   [4, 18, 10],  [5, 9, 5],
        [6, 11, 3],   [7, 27, 19],  [8, 33, 25],  [9, 40, 32],  [10, 32, 24], [11, 35, 27],
        [12, 30, 22], [13, 40, 32], [14, 42, 34], [15, 47, 39], [16, 44, 36], [17, 48, 40],
        [18, 52, 44], [19, 54, 46], [20, 42, 34], [21, 55, 47], [22, 56, 48], [23, 57, 49],
        [24, 60, 52], [25, 50, 42], [26, 52, 44], [27, 51, 43], [28, 49, 41], [29, 53, 45],
        [30, 55, 47], [31, 60, 52], [32, 61, 53], [33, 59, 51], [34, 62, 54], [35, 65, 57],
        [36, 62, 54], [37, 58, 50], [38, 55, 47], [39, 61, 53], [40, 64, 56], [41, 65, 57],
        [42, 63, 55], [43, 66, 58], [44, 67, 59], [45, 69, 61], [46, 69, 61], [47, 70, 62],
        [48, 72, 64], [49, 68, 60], [50, 66, 58], [51, 65, 57], [52, 67, 59], [53, 70, 62],
        [54, 71, 63], [55, 72, 64], [56, 73, 65], [57, 75, 67], [58, 70, 62], [59, 68, 60],
        [60, 64, 56], [61, 60, 52], [62, 65, 57], [63, 67, 59], [64, 68, 60], [65, 69, 61],
        [66, 70, 62], [67, 72, 64], [68, 75, 67], [69, 80, 72]
  ]
dog_cat_table = Daru::View::Table.new(data, pageSize: 8)
dog_cat_table.show_in_iruby

Out[64]:

In [67]:

line_dog_cat_options = {
  
}
# We can pass dataframe/vector/data array/ google datatable or Daru-view Table  as data source
line_dog_cat_chart = Daru::View::Plot.new(dog_cat_table.table, line_dog_cat_options)
line_dog_cat_chart.show_in_iruby

Out[67]:

In [69]:

line_dog_cat_options = {
  hAxis: {
          title: 'Time'
        },
        vAxis: {
          title: 'Popularity'
        },
        colors: ['#a52714', '#097138'],
        crosshair: {
          color: '#000',
          trigger: 'selection'
        }
}
# We can pass dataframe/vector/data array/ google datatable or Daru-view Table  as data source
line_dog_cat_chart = Daru::View::Plot.new(dog_cat_table.table, line_dog_cat_options)
# click to see the crosshair
line_dog_cat_chart.show_in_iruby

Out[69]:

In [74]:

line_dog_cat_options = {
  hAxis: {
          title: 'Time'
        },
        vAxis: {
          title: 'Popularity'
        },
        colors: ['#AB0D06', '#007329'],
        trendlines: {
          0 => {type: 'exponential', color: '#333', opacity: 1},
          1 => {type: 'linear', color: '#111', opacity: 0.3}
        },
  height: 500
}
# We can pass dataframe/vector/data array/ google datatable or Daru-view Table  as data source
line_dog_cat_chart = Daru::View::Plot.new(dog_cat_table.table, line_dog_cat_options)

line_dog_cat_chart.show_in_iruby

Out[74]:

In [77]:

line_dog_cat_options = {
hAxis: {
          title: 'Time'
        },
        vAxis: {
          title: 'Popularity'
        },
        colors: ['#a52714', '#097138'],
        series: {
          0 => {
            lineWidth: 10,
            lineDashStyle: [5, 1, 5]
          },
          1 => {
            lineWidth: 5,
            lineDashStyle: [7, 2, 4, 3]
          }
        },
  height: 500
}
# We can pass dataframe/vector/data array/ google datatable or Daru-view Table  as data source
line_dog_cat_chart = Daru::View::Plot.new(dog_cat_table.table, line_dog_cat_options)

line_dog_cat_chart.show_in_iruby

Out[77]:

In [78]:

line_dog_cat_options = {
 hAxis: {
          title: 'Time',
          textStyle: {
            color: '#01579b',
            fontSize: 20,
            fontName: 'Arial',
            bold: true,
            italic: true
          },
          titleTextStyle: {
            color: '#01579b',
            fontSize: 16,
            fontName: 'Arial',
            bold: false,
            italic: true
          }
        },
        vAxis: {
          title: 'Popularity',
          textStyle: {
            color: '#1a237e',
            fontSize: 24,
            bold: true
          },
          titleTextStyle: {
            color: '#1a237e',
            fontSize: 24,
            bold: true
          }
        },
        colors: ['#a52714', '#097138'],
  height: 500
}
# We can pass dataframe/vector/data array/ google datatable or Daru-view Table  as data source
line_dog_cat_chart = Daru::View::Plot.new(dog_cat_table.table, line_dog_cat_options)

line_dog_cat_chart.show_in_iruby

Out[78]:

In [ ]: