In [1]:
require 'mikon'
Out[1]:
Out[1]:
In [2]:
path = File.expand_path("../data/gdp.csv", __FILE__)
df1 = Mikon::DataFrame.from_csv(path)
Out[2]:
In [3]:
df2 = df1.select{year==2012}
df2[:value].plot
Out[3]:
In [4]:
df3 = df1.select{country_or_area[0] == "A"}
Out[4]:
In [5]:
df4 = df3.pivot(column: :country_or_area, row: :year, value: :value)
Out[5]:
In [6]:
df4.fillna(0)
Out[6]:
In [7]:
df4.plot
Out[7]:
In [5]:
df1.map{year + 2}
Out[5]:
In [7]:
df1[10..20]
Out[7]:
In [8]:
df1.tail(2)
Out[8]:
In [10]:
df1.head(2)
Out[10]:
In [11]:
df1.insert_column(:value_2){value*2}
Out[11]:
In [8]:
2*df1[:value]
Out[8]:
In [7]:
df1[:value] - df1[:value]
Out[7]:
In [13]:
df1.any?{value > 5}
Out[13]:
In [14]:
df1.all?{value > 1}
Out[14]:
In [9]:
df = Mikon::DataFrame.new({a: [1,2,3], b: [2,3,4]})
Out[9]:
In [10]:
df[:b] - df[:a]
Out[10]:
In [11]:
2 * df[:a]
Out[11]:
In [13]:
df[:a]%2
Out[13]:
In [16]:
df[1..2]
Out[16]:
In [17]:
df.select{a**2 < b}
Out[17]:
In [9]:
df2 = Mikon::DataFrame.new({a: [1,2,3,4], b: [2,3,4,5]}, index: [:a, :b, :c, :d])
Out[9]:
In [10]:
df2[:a .. :c]
Out[10]:
In [20]:
[1,2].each{|val| p val}
Out[20]:
In [21]:
df = Mikon::DataFrame.new({a: [1,2,3,4,5,6,7,8,9], b: [1,2,3,4,5,6,7,8,9]})
Out[21]:
In [14]:
df.map{a+b}.name(:c)
Out[14]:
In [23]:
hoge = []
df.each{hoge.push(a*b)}
hoge
Out[23]: