This is an old revision of the document!
Bern Budget
Data
- Stadt Bern - PGB 2012.xlsx
Data Processing
- Exported XLSX file to UTF-8 CSV files via Numbers (iWork).
- Note: Numbers only supports CSV with comma separation therefore: replaced all “,” with “^^^” and later convert them back
- Extracted data into an multidimensional PHP array
- Exported to JSON
ToDo
- Parse detail pages to extract products within product groups
- Improve visualization to make circle size comparable across hierarchy depth
Team
- Duc Ngo Viet