Finding the most common values from given data
- by Ben Shelock
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?
