Re: doing an inner join via cross-product

2020-07-20 Thread Bruce Gray
> On Jul 19, 2020, at 3:02 PM, Joseph Brenner wrote: > > I was thinking about the cross-product operator the other day, > and I was wondering if there might be a convenient way of > filtering the resulting cartesian product to do something like a > database inner join: > >my @level = ( g

Re: doing an inner join via cross-product

2020-07-20 Thread Aureliano Guedes
With a dataframe data structure and some adjusts and some functions modifications it could be doing like: data1 .# perhaps the space after . is intentional to bring the idea of pipes replace f(x) with x . f() left_join(data2, by={ x = columname_on_d

Re: doing an inner join via cross-product

2020-07-19 Thread Darren Duncan
This reminds me of my 2009 Set::Relation Perl module, which works to help you do SQL features like this in your application, but will soon be superseded by another module that also has a Raku version. -- Darren Duncan On 2020-07-19 1:02 p.m., Joseph Brenner wrote: I was thinking about the cros