Monthly Archives: August 2019

Data Shaping in Google Refine – Generating New Rows from Multiple Values in a Single Column

Originally posted on OUseful.Info, the blog…:
One of the things I’ve kept stumbling over in Google Refine is how to use it to reshape a data set, so I had a little play last week and worked out a couple of new (to me) recipes. The first relates to reshaping data by creating new…

Is Twitter Starting to Make a Grab for the Interest Graph?

Originally posted on OUseful.Info, the blog…:
Over the last couple of years, I’ve dabbled with mapping parts of the interest graph defined by friends and follower relationships on Twitter. But with a couple of recent Twitter announcements, I’m starting to wonder if my ability to continue producing such maps will, to all and intents…

Emergent Social Interest Mapping – Red Bull Racing Facebook Group

Originally posted on OUseful.Info, the blog…:
With the possibility that my effectively unlimited Twitter API key will die at some point in the Spring with the Twitter API upgrade, I’m starting to look around for alternative sources of interest signal (aka getting ready to say “bye, bye, Twitter interest mapping”). And Facebook groups look…

Social Interest Positioning – Visualising Facebook Friends’ Likes With Data Grabbed Using Google Refine

Originally posted on OUseful.Info, the blog…:
What do my Facebook friends have in common in terms of the things they have Liked, or in terms of their music or movie preferences? (And does this say anything about me?!) Here’s a recipe for visualising that data… After discovering via Martin Hawksey that the recent (December,…

Merging Data Sets Based on Partially Matched Data Elements

Originally posted on OUseful.Info, the blog…:
A tweet from @coneee yesterday about merging two datasets using columns of data that don’t quite match got me wondering about a possible R recipe for handling partial matching. The data in question related to country names in a datafile that needed fusing with country names in a…