-
Notifications
You must be signed in to change notification settings - Fork 21
Pune Budget data
answerquest edited this page Nov 4, 2017
·
11 revisions
- Budget 2017-18 released in excel format: http://www.punecorporation.org/en/budget-2017-2018
- See work done on 2016-17 budget (data curation, visualization)
- Pune Budget 2017-18 : table columns description : see this to learn about the budget document's original structure
- See Simplified headers for 2017-18 budget tables/sheets
- Task : Making flat tables of 2017-18 budget
- Task : Import flat tables created above to a database
- Task : Create a nested JSON to express the budget document's hierarchy see sample
- Task : Create a visualization that combines the nested JSON and flat table. See: Budget data visualizer
- Curate the 2017-18 data to bring it to a unified flat structure (similar work was done by Nikhil for 2016-17 budget)
- Put the budget data online in a searchable table, similar to what Ravikant did with Water Cup Villages data.
- Make an online database and a query system using which any user can create custom queries and draw out data.
- Have a system for sharing those queries (for starters, could be as simple as a comments section where users can submit their queries)
- Load multiple years' data into the same database and start exploring it all.
- Bring out ward-wise (using ward number info given in some of the entries) various expenditures.