I have a data set of about ~75 administrative regions. Among many other variables are four specific demographic variables, and a number which represents per-person funding from a government grant.
I am trying to find a way to determine which regions are most similar in demography but which receive the most different funding levels.
I am leaning towards using sklearn.neighbor to find the most similar regions and just visually finding the least similar funding levels, but can I pass it an array of 75 items, with 4 values each?
Is there a better way of doing this?
Thanks
Edit to include sample table:
id | poverty | recimm | loneparents | edu level | funding |
---|---|---|---|---|---|
001 | 33 | 44 | 61 | 17 | 155.10 |
002 | 29 | 13 | 21 | 1 | 255.75 |
003 | 14 | 18 | 24 | 66 | 555.74 |