Analyze a field

Learn how to analyze specific fields, find missing values, and discover patterns.

Analyzing a specific field yields more detailed insights. You can have AI analyze the value distribution, missing situation, and anomaly patterns of a field.

In a cleaning plan, understanding which fields need treatment and how to treat them is an important first step.

Field analysis

Have AI analyze statistics for a specific field: unique value count, missing value ratio, most common values, and distribution.

If a field's analysis results do not match expectations, you may need to check whether the data was imported correctly.

Missing analysis

Analyze the missing value situation for a field: missing proportion, patterns in missing occurrences, and whether they correlate with other fields.

If an important field has many missing values, consider filling or flagging in the cleaning plan.

Pattern analysis

Have AI check whether there are repeated or inconsistent patterns in field values. For example, inconsistent date formats or variant category labels.

Pattern analysis helps you discover non-standard data that needs to be handled in the cleaning plan.