45 lines
1.5 KiB
Kotlin
Vendored
45 lines
1.5 KiB
Kotlin
Vendored
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"
|
|
}
|