Blog

Time Series Transformations for Oil and Gas Using TERR

facebooktwittergoogle_plusredditpinterestlinkedinmail

Time Series Transformation for Oil and Gas Using TERR - Syntelli

Time Series Transformations For Oil & Gas

In this TERR tutorial, we will explore time series transformations often associated with oil and gas analysis.

Up to this point, we’ve only explored general use cases, now we get into some industry specific data and techniques.

For Oil and Gas, our focus is going to be public production data. We will explore techniques to combine data sets, manipulate text, and do some very industry relevant time series analysis all within TERR.

In short, we’re going to use a script to pull multiple oil production data sets via an API into TERR, use base TERR functions to truncate the output data to only return production data from peak output forward, and then normalize all the output data to be relative to our median output location.

We will transform this data:

TERR Oil and Gas 1

 

 

Into this data:

TERR oil and Gas 2

 

Data Sourcing

For the sake of easily accessible data, we are going to use oil field production data leading up to the recession in 2008. Fortunately, this data are in a similar exponential decay pattern seen in individual wells. The data are also available through online data api services, such as quandl.com, making it easy to access our data.

First things first, let’s grab some data.

Oklahoma:

https://www.quandl.com/api/v1/datasets/DOE/MCRFPOK1.csv?trim_end=2008-12-30

Utah:

https://www.quandl.com/api/v1/datasets/DOE/MCRFPUT1.csv?trim_end=2008-12-30

California:

https://www.quandl.com/api/v1/datasets/DOE/MCRFPCA1.csv?trim_end=2008-12-30


Download the entire tutorial below.

Download

Learn this and more about TERR in our latest Ebook!

Get TERR Ebook


Daniel-Smith
Daniel Smith

Principal Consultant
About Daniel: Using Business Intelligence platforms to bridge the gap between Advanced Data Analytics and the efficient effective principles of accounting, Daniel applies technology and mathematics to make business faster and smarter.

Daniel has managed solutions for diverse client sectors such as as advertising, military, insurance, and oil & gas. These solutions include Business Intelligence Platform management, online key performance indicator identification and tracking, to full predictive data model construction. Although the analytic solutions are often mathematically complex, Daniel’s presentation and academic background ensures any insights delivered by solutions are relevant and simple to understand.

facebooktwittergoogle_plusredditpinterestlinkedinmail

Leave a Comment

Your email address will not be published. Required fields are marked *

 

Login

Register | Lost your password?