Skip to content

Mission 8 - Manipulating data

Learning Objective

In this mission we learn how to manipulate the data using the GPT copilot. For example we can use it to remove all empty rows from the dataset, split columns into two columns.

Data

Please download the required dataset we will use: business_transaction.xlsx

Steps

  1. After opening the data, click on the broom to enter the data cleanser, see figure below.
  2. As shown in the figure below, input a prompt that specifies in detail how the data should be manipulated.

​

Image title

Click on the broom to open the GPT powered data manipulator.

​

Image title

Showing the prompt and the column that we wish to manipulate. In this case we want to split the column into the amount and the currency, so for example "55 CHF" would become "55" and "CHF" in respective column.
Tip In the figure above showing the data cleanser, there are three text inputs. The upper one is for editing the data, the middle one is for querying and searching the data, and the smaller bottom one allows editing of individual cells.

Result

Image title

Notice how the two new columns appeared as we asked it and also how LOGIBLOX inferred the column types to be whole number and text.

Well done! Now let's move on to the next mission!