graph analysis of City of Aurora, IL expenditure reports
This analysis package is an example of a "graph" analysis. This graph analysis method is widely applicable to many large data sets and allows for detailed analysis of such data sets. The method is iterative and proceeds in a stepwise fashin, based on the results of previous iteration(s).
This analysis will be based on the following PDF data:
The first page of each PDF contains header information and then every subsequent page has the same output format, such as:
The individual files are downloaded to a directory and then converted to a text file
The text file can be opened in an editor. Every section begins with the same format below.
There are 262 seperate sections in the file being examined below
The data is given sperated into nine distinct "EAL DESCRIPTIONS" sections
The data is read with the code below and each time the "DEPT" line changes, the data for the previous block is printied out.
The DEPARTMENT TOTAL dollar amounts are converted to integers for building the graph
Further data can be extracted for each page of text. For now, we can build a graph using the data extracted in each printout block above.
The dollar amounts for each unique EAL code type are agregated below. The columns are the total dollars, the average dollars, and the # of report sections contributing dollars.
The FUND information can be added to the graph below. Adding the highlighted line of code causes the second order graph to accumulate and printout as shown.