Mission 8: Manipulating Data with AI

Learning Objective

Learn how to manipulate data using the AI-powered GPT copilot. Perform complex operations like removing empty rows, splitting columns, and transforming data using natural language commands.

Dataset

Download the required dataset: business_transaction.xlsx

Step-by-Step Instructions

1. Access the Data Cleanser

After opening your data, click on the broom icon to enter the AI-powered data cleanser.

Data Cleanser Icon — Click on the broom to open the GPT-powered data manipulator

2. Enter Your Manipulation Prompt

Input a prompt that specifies in detail how the data should be manipulated.

Example: Splitting a Column

In this example, we want to split a column containing amounts with currency (e.g., "55 CHF") into two separate columns: - One column for the amount (55) - One column for the currency (CHF)

Manipulation Prompt — The prompt and column we wish to manipulate - splitting "55 CHF" into separate amount and currency columns

Understanding the Data Cleanser Interface

There are three text input areas: - Upper input - For editing and transforming data - Middle input - For querying and searching data - Bottom input - For editing individual cells

Result

Common Data Manipulation Tasks

Remove empty rows - "Remove all rows where all cells are empty"
Split columns - "Split the Address column into Street, City, and ZIP"
Combine columns - "Combine First Name and Last Name into Full Name"
Fill missing values - "Fill empty cells in Price column with 0"
Format data - "Convert all text in Name column to uppercase"

Summary

You've successfully learned how to:

✓ Access the AI-powered data cleanser

✓ Use natural language to manipulate data

✓ Split columns into multiple columns

✓ Let AI automatically infer appropriate column types

✓ Perform complex data transformations without coding

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