VisiData: Data Cleaning Joining Rows

by frosencrantz 3 years ago

GNU/Linux ◆ xterm-256color ◆ bash 1056 views

i - addcol-incr

] - sort it

= cname if A%2 == 0 else None

‘ freeze new col

‘-‘ remove the original (it is not fillable)

gs - select all rows

f - fill Nulls.

gu - unselect all

C - column sheet

zK 1 - move column left 1

s - select two columns to join

& join

q - back to sheet

z| A%2 == 1 - select odd rows

“ - prune table

Used for: https://github.com/saulpw/visidata/discussions/977

More by frosencrantz

Visidata open-colors sheet 00:14

by frosencrantz 3 years ago

Empty frozen column from duplicate DirSheet 00:20

by frosencrantz 3 years ago

VisiData: Create Sample Dirty Data out of help-commands-all 01:06

by frosencrantz 3 years ago

jc + VisiData 01:59

by frosencrantz 1 year 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 415793.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/415793.cast',
      document.getElementById('player'),
      { cols: 149, rows: 47 }
    );
  </script>
</body>
</html>

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

While this site doesn't provide 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, generate a GIF with the following command:

agg https://asciinema.org/a/415793 demo.gif

Or, if you already downloaded the recording file:

agg demo.cast demo.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.