# 23andme raw data analysis

**URL:** <https://discuss.hail.is/t/23andme-raw-data-analysis/390>\
**Category:** Help \[0.1\]\
**Created:** [January 5, 2018, 6:59pm UTC](https://discuss.hail.is/t/23andme-raw-data-analysis/390 "2018-01-05T18:59:08Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![fractal76](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.hail.is/fractal76/32/123_2.png) [@fractal76](https://discuss.hail.is/u/fractal76)\
**Post date:** [January 5, 2018, 6:59pm UTC](https://discuss.hail.is/t/23andme-raw-data-analysis/390/1 "2018-01-05T18:59:08Z")

</div>

Has anyone used HAIL to analyze raw data from 23andme for further insights?

If so, can you describe high level steps, and any interesting results/analysis to try.

---

<div class="post-metadata">

**Author:** ![tpoterba](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.hail.is/tpoterba/32/61_2.png) [@tpoterba](https://discuss.hail.is/u/tpoterba)\
**Post date:** [January 5, 2018, 8:02pm UTC](https://discuss.hail.is/t/23andme-raw-data-analysis/390/2 "2018-01-05T20:02:11Z")

</div>

Can you provide a bit more information about what you’re looking to do? The help we’re qualified to offer is primarily technical, not scientific.

---

<div class="post-metadata">

**Author:** ![fractal76](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.hail.is/fractal76/32/123_2.png) [@fractal76](https://discuss.hail.is/u/fractal76)\
**Post date:** [January 8, 2018, 4:20pm UTC](https://discuss.hail.is/t/23andme-raw-data-analysis/390/3 "2018-01-08T16:20:48Z")

</div>

at the most basic level - can hail parse raw data from 23andme - but i can see how this might be not be super useful for an armchair enthusiast like myself, if i don’t know what analysis i am looking to do in the first place!

---

<div class="post-metadata">

**Author:** ![tpoterba](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.hail.is/tpoterba/32/61_2.png) [@tpoterba](https://discuss.hail.is/u/tpoterba)\
**Post date:** [January 8, 2018, 4:21pm UTC](https://discuss.hail.is/t/23andme-raw-data-analysis/390/4 "2018-01-08T16:21:57Z")

</div>

What file format? Hail can parse PLINK files, which is a standard gneotype chip format.

---

<div class="post-metadata">

**Author:** ![danking](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.hail.is/danking/32/43_2.png) [@danking](https://discuss.hail.is/u/danking)\
**Post date:** [January 10, 2018, 6:02pm UTC](https://discuss.hail.is/t/23andme-raw-data-analysis/390/5 "2018-01-10T18:02:04Z")

</div>

Based on [the description provided by 23andme](https://customercare.23andme.com/hc/en-us/articles/212196868-Accessing-and-Downloading-Your-Raw-Data), you could load your data as a four column KeyTable using [HailContext.import\_table](https://hail.is/docs/stable/hail.HailContext.html#hail.HailContext.import_table). Now you have an RSID, Chromsome, Position, and genotype table. But you haven’t achieved much more than loading your data into a SQL-like system.

There’s not much you can do with this data. Hail really shines when you have a large dataset, particularly of many sequenced genomes.

A book like [Exploring the Personal Genome](https://www.amazon.com/Exploring-Personal-Genomics-Joel-Dudley/dp/0199644497) might help you understand what questions you want to ask.

---

<div class="post-metadata">

**Author:** ![fractal76](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.hail.is/fractal76/32/123_2.png) [@fractal76](https://discuss.hail.is/u/fractal76)\
**Post date:** [January 18, 2018, 4:41pm UTC](https://discuss.hail.is/t/23andme-raw-data-analysis/390/6 "2018-01-18T16:41:56Z")

</div>

for posterity - in case some newbie stumbles on this as well - these site is super useful -  
[https://www.promethease.com](https://www.promethease.com)

---

<div class="post-metadata">

**Author:** ![Rosha\_Simon](https://avatars.discourse-cdn.com/v4/letter/r/e47c2d/32.png) [@Rosha\_Simon](https://discuss.hail.is/u/Rosha_Simon)\
**Post date:** [October 31, 2018, 9:39am UTC](https://discuss.hail.is/t/23andme-raw-data-analysis/390/7 "2018-10-31T09:39:00Z")

</div>

I am late to the party but Xcode Life is also a great website to try: [https://www.xcode.life](https://www.xcode.life)

---

<div class="post-metadata">

**Author:** ![jbloom](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.hail.is/jbloom/32/109_2.png) [@jbloom](https://discuss.hail.is/u/jbloom)\
**Post date:** [October 31, 2018, 11:10am UTC](https://discuss.hail.is/t/23andme-raw-data-analysis/390/8 "2018-10-31T11:10:16Z")

</div>

gnomAD is also a great resource for exploring genomic variation, either through the website or with Hail (for example, you could annotate your genome with gnomAD’s info and then filter to find your rare, loss-of-function variants):  
[http://gnomad.broadinstitute.org/](http://gnomad.broadinstitute.org/)
