- Joined
- May 24, 2017
- Messages
- 619
- Reaction score
- 1,018
Hi all,
As discussed in a previous thread (Osteopathic Applicant Rating System?), I have been working on scraping the mean GPA and mean MCAT for all DO schools from ChooseDO's Explorer Tool (Choose DO Explorer Registration - Choose DO).
I have completed the code to scrape the data, and you can find the mean values I found at the Google sheet linked at the end of this post. The sheet is read-only, so you should make your own copy if you want to edit things. If you disseminate the sheet, please do leave the link to this thread intact so that the most recent version is easily accessible from a single location.
Some caveats to keep in mind:
1) I calculated the values with certain tolerances as otherwise the search would take too long (I could get it smaller, and may do so in the future, but this is just a proof of concept).
2) The mean GPA is within a range of 0.005 (that is, the real value is within 0.005 of the value in the sheet).
3) The mean MCAT is within a range of 0.1 (that is, the real value is within 0.1 of the value in the sheet).
4) The data in the sheet is up-to-date as of April 28, 2020. If you're reading this in the future and want me to update it again, PM me (though whether the data is different from year to year depends on ChooseDO).
5) These are only MEANS. DO schools are known for accepting a wide range of GPA and MCAT scores. ChooseDO does not allow me to scrape the standard deviation of these values, or I'd have also provided a rough 10th and 90th percentile.
6) This has no data for recently-opened schools or schools that aren't on ChooseDO. Please let me know if a school of interest is missing and I'll check to confirm that both of these are the case.
7) There are other subsheets (accessible through the tabs at the bottom of the linked sheet) that have the schools sorted by GPA and MCAT, respectively.
Enjoy. I sincerely hope this information helps in determining what DO schools you might like to apply to and that it hopefully fills a gap that has been missing in most DO data out there.
I plan to continue working on information for DO applications in the future, but let me know if there's anything specific you want to see!
If you have any questions or would like any information from me, feel free to post here or PM me.
Best,
Seihai
Sheet link:
Sheet (for some reason, SDN auto-embeds it, so use the link above to navigate to it directly for better viewing):
EDIT History
28 July 2019: Made ranges narrower after figuring out how to make searching/filtering more efficient. Tolerances narrowed from 0.01 and 0.5 to 0.005 and 0.1 for GPA and MCAT, respectively. Sheet link remains the same. Also added sheets where schools are sorted by GPA and MCAT.
23 December 2019: Updated (but the data itself didn't change) the numbers by rescraping ChooseDO after getting around their login barrier.
20 January 2020: Forgot to add the edit for 23 December 2019 above, so did so on this day. No other material changes to the post.
28 April 2020: Updated all of the data from ChooseDO.
As discussed in a previous thread (Osteopathic Applicant Rating System?), I have been working on scraping the mean GPA and mean MCAT for all DO schools from ChooseDO's Explorer Tool (Choose DO Explorer Registration - Choose DO).
I have completed the code to scrape the data, and you can find the mean values I found at the Google sheet linked at the end of this post. The sheet is read-only, so you should make your own copy if you want to edit things. If you disseminate the sheet, please do leave the link to this thread intact so that the most recent version is easily accessible from a single location.
Some caveats to keep in mind:
1) I calculated the values with certain tolerances as otherwise the search would take too long (I could get it smaller, and may do so in the future, but this is just a proof of concept).
2) The mean GPA is within a range of 0.005 (that is, the real value is within 0.005 of the value in the sheet).
3) The mean MCAT is within a range of 0.1 (that is, the real value is within 0.1 of the value in the sheet).
4) The data in the sheet is up-to-date as of April 28, 2020. If you're reading this in the future and want me to update it again, PM me (though whether the data is different from year to year depends on ChooseDO).
5) These are only MEANS. DO schools are known for accepting a wide range of GPA and MCAT scores. ChooseDO does not allow me to scrape the standard deviation of these values, or I'd have also provided a rough 10th and 90th percentile.
6) This has no data for recently-opened schools or schools that aren't on ChooseDO. Please let me know if a school of interest is missing and I'll check to confirm that both of these are the case.
7) There are other subsheets (accessible through the tabs at the bottom of the linked sheet) that have the schools sorted by GPA and MCAT, respectively.
Enjoy. I sincerely hope this information helps in determining what DO schools you might like to apply to and that it hopefully fills a gap that has been missing in most DO data out there.
I plan to continue working on information for DO applications in the future, but let me know if there's anything specific you want to see!
If you have any questions or would like any information from me, feel free to post here or PM me.
Best,
Seihai
Sheet link:
Code:
https://docs.google.com/spreadsheets/d/1_xNtmrSLYsHidZCOhOt7-9DDV9F6Qcfynbnx2T9t-ok/edit?usp=sharing
Sheet (for some reason, SDN auto-embeds it, so use the link above to navigate to it directly for better viewing):
EDIT History
28 July 2019: Made ranges narrower after figuring out how to make searching/filtering more efficient. Tolerances narrowed from 0.01 and 0.5 to 0.005 and 0.1 for GPA and MCAT, respectively. Sheet link remains the same. Also added sheets where schools are sorted by GPA and MCAT.
23 December 2019: Updated (but the data itself didn't change) the numbers by rescraping ChooseDO after getting around their login barrier.
20 January 2020: Forgot to add the edit for 23 December 2019 above, so did so on this day. No other material changes to the post.
28 April 2020: Updated all of the data from ChooseDO.
Last edited: