framequery icon indicating copy to clipboard operation
framequery copied to clipboard

SQL on dataframes - pandas and dask

Results 4 framequery issues
Sort by recently updated
recently updated
newest added

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`