Tidy Viewer (tv)

Pretty Printing

Contents

Features

Installation

Cargo

cargo install tidy-viewersudo cp /home/$USER/.cargo/bin/tidy-viewer /usr/local/bin/.echo"alias tv='tidy-viewer'">>~/.bashrcsource~/.bashrc

Debian

wget https://github.com/alexhallam/tv/releases/download/<VERSION>/tidy-viewer_<VERSION>_amd64.debsudo dpkg -i tidy-viewer_<VERSION>_amd64.debecho"alias tv='tidy-viewer'">>~/.bashrcsource~/.bashrc

AUR

paru -S tidy-viewer

Snap

sudo snap install --edge tidy-viewer

Homebrew

brew install tidy-viewer

Examples

Diamonds

# Download the diamonds datawget https://raw.githubusercontent.com/tidyverse/ggplot2/master/data-raw/diamonds.csv# pipe to tvcat diamonds.csv| tv

Starwars

wget https://raw.githubusercontent.com/tidyverse/dplyr/master/data-raw/starwars.csv# Pass as argumenttv starwars.csv

Pigeon Racing

wget https://raw.githubusercontent.com/joanby/python-ml-course/master/datasets/pigeon-race/pigeon-racing.csvcat pigeon-racing.csv| tv

Titanic

wget https://raw.githubusercontent.com/datasciencedojo/datasets/master/titanic.csv# send to pager with color# lesstv titanic.csv -ea| less -R# battv titanic.csv -a -n 1000| bat -p

Significant Figure Definitions And Rules

Definitions

     ┌─────┐      ┌─────┐     ─┐     │     │      │     │      │     │     │      │     │      │     │     │      │     │      │     │     │      │     │      │     │     │  ┌┐  │     │      │     └─────┘  └┘  └─────┘    ──┴─   │        │    │                │   └────────┘  ▲ └────────────────┘left hand side │  right hand side     (lhs)     │       (rhs)            decimal

 ┌─────┐      ┌─────┐     ─┐     ┌─────┐ │     │      │     │      │     │     │ │     │      │     │      │     │     │ │     │      │     │      │     │     │ │     │      │     │      │     │     │ │     │  ┌┐  │     │      │     │     │ └─────┘  └┘  └─────┘    ──┴─    └─────┘│                     │         │       │└─────────────────────┘         └───────┘       leading 0s              trailing 0s

 ─┐     ┌─────┐       ─┐  │     │     │        │  │     │     │        │  │     │     │        │  │     │     │        │  │     │     │  ┌┐    │──┴─    └─────┘  └┘  ──┴─                   │        │                   └────────┘              fractional digit(s)

Rules

# Pseudo Code: Sigfig logic assuming sigfig = 3if lhs == 0:    n = ((floor(log10(abs(x))) + 1 - sigfig)    r =(10^n) * round(x / (10^n))    return r    // (0.12345 -> 0.123)else:    if log10(lhs) + 1 > sigfig:        if rhs > 0:            //concatenate:            //(lhs)            //(point)            //(123.45 -> 123.)        else:            //concatenate:            //(lhs)            //(1234.0 -> 1234)            //(100.0 -> 100)    else:        //concatenate:        //(lhs)        //(point)        //sigfig - log10(lhs) from rhs        //(12.345 -> 12.3)        //(1.2345 -> 1.23)

Tools to pair with tv

Tools similar to tv

1. NA comprehension

2. Column Overflow Logic

Configuration Dotfile

FAQ

Help

tv 1.5.2Tidy Viewer (tv) is a csv pretty printer that uses column styling to maximize viewer enjoyment.✨✨📺✨✨    Example Usage:    wget https://raw.githubusercontent.com/tidyverse/ggplot2/master/data-raw/diamonds.csv    cat diamonds.csv | head -n 35 | tv    tv diamonds.csv    Configuration File Support:    An example config is printed to make it easy to copy/paste to `tv.toml`.    Check the parameters you have changed with `tv --config-details`.    The config (tv.toml) location is dependent on OS:* Linux:$XDG_CONFIG_HOME or$HOME/.config/tv.toml* macOS:$HOME/Library/Application Support/tv.toml* Windows: {FOLDERID_RoamingAppData}\tv.toml## ==Tidy-Viewer Config Example==## Remove the first column of comments for valid toml file## All fields must be defined. Partial files will not be read.## The delimiter separating the columns. [default: ,]        #delimiter = ","## Add a title to your tv. Example 'Test Data' [default: NA ("")]        #title = ""## Add a footer to your tv. Example 'footer info' [default: NA ("")]        #footer = ""## The upper (maximum) width of columns. [default: 20]        #upper_column_width = 20## The minimum width of columns. Must be 2 or larger. [default: 2]        #lower_column_width = 2## head number of rows to output <row-display> [default: 25]        #number = 35## extend width and length in terms of the number of rows and columns displayed beyond term width [default: false]        # extend_width_length = true## meta_color = [R,G,B] color for row index and "tv dim: rows x cols"        #meta_color = [64, 179, 162]## header_color = [R,G,B] color for column headers        #header_color = [232, 168, 124]## std_color = [R,G,B] color for standard cell data values        #std_color = [133, 205, 202]## na_color = [R,G,B] color for NA values        #na_color = [226, 125, 95]## neg_num_color = [R,G,B] color for negative values        #neg_num_color = [226, 125, 95]USAGE:    tidy-viewer [FLAGS] [OPTIONS] [FILE]FLAGS:    -C, --config-details             Show the current config details    -d, --debug-mode                 Print object details to make it easier for the maintainer to find and resolve bugs.    -e, --extend-width-and-length    Extended width beyond term width (do not truncate). Useful with `less -S`.    -f, --force-all-rows             Print all rows in file. May be piped to 'less -S'. Example `tidy-viewer                                     data/diamonds.csv -f -a | less -R`    -a, --color-always               Always force color output. Example `tv -a starwars.csv | less -R` or `tv -a                                     starwars.csv | bat -p`. The `less` cli has the `-R` flag to parse colored output.    -h, --help                       Prints help information    -D, --no-dimensions              Turns off dimensions of the data    -R, --no-row-numbering           Turns off row numbering    -V, --version                    Prints version informationOPTIONS:    -c, --color <color>            There are 5 preconfigured color palettes (Defaults to nord):                            (1)nord                            (2)one_dark                            (3)gruvbox                            (4)dracula                            (5)solarized light [default: 0]    -s, --delimiter <delimiter>                      The delimiter separating the columns.    -F, --footer <footer>                            Add a footer to your tv. Example 'footer info' [default: NA]    -l, --lower-column-width <lower-column-width>            The lower (minimum) width of columns. Must be 2 or larger. [default: 2]    -n, --number-of-rows-to-output <row-display>     Show how many rows to display. [default: 25]    -g, --sigfig <sigfig>                            Significant Digits. Default 3. Max is 7 [default: 3]    -t, --title <title>                              Add a title to your tv. Example 'Test Data' [default: NA]    -u, --upper-column-width <upper-column-width>    The upper (maximum) width of columns. [default: 20]ARGS:    <FILE>    File to process

Use With Database Engines

Use With SQLite

wget https://github.com/multiprocessio/dsq/blob/43e72ff1d2c871082fed0ae401dd59e2ff9f6cfe/testdata/taxi.csv.7z?raw=true -O taxi.csv.7z7z x taxi.csv.7zcd testdatals -l --block-size=M# the data is farily large at 192MB

SQLite One-liner

sqlite3 :memory: -csv -header -cmd'.import taxi.csv taxi''SELECT passenger_count, COUNT(*), AVG(total_amount) FROM taxi GROUP BY passenger_count'| tv

sqlite3 -csv -header<file_name.sqlite>'select * from <table>;'| tv

Use With DuckDB

wget https://github.com/multiprocessio/dsq/blob/43e72ff1d2c871082fed0ae401dd59e2ff9f6cfe/testdata/taxi.csv.7z?raw=true -O taxi.csv.7z7z x taxi.csv.7zcd testdatals -l --block-size=M# the data is fairly large at 192MB

Fun Withtv

duckdb --csv -c"select norm1 from norms.csv"| ../target/release/tidy-viewer -f -a| less -R

DuckDB One-liner

duckdb --csv -c"SELECT passenger_count, COUNT(*), AVG(total_amount) FROM taxi.csv GROUP BY passenger_count ORDER BY passenger_count"| tv

Inspiration