framequery
framequery copied to clipboard
SQL on dataframes - pandas and dask
For example: ```sql select * from test order by 4 * c1 ```
`distinct on` allows to formulate `argmax` / `argmin` like queries. For example: ``` select distinct on (key) key, sort_key, value order by key, sort_key desc ```
Add support for analytic functions. In particular: - `AVG` - `ROW_NUMBER` - `LAG` - `SUM` With support for: - `ORDER BY ...` - `PARTITION BY ...`
Add support for - `UNION` - `INTERSECTION` - `MINUS`