Skip to main content
SimilarExport ZIP
100%

Useful csvkit commands

✓ Published0🌍 Public
WWilliamQLiu
Last edited Jan 21, 2015
Created on Jan 19, 2015

This example demonstrates the versatility of csvkit, a command-line toolkit for working with tabular data, by presenting a collection of common workflows. It shows how to inspect, filter, merge, and transform CSV files using commands like `csvstat`, `csvcut`, `csvlook`, and `csvgrep`. The visualization highlights chaining commands with pipes to combine operations, such as using `csvsql` for SQL queries and joins across multiple files, `csvjson` to convert data into JSON or GeoJSON, and `csvstack` to merge datasets. It also covers importing and exporting data to and from SQL databases via `csvsql` and `sql2csv`, using Postgres and MSSQL connection strings.

AI-generated description

Similar vizzes

Loading thumbnail…

csv2tsv

This example converts comma-separated values to tab-separated values in a single pass. It parses a CSV file from disk using `d3.csv.parse` and immediately formats the resulting data structure as TSV with `d3.tsv.format`. The tool reads its input from a file path provided as a command-line argument and writes the converted output to standard output, enabling easy redirection. The code relies on the `d3` library and Node.js’s `fs` module for file access, and it is intended to be run as an executable script.

Mmbostock
62% match
Loading thumbnail…

Gist 585199

This visualization loads an external CSV file and parses its rows into JavaScript objects, mapping each column name from an array to the corresponding values in each line. It handles quoted fields that contain commas by merging split segments until the quote count is even, and it logs warnings for malformed lines that do not match the expected number of columns. The example demonstrates a reusable CSV-asynchronous-loading helper, but does not show any charting, layout, or rendering code beyond the data preparation stage.

RRandomEtc
61% match
Loading thumbnail…

Loading and Parsing CSV Data

This example demonstrates how to load and parse CSV data using D3 v5. It displays the file size, row count, and column count of a wildlife trade dataset pulled from a GitHub gist. The primary approach uses `d3.csv`, which fetches and parses the CSV in one step, while commented-out alternatives show `fetch` with `async`/`await` combined with `d3.csvParse`. The results appear as large text in a `pre` element, providing a simple, immediate visual summary of the dataset’s basic dimensions.

KKarenNg
61% match
Loading thumbnail…

Loading and Parsing CSV Data

This example demonstrates how to load and parse CSV data using D3 v5. It displays the file size, row count, and column count of a wildlife trade dataset pulled from a GitHub gist. The primary approach uses `d3.csv`, which fetches and parses the CSV in one step, while commented-out alternatives show `fetch` with `async`/`await` combined with `d3.csvParse`. The results appear as large text in a `pre` element, providing a simple, immediate visual summary of the dataset’s basic dimensions.

KKarenNg
61% match
Loading thumbnail…

Loading and Parsing CSV Data

This example demonstrates how to load and parse CSV data by fetching a remote file and displaying basic statistics about it. The page shows the file size in kilobytes, the total number of rows, and the number of columns. It uses the D3.js library (v7) with the `d3.csv` method to retrieve the data from a GitHub gist containing CSS named colors, and `d3.csvFormat` to calculate the data length. The results are rendered as text in a `<pre>` element.

LLisa Wagner
60% match
Loading thumbnail…

Kaggle-Privatization of Space-csv

This example loads a CSV file of global space launches from a GitHub gist and displays basic file statistics. It shows the dataset’s size in kilobytes, its row count, and its column count as large text. The code uses the d3.csv function to fetch and parse the data, then accesses the results through d3.csvFormat to compute the byte length. It also demonstrates an alternative approach using fetch with async and await in commented-out sections.

TTaylor
60% match
Loading thumbnail…

CSV Fetch and Parse

This example demonstrates a minimal workflow for fetching and parsing remote CSV data with D3. It shows the resulting dataset’s size in kilobytes, row count, and column count in large text on the page. The code uses `d3.csv` to load a CSV file from a GitHub gist and `d3.csvFormat` to measure its string length, while also logging the parsed array to the console. A commented-out alternative shows manual fetching via the Fetch API and parsing with `d3.csvParse`.

AAndres de la Garza
60% match
Loading thumbnail…

Parsing CSV Data with D3

This visualization demonstrates how to parse CSV data using D3.js by fetching a remote file and displaying summary statistics. The page shows the dataset’s row count, column count, and file size in kilobytes within a large text element. It uses D3’s `d3.csv()` function to load and parse the CSV from a GitHub gist, then formats the data with `d3.csvFormat()` to calculate its size. The example also includes commented-out code using `fetch()`, `async`/`await`, and `d3.csvParse()` as an alternative parsing approach.

TTetiana Humeniuk
60% match