Andrea Borruso

> I am curious if there is functionality to do a left-join and get a single csv output. You must add [`unsparsify` verb](https://miller.readthedocs.io/en/latest/reference-verbs.html#unsparsify). Running ``` mlr --icsv --ocsv join -j...

I agree. It's not what you want, but I add that you could use `mlr --csv filter 'NR>2' input.csv`

@kub1x and look please at this stack overflow answer https://stackoverflow.com/a/55687128/757714

@kub1x if you solve your problem, please write here about it. And than @johnkerl will close the issue. Thank you

@kub1x and this is another way ``` mlr --c2p put ' if (NR % 10 == 0) {$rule=NR} else {$rule = ""}; begin { @start = 10; } if ($rule...

> Thirdly: a `mlr split` verb (with `--max-num-files` and `--max-record-count` being mutually exclusive options, and a `--filename-template`) might be a handy keystroke-saver for the above DSL expressions. This could be...

Hi @johnkerl , I had already tried with pprint but I have for that input `mlr: Header-data length mismatch in file pprint at line 3`. Is it ok? thank you

And I have no error if I remove the line with empty "cells", it works with ``` OC Yea NO Yea DE Yea WI Yea SP Yea SU Yea AU...

I have find a solution using sed. The raw input file is this https://www.metoffice.gov.uk/pub/data/weather/uk/climate/datasets/Tmin/ranked/UK.txt My solution was to use sed in [this way](https://gist.github.com/aborruso/41e825a0bd30649c9341b04347304b39#file-00_uk-tmin-sh-L10-L11). At the end I have a CSV.

@johnkerl what is NFR? Is it Non-Functional Requirements? What's the practical meaning? Thank you