plugins/kotlin-dataframe/testData/box/joinWithKinds.kt

import org.jetbrains.kotlinx.dataframe.*
import org.jetbrains.kotlinx.dataframe.annotations.*
import org.jetbrains.kotlinx.dataframe.api.*
import org.jetbrains.kotlinx.dataframe.io.*

fun box(): String {
    val typed = dataFrameOf("name", "age", "city", "weight")(
        "Alice", 15, "London", 54,
        "Bob", 45, "Dubai", 87,
        "Charlie", 20, "Moscow", null,
        "Charlie", 40, "Milan", null,
        "Bob", 30, "Tokyo", 68,
        "Alice", 20, null, 55,
        "Charlie", 30, "Moscow", 90,
    )

    val typed2 = dataFrameOf("name", "origin", "grade", "age")(
        "Alice", "London", 3, "young",
        "Alice", "London", 5, "old",
        "Bob", "Tokyo", 4, "young",
        "Bob", "Paris", 5, "old",
        "Charlie", "Moscow", 1, "young",
        "Charlie", "Moscow", 2, "old",
        "Bob", "Paris", 4, null,
    )

    typed.joinWith(typed2) { name == right.name && city == right.origin }.assert()

    typed.joinWith(typed2, type = JoinType.Inner) { name == right.name && city == right.origin }.assert()

    typed.innerJoinWith(typed2) { name == right.name && city == right.origin }.assert()

    typed.leftJoinWith(typed2) { name == right.name && city == right.origin }.assert()

    typed.rightJoinWith(typed2) { name == right.name && city == right.origin }.assert()

    typed.fullJoinWith(typed2) { name == right.name && city == right.origin }.assert()

    typed.filterJoinWith(typed2) { city == right.origin }.assert()

    typed.excludeJoinWith(typed2) { city == right.origin }.assert()

    return "OK"
}