RCOMM 2011 Challenge 1: Hobbit Genealogy

Created: 2011-11-02 17:43:08      Last updated: 2011-11-02 17:44:17

This is a solution for Challenge 1 of the a live data mining process design competition "Who Wants to be a Data Miner" held at RCOMM 2011 in Dublin.

As you certainly know, Balbo Baggins is the common ancestor of Balbo and Frodo Baggins. The file opened by the operator "Open Ancestor" contains a table with details about parentship in the Baggins family (insert a breakpoint after read CSV). Each example contains a parent and a child. Of course, the same parent can be contained multiple times in the data set. The task of Challenge 1 was to find all descendants (and their their respective levels) from Balbo.

This solution achieves this goal by starting with an example set with a single row (Balbo) and joining the parentship table. This yields all children of Balbo. Repeating this, all grandchildren are found. The process uses a loop to iterate down to level 6 (which is empty because no more information is provided for this level). Bilbo and Frodo are found on Levels 3 and 4, respectively.

Information Preview

Information Run

Not available

Information Workflow Components


Information Workflow Type


Information Uploader

Information License

All versions of this Workflow are licensed under:

Information Version 1 (of 1)

Information Credits (0)



Information Attributions (0)



Information Tags (0)


Log in to add Tags

Information Shared with Groups (0)


Information Featured In Packs (1)

Log in to add to one of your Packs

Information Attributed By (0)



Information Favourited By (0)

No one

Information Statistics


Citations (0)


Version History

In chronological order:

Reviews Reviews (0)

No reviews yet

Be the first to review!

Comments Comments (0)

No comments yet

Log in to make a comment

Workflow Other workflows that use similar services (0)

There are no workflows in myExperiment that use similar services to this Workflow.