2 Scripts for getting stats

Michael Zhang edited this page 2024-04-27 00:10:42 +00:00

Average score for each level:

$ csvjson output.csv | jq -c 'map(select(.Lamp != "Fail")) | group_by(.Rating) | map(. | [(.[0].Rating | round), (map(.Score) | length as $length | add / $length | round)]) | .[]'
[8,895073]
[9,909287]
[10,915836]
[11,896387]
[12,889375]
[13,836118]
[14,799162]
[15,800785]
[16,774763]
[17,662870]