A related follow on… Not sure if it’s a bug or by design, but it would appear new column names can’t be exactly the same as range variables.
df_new = @from i in df_one begin
@join j in df_two on i.name equals j.name into k
@let count = length(k)
@select {i.name, count=count}
@collect DataFrame
end
println(df_new)
#output
3×2 DataFrames.DataFrame
│ Row │ name │ _2_ │
├─────┼─────────┼─────┤
│ 1 │ "John" │ 2 │
│ 2 │ "Sally" │ 4 │
│ 3 │ "Kirk" │ 3 │
I did expect that new column to be called “count” not “2”. Anything to the left of an “=” in a @select statement to be considered a column name?