> ## Documentation Index
> Fetch the complete documentation index at: https://parabola.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.
# Cleaning data
In this lesson, you'll learn the three main types of data cleanup — columns, rows, and values — and get prompting tips to get the best results when cleaning data in Parabola.
***
Before combining your data sets, clean both files so each one only contains the columns you need.
```text wrap theme={null}
I want to clean my Shopify inventory data. Keep only these columns and rename them:
- "Product: Title" → "Product Title"
- "Variants: Title" → "Variant Title"
- "Variants: Sku" → "SKU"
- "Variants: Inventory Quantity" → "Shopify Quantity"
```
```text wrap theme={null}
I want to clean my NetSuite inventory data.
Keep only the following columns:
- "SKU"
- "In-Stock"
Rename "In-Stock" to "NetSuite Quantity".
Then remove the "R-" prefix from all values in the "SKU" column.
```
The steps added to your canvas and their exact documentation may differ from what you see below — every AI response is unique. The important thing is that your resulting data set matches what you see here.
