We currently have 4 features in the frontend - Health Behaviours, Clinical Care, Socio Economic factors and Quality of life. Each of these have their own subfeatures that have data in the excel sheet.
Now what I want is, given the state, county, feature, I want an output of all the counties in the state and the value of each of their features SCALED between 1 and 10. I also want a flag that says whether a higher value is good or bad.
For example, if I choose California and Socio Economic Factors, I want an output in a format similar to this:
JSON response:
[
California : [
'Alamada': ['Violent crime rate': 6, 'Injury Death Rate': 8]
'Alpine': ['Violent crime rate': 7, 'Injury Death Rate': 2]
'Amador': ['Violent crime rate': 9, 'Injury Death Rate': 4]
.....
],
'HigherGood': False //This denotes that higher value means bad
]
We currently have 4 features in the frontend - Health Behaviours, Clinical Care, Socio Economic factors and Quality of life. Each of these have their own subfeatures that have data in the excel sheet.
Now what I want is, given the state, county, feature, I want an output of all the counties in the state and the value of each of their features SCALED between 1 and 10. I also want a flag that says whether a higher value is good or bad.
For example, if I choose California and Socio Economic Factors, I want an output in a format similar to this:
JSON response:
[
California : [
'Alamada': ['Violent crime rate': 6, 'Injury Death Rate': 8]
'Alpine': ['Violent crime rate': 7, 'Injury Death Rate': 2]
'Amador': ['Violent crime rate': 9, 'Injury Death Rate': 4]
.....
],
'HigherGood': False //This denotes that higher value means bad
]