Transform your data

The Transformations agent located on the right-side of the Conode application deals with manipulating your data manually using set options: Edge Value, Node Label, and Data Type.

Alternatively, interact with the Conode AI to automatically transform your data through natural language-based prompts.

Transform Numeric Nodes Edge Value

When dealing with numeric variables, you have the ability to manipulate the values of their outgoing edges through operations such as Add, Multiply, Subtract, and Divide, using either another numeric feature or a numerical value. Select the node(s) whose values you wish to transform, and add them to your input. Choose the type of operator +, -, x, ÷ , and set the value to apply transformations to.

Example 1

Consider a dataset detailing product features, including a column labeled "box width [m]". To convert these units into centimeters, simply select the corresponding node and apply the Multiply operation with a Numeric Value of 100.

Example 2

Suppose you've just imported a dataset containing customer orders, with two numeric features in your taxonomy labeled "orders of product 1" and "orders of product 2". By selecting these nodes and utilizing the Add transformation with Headers, you can create a new node indicating the total number of product orders per customer.

Transform Node Labels

The Replace option allows you to change sections of the node labels selected by matching the pattern of your input.

From : Current ‘old’ section of the selected node label(s) you want replaced.

To : ‘New’ section you now want it to be.

For instance, you want to replace all node labels that contain the word ‘Conode’ (old) to be ‘Conode’ (new).

The Transform in place box can be checked to apply the transformation to the nodes currently selected. If not checked, Conode generates a new view that contains the transformed nodes as new nodes.

Split

The Split option generates a new set of nodes, each containing sections of your labels that have been split based on what you indicated to split by.

For instance, your data contains flight information, and representative node labels follow this format: country A to country B. You split all your labels by the word ‘to’, and will now have 2 groups of nodes: departing country and arriving country.

Transform Data Types

You can modify the data types of features within your taxonomy using the Convert Nodes agent located in the Transformations drawer.

String Transformation:

To convert a numeric or datetime variable into a categorical variable, select the corresponding feature node and apply a string transformation. This action converts the outgoing edges from the header node into intermediate nodes, with labels representing the weight of the edges.

For instance, imagine transforming a metric like "maximum vehicle speed," which is directly connected to nodes representing collision events with edge weights equivalent to the vehicle's speed during those events. After transformation the same header node "maximum vehicle speed" links to a new set of nodes with labels reading the vehicle speeds. These nodes, in turn, connect to the event nodes.

Numerical Transformation:

You can convert a categorical variable into a numerical variable when all categorical values stored in node labels are numbers.

For example, consider a categorical header "number of items purchased," linked to three intermediate nodes labeled "10," "5," and "8". These nodes connect to data nodes representing rows in your database. Upon applying a numerical transformation, the "number of items purchased" header node will directly connect to the data nodes with edge weights of 10, 5, and 8 respectively.