Data to Insight is not a software supplier in the traditional sense -- we're here to help local authority (LA) colleagues get work done and share it with each other. The best thing about Data to Insight is the community of analysts who are doing and sharing great work through this network.
We recognise that different LAs want different levels of engagement with our work. As such, we offer four key collaboration approaches to suit different users’ information needs.
Annex A Explorer
The Annex A Explorer extracts Annex A data back out of the ChAT Excel tool and recreates key visualisation from the ChAT report. The idea is to show what kind of thing is possible in Python using relatively little code, and very quickly. So long as you have a version of the ChAT tool with your Annex A data loaded into it, you can easily run this tool. The only current version of the Annex A explorer that has been released is the Dev version, but learning and Usability versions are on the way. Versions of this tool that read directly from the .CSVs that make up the Annex A, bypassing the ChAT tool are currently in design stage.
Using the tool
With just a little Python experience, using this tool is easy. For minimum use of the dev version, you simply need to scroll to the first cell with code in and replace the text YOUR FILEPATH HERE with the file directory where your ChAT is stored. You then need to update the variable 'chat' below. Replace the words YOUR FILENAME HERE with the filename of your ChAT file. When updating the filepath, ensure the filepath is surrounded by single quotes, as in the example below, and again like the example below, is preceded by an r. When updating the file name, ensure it is followed by .xlsx, and that the whole thing is surrounded by quotes, as in the example below.
The example above shows what the code may look like when filled correctly with your filepath and filename. Once you have done this, you can simply click the Restart and Run All button in the Notebook's toolbar. After waiting a little while (it takes a while to read the ChAT file), you'll get your outputs, graphs that visualise the same data as the ChAT report, in the same way.