daphne-eu / daphne

DAPHNE: An Open and Extensible System Infrastructure for Integrated Data Analysis Pipelines
Apache License 2.0
67 stars 62 forks source link

implement count built-ins for DaphneDSL #910

Open m-birke opened 1 week ago

m-birke commented 1 week ago

sth. to count a specific values like count(matrix[,0], value) (or from a frame)(also on strings)

and/or

unique_counts as know from numpy

There are currently ways to circumvent this by reshaping a matrix into single col, convert it to a frame, register it as a view and finally conduct SQL ops

Or is it the idea to provide such functionality trough SQL?