I actually had it wrong in mine. Wasn't paying attention and had the dictionary the wrong way around. Probably would have been more obvious with the char since you can't sum them... With the reverse thrown in to switch…
Using the file from the original, 1#desc sum each group (!/) (" II";"\t") 0: `:tsvfile Took about 3 seconds, 2.5 of which was reading the file EDIT: q)\ts d: (!/) (" II";"\t") 0: `:tsvfile 2489 134218576 q)\ts 1#desc…
I actually had it wrong in mine. Wasn't paying attention and had the dictionary the wrong way around. Probably would have been more obvious with the char since you can't sum them... With the reverse thrown in to switch…
Using the file from the original, 1#desc sum each group (!/) (" II";"\t") 0: `:tsvfile Took about 3 seconds, 2.5 of which was reading the file EDIT: q)\ts d: (!/) (" II";"\t") 0: `:tsvfile 2489 134218576 q)\ts 1#desc…