plugins/kotlin-dataframe/testData/box/joinKinds.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.join(typed2) { name and it.city.match(right.origin) }.assert()

    typed.join(typed2, type = JoinType.Inner) { name and it.city.match(right.origin) }.assert()

    typed.innerJoin(typed2) { name and it.city.match(right.origin) }.assert()

    typed.leftJoin(typed2) { name and it.city.match(right.origin) }.assert()

    typed.rightJoin(typed2) { name and it.city.match(right.origin) }.assert()

    typed.fullJoin(typed2) { name and it.city.match(right.origin) }.assert()

    typed.filterJoin(typed2) { city.match(right.origin) }.assert()

    typed.excludeJoin(typed2) { city.match(right.origin) }.assert()

    return "OK"
}