how to get count of unique values unix code example
Example: count the number of unique elements in a column bash
# Example usage:
awk -F '\t' '{print $7}' input_file | sort | uniq -c
# Breakdown:
# awk returns the 7th tab-delimited column/field of the input_file
# sort sorts the entries so that duplicate entries are adjacent
# uniq -c returns the counts of each type of element
# Note, add "| cut -c 9-" to remove the counts if you only want the
# unique values found in the column/field