📊 Stats-CSV-CLI: CSV Statistical Metrics CLI Tool

stats-csv-cli is a command-line tool for calculating various statistical metrics from CSV files using stdlib-js library. It supports multiple metrics with options for choosing different algorithms, correction values, and stride values, making it highly customizable and efficient.

Features

• Variance: Calculate variance with multiple algorithm(packages) options-
• Standard Deviation: Compute standard deviation with customizable correction and stride-
• Min/Max: Find minimum and maximum values across columns-
• Range: Calculate the difference between min and max-
• Mean: Compute the average value-
• MaxAbs/MinAbs: Find the maximum and minimum absolute values-
• Output to CSV: Save results to CSV files-
• Help Command: Detailed help for each metric.

Installation

Add stats-cli globally

npm install -g stats-csv-cli

If You get stats-cli: command not found even after successfully installing stats-cli, try running npm link first.

Demo Usage

Sample CSV File: data.csv

name,age,salary,weight
Rahul,21,50000,60
vinod,30,60000,70
Mahesh,35,55000,65
Jay,40,70000,80
Rhea,28,52000,58

Commands and Examples

1. Variance Calculation (By default correction and stride is 1)

stats-cli variance data.csv -c age,salary --corr 1 --stride 2 -o variance_output.csv

stats-cli variance data.csv -c age,salary --pkg variancepn,varianceyc

2. Standard deviation Calculation (By default correction and stride is 1)

stats-cli stdev data.csv -c age,salary --corr 1 --stride 2 -o variance_output.csv

stats-cli stdev data.csv -c age,salary --pkg stdevpn,stdevyc

3. Maximum value Calculation (By default stride is 1)

stats-cli max data.csv -c age,salary

4. Maximum absolute value Calculation (By default stride is 1)

stats-cli maxabs data.csv -c age,salary

5. Minimum value Calculation (By default stride is 1)

stats-cli min data.csv -c age,salary

6. Minimum absolute value Calculation (By default stride is 1)

stats-cli minabs data.csv -c age,salary

7. Range Calculation (By default stride is 1)

stats-cli range data.csv -c age,salary

8. Mean Calculation (By default stride is 1)

stats-cli mean data.csv -c age,salary

stats-cli mean data.csv -c age,salary --pkg meanors, meanwd

8. Help

stats-cli help

stats-cli help -c <command name>

Author

• Rahul Kumar
• rahulptl165