miller
miller copied to clipboard
johnkerl
Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON
I'm missing something basic -- but `mlr sort` simply won't return any results: ``` ❯ mlr --csv head ../wikidata/P1056.csv subject,subjectLabel,object,objectLabel http://www.wikidata.org/entity/Q524931,coup de grâce,http://www.wikidata.org/entity/Q4,death http://www.wikidata.org/entity/Q6437079,Krinos Foods,http://www.wikidata.org/entity/Q41,Greece http://www.wikidata.org/entity/Q7050424,Norbest,http://www.wikidata.org/entity/Q43,Turkey http://www.wikidata.org/entity/Q4990,Ursus Breweries,http://www.wikidata.org/entity/Q44,beer http://www.wikidata.org/entity/Q4995,SABMiller,http://www.wikidata.org/entity/Q44,beer http://www.wikidata.org/entity/Q106854,Beck's,http://www.wikidata.org/entity/Q44,beer...
Hi, I have this [Eurostat TSV](https://gist.githubusercontent.com/aborruso/59f51d0c7cf5feb3d08b7ffdd1db04c7/raw/6245a2b3b0fbe52efb95c1065a6da302d0c70e5b/tmp.tsv) (the first column is a sort of a CSV inside the column). I want to apply a wide to long reshape to all field...
Hello @johnkerl and everyone else. In recent times I've sort of twisted Miller in order to use it to parse [LDIF](https://en.wikipedia.org/wiki/LDAP_Data_Interchange_Format) representations of data from an LDAP directory. Apart from...
I have a JSON file with the data below and I'm hoping to extract the value of domain.domain using the command thusly `~/go/bin/mlr --ijson --ocsv cut -f domain.domain * `...
Hi, I think Miller is one of the best tool to work on text structured data. Unfortunately (it seems to me) it is not very known. Than I'm doing a...
I may be missing it, but I'm feeling that just having `system()` for external calls is too limiting. In Node we have [child_process.spawn(command[, args][, options])](https://nodejs.org/docs/latest-v12.x/api/child_process.html#child_process_child_process_spawn_command_args_options) I know Rust has something...
## Unexpected back reference scope Given a CSV file like this. ```csv original,expected abc123,abc-456 ``` This miller command: ```bash mlr --csv --from test.csv put ' if ($original =~ "([a-z]{3})([0-9]{3})") {...
Hi, I have this [input CSV](https://gist.githubusercontent.com/aborruso/36fd3f1cb3d9dbfb2dc433e0c5de05c6/raw/a15e99f877c148fedabad3cac680f535523481aa/input.csv), that is wrong: It has two cells in two fields without field name. But if I run `mlr --ifs ";" --csv check input.csv`, I...
PPRINT output does not align correctly when there are combining characters, e.g. ```sh $ echo "name,age\nกา,24\nก่า,25" | mlr --c2p cat name age กา 24 ก่า 25 ``` (Note: ก่า =...
