June 18, 2024

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.csv

See also:


personal computing command-line interface (cli) gnu linux trisquel shell literacy office applications wiki datamash visidata spreadsheet stuff in the terminal offline

No affiliate links, no analytics, no tracking, no cookies. This work © 2016-2024 by yctct is licensed under CC BY-ND 4.0 .   about me   contact me   all entries & tags   FAQ   GPG public key

GPG fingerprint: 2E0F FB60 7FEF 11D0 FB45 4DDC E979 E52A 7036 7A88