Subsurface Syntax

Subsurface Syntax

Data Aggregation in Python with Pandas: Analysing Geological Lithology Data

Exploring lithology variations within the Zechstein Group of the Norwegian Continental Shelf

Andy McDonald's avatar
Andy McDonald
Jun 29, 2023
∙ Paid

Exploring lithology variations within the Zechstein Group of the Norwegian Continental Shelf

Image generated by the author using Midjourney (Paid subscription plan).

Using data aggregation techniques can help us transform an overwhelming and almost incomprehensible numeric dataset into something that is easily digestible and much more reader-friendly. The process of data aggregation involves summarising multiple data points into single metrics that can be used to provide a high-level overview of the data.

One way we can apply this process within petrophysics and geoscience is to summarise the lithological composition of geological formations that have been interpreted from well log measurements.

Within this short tutorial, we will see how we can take a large dataset consisting of 90 plus wells from the Norwegian Continental Shelf, and extract the lithology composition of the Zechstein Group.

Importing Libraries and Loading Data

To begin, we first need to import the pandas library, which wil…

Keep reading with a 7-day free trial

Subscribe to Subsurface Syntax to keep reading this post and get 7 days of free access to the full post archives.

Already a paid subscriber? Sign in
© 2026 Andy McDonald · Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture