I am trying to produce a species discovery curve, which is basically the number of unique species observed over time. So, at time t, the value is
length(unique(_.species_name)) for all observations up to time t - this in itself is super easy to do, but I am looking for a way to do it using
Is there a mechanism to iterate? The issue I had with
@groupby is that it only gives access to a single value when grouping by date, and I’m looking for a way to group by “all values lower than the current one”.
I realize that this isn’t necessarily a problem to solve with
Query.jl but I’m trying “for fun”.