> ## 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

<Frame>
  <iframe src="https://www.youtube.com/embed/wMlQY-vNWJI" title="Cleaning data" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen />
</Frame>

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.

***

<Card icon="sparkles" title="Building challenge">
  Before combining your data sets, clean up the sales data — keeping only what you need and removing orders that shouldn't be in the report. Copy and paste this prompt into Parabola:

  ```text wrap theme={null}
  I want to clean my sales data. Keep only "SKU#", "Product Title", "Line Item Price", "Units", and "Status" from the sales data set. Also rename "SKU#" to "SKU" and remove any rows where "Status" is "Cancelled" or "Refunded".
  ```
</Card>

<Accordion title="Check your work">
  <Note>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.</Note>

  <Frame>
    <img src="https://mintcdn.com/parabola-7119dfb0/CAGXdc7-yLmtAwae/images/general-operators-clean-canvas.png?fit=max&auto=format&n=CAGXdc7-yLmtAwae&q=85&s=f0a88309d1d6f4a304a272f009c505d9" alt="Clean data canvas view" width="3236" height="1852" data-path="images/general-operators-clean-canvas.png" />

    <img src="https://mintcdn.com/parabola-7119dfb0/CAGXdc7-yLmtAwae/images/general-operators-clean-data.png?fit=max&auto=format&n=CAGXdc7-yLmtAwae&q=85&s=a5b7cc179645b5ab1524e536268d3087" alt="Clean data step results" width="3242" height="1860" data-path="images/general-operators-clean-data.png" />
  </Frame>
</Accordion>
