Skip to content

Module 1F: ASCAP Data (So Now What?)

Scotty Carlson edited this page Jan 27, 2017 · 6 revisions

Here's a question you might be thinking at this point: why did we do all of that?

The obvious answer was to clean a set of messy data. In the state we've left it, we can easily export it to other formats, or even share it with others as a Refine project.

Mod1

But beyond this exercise of data cleanliness, there's more that we can learn with Refine. For instance, faceting on the split-apart songwriting names can tell us a lot about who Jerry frequently wrote with. Obviously Robert Hunter will be high up there, but who are his other most (and least) frequent collaborators? Faceting can answer that.

Mod1

Similarly, a numeric facet on the total shares owned by ASCAP can tell us quite a bit. This example numerical facet is only going to show the Garcia songs that ASCAP owns less than a 50 percent stake in:

mod1

In summation, there's more to data cleaning and normalization than anal-retentiveness. (Although there's quite a bit of that, too.)

End of Module 1.

Module 2 >

Clone this wiki locally