Working with CSV

Comprehensive CSV and TSV file handling with automatic format detection, advanced header processing, and high-performance data operations.

Introduction

Tip

You can use loadTable and saveTable from dpkit instead of @dpkit/csv to load and save CSV files if the framework can infer that files are in the csv/tsv format.

The CSV plugin is a part of the dpkit ecosystem providing these capabilities:

• loadCsvTable
• saveCsvTable
• inferCsvDialect

For example:

import { loadCsvTable } from "@dpkit/csv"

const table = await loadCsvTable({path: "table.csv"})
// the field types will be automatically inferred
// or you can provide a Table Schema

Basic Usage

Loading CSV Files

import { loadCsvTable } from "@dpkit/csv"

// Load a simple CSV file
const table = await loadCsvTable({ path: "data.csv" })

// Load with custom dialect
const table = await loadCsvTable({
  path: "data.csv",
  dialect: {
    delimiter: ";",
    header: true,
    skipInitialSpace: true
  }
})

// Load multiple CSV files (concatenated)
const table = await loadCsvTable({
  path: ["part1.csv", "part2.csv", "part3.csv"]
})

Saving CSV Files

import { saveCsvTable } from "@dpkit/csv"

// Save with default options
await saveCsvTable(table, { path: "output.csv" })

// Save with custom dialect
await saveCsvTable(table, {
  path: "output.csv",
  dialect: {
    delimiter: "\t",
    quoteChar: "'"
  }
})

Dialect Detection

import { inferCsvDialect } from "@dpkit/csv"

// Automatically detect CSV format
const dialect = await inferCsvDialect({ path: "unknown-dialect.csv" })
console.log(dialect) // { delimiter: ",", header: true, quoteChar: '"' }

// Use detected dialect to load
const table = await loadCsvTable({
  path: "unknown-dialect.csv",
  dialect
})

Advanced Features

Multi-Header Row Processing

// CSV with multiple header rows:
// Year,2023,2023,2024,2024
// Quarter,Q1,Q2,Q1,Q2
// Revenue,100,120,110,130

const table = await loadCsvTable({
  path: "multi-header.csv",
  dialect: {
    headerRows: [1, 2],
    headerJoin: "_"
  }
})
// Resulting columns: ["Year_Quarter", "2023_Q1", "2023_Q2", "2024_Q1", "2024_Q2"]

Comment Row Handling

// CSV with comment rows:
// # This is a comment
// # Generated on 2024-01-01
// Name,Age,City
// John,25,NYC

const table = await loadCsvTable({
  path: "with-comments.csv",
  dialect: {
    commentRows: [1, 2],
    header: true
  }
})

Remote File Loading

// Load from URL
const table = await loadCsvTable({
  path: "https://example.com/data.csv"
})

// Load multiple remote files
const table = await loadCsvTable({
  path: [
    "https://api.example.com/data-2023.csv",
    "https://api.example.com/data-2024.csv"
  ]
})