VisiData: come generare un tabella pivot

by aborruso 5 years ago

GNU/Linux ◆ xterm-256color ◆ zsh 161 views

Verrà presa come esempio una tabella così fatta (sono i residenti per etnia nel comune di Milano nel 2018), estrapolata dai dati pubblicati qui https://github.com/opendatasicilia/tansignari/issues/67#issue-442804855

Anno	IdNil	Nil	Eta	Genere	Cittadinanza	Residenti
2018	1	Duomo	0	Femmine	Australia	1
2018	1	Duomo	0	Femmine	Austria	1
2018	1	Duomo	0	Femmine	Italia	39
2018	1	Duomo	0	Femmine	Perù	2
2018	1	Duomo	0	Femmine	Sri Lanka (ex Ceylon)	1
2018	1	Duomo	0	Maschi	Filippine	2
2018	1	Duomo	0	Maschi	Italia	48
2018	1	Duomo	0	Maschi	Sri Lanka (ex Ceylon)	1
2018	1	Duomo	1	Femmine	Cinese, Rep. Popolare	1
2018	1	Duomo	1	Femmine	Filippine	2

Questi gli step:

vd nomefile.csv;
poi si imposta a numerica la colonna “Residenti” facendo click su #;
poi sulla colonna residenti si fa click su + e si sceglie sum come funzione di aggregazione;
poi si impostano come colonne chiave la colonna “Cittadinanza” e poi “Nil”, facendo click su !;
poi sulla colonna “Genere” si da click su SHIFT+w
poi si ordina per colonne chiave con g+[.

L’output è

Nil	Cittadinanza	Residenti_sum_Femmine	Residenti_sum_Maschi	Total_Residenti_sum	Total_count
Adriano	Afghanistan	0	25	25	12
Adriano	Albania	40	37	77	58
Adriano	Algeria	1	15	16	14
Adriano	Apolide	0	3	3	3
Adriano	Argentina	5	4	9	8
Adriano	Armenia	4	4	8	8
Adriano	Australia	1	1	2	2
Adriano	Azerbaigian	0	1	1	1
Adriano	Bangladesh	32	87	119	56
Adriano	Benin (ex Dahomey)	0	1	1	1

More by aborruso

Visidata: wide to long (Melting) 01:23

by aborruso 5 years ago

untitled 00:26

by aborruso 5 years ago

Dati ARPA Veneto, da JSON a CSV a riga di comando 00:02

by aborruso 6 years ago

VisiData: wide to long conversion 01:49

by aborruso 5 years ago

See all

You can download this recording in asciicast v2 format, as a .cast file.

Download

Replay in terminal

You can replay the downloaded recording in your terminal using the asciinema play command:

asciinema play 245472.cast

If you don't have asciinema CLI installed then see installation instructions.

Use with stand-alone player on your website

Download asciinema player from the releases page (you only need .js and .css file), then use it like this:

<!DOCTYPE html>
<html>
<head>
  <link rel="stylesheet" type="text/css" href="asciinema-player.css" />
</head>
<body>
  <div id="player"></div>
  <script src="asciinema-player.min.js"></script>
  <script>
    AsciinemaPlayer.create(
      '/assets/245472.cast',
      document.getElementById('player'),
      { cols: 157, rows: 38 }
    );
  </script>
</body>
</html>

See asciinema player quick-start guide for full usage instructions.

While this site doesn't offer GIF conversion at the moment, you can still do it yourself with the help of asciinema GIF generator utility - agg.

Once you have it installed run the following command to create GIF file:

agg https://asciinema.org/a/245472 245472.gif

Or, if you already downloaded the recording file:

agg 245472.cast 245472.gif

Check agg --help for all available options. You can change font family and size, select color theme, adjust speed and more.

See agg manual for full usage instructions.