This MWE is supposed to do an inner join (i.a equals j.c || i.b equals j.e) and output all the elements of the first df: df1 = DataFrame(a=[1,2,3], b=[1.,2.,3.]) df2 = DataFrame(c=[2,4,2], d=["John", "Jim","Sally"],e=[1.,1.,3.]) x = @from i in df1 begin @join j in df2 on i.a equals j.c || i.…

This works (new example data so correct result is not empty): df1 = DataFrame(a=[1,2,3], b=[1.,2.,3.]) df2 = DataFrame(c=[2,4,3], d=["John", "Jim","Sally"],e=[1.,1.,3.]) x = @from i in df1 begin @join j in df2 on (i.a,i.b) equals (j.c,j.e) @select i @collect DataFrame end @test x[1,:]…

LINQ inner joins and select all in Query.jl

New to Julia

xiaodai September 14, 2020, 4:31am 2

I am trying to solve it.

BTW, what attracted you to use Query.jl in the first place? Is it because it sounds like the equiavelnt of tidyverse in Julia?

Topic		Replies	Views
Iterate across two DataFrames using Query.jl New to Julia query	5	1185	November 19, 2018
Accessing full dataframe after a join within a Query.jl query Data	4	1083	April 7, 2017
Comparing DataFrames native API and Query Data	4	1545	September 1, 2017
Query.jl - Return all columns with @map Data question	3	1247	August 5, 2019
Query.jl: Automatize multiple @select at once Data metaprogramming , query	5	1400	July 20, 2017

LINQ inner joins and select all in Query.jl

Related topics