« Changelog History


krangl v0.15 Release Notes

Release Date: 2020-11-05 // over 3 years ago

  • 🆕 New Features

    • 👍 #97 Added Excel read/write support (by LeandroC89) ```kotlin

    // read df = DataFrame.readExcel("data.xlsx", sheetName = "sales") df = DataFrame.readExcel("data.xlsx", cellRange = CellRangeAddress.valueOf("A1:D10"))

    // write df.writeExcel("results.xslx")

    
* [#95](https://github.com/holgerbrandl/kscript/issues/95) Improved column type casts

    dataFrameOf("foo")(1, 2, 3).addColumn("stringified_foo") { it["foo"].toStrings() }.schema()

    DataFrame with 3 observations foo [Int] 1, 2, 3 stringified_foo [Str] 1, 2, 3

    dataFrameOf("foo")("1", "2", "3").addColumn("parsed_foo") { it["foo"].toInts() }.schema()

    DataFrame with 3 observations foo [Str] 1, 2, 3 parsed_foo [Int] 1, 2, 3

    • #99 Added filtering by list (similar to R's %in% operator) kotlin irisData.filter { it["Species"].inList("setosa", "versicolor") }

    🐛 Bug Fixes

    • 🏗 #84 Builder now supports mixed numbers in column
    • 🛠 #96 & #94 Fixed bugs in join
    • #100 Improved SQL bindings
    • 🛠 #99 Fixed median