// Basic usage without column structure
const csvFile = new CSVFile("data.csv");
const rowCount = await csvFile.getRowCount();
const firstRow = await csvFile.getRow(0);

// With typed column structure
const typedCSV = new CSVFile("users.csv", {
  name: 0,
  email: 1,
  age: 2
});

const user = await typedCSV.getRow(0);
console.log(user.name, user.email, user.age); // Type-safe access

// Filtering and mapping
const adults = await csvFile.filter(row => parseInt(row.age) >= 18);
const names = await csvFile.map(row => row.name.toUpperCase());

// Writing data to CSV
await CSVFile.writeToFile(
  [{ name: "John", email: "john@example.com" }],
  "output.csv",
  { name: 0, email: 1 }
);

// Simple CSV file
const csv = new CSVFile("data.csv");

// With column structure for type safety
const csv = new CSVFile("users.csv", {
  id: 0,
  name: 1,
  email: 2
});

// With custom parsing options
const csv = new CSVFile("data.tsv", undefined, {
  delimiter: "\t",
  hasHeader: false,
  quoteChar: "'"
});

const columnCount = await csv.getColumnCount();
console.log(`CSV has ${columnCount} columns`);

const headers = await csv.getHeader();
console.log("Columns:", headers); // ["name", "email", "age"]

const row = await csvFile.getRow(0);
console.log(row);
// { column1: "value1", column2: "value2" } (if column structure is provided)
// OR
// ["value1", "value2"] (if column structure is not provided)

const csv = new CSVFile("large-dataset.csv");
const totalRows = await csv.getRowCount();
console.log(`Dataset contains ${totalRows} records`);

const data = [
    { column1: "value1", column2: "value2" },
    { column1: "value3", column2: "value4" },
];
await CSVFile.writeToFile(
    data,
    "path/to/output.csv",
    { column1: 0, column2: 1 }
);