usage: csvstat [-h] [-d DELIMITER] [-t] [-q QUOTECHAR] [-u {0,1,2,3}] [-b]


               [-p ESCAPECHAR] [-z FIELD_SIZE_LIMIT] [-e ENCODING] [-L LOCALE]


               [-S] [--blanks] [--null-value NULL_VALUES [NULL_VALUES ...]]


               [--date-format DATE_FORMAT] [--datetime-format DATETIME_FORMAT]


               [-H] [-K SKIP_LINES] [-v] [-l] [--zero] [-V] [--csv] [--json]


               [-i INDENT] [-n] [-c COLUMNS] [--type] [--nulls] [--non-nulls]


               [--unique] [--min] [--max] [--sum] [--mean] [--median]


               [--stdev] [--len] [--max-precision] [--freq]


               [--freq-count FREQ_COUNT] [--count]


               [--decimal-format DECIMAL_FORMAT] [-G] [-y SNIFF_LIMIT] [-I]


               [FILE]
Print descriptive statistics for each column in a CSV file.
positional arguments:


  FILE                  The CSV file to operate on. If omitted, will accept


                        input as piped data via STDIN.
optional arguments:


  -h, --help            show this help message and exit


  --csv                 Output results as a CSV table, rather than plain text.


  --json                Output results as JSON text, rather than plain text.


  -i INDENT, --indent INDENT


                        Indent the output JSON this many spaces. Disabled by


                        default.


  -n, --names           Display column names and indices from the input CSV


                        and exit.


  -c COLUMNS, --columns COLUMNS


                        A comma-separated list of column indices, names or


                        ranges to be examined, e.g. "1,id,3-5". Defaults to


                        all columns.


  --type                Only output data type.


  --nulls               Only output whether columns contains nulls.


  --non-nulls           Only output counts of non-null values.


  --unique              Only output counts of unique values.


  --min                 Only output smallest values.


  --max                 Only output largest values.


  --sum                 Only output sums.


  --mean                Only output means.


  --median              Only output medians.


  --stdev               Only output standard deviations.


  --len                 Only output the length of the longest values.


  --max-precision       Only output the most decimal places.


  --freq                Only output lists of frequent values.


  --freq-count FREQ_COUNT


                        The maximum number of frequent values to display.


  --count               Only output total row count.


  --decimal-format DECIMAL_FORMAT


                        %-format specification for printing decimal numbers.


                        Defaults to locale-specific formatting with "%.3f".


  -G, --no-grouping-separator


                        Do not use grouping separators in decimal numbers.


  -y SNIFF_LIMIT, --snifflimit SNIFF_LIMIT


                        Limit CSV dialect sniffing to the specified number of


                        bytes. Specify "0" to disable sniffing entirely, or


                        "-1" to sniff the entire file.


  -I, --no-inference    Disable type inference (and --locale, --date-format,


                        --datetime-format, --no-leading-zeroes) when parsing


                        the input.

csvstat examples/realdata/FY09_EDU_Recipients_by_State.csv

$ csvstat --min examples/realdata/FY09_EDU_Recipients_by_State.csv


  1. State Name: None


  2. State Abbreviate: None


  3. Code: 1


  4. Montgomery GI Bill-Active Duty: 435


  5. Montgomery GI Bill- Selective Reserve: 48


  6. Dependents' Educational Assistance: 118


  7. Reserve Educational Assistance Program: 60


  8. Post-Vietnam Era Veteran's Educational Assistance Program: 1


  9. TOTAL: 768


 10. j: None

$ csvstat -c 4 --mean examples/realdata/FY09_EDU_Recipients_by_State.csv
6,263.904