Tuesday, November 7, 2017

Visualizing Ancestry Relationships using Google Fusion Tables (Part 2 - Import the sheet to Google Fusion Tables)


Prepare the spreadsheet (excel or google) following previous instructions in Part 1.

Now that your sheet is created, head on over to the Fusion Table site and upload your sheet.


Find your sheet and import it to fusion tables, and press “Next”


Ensure data is what you want to import, and press next:




Edit the table information how you want with a unique name, then press “finish”:



Once the table is loaded, click the red “+” and select “Add Chart”:




Explore the results! Press “Done” when finished configuring the Network plot chart:




Explore and build upon this idea. It was the most basic level to create a network diagram. Granted, creating the data was a pain!  Play around and experiment. Add a third column with distinguishing information like say, your shared CM with your match. Or maybe which chromosome that match shares with you. Who knows! Leave a comment on anything cool you discover or ideas for improving this.






No comments:

Post a Comment