WITH mapping as (
select
m.f1, m.f2
from (
select onehot_encoding(species, category) m
from test
) tmp
)
select
array(m.f1[t.species],m.f2[t.category],feature(‘count’,count)) as sparse_features
from
test t
CROSS JOIN mapping m;
[“2″,”8″,”count:9”]
[“5″,”8″,”count:10”]
[“1″,”6″,”count:101”]
WhereOS is a data innovation platform and service.
For teams and businesses who want to get more value out of data – WhereOS minimizes your effort and maximizes your results.
If you wish discuss with us, please contact us through support@eaglepeaks.com or call us +358 50 486 9257.
© WhereOS 2021 All rights reserved
