any suggestions on how we can implement this?
<ht...
# daft-devc
Cory Grinstead
11/06/2024, 9:05 PMany suggestions on how we can implement this?
https://github.com/Eventual-Inc/Daft/issues/3194
Like if you wanted the same output through the dataframe api, how would one go about it?
c
Colin Ho
11/06/2024, 10:39 PMYou'd need to alias the right side join key, like:
Copy code
table1.join(
table2, left_on="id", right_on=daft.col("id").alias("right.id"), how="left"
).collect()š 1
Colin Ho
11/06/2024, 10:39 PM Copy code
āāāāāāāāā¬āāāāāāāā¬āāāāāāāāāāā¬āāāāāāāāāāāāāā®
ā id ā value ā right.id ā right.value ā
ā --- ā --- ā --- ā --- ā
ā Int64 ā Utf8 ā Int64 ā Utf8 ā
āāāāāāāāāŖāāāāāāāāŖāāāāāāāāāāāŖāāāāāāāāāāāāāā”
ā 1 ā a ā None ā None ā
āāāāāāāāā¼āāāāāāāā¼āāāāāāāāāāā¼āāāāāāāāāāāāāā¤
ā 2 ā b ā 2 ā b ā
āāāāāāāāā¼āāāāāāāā¼āāāāāāāāāāā¼āāāāāāāāāāāāāā¤
ā 3 ā c ā 3 ā c ā
āāāāāāāāā¼āāāāāāāā¼āāāāāāāāāāā¼āāāāāāāāāāāāāā¤
ā 4 ā d ā 4 ā d ā
ā°āāāāāāāā“āāāāāāāā“āāāāāāāāāāā“āāāāāāāāāāāāāāÆ4 Views