use Red; red-defaults "DuckDB"; red-do { my \T = .read-csv: "iot-sensor-100.csv"; say T.^all .classify(*.device) .map(-> (:key($device), :value($rows)) { my $count = $rows.elems; my $values = $rows.map(*.value); [$device, $count, $values.sum / $count, $values.min, $values.max] }) .sort(*[0]) .Array }