Counting unique text occurences without empty cells

[alvanuffelen]

Prerequisites

• [x] make sure you're are using the latest version by csvtk version
• [x] read the usage

Describe your issue

Is there a way to count unique text occurrences in a column without counting empty cells? example.txt

cat example.txt | csvtk summary -f order:countuniq,family:countuniq,genus:countuniq,species:countuniq
order:countuniq,family:countuniq,genus:countuniq,species:countuniq
29,35,43,94

[shenwei356]

Oh, it's not supported. A work around solution:

for rank in order family genus species; do
    echo -ne “rank,$(csvtk cut -f $rank example.txt | csvtk uniq -f $rank | csvtk grep -r -v -p ^$ | csvtk nrows)\n";
done

[alvanuffelen]

Thanks, that worked! Although, I had to change “rank to "$rank