从给定数据中查找最常见的值

Question

I have some data that looks something like this...

+----------+----------+----------+
| Column 1 | Column 2 | Column 3 |
+----------+----------+----------+
|   Red    |   Blue   |   Green  |
|  Yellow  |   Blue   |   Pink   |
|  Black   |   Grey   |   Blue   |
+--------------------------------+

I need to go through this data and find the 3 most common colours.

The raw data is in CSV and there's likely to be thousands more rows. (link)

What's the best way of doing this?

Answer 1

There's no magic... one row at time, one column at time.

And count each color.