qsv cheat sheet

The infographic may be outdated so feel free to update it if so.

Typst source code

#import "@preview/cram-snap:0.1.0": cram-snap

#set page(
  paper: "us-letter",
  flipped: true,
  margin: 1in,
)
#set text(font: "Arial", size: 11pt)

#show: cram-snap.with(
  title: [Explore several qsv use cases],
  column-number: 1 // or 2
)

#set align(center)
#link("https://github.com/jqnatividad/qsv")[qsv] is a spreadsheet data wrangling command-line tool.

#table(
  table.header[Data analysis],
  [`qsv count <path>`], [Print the total non-header row count (to add the header row include `-n`)],
  [`qsv headers <path> --just-count`], [Print the total column count],
  [`qsv stats <path>`], [Print statistical data for each column],
  [`qsv stats <path> -E`], [Print statistical data for each column (can take longer but adds more stats)],
  [`qsv frequency <path>`], [Print frequency data for each column],
  [`qsv sniff <path>`], [Attempt inferring/printing metadata],
  [`qsv search <regex> <path>`], [Print rows that have a field which match the given regular expression],
  [`qsv search <literal> <path> --literal`], [Print rows that have a field which match the given literal string (text)]
)

#table(
  table.header[`qsv slice`],
  [`qsv slice <path> -s 0 -e 100`], [Print the first 100 non-header rows],
  [`qsv slice <path> -s 0 -e 100 -n`], [Print the first 100 rows],
  [`qsv slice <path> -s 0 -e 100 --json`], [Print the first 100 non-header rows in JSON format],
  [`qsv slice <path> -o <path.X>`], [Replace the file extension `X` with any of: `csv`, `tsv`, `tab`, `ssv`, and further add `.sz` to any of the extensions to get a Snappy compressed file]
)