No-Code Data Exploration: Use Data Painter to Explore Your Data Visually
Published: 2023-02-14 11:40:54

Data Painter is a creative yet powerful feature of RATH. You can easily clean data, model data, and explore data using a Painting Tool, which turns the complex Exploratory Data Analysis process visual and simple.

Data painter is especially good at explaining complex visual patterns which can be difficult to describe by simple statistics indicators.

## Prerequisites

The following data visualization from the "College" dataset shows the relationship between `AverageFacultySalary` and `AverageCost`. We want to study why the data is not evenly distributed, but rather split into two parts.

![Edit with Data Painter](https://docs-us.oss-us-west-1.aliyuncs.com/img/data-painter/edit-with-data-painter.png)

Click on the **Data Painter** button to explore this chart.

## Explore data

### Case 1.

On the Data Painter tab, we can paint the dots which represent the data we want to explore with your mouse cursor.

Click on the **Search** button to automatically analyze your data painting. RATH can automatically detect your intent and recommends a data visualization for a possible explanation.

![Explore data with Data Painter](https://docs-us.oss-us-west-1.aliyuncs.com/img/data-painter/explore-data-with-data-painter.gif)

The auto-generated result explains why the data is distributed unevenly: it was caused by the `FundingModel` variable. The blue dots on top of the chart are private schools, while the red dots on the lower side of the chart are public schools.

![Data Exploration Result with Data Painter](https://docs-us.oss-us-west-1.aliyuncs.com/img/data-painter/data-exploration-result-with-data-painter.png)


For more suggested results, you can click on the "Next" and "Last" buttons to navigate through all the generated results.


### Case 2.

In the following case, we are about to explore an interesting pattern that is more complex.

**Step 1**. We are about to analyze a chart with a complicated pattern. The chart demonstrates the relationship between `SOC` and the `Maximum battery voltage`.
![Data Exploration - patterns about battery SOC](https://docs-us.oss-us-west-1.aliyuncs.com/img/data-painter/data-exploration-pattern-soc.png)

**Step 2.** We can use the Data Painter to study the unusual pattern in the chart. Click on the Data Painter button under the chart, and color the pattern by dragging your mouse cursor. 

Click on the **Search** button. RATH can automatically detect your intention. Here, RATH suggests the deciding factor is the Vehicle Condition. The pattern represents the vehicle engine is in a flameout condition.

![Explore SOC patterns with Data Painter](https://docs-us.oss-us-west-1.aliyuncs.com/img/data-painter/data-painter-pattern-soc.gif)

## Erase unwanted data

You can use Data Painter to remove unwanted parts of data, or remove anomalies.

To erase data in Data Painter, click on the **Erase** button, and wipe out the unwanted data.

![Erase data with Data Painter](https://docs-us.oss-us-west-1.aliyuncs.com/img/data-painter/data-painter-remove-unwanted-data-1.gif)

After removing the unwanted parts of the data, you can focus on the data that you want to anslysis.

![Erase data with Data Painter](https://docs-us.oss-us-west-1.aliyuncs.com/img/data-painter/data-painter-remove-unwanted-data-2.gif)

## Explore patterns in data

You might spot some patterns in the data. However, there are no available variables or features that could accurately describe the patterns in the original data.

In this case, you can create new variables and features with Data Painter, by painting the data in different colors. Each color represents a different subset or group.

![Explore patterns in data](https://docs-us.oss-us-west-1.aliyuncs.com/img/data-painter/explore-patterns-in-data.gif)

You can also visualize the patterns in your data by building customized charts. Click on the **Explore** button and use a Tableau-like User Interface to build customized charts by dragging and dropping.

![Build customized charts in Data Painter](https://docs-us.oss-us-west-1.aliyuncs.com/img/data-painter/customized-charts-with-data-painter.gif)

## Like my post?👾
I am also working on an Awesome Open Source project named: [RATH](https://kanaries.net).
Check it out on [GitHub](https://github.com/Kanaries/Rath)!