For this project, our client was looking to purchase a number of oil & gas wells and wanted to analyze publicly available production data. We wrote a Python script that automatically inputted each API number into the state website, initiated the search, found the production data table in the HTML code of the website, and pulled the data into an Excel spreadsheet. What would have taken hours of search → copy → paste → search with potential for human error, now only took about 100 seconds with complete confidence in the accuracy in the data.
In addition to quickly pulling the data, we utilized the Python library, Matplotlib, to automatically generate a graph of historic production data for each well of interest. So, not only did the client receive production data in tabular format, but we also kick started his analysis by providing visual aids of the data for each well.
Time Saved by Millstream Solution: 8 minutes/well x 200 wells = 3.33 days
Key Words: Python, Pandas, MatplotLib, Oil & Gas, Excel