Regrouping is something that I've had to do many times during my career in data analytics, unfortunately a lot of relationships aren't defined through a single unique identifier, at least not at first. This code snippet is designed to flush out the transitive relationships defined between pairs of elements and assign all elements in the graph a single unique identifier. Get ready for some SQL looping action...
Anybody who's had contact with software development will be familiar with at least some of the methodologies explored over the years, the spiral model, agile development, the waterfall. However useful as these are, applying their principles to Data Analytics is somewhat of a tricky endeavour.
When working with data, one thing gets me over and over again - granularity. Settling on the right level of granularity means striking a balance between detailed reporting and faster queries all while trying to maintain the elusive quality of simplicity and it's not an easy task.
Whether you’re growing a mo’ or know a bro who’s got one on the go, you can’t escape Movember - the month of moustache. And we’re already half way through! As you might be able to tell from the pictures above I’m growing one myself this year and thus far have had curious glances, polite smiles and one “what is that on your lip! It’s even ginger!” in response.
I’m writing this 30,000 feet in the air. Through the foggy porthole window I can see ships crossing the channel and sunlight reflecting red on the horizon. Shortly my flight will be descending into the London night-time and for a few minutes I will get to see London in a way that wasn’t possible over 100 years ago.
Keep track of new posts by subscribing to the latest posts RSS feed.
View the whole tag cloud