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:
- 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
✍✍✍✍✍✍✍✍✍✍✍✍✍✍
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