Combining Well Log Data With Formation Tops in Python for Petrophysics

When working with well log data we often have to deal with different data sources and sampling rates. One area where we commonly experience this is with well log data and formation tops. Formation top data contains a formation name along with a single depth reference, whereas well log data is regularly depth sampled.
In this video I will go over the process on how to create a master dataframe with well log data and formation tops data.
⭐️ If you haven't already, make sure you subscribe to the channel: / @andymcdonald42
▼ --- SUPPORT THE CHANNEL --- ▼
☕️ BUY ME A COFFEE: www.buymeacoffee.com/andymcdo...
▼ --- GET THE CODE -- ▼
github.com/andymcdgeo/streaml...
▼ --- RECOMMENDED BOOKS --- ▼
As an Amazon Associate, I earn from qualifying purchases. By buying through any of the links below I will earn a commission at no extra cost to you.
PYTHON FOR DATA ANALYSIS: Data Wrangling with Pandas, NumPy, and IPython
UK: amzn.to/3HNycJ9
US: amzn.to/3DL7qPv
FUNDAMENTALS OF PETROPHYSICS
UK: amzn.to/3l1PgSf
PETROPHYSICS: Theory and Practice of Measuring Reservoir Rock and Fluid Transport Properties
UK: amzn.to/30UNWZS
US: amzn.to/3DNqBbd
WELL LOGGING FOR EARTH SCIENTISTS
UK: amzn.to/3FHsbfn
US: amzn.to/3CILAuE
GEOLOGICAL INTERPRETATION OF WELL LOGS
UK: amzn.to/3l2v2HV
US: amzn.to/30UOTkU
▼ --- SOCIAL CHANNELS --- ▼
Thanks for watching, if you want to connect you can find me at the links below:
/ andymcdonaldgeo
/ geoandymcd
/ andymcdonaldgeo
www.andymcdonald.scot/
Be sure to sign up for my newsletter to be kept updated when I post and share new content on TH-cam and Medium.
www.getrevue.co/profile/andym...
#datascience #petrophysics #python #streamlit #eda

[@mahammadodj]

Thanks! I actually did it using merge,sorting and forward filling functions. Your solution is straightforward.

[@vitorribeirosa]

Thanks, Andy!!!
Great content!!!

[@AndyMcDonald42]

Thanks Vitor

[@princyagr]

It was quite helpful for me! Thanks!

[@AndyMcDonald42]

Great to hear 👍

[@mauriciofut10]

Thank you for taking the time on doing these videos! this is really helpful.. I was wondering if there is a library like Lasio that could do the same in reading a DLIS file to pull the arrays and index them against depth. thank you!

[@CarlosRodriguez-xk9ot]

great work!

[@CarlosRodriguez-xk9ot]

You ought to consider one regarding python scripts in techlog

[@salihaamoura232]

Thank you very much

[@AndyMcDonald42]

You're welcome 🙂

[@abdelmoneimmohammad6168]

This is really interesting and helpful. Could you please share your thoughts how would the function look like if we are dealing with multiple wells in the same spread sheet and we want to assign the samples to formations?
Thanks so much for sharing all these amazing videos ❤😊

[@AndyMcDonald42]

Thanks. 👍
There are a few ways I can think of on how to deal with this.
Assuming you have a well log dataframe with multiple wells you will likely have a well name column. I would then ensure that the formation tops spreadsheet also has a well name column.
The function could then be changed to include a lookup to check that the well names match before adding in the formations to the dataframe.
I may do a video on this in the near future.

[@Shahnawazkhan-ep2bu]

Thanks good stuff. I am dealing with multiple wells with formation tops- I have to sort out how we do it

[@AndyMcDonald42]

I am hoping to have a video available on this topic soon

[@mdaneesau]

Hi Andy, Could you please help me in this. I have a dataframe with multiple wells having log curve data along with DEPTH and Well Name as two column. Now i want to create a flag column into this dataframe based on depth falling in any of the pay zone interval (for each well 3-4 intervals are there, mentioned in excel) for that particular well mentioned in an excel sheet. How can i do this? Thank you in advance.

[@nusratrani4590]

Hi Andy! Thanks for the nice content. Can you please let me know How can i apply same function on multiwell las data (saved in one csv). Similarly i have FM tops csv for multiple wells (I have common UWI in both CSV)

[@AndyMcDonald42]

Hi Nusrat. Sorry for the late reply.
I have just published a medium article on this very topic. I am hoping to do a video on it soon.
You can check out the article below ⬇️
andymcdonaldgeo.medium.com/creating-an-multi-well-integrated-well-log-and-formation-tops-dataframe-in-python-469670550aaf

[@nusratrani4590]

@@AndyMcDonald42 Thank you!

[@manueldavidsoto4501]

Nady, the code in the link above is not the code your are showing in the video, can you check please. Thansk a lot.