view release on metacpan or  search on metacpan

README  view on Meta::CPAN

NAME
    Acme::CPANModules::WorkingWithCSV - List of modules/applications to work
    with CSV (comma-separated value) data in Perl

VERSION
    This document describes version 0.003 of
    Acme::CPANModules::WorkingWithCSV (from Perl distribution
    Acme-CPANModules-WorkingWithCSV), released on 2023-10-31.

DESCRIPTION
    The following are tools (modules and scripts) to work with the CSV
    format:

    Parsing

    First things first, the most important module to work with CSV in Perl
    is Text::CSV (which will use Text::CSV_XS backend when possible but fall
    back to Text::CSV_PP otherwise). It's not in core, but only a cpanm
    command away.

    Generating CSV from Perl array/structure

    Text::CSV (as well as Text::CSV_XS) can render a line of CSV from Perl
    array(ref) with their say() method.

    dd2csv from App::CSVUtils

    Perinci::CmdLine framework can render function result (CLI output) as
    CSV.

    Converting to/from other formats

    *INI*: ini2csv from App::TextTableUtils

    *TSV*: csv2tsv and Ltsv2csv from App::CSVUtils

    *LTSV*: csv2ltsv from App::CSVUtils and Lltsv2csv from App::LTSVUtils

    *XLS* and *XLSX*: csv2tsv and tsv2csv from App::CSVUtils

    *JSON*: csv2json and json2csv from App::TextTableUtils

    *Markdown table*: csv2mdtable from App::TextTableUtils

    *Org table*: csv2orgtable from App::TextTableUtils

    *SQLite database*: csv2sqlite from App::SQLiteUtils

    Rendering as text/ASCII table

    csv2texttable from App::TextTableUtils

    Changing field separator character, field quote character, and/or escape
    character

    csv-csv from App::CSVUtils

    Adding/removing columns

    csv-add-fields, csv-delete-field, csv-select-fields from App::CSVUtils

    Processing columns of CSV with Perl code

    csv-munge-field from App::CSVUtils

    Processing rows of CSV with Perl code

    Aside from the obvious Text::CSV, you can also use csv-each-row,
    csv-munge-row, csv-mp from App::CSVUtils.

    Merging rows from several CSV files into one

    csv-setop, csv-concat from App::CSVUtils

    Splitting a CSV file into several

    csv-split from App::CSVUtils

    Sorting CSV rows

    csv-sort from App::CSVUtils

    Sorting CSV columns

    csv-sort-fields from App::CSVUtils

    Filtering CSV columns

    csv-select-fields from App::CSVUtils

    Filtering CSV rows

    csv-grep and csv-select-rows from App::CSVUtils

    csvgrep from csvgrep

    Transposing CSV

    csv-transpose from App::CSVUtils

    Summing and averaging rows

    csv-sum and csv-avg from App::CSVUtils

    Producing frequency table from CSV

    csv-freqtable from App::CSVUtils

    Performing set operations (intersection, union, difference) on CSV

    csv-setop from App::CSVUtils

    ** Other modules/unorganized