I've got a table that looks something like this:
Code | Value |
---|---|
11000 | 1 |
12000 | 0 |
13000 | 1 |
11000 | 0 |
11000 | 0 |
11000 | 0 |
12000 | 0 |
12000 | 1 |
13000 | 1 |
I want to find a result that groups by the "code" column and finds which number is most frequently occurring in the "value" column. Result would look something like this:
Code | Value |
---|---|
11000 | 0 |
12000 | 0 |
13000 | 1 |
I've explored the summary statistics tool and unfortunately there's no option to find the mode (frequency) that a value occurs in a field. Frequency_analysis doesn't do the grouping either. Is there any tool out there made for this already or is this something I'll have to come up with my own code for? It's certainly doable, was just hoping for an easy option already.
You're right. I figured it out after I posted this. I was using the summary_field parameter when I shouldn't have, I should have just used both fields in the frequency_field parameter.