Google Refine is a desktop database/spreadsheet application that allows filtering and merging of large datasets.
Using this application with local council spending information reduces inconstancies and allows more accurate filtering and assessment of data.
Prior to refining with Google Refine there were:-
- 225 “types” of spend
- 790 organisations
- 220 “types” of spend
- 777 organisations
You may think “so what?”
Let me give you an example of how these inconsistencies impact on the totals of type of spend.
So the inconstancies surrounding that simple “s”, means that the total is £6773 less than it should be when compiling reports.