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:

✍✍✍✍✍✍✍✍✍✍✍✍✍✍

I do self-funded research and I'm writing a book.

> What's the book about?

About technologies and agency.

Meaning, technologies can foster agency. No doubt. But I am also asking:

Can usage of technologies give us a sense of empowerment while in fact undermining our abilities?

I posted a summary of the prologue on the homepage: https://yctct.com/

✍✍✍✍✍✍✍✍✍✍✍✍✍✍


personal computing command-line interface (cli) gnu linux trisquel shell literacy office applications wiki datamash visidata

No affiliate links, no analytics, no tracking, no cookies. This work © 2016-2024 by yctct.com 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