miller
miller copied to clipboard
Published
20 hours ago •
johnkerl
johnkerl
A proposal: fill stackexchange with Miller
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 simple thing: search for Miller matter in stack exchange (as this) and write answers Miller related. I'm still a Miller "yellow belt" 😄 , but I started with this, this, this and this one.
I think that all those who often use this fantastic tool could do it.
What do you think about?
Two useful things:
- a better search output list https://stackexchange.com/filters/358478/csv?sort=newest
- the RSS feed of this https://stackexchange.com/feeds/tagsets/358478/csv?sort=newest
I'm adding some new reply:
- https://unix.stackexchange.com/questions/492434/sed-delete-csv-column-if-exists/492534#492534
- https://unix.stackexchange.com/questions/486655/parsing-csv-that-has-multiple-line-values-with-carriage-returns/491748#491748
- https://unix.stackexchange.com/questions/472858/csv-file-group-and-sum-values-based-on-first-pattern-of-each-value/491732#491732
- https://unix.stackexchange.com/questions/476023/organizing-data-by-a-header/491731#491731
- https://unix.stackexchange.com/questions/484274/add-a-pattern-before-the-delimiter/491730#491730
- https://unix.stackexchange.com/questions/430199/output-a-header-label-in-data-field-in-miller/492541#492541
- https://unix.stackexchange.com/questions/238046/stack-data-from-multiple-delimited-files-into-one-with-variable-columns/492859#492859
- https://unix.stackexchange.com/questions/457091/convert-data-from-ldif-file-to-csv/492863#492863
- https://unix.stackexchange.com/questions/318446/cut-an-array-column-and-join-an-another-column-to-a-csv-file/492865#492865
- https://unix.stackexchange.com/questions/493551/join-two-files-based-on-a-common-field/493629#493629
- https://unix.stackexchange.com/questions/493552/compare-columns-in-2-files-and-put-information-according-to-file-1/493627#493627
- https://unix.stackexchange.com/questions/494259/getting-file-as-rows-and-columns-data-matrix/494273#494273
- https://askubuntu.com/questions/1109590/extracting-numbers-whose-lengths-are-fixed-from-text-file/1109598#1109598
- https://unix.stackexchange.com/questions/494778/how-remove-duplicate-names-and-print-array-after-unique-names/494801#494801
- https://unix.stackexchange.com/questions/494803/how-can-i-remove-repeated-lines-taking-into-consideration-the-text-from-just-a-c/494874#494874
- https://unix.stackexchange.com/questions/495005/sql-operation-on-csv-file-using-bash-or-shell/495026#495026
- https://unix.stackexchange.com/questions/7698/command-to-layout-tab-separated-list-nicely/495416#495416
- https://unix.stackexchange.com/questions/7425/is-there-a-robust-command-line-tool-for-processing-csv-files/495417#495417
- https://stackoverflow.com/questions/54273438/merging-two-csv-files-cant-get-rid-of-newline/54274740#54274740
- https://stackoverflow.com/questions/54273622/convert-entry-log-csv-to-list-of-names-based-on-whether-they-entered-on-each-d/54275979#54275979
- https://stackoverflow.com/questions/54277980/split-large-csv-file-into-several-based-on-condition/54280028#54280028
- https://askubuntu.com/questions/1109777/move-specific-column-from-csv-file-in-front-select-column-by-name/1111476#1111476
- https://stackoverflow.com/questions/54312302/need-to-replace-specific-text-in-csv-file-using-batch-script/54314203#54314203
- https://stackoverflow.com/questions/54317248/converting-from-field-value-format-to-csv/54317558#54317558
- https://stackoverflow.com/questions/54353222/how-to-re-pivot-data-in-bash/54356470#54356470
- https://stackoverflow.com/questions/54363812/add-trailing-commas-to-ensure-csv-rows-have-same-number-of-columns/54368097#54368097
- https://unix.stackexchange.com/questions/497716/to-get-average-of-columns-for-all-the-entries-whose-first-column-entries-are-dup/497884#497884
- https://unix.stackexchange.com/questions/498132/removing-duplicate-entries-and-replacing-it-with-comma-bash/498150#498150
- https://unix.stackexchange.com/questions/499352/how-to-generate-a-pivotal-table/499444#499444
- https://stackoverflow.com/questions/54594951/delete-all-line-after-a-specific-date/54596152#54596152
- https://stackoverflow.com/questions/54661258/remove-rows-based-on-values-in-a-column/54664933#54664933
- https://stackoverflow.com/questions/54679856/text-processing-csv-file-truncate-digits-without-rounding/54680559#54680559
- https://stackoverflow.com/questions/54678054/whats-the-best-practice-to-scan-a-text-file-on-linux-for-quality-checking-patt/54680780#54680780
- https://unix.stackexchange.com/questions/501550/how-to-extract-fields-from-a-csv-i-e-comma-separated-where-some-of-the-fields-ha/501635#501635
- https://unix.stackexchange.com/questions/502368/output-to-last-column-depending-on-first-column-if-is-greater-less-than-or-equa/502377#502377
- https://stackoverflow.com/questions/17752072/combining-multiple-csv-files/54855980#54855980
- https://unix.stackexchange.com/questions/504891/how-could-i-painlessly-split-or-reverse-last-first-within-a-record-in-mille/504978#504978
- https://askubuntu.com/questions/1122680/comparing-the-content-and-produce-new-file/1124822#1124822
- https://stackoverflow.com/questions/55124218/merge-2-csv-files-via-batch/55125480#55125480
- https://stackoverflow.com/questions/55149498/how-can-i-count-the-rows-of-a-csv-with-only-the-linux-terminal/55151056#55151056
- https://unix.stackexchange.com/questions/507719/creating-new-columns/507778#507778
- https://askubuntu.com/questions/1127670/delete-multiple-columns-using-awk-or-sed/1127741#1127741
- https://stackoverflow.com/questions/55368375/copy-first-column-to-new-column-renamed-header-at-end-in-csv-with-mac-terminal/55371953#55371953
- https://stackoverflow.com/questions/51233041/how-to-format-csv-into-multiline-newline-delimited-plain-text-output-using-csvki/55529867#55529867
- https://unix.stackexchange.com/questions/511658/getting-values-from-comma-seperated-file/511706#511706
- https://unix.stackexchange.com/questions/511773/how-to-compare-two-csv-files-and-display-unique-records/511831#511831
- https://stackoverflow.com/questions/55602163/is-there-a-way-to-parse-multiple-lines-to-a-single-line-by-merging-duplicates-an/55627219#55627219
- https://unix.stackexchange.com/questions/512169/how-to-rename-output-of-split-command-to-match-the-first-word-in-each-line/512178#512178
- https://stackoverflow.com/questions/55685497/split-huge-csv-by-columns-with-miller/55687128#55687128
- https://stackoverflow.com/questions/55743810/check-if-value-of-column-1-exists-anywhere-in-column-2-write-result-to-column-3/55750730#55750730
- https://superuser.com/questions/1432161/how-to-filter-value-in-csv-with-batch-and-show-the-output-to-txt/1432211#1432211
- https://stackoverflow.com/questions/41842304/reshaping-from-wide-to-long-format/56073938#56073938
- https://unix.stackexchange.com/questions/520031/pivot-file-values/520468#520468
- https://stackoverflow.com/questions/56257428/parsing-csv-which-contains-json/56261697#56261697
- https://unix.stackexchange.com/questions/520492/merging-csv-files-with-key-columns/520513#520513
- https://unix.stackexchange.com/questions/522046/how-to-convert-a-3-column-csv-file-into-a-table-or-matrix/522550#522550
- https://stackoverflow.com/questions/56440446/how-to-unstack-data-from-one-column-to-multiple-column/56441388#56441388
- https://unix.stackexchange.com/questions/523479/convert-rows-into-columns-in-bash-shell-script/523735#523735
- https://unix.stackexchange.com/questions/524169/comparing-two-csv-files-and-write-into-3rd-file/524212#524212
- https://askubuntu.com/questions/1153856/csv-to-tsv-without-replacing-commas-within-quotes/1153968#1153968
- https://unix.stackexchange.com/questions/527563/how-to-add-new-column-with-constant-value-in-a-text-file/527614#527614
- https://gis.stackexchange.com/questions/328580/finding-maximum-distribution-between-multiple-columns/328617#328617
- https://datascience.stackexchange.com/questions/55879/file-format-where-column-names-are-repeated-on-each-row/55917#55917
- https://unix.stackexchange.com/questions/532043/unable-to-simply-use-tr-to-convert-a-tab-delimited-variable-file-to-a-comma-deli/532119#532119
- https://unix.stackexchange.com/questions/532092/split-file-lines-based-on-first-field/532123#532123
- https://stackoverflow.com/questions/57226479/conditional-append-of-strings-on-fields-in-a-csv-file/57231210#57231210
- https://unix.stackexchange.com/questions/533490/joining-merging-csv-files-that-do-not-share-all-their-headers-column/533601#533601
- https://unix.stackexchange.com/questions/450915/merging-multiple-csv-files-for-matching-and-non-matching-columns/533605#533605
- https://stackoverflow.com/questions/57388777/get-difference-between-two-csv-files-based-on-column-using-bash/57389381#57389381
- https://unix.stackexchange.com/questions/535351/extract-file-with-two-matched-strings-at-the-same-time/535378#535378
- https://unix.stackexchange.com/questions/535518/nested-loops-for-text-file/535591#535591
- https://stackoverflow.com/questions/57586507/reading-large-csv-and-splitting-it-into-smaller-chunks/57587030#57587030
- https://stackoverflow.com/questions/57672681/bash-grep-lines-from-csv-based-on-column-3-if-length-is-6-chars-numbers/57673347#57673347
- https://stackoverflow.com/questions/57874901/how-to-split-csv-rows-then-duplicate-that-row/57877936#57877936
- https://stackoverflow.com/questions/57978050/how-to-flatten-this-json-as-a-tsv/57978379#57978379
- https://unix.stackexchange.com/questions/542539/replace-the-content-of-specific-cells-in-a-tsv-file-with-the-edited-content-of-o/542565#542565
- https://unix.stackexchange.com/questions/543221/given-pattern-replacement-with-comma/543311#543311
- https://unix.stackexchange.com/a/544059/195582
- https://unix.stackexchange.com/questions/543726/split-the-content-of-a-specific-column-with-variable-number-of-strings/544063#544063
- https://unix.stackexchange.com/questions/544163/csv-dataset-to-text-dataset/544166#544166
- https://stackoverflow.com/questions/58128032/splitting-a-column-into-two-columns-base-on-a-separator-in-csv-file-using-awk/58146864#58146864
- https://askubuntu.com/questions/1178129/compare-2-cols-when-1st-col-2nd-col-remove-2nd-col/1178661#1178661
- https://askubuntu.com/questions/1178592/count-number-of-different-name-in-a-file/1178739#1178739
- https://unix.stackexchange.com/questions/545343/extract-columns-with-certain-characters-and-store-them-in-separate-file/545356#545356
- https://stackoverflow.com/questions/58271333/create-a-csv-file-from-json-data-using-jq/58277093#58277093
- https://unix.stackexchange.com/questions/545788/compare-2-comma-separated-files-and-output-the-difference/545937#545937
- https://stackoverflow.com/questions/58327627/how-to-split-a-csv-file-such-that-first-column-stays/58330927#58330927
- https://unix.stackexchange.com/questions/546910/merge-csv-files-based-on-id-even-when-unmatched-ids-and-indefinite-number-of-col/547056#547056
- https://stackoverflow.com/questions/45484459/how-to-edit-a-cell-in-a-csv-file/58412431#58412431
- https://stackoverflow.com/questions/58431657/how-to-parse-a-complicated-csv-file-with-in-r/58433337#58433337
- https://stackoverflow.com/questions/58459956/edit-a-csv-column-through-another-column/58461626#58461626
- https://stackoverflow.com/questions/58603534/how-to-import-nested-json-file-into-google-sheets-with-some-missing-keyvalue-pa/58630961#58630961
- https://askubuntu.com/questions/1184179/how-to-rename-the-exisitng-cell-names-based-on-number-of-their-occurnaces-in-a-p/1185056#1185056
- https://stackoverflow.com/questions/58627542/remove-quotes-from-all-columns-with-awk/58638816#58638816
- https://unix.stackexchange.com/questions/550676/sum-of-even-and-odd-numbers-of-odd-and-even-lines/550736#550736
- https://stackoverflow.com/questions/58786303/transform-csv-file-into-a-flat-file-for-pandas/58790398#58790398
- https://unix.stackexchange.com/questions/551162/combine-file-data-sort-on-chromosome-position-next-to-each-other-column-vise/551417#551417
- https://stackoverflow.com/questions/58677751/how-to-merge-rows-in-openrefine/58814336#58814336
- https://stackoverflow.com/questions/58961650/merge-content-of-two-csv-file-side-by-side-in-bash/58964168#58964168
- https://stackoverflow.com/questions/59041187/sorting-csv-file-based-on-column-2-only/59041272#59041272
- "How to add new columns to CSVs with the same text in all lines" https://askubuntu.com/questions/1193534/how-to-add-new-columns-to-csvs-with-the-same-text-in-all-lines/1193544#1193544
- "csv text-processing question" https://unix.stackexchange.com/questions/555643/csv-text-processing-question/555667#555667
- "how to keep rows if there are a certain number of observations based on the first column?" https://unix.stackexchange.com/questions/558147/how-to-keep-rows-if-there-are-a-certain-number-of-observations-based-on-the-firs/558258#558258
- "Add Column to CSV based on Filename" https://stackoverflow.com/questions/59422250/batch-script-add-column-to-csv-based-on-filename/59426724#59426724
- "Concatenating columns of the same csv file to create a new column with a new heading" https://unix.stackexchange.com/a/558359/195582
- "How can I replace strings in a given column of a table using awk and regex?" https://unix.stackexchange.com/a/558362/195582
- "JSON -> csv creating header line and padding header if found empty field" https://unix.stackexchange.com/questions/507005/json-csv-creating-header-line-and-padding-header-if-found-empty-field/560690#560690
- "How to convert yaml to csv file format?" https://askubuntu.com/questions/941477/how-to-convert-yaml-to-csv-file-format/1201270#1201270
- "Shard CSV based on time values" https://stackoverflow.com/questions/59673777/shard-csv-based-on-time-values/59682909#59682909
- "How to parse Stdout as a mix of CSV and JSON?" https://unix.stackexchange.com/questions/561467/how-to-parse-stdout-as-a-mix-of-csv-and-json/561576#561576
- "How to use awk for joining two csv using a key column and write a another csv" https://unix.stackexchange.com/questions/560266/how-to-use-awk-for-joining-two-csv-using-a-key-column-and-write-a-another-csv/561580#561580
- "How to extract column name (header) from a CSV file which contains the max value in a row?" https://unix.stackexchange.com/questions/217817/how-to-extract-column-name-header-from-a-csv-file-which-contains-the-max-value/562350#562350
- "Need help to JOIN two CSV files" https://stackoverflow.com/questions/59913035/need-help-grepping-from-csv/59916638#59916638
- "Applying sort -u to one specific column in a CSV file?" https://stackoverflow.com/questions/59924061/applying-sort-u-to-one-specific-column-in-a-csv-file/59946495#59946495
- "compare the values of 2 files and merge the similar entries" https://stackoverflow.com/questions/60024879/compare-the-values-of-2-files-and-merge-the-similar-enteries/60025241#60025241
- "How to split one column into two based on a certain character?" https://unix.stackexchange.com/questions/565537/how-to-split-one-column-into-two-based-on-a-certain-character/565541#565541
- "SSV/CSV Manipulation: Calculate Ratios" https://unix.stackexchange.com/a/566055/195582
- "Column transposition according to two values" https://unix.stackexchange.com/questions/566096/column-transposition-according-to-two-values/566098#566098
- "Bash - Removing empty columns from .csv file" https://stackoverflow.com/questions/60098400/bash-removing-empty-columns-from-csv-file/60134937#60134937
- "Merge 3 .csv into one file with different number of columns" https://superuser.com/questions/1523440/merge-3-csv-into-one-file-with-different-number-of-columns/1524270#1524270
- "csv file - remove line feed in the middle of string" https://stackoverflow.com/questions/60177576/csv-file-remove-line-feed-in-the-middle-of-string/60178030#60178030
- "How to get data for past hour, 6h, 24h from CSV log file with awk, sed or other?" https://stackoverflow.com/questions/60365724/how-to-get-data-for-past-hour-6h-24h-from-csv-log-file-with-awk-sed-or-other/60371907#60371907
- "How to add a value of the variable at the beginning of a csv file" https://stackoverflow.com/questions/60379142/how-to-add-a-value-of-the-variable-at-the-beginning-of-a-csv-file/60390718#60390718
- "Convert JSON array into CSV", https://unix.stackexchange.com/questions/570548/convert-json-array-into-csv/570571#570571
- "How to combine TSV file" https://askubuntu.com/a/1217868/796708
- "How to put pivot table using Shell script" https://stackoverflow.com/questions/61186811/how-to-put-pivot-table-using-shell-script/61204513#61204513
- "Bash script to add double quotes in .CSV comma delimited file" https://stackoverflow.com/questions/61220101/bash-script-to-add-double-quotes-in-csv-comma-delimited-file/61244777#61244777
- "How can I delete from a file every second and fourth comma separated word using sed?" https://unix.stackexchange.com/questions/581068/how-can-i-delete-from-a-file-every-second-and-fourth-comma-separated-word-using/581072#581072
- "How to append additional text found in a duplicate entry to the original text" https://superuser.com/questions/1540589/how-to-append-additional-text-found-in-a-duplicate-entry-to-the-original-text/1543477#1543477
- "Concatenate matching ids from two files, with other columns from both files" https://unix.stackexchange.com/questions/583795/concatenate-matching-ids-from-two-files-with-other-columns-from-both-files/583821#583821
- "I want to convert list of json files to csv with only specific attributes" https://stackoverflow.com/questions/61819131/i-want-to-convert-list-of-json-files-to-csv-with-only-specific-attributes/61835027#61835027
- "CSV Filtering a column with mixed data types" https://stackoverflow.com/a/62099705/757714
- "(AWK) Csv separating same variables in columns into different files" https://unix.stackexchange.com/questions/590911/awk-csv-separating-same-variables-in-columns-into-different-files/591041#591041
- "GROUP BY CSV columns in bash" https://stackoverflow.com/questions/62252413/group-by-csv-columns-in-bash/62258153#62258153
- "vlookup using UNIX shell" https://unix.stackexchange.com/questions/592517/vlookup-using-unix-shell/592980#592980
- "Querying csv files like sql" https://unix.stackexchange.com/questions/593939/querying-csv-files-like-sql/594193#594193
- "Filling in blank spaces in the first column of a csv file using Bash / awk" https://unix.stackexchange.com/questions/601138/filling-in-blank-spaces-in-the-first-column-of-a-csv-file-using-bash-awk/602193#602193
- "Log search within date range" https://unix.stackexchange.com/questions/604588/log-search-within-date-range/604736#604736
- "Find value from one csv in another one (like vlookup) in bash (Linux)" https://stackoverflow.com/questions/10697724/find-value-from-one-csv-in-another-one-like-vlookup-in-bash-linux/63666127#63666127
- "Manipulate csv file using bash script or python, converting certain columns into rows" https://askubuntu.com/a/1273008/796708
- "Handle CSV data: Separate data with a comma" https://stackoverflow.com/questions/63999865/handle-csv-data-separate-data-with-a-comma/64012427#64012427
- "How to “Partial-Transpose-and-Duplicate” rows in a CSV with a CSV command line tool" https://stackoverflow.com/questions/64220427/how-to-partial-transpose-and-duplicate-rows-in-a-csv-with-a-csv-command-line-t/64240640#64240640
- "Csv trasform one row in 4 row" https://stackoverflow.com/questions/64322327/csv-trasform-one-row-in-4-row/64332420#64332420
- "Grep the data only (-o) and the first column", https://unix.stackexchange.com/questions/615597/grep-the-data-only-o-and-the-first-column/617644#617644
- "sorting a csv file with 3 columns", https://askubuntu.com/questions/1277136/sorting-a-csv-file-with-3-columns/1295780#1295780
- "How do I print all lines of a file with duplicate values in a certain column", https://unix.stackexchange.com/questions/255563/how-do-i-print-all-lines-of-a-file-with-duplicate-values-in-a-certain-column/621876#621876
- "Parsing through Bash", https://stackoverflow.com/questions/65208302/parsing-through-bash/65213118#65213118
- "I need an efficient method to combine thousands of csv files", https://unix.stackexchange.com/questions/625168/i-need-an-efficient-method-to-combine-thousands-of-csv-files/625194#625194
- "Compare csv files based on column value", https://stackoverflow.com/questions/65592814/compare-csv-files-based-on-column-value/65608417#65608417
- "How to rearrange columns when you don't know their initial positions (UNIX, BASH)", https://superuser.com/questions/1618362/how-to-rearrange-columns-when-you-dont-know-their-initial-positions-unix-bash/1618583#1618583
- "Sort multiple columns in csv including date stored as dd/mm/yyyy", https://unix.stackexchange.com/a/632204/195582
- "How to get the pivot lines from two tab-separated files?", https://stackoverflow.com/questions/66121376/how-to-get-the-pivot-lines-from-two-tab-separated-files/66167539#66167539
- "grep output from long to wide", https://unix.stackexchange.com/questions/634364/grep-output-from-long-to-wide/634376#634376
- "Adding CSV layer to QGIS when X and Y fields are the same", https://gis.stackexchange.com/questions/388039/adding-csv-layer-to-qgis-when-x-and-y-fields-are-the-same/388042#388042
- "How to split the data from two columns based on two different delimiters in a Redshift database?", https://stackoverflow.com/questions/66359957/how-to-split-the-data-from-two-columns-based-on-two-different-delimiters-in-a-re/66412025#66412025
- "How to convert a CSV (with quote) to TSV?", https://stackoverflow.com/questions/66422944/how-to-convert-a-csv-with-quote-to-tsv/66435748#66435748
- "converting space separated file into csv format in linux", https://stackoverflow.com/questions/66456419/converting-space-separated-file-into-csv-format-in-linux/66477278#66477278
- "Bash to send variable value to csv?", https://unix.stackexchange.com/questions/650580/bash-to-send-variable-value-to-csv/650724#650724
- "awk extract columns that meet condition", https://unix.stackexchange.com/a/651415/195582
- "Is it possible to rename multiple columns of a CSV to empty columns when using miller?", https://stackoverflow.com/a/68452078/757714
- "How to merge multiple Mac excel files all with headers that are the same but out of order", https://superuser.com/questions/1666750/how-to-merge-multiple-mac-excel-files-all-with-headers-that-are-the-same-but-out/1666899#1666899
- "How to extract columns by names from CSV file?", https://unix.stackexchange.com/questions/663701/how-to-extract-columns-by-names-from-csv-file/663792#663792
And we have the first accepted answer https://unix.stackexchange.com/questions/430199/output-a-header-label-in-data-field-in-miller/492541#492541 (the one related to #215 )
The second miller answer chosen as the right one :) https://unix.stackexchange.com/questions/492434/sed-delete-csv-column-if-exists/492534#492534
The third miller answer chosen as the right one :) https://unix.stackexchange.com/questions/494259/getting-file-as-rows-and-columns-data-matrix/494273#494273
Another Miller answer chosen as the right one: https://stackoverflow.com/a/54317558/757714
Another Miller answer chosen as the right one: https://unix.stackexchange.com/questions/504891/how-could-i-painlessly-split-or-reverse-last-first-within-a-record-in-mille/504978#504978
Another Miller answer chosen as the right one (it's not a great reply): https://stackoverflow.com/questions/55149498/how-can-i-count-the-rows-of-a-csv-with-only-the-linux-terminal/55151056#55151056
Another Miller answer chosen as the right one: https://stackoverflow.com/questions/55368375/copy-first-column-to-new-column-renamed-header-at-end-in-csv-with-mac-terminal/55371953#55371953
Another Miller answer chosen as the right one: https://stackoverflow.com/questions/51233041/how-to-format-csv-into-multiline-newline-delimited-plain-text-output-using-csvki/55529867#55529867
Another Miller answer chosen as the right one: https://stackoverflow.com/questions/55685497/split-huge-csv-by-columns-with-miller/55687128#55687128
Another Miller answer chosen as the right one: https://stackoverflow.com/a/56441388/757714
How about a miller tag? I don't have enough points (Awarded at: 1,500 reputation)
Hi @f3rn4nd0-c354r there is the tag in unix.stackexchange.
It would be useful to add it in "generic" stackoverflow, I cannot do it because I have 2.3k network reputation, but only 890 in stackoverflow :(
I have no time to work on it, but maybe something (at least part of it) for 'miller': https://gis.stackexchange.com/q/328580/5256?
@NikosAlexandris this is my answer https://gis.stackexchange.com/a/328617/466 (I hope to be useful)
Another Miller answer chosen as the right one: https://datascience.stackexchange.com/a/55917/65128
Another Miller answer chosen as the right one: https://datascience.stackexchange.com/questions/55879/file-format-where-column-names-are-repeated-on-each-row/55917#55917
Another Miller answer chosen as the right one: https://unix.stackexchange.com/questions/492434/sed-delete-csv-column-if-exists/492534#492534
Another Miller answer chosen as the right one: https://stackoverflow.com/questions/58603534/how-to-import-nested-json-file-into-google-sheets-with-some-missing-keyvalue-pa/58630961#58630961
Another Miller answer chosen as the right one: "Sum of even and odd numbers of odd and even lines" https://unix.stackexchange.com/questions/550676/sum-of-even-and-odd-numbers-of-odd-and-even-lines/550736#550736
How about a miller tag? I don't have enough points (Awarded at: 1,500 reputation)
@f3rn4nd0-c354r Finally we have it :) https://github.com/johnkerl/miller/issues/288
Another Miller answer chosen as the right one: "How to add new columns to CSVs with the same text in all lines" https://askubuntu.com/a/1193544/796708
Another Miller answer chosen as the right one: "Create .jsonl files from .csv" https://stackoverflow.com/questions/59472551/create-jsonl-files-from-csv/59472641#59472641
Another Miller answer chosen as the right one: "Column transposition according to two values" https://unix.stackexchange.com/a/566098/195582
Another Miller answer chosen as the right one: "Advance CSV reader to parsing string in linux" https://stackoverflow.com/a/61116317/757714
Another Miller answer chosen as the right one: "How to put pivot table using Shell script" https://stackoverflow.com/questions/61186811/how-to-put-pivot-table-using-shell-script/61204513#61204513
Another Miller answer chosen as the right one: "vlookup using UNIX shell" https://unix.stackexchange.com/a/592980/195582