Vanuatu-National-Statistics-Office / vnso-nsdp-platform

MIT License
0 stars 4 forks source link

CSV Data Template #76

Open hugo-e-pigott opened 3 years ago

hugo-e-pigott commented 3 years ago

Current format is:

Disaggregation1, Disaggregation2,....., Value

What if you are only interested in specific disaggregations, how are these Values calculated?

Currently we have a value if all disaggregations are present, but we may only want to focus on specific ones, for instance- number of girls in an Area Council, and not look at their education etc.

brockfanning commented 3 years ago

@Vanuatu-National-Statistics-Office/nsdp-platform-team The easiest way to handle that currently is to leave out the disaggregations that you're not interested in displaying. So for example, you could omit the "education" column from the CSV file.

However if you are not able to omit these columns from the data, it is also possible to drop them dynamically with a small bit of Python code. I've posted some comments in the file where this Python code would need to go: https://github.com/Vanuatu-National-Statistics-Office/vnso-nsdp-platform/blob/develop/scripts/alter_data.py