Use Tablesaw with Kotlin

%%classpath add mvn
tech.tablesaw tablesaw-beakerx 0.36.0
com.jimmoores quandl-tablesaw 2.0.0

import tech.tablesaw.aggregate.AggregateFunctions.*
import tech.tablesaw.api.*
import tech.tablesaw.columns.*

val numbers = arrayOf(1, 2, 3, 4)
val col = DoubleColumn.create("nc", numbers)
println(col.print())

col.get(2)

col.multiply(4)

println(col.multiply(4).print())

col.isLessThan(3.0)

val c = col.isLessThan(3.0)
c

println(col.where(c).print())

col.where(col.isLessThan(3.0).and(col.isPositive()))

println(col.where(col.isLessThan(3.0).and(col.isPositive())).print())

col.where(Selection.with(0, 2))

col.where(Selection.withRange(1, 3))

val flights = Table.read().csv("../../home/media/data/flights14.csv")

flights.structure()

flights.columnNames()

flights.shape()

flights.first(10)

flights.summary()

val values = doubleArrayOf(1.0, 2.0, 3.0, 7.0, 9.44242, 11.0)
values

val column = DoubleColumn.create("my_numbers", values)

DoubleColumn.create("col", 0.until(10).map{
    i -> i.toDouble()
})

import tech.tablesaw.api.Table
import tech.tablesaw.api.DoubleColumn

val table = Table.create("Table1")

for (i in 0.until(10)) {
    val column = DoubleColumn.create("column_" + i, 0.until(10).map{
        j -> (j + 10 * i).toDouble()
    })
    table.addColumns(column)
}
table.print()