Colc is a CommandLineTool to take statistics from a column of a file.
This command depends these commands(head|tail|cut|sort|awk) on bash.
colc [column] [file.csv|tsv|txt]
*1
When you set [column,column] on the column parameter,
you'll get the correlation coefficient of two columns.
(thie feature don't support below options)
# check the column is valid
-c,--check
# show frequency table and histogram
-b,--binsize <number>
# with binsize option, filter frequency
-f,--filter <number(1-99)>
- Quick
- Auto detect a separator
- Auto detect a header row
# Install
brew install solaoi/tap/colc
# Update
brew upgrade colcyou can download a binary release here.
# Install with wget or curl
## set the latest version on releases.
VERSION=v1.0.15
## case you use wget
wget https://github.com/solaoi/colc/releases/download/$VERSION/colc_linux_amd64.tar.gz
## case you use curl
curl -LO https://github.com/solaoi/colc/releases/download/$VERSION/colc_linux_amd64.tar.gz
## extract
tar xvf ./colc_linux_amd64.tar.gz
## move it to a location in your $PATH, such as /usr/local/bin.
mv ./colc /usr/local/bin/There is a some.csv.
1,54,3,73,5
51,4,8,41,1
3,4,80,1,13
Then you wanna get the second column's statistics.
Just do it!
colc 2 some.csv
Of course -b,--binsize works well:)
colc 2 some.csv -b 10
There are noises, then filter necessaries(>=1%) with -f,--filter
colc 2 some.csv -b 10 -f 1
If you wanna check whether the file is valid in advance,
-c,--check answers the file is dirty or clean.
colc 2 some.csv -c
# Run
deno run --allow-run --allow-env colc.ts
# Install
deno install -f --allow-run --allow-env colc.ts
# UnInstall
rm $(which colc)