Create a contingency table (a.k.a. cross tabulation) with Datamash
file.csv has two columns with variables, say, with dates in the first one and some names in the second one. I want to create a contingency table with dates in the left column and names in the top row. To do this I can run:
$ datamash -s crosstab 1,2 -t , < file.csv > crosstab.csv Note: the file is coma-separated (.csv) hence the option -t ,.
To display the cross table, I can run:
$ vd crosstab.csvSee also:
- Sum values per group (of a text/data file) from the command line with Datamash
- Display a .csv file as a table in the terminal with Visidata
personal computing command-line interface (cli) gnu linux trisquel shell literacy office applications wiki datamash visidata spreadsheet stuff in the terminal offline text processing
