Jump to content
We've recently updated our Privacy Statement, available here. ×

Bring all wells at same start point to compare duration


Go to solution Solved by Olivier Keugue Tadaa,

Recommended Posts

Hello,

 I am trying to create a visual from my data to compare the duration for each well (how much it takes to drill). They don't start all at the same date, but when compare on the days duration I would like to have them starting from the same point (0 days). I have a screenshot with what I could accomplish but is not exactly what I want.

image.thumb.png.2a2ab33b095fbe140977b2cfe6f5b7ca.png

For [Days] column, I used a python script as data function: EPOCH is 1sec data.

import pandas as pd
import numpy as np

df = pd.DataFrame(WellslOpscomparison)
days_time_list = [] 
time_zero = 0

for index, row in df.iterrows():
    if row['OP_CLASS_DESC'] == 'Drilling':        
        time_zero = row['EPOCH']          
    days_time_list.append(row['EPOCH'] - time_zero)    

Days_Time = pd.Series(days_time_list)

 

Maybe this can be twitched a bit to get the desired result. Or, there is another way to do it. Any help is much appreciated

Link to comment
Share on other sites

  • Solution

Hi Cristian

I have created the attached dummy dataset and have obtained, like you, the below chart to start

image.thumb.png.f8b1328b4c51739f1a89d8f09788fb95.png

then add the following two calculated columns 

  1. [day zero per well]. :::: first([Date]) over ([well])
  2. [days duration]:::  DateDiff('day',[day zero per well],[Date])

Display the chart by [days duration]

image.thumb.png.c7215a4aa09f6590ad9115318766e884.png

 

I hope this helps solve your issue

 

community_cases.xlsx

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...