In Unix, how do I find the 10 most frequent value in column 1 whose values in column 2 == 'blue'?

Asked May 18 '20 at 01:46

Active May 18 '20 at 01:48

Viewed 188 times

I need to find the top 10 frequent numbers in column 1 whose values are 'blue' in column 2. So far I am able to get the top 10 of ALL numbers, but not sure how to add the column 2 constraint. I have this code so far:

awk -F ',' '{print $1}' data.csv | sort | uniq -c | sort -nr | head -10

I think I will need to incorporate '$2=='blue'' somewhere?

edited May 18 '20 at 01:48

RamblinRose

4,883
2
21
33

asked May 18 '20 at 01:46

hackerman

Add an example. – dawg May 18 '20 at 01:49
You are pretty close. See this answer: https://stackoverflow.com/questions/14739057 for some ideas. – zedfoxus May 18 '20 at 01:50
Probably just `awk -F ',' '$2=="blue" {print $1}'data.csv | sort | uniq -c | sort -nr | head -10` – dawg May 18 '20 at 01:51
I tried awk -F ',' '$2=="blue" {print $1}'data.csv | sort | uniq -c | sort -nr | head -10 but it doesn't work – hackerman May 18 '20 at 02:57
Come back with something more specific than *it doesn't work* – dawg May 18 '20 at 03:28
It _runs but doesn't output anything_ – hackerman May 18 '20 at 07:35

In Unix, how do I find the 10 most frequent value in column 1 whose values in column 2 == 'blue'?

0 Answers0