Visual statistics for analysing the parliament’s data

Build Team

Elena Croitoru

Description

This tool generates visual statistics from the parliament\'s numerical data. It can be used to understand/predict the economical trends in the UK and detect potential problems in certain regions.

The tool parses some of the excel files that were provided and generates graphs that represent the distribution of crime or unemployment numbers per UK regions.

Any type of data in excel format can be parsed and interpreted in this manner with some adjustment.

The tool also levels the data visualized so that the user has a consistent visualization for all years.

After generating the distribution per all years available, it plays an animation of all the generated charts showing the evolution of the crime/unemployment numbers over time. The user may stop the animation at any time, switch to a different category (this is applicable for crime data) and play the corresponding set of graphs.

Based on the crime data over the last three years, a prediction has been generated for the next year by using neural networks. The prediction can be significantly improved if the training set is composed of more than three years\' worth of data.

Approximately 635 graphs were generated by this tool; the number depends on the combinations of numbers we choose to plot.

Please see the screenshots from the web application at:

http://www.flickr.com/photos/69461644@N05/

Slides:

http://portal.sliderocket.com/BDQSW/RSP

Ideas for taking this project forward

The tool can be used to visualize any type of data: votes, energy consumption etc. The project can be further developed to allow users to choose which/how much data is to be plotted in the charts.

The tool requires only a bit of modification in order to draw several series per graph (for example unemployment and crime data in the same graph with different colours).

Estimated costs for taking this project forward

Two persons could implement most of the above features in 1-2 weeks.

About the data used for this project

I used the following excel files: Crime: https://s3-eu-west-1.amazonaws.com/rsparly/Constituency-Stats/Crime/Crime+tester+data.xlsx Unemployment: https://s3-eu-west-1.amazonaws.com/rsparly/Constituency-Stats/Claimant/nomis20111021122459.xls

Issues encountered and partially solved:

The excels had different regions recorded for unemployment and crime data which meant that the x axis wouldn\'t match for the two types of data.

The sheets do not have the same format even in the same excel.

The order of the regions is different from year to year which meant that sorting was required.

Project URL:

http://portal.sliderocket.com/BDQSW/RSP

Twitter: @elenacroitoru


Created at

Rewired State: Parliament

Flickr Photos

Add photos by tagging them with rewiredstate:project="visual-statistics-for-analysing-parliament-data"