Datagration Knowledge Base

Back to home

Datagration Knowledge Base

P#

P#

Introduction to P#, Datagration's unique petro-technical scripting language.

Getting Started with P#

What is the autocomplete in P# scripts?

What is P#?

What are the Datagration Scripting Best Practices?

How do I write P# Scripts?

How do I make sure that no one can edit my P# script?

How do I use Placeholders in P# Scripts?

How do I know what's being changed on my scripts?

See more

Data Cleansing

How do I write a data Cleansing Script in P#?

What is data cleansing in PetroVisor?

String Functions

TimeStringSignal()

Upper()

Trim()

ToBoolean()

ToAggregation()

TimeSignal()

StringSignal()

StartOfDepth()

ResponseSurfaceScore()

ResponseSurfaceProbability()

ResponseSurfaceAggregationPoint()

ResponseSurfaceAggregation()

ResponseSurface()

PredictProbability()

Predictor()

OpportunitiesByName()

Mid()

Lower()

LastStringValue()

IsInsideDataGridCell()

EntitiesInsideDataGridCell()

EntitiesFromEntitySet()

EntitiesByName()

EndofDepth()

DepthSignal()

CurrentDataGridCell()

_List()

AggregateJSON()

_Hierarchy()

CurrentHierarchy()

ScenarioStringValue()

Signal()

NullString()

Concat()

CurrentEntity()

CurrentParent()

ParseJSON()

ToString()

Find()

Len()

Left()

Right()

See more

Scenario Functions

ScenarioEntities()

ScenarioScope()

ScenarioValue()

Regression Functions

RegressionParameter()

RegressionValue()

Placeholder Functions

_DateTime()

_Double()

_Entity()

_Signal()

_String()

See more

Neighborhood Functions

DataGridCellValue()

CurrentRoot()

AggregateDataGrid()

AggregrateDataGrid()

AggregateFromEntities()

AggregateIfTagged

Neighbors

PercentRank

See more

Mathematical Functions

NumberOfPredictors()

NumberOfInputFeatures()

Ceiling()

Abs

ACos

ASin

ATan

Cos()

E

Exp

Floor()

LN

Log

LOG2

Pi

Power

Random

Root

Round()

Sin

Sqrt

Tan

Trunc

See more

Logic Functions

Contains

EndsWith()

IF THEN ELSEIF ELSE

IIf

IsEntityType

IsNotNull

IsNull

IsTagged

StartsWith()

See more

Entities Function

EntitiesFromContext()

EntitiesFromIntersection()

EntitiesByHierarchy()

All

BestChild

BestChildren

BestEntity

EntitiesByAlias

EntitiesByCondition()

EntitiesByDelimitedString

EntitiesByParent()

EntitiesByParentTag

EntitiesByTag

EntitiesByType

Siblings

ValueForEntity

See more

Moving Window Functions

MovingAvg

MovingChange

MovingDiff

MovingDiv

MovingMax

MovingMin

MovingOscillationCoefficient

MovingOutlier

MovingSlope

MovingStep

MovingSum

See more

Time and Date Functions

StartofTag()

CurrentScopeIncrement()

TagDuration()

EndOfTag()

CurrentScope

CurrentStep

Day

DayOfWeek

DayOfYear

DaysInMonth

DateDiff()

EndOf()

Hour

Millisecond

Minute

Month

Next

Now

Previous()

Second

Shift

StartOf()

ToDateTime

Today

Year()

ToTimeStep()

See more

Statistical Functions

MovingPercentile()

CumulativeByRank()

Mod()

Average

Count

Cumulative

First

HistoryCumulative

Last

Max

Median

Min

Mode

Normalize()

Percentile

StDev

Sum

Variance

See more

Economic Functions

IRR()

NPV()

Data Handling

NullDate()

Replace()

FillGaps()

Null()

Replace()

Smooth()

ToDouble()

See more

Additional Functions

IsOpportunity()

TablesIntersection()

TableKey()

How do I use a depth dependent scope?

DepthValue()

DynaCard()

LastValue()

PVTValue()

Rank()

TableValue()

TableValueAggregated()

WorkspaceDictionary()

WorkspaceEnumeration()

WorkspaceList()

WorkspaceValue()

See more

Directional Functions

CurrentScopeDepthIncrement()

CurrentDepthStep()

CoordinateCRS()

CoordinateDegree()

CoordinateUTM()

MinDistance()

ToDepthStep()

See more

Machine Learning Functions

DetectAnomaly()

DetectChangePoint()

DetectSpike()

Predict()

PredictScore()

Forecast()

See more

DCA Functions

DCAModelDate()

DCAModelParameter()

DCAModelValue()