IODP Site Data
I automated data collection and reorganization to update records of proposed and completed drilling sites for the International Ocean Discovery Program.
The International Ocean Discovery Program (IODP)
Scientific ocean drilling is an international, collaborative endeavor that produces a wealth of information and high-impact results in diverse fields ranging from climate change to deep life to planetary dynamics to geohazards. IODP expeditions are developed from thoroughly reviewed proposals that progress from iterative scientific and safety panels to scheduling and facility boards for implementation.
The IODP website ties together the efforts of the international platform providers and funding partners to support a globally cohesive program. We maintain and update the site with proposal and expedition information, which includes tracking the proposed drilling sites from proposals and the drilled hole data from expeditions. Several times a year, I update the tables and files made available on the site with results and progress from major panel meetings and completed expeditions.
I automated most of the data compilation needed to produce KML files mapping proposed drilling sites in active IODP proposals, scheduled expeditions, and recently completed expeditions. This project involved gathering information from datatables on various web pages, reformatting the data, and populating Excel spreadsheets using the Python Pandas library and XlsxWriter module.
