Day 3 was food hygiene data from the food standard agency first we had to download the data and XML parse it because the data is in XML like this:

We used an XML Parse tool and included Child Values and Outer XML to include all the data in the outer XML code and inner XML code, I discovered if I didn’t include outer XML code some of the data for geocoding wouldn’t show, this parsed the data in a clean format that didn’t need much extra work. Only Food Scores, as well as longitude and latitude, needed some additional parsing and cleaning.

Following this, I wanted to have a good story to visualise my data so as a huge coffee advocate and regular consumer of Starbucks I decided to compare ratings between major coffee chains and independent coffee shops:

My visualisation detailed this comparison: click here for the interactive viz