Hey i want to count the amount of data in a certain column in awk. an example dataset is 2 5 8 1 3 7 8 5 9 and I want to count the frequency of the 5 in the second colum. This is what i tried that didn't work { total = 0; for(i=1;i<=NF;i++) { if(i==2) {if($i==5) {total++;} } printf("%s ", total); } }
![Awk count frequency](https://cdn-ak-scissors.b.st-hatena.com/image/square/98d6f053a97a87156775f60757c60865d0f2c47d/height=288;version=1;width=512/https%3A%2F%2Fcdn.sstatic.net%2FSites%2Fstackoverflow%2FImg%2Fapple-touch-icon%402.png%3Fv%3D73d79a89bded)