Data Cleaning Process Automation - Historical Trading Data

1. Data Acquisition

Simulating the acquisition of historical trading data.







2. Data Cleaning Rules Configuration

Define rules for data cleaning.

3. Raw Data

Display of raw historical trading data.

Date Stock Code Price Volume
2024-01-31 600520 150.25 1000
2024-01-31 600520 150.50
2024-02-01 600519 1800.00 500
2024-02-01 600519 1799.50
2024-02-02 000858 250.75 2000
2024-02-02 000858 251.00 1500

4. Cleaned Data

Display of cleaned historical trading data.

Date Stock Code Price Volume

5. Data Quality Check Results

Results of data quality checks.

Rule Status Message

6. Financial Risk Identification and Management

Showcasing the detection and management of financial risks.

Date Stock Code Risk Description

7. Risk Assessment Results

Results of risk assessment and the related indicators used.

Assessment Date Stock Code Risk Level Risk Score

8. Data Lineage Analysis

Displaying the flow and transformation of the data.