awk: Iterate over columns of a file and count a pattern in each column

count_pattern_each_column.md

Iterate over columns of a file and count a pattern in each column

Count -9999 occurrences in each column of file.csv.

awk -F',' '{
    for (i = 1; i <= NF; i++) {
        if ($i == -9999) {
            count[i]++
        }
    }
    total_lines++
} END {
    for (i = 1; i <= NF; i++) {
        print "Column " i ": " count[i] " occurrences out of " total_lines " lines"
    }
}' file.csv