SQL and fast grouped method improvements
Much of this release is setting up for...
- fast methods to become drop-in replacements for their slow, reference implementation counterparts!
- SQL fixes and features for funneljoin-py
Fixes
- Pandas anti_join breaking when on argument is a string (#264)
- Sql now resets order by after joins (#277)
- Fixed major regression for sql where filter with multiple arguments did strange and terrible things (#277)
- Sql summarize correctly makes a subquery when group_by references a recently created column (#278)
- Sql right_join had to switch lhs and rhs, but was not correctly handling all implications of that. Specifically how key columns are kept, and suffixes used. (#279)
Features
- Fast grouped methods determine whether they can run quickly, fallback if not, along with a warning. Lambdas can be used to explicitly take the slower, reference implementation route (#268).
- Fast grouped methods allow property operations that return dim 0 results, like dtype. (#269)
-
in sql arrange now produces the correctDESC
, rather than being a-
operation (#280)- pandas arrange now works on grouped data. i.e. DataFrameGroupBy. (#280)
QA
- a slew of tests!