holgerbrandl/krangl

Hello everyone,

I thought I might as well try here first before making an issue. I have a relatively simple question -- what is the simplest way to append rows to DataFrames?

In short what I'm trying to do: I want Pandas' append functionality: https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.append.html

I understand DataFrames are immutable, so I'd ultimately be creating a new DataFrame in the end. However, the only way I've seen so far to create such a DataFrame is to create a row iterable, and feed that into another dataFrameOf like so:

    val frame: DataFrame = dataFrameOf("Col1", "Col2") (
        "A", "B"
    )

    val newFrame: DataFrame = dataFrameOf("Col1", "Col2") (
        frame.rows.asSequence().map { it.values }.flatten() + sequenceOf("C", "D")
    )
/**
 * A DataFrame: 2 x 2
 *     Col1   Col2
 * 1      A      B
 * 2      C      D
 */

This seems particularly ugly (not to mention that the items may be in the wrong order...) There must be a better way, surely?