search

DEIB-GECO / PyGMQL

Python Library for data analysis based on GMQL
Apache License 2.0
13 stars 5 forks source link

The result of an ORDER operation returns a "_group" metadata attribute instead of "_order" #26

Closed lucananni93 closed 6 years ago

lucananni93 commented 6 years ago

Query:

# order_1
D = SELECT(region: chr == chr1) Example_Dataset_1;
D1 = EXTEND(Region_count AS COUNT()) D;
RES = ORDER(Region_count DESC; meta_top: 2) D1;
MATERIALIZE RES INTO order_1;

Code:

res = gl.get_example_dataset("Example_Dataset_1")
res = res.reg_select(res.chr == 'chr1')
res = res.extend({'Region_count': gl.COUNT()})
res = res.order(meta=['Region_count'], meta_ascending=[False], meta_top="top", meta_k=2)
res = res.materialize()