# pradheepsrinivas16-crypto/data-cleaning-reporting-automation architecture

> Architecture diagram of the GitHub repository pradheepsrinivas16-crypto/data-cleaning-reporting-automation, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-03). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation
- Repository: https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation

## Overview

This is a command-line retail-sales cleaning and reporting tool. The user runs the Python script on the raw CSV; the workflow cleans and validates records, analyzes business metrics, and writes cleaned data, audit flags, and an Excel report. The README documents the end-to-end stages and report contents. The source excerpt shows cleaning logic and analysis/reporting code, but omits parts of the script, so internal call relationships are shown only where the README supports them.

Main entry points: [`task4_automation_final_v2.py`](https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/task4_automation_final_v2.py) (CLI Workflow), [`retail_store_sales.csv`](https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/retail_store_sales.csv) (Raw Sales CSV), [`Clean_Retail_Store_Sales.csv`](https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/Clean_Retail_Store_Sales.csv) (Cleaned Sales CSV), [`Cleaning_Audit_Flags.csv`](https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/Cleaning_Audit_Flags.csv) (Audit Flags CSV)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_workflow["Workflow"]
  node_rawdata["Raw Sales CSV"]
  node_runner["CLI Workflow"]
  node_cleanout["Cleaned Sales CSV"]
end

subgraph group_quality["Data Quality"]
  node_cleaning["Clean and Recover"]
  node_audit["Cleaning Audit"]
  node_validation["Data Validation"]
  node_auditout["Audit Flags CSV"]
end

subgraph group_reporting["Analysis and Reporting"]
  node_analysis["Business Analysis"]
  node_excel["Excel Report"]
  node_reportout["Automated Workbook"]
end

node_user(("Operator"))

node_user -->|"runs"| node_runner
node_rawdata -->|"reads"| node_runner
node_runner -->|"cleans"| node_cleaning
node_cleaning -->|"validates"| node_validation
node_cleaning -->|"records actions"| node_audit
node_runner -->|"analyzes"| node_analysis
node_runner -->|"generates"| node_excel
node_cleaning -->|"writes"| node_cleanout
node_audit -->|"writes"| node_auditout
node_analysis -.->|"supplies summaries"| node_excel
node_excel -->|"writes"| node_reportout

click node_rawdata "https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/retail_store_sales.csv"
click node_runner "https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/task4_automation_final_v2.py"
click node_cleaning "https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/task4_automation_final_v2.py"
click node_audit "https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/task4_automation_final_v2.py"
click node_validation "https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/task4_automation_final_v2.py"
click node_analysis "https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/task4_automation_final_v2.py"
click node_excel "https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/task4_automation_final_v2.py"
click node_cleanout "https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/Clean_Retail_Store_Sales.csv"
click node_auditout "https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/Cleaning_Audit_Flags.csv"
click node_reportout "https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/Retail_Data_Automated_Report.xlsx"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_rawdata,node_runner,node_cleanout toneBlue
class node_cleaning,node_audit,node_validation,node_auditout toneAmber
class node_analysis,node_excel,node_reportout toneMint
class node_user toneIndigo
```

## Components

### Workflow

- [Raw Sales CSV](https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/retail_store_sales.csv): `retail_store_sales.csv`
- [CLI Workflow](https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/task4_automation_final_v2.py): `task4_automation_final_v2.py`
- [Cleaned Sales CSV](https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/Clean_Retail_Store_Sales.csv): `Clean_Retail_Store_Sales.csv`

### Data Quality

- [Clean and Recover](https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/task4_automation_final_v2.py): `task4_automation_final_v2.py`
- [Cleaning Audit](https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/task4_automation_final_v2.py): `task4_automation_final_v2.py`
- [Data Validation](https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/task4_automation_final_v2.py): `task4_automation_final_v2.py`
- [Audit Flags CSV](https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/Cleaning_Audit_Flags.csv): `Cleaning_Audit_Flags.csv`

### Analysis and Reporting

- [Business Analysis](https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/task4_automation_final_v2.py): `task4_automation_final_v2.py`
- [Excel Report](https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/task4_automation_final_v2.py): `task4_automation_final_v2.py`
- [Automated Workbook](https://github.com/pradheepsrinivas16-crypto/data-cleaning-reporting-automation/blob/main/Retail_Data_Automated_Report.xlsx): `Retail_Data_Automated_Report.xlsx`

### Other components

- **Operator**

## Connections

- Operator → CLI Workflow: runs (evidence: `README.md`)
- Raw Sales CSV → CLI Workflow: reads (evidence: `README.md`)
- CLI Workflow → Clean and Recover: cleans (evidence: `README.md`)
- Clean and Recover → Data Validation: validates (evidence: `README.md`)
- Clean and Recover → Cleaning Audit: records actions (evidence: `README.md`)
- CLI Workflow → Business Analysis: analyzes (evidence: `README.md`)
- CLI Workflow → Excel Report: generates (evidence: `README.md`)
- Clean and Recover → Cleaned Sales CSV: writes (evidence: `README.md`)
- Cleaning Audit → Audit Flags CSV: writes (evidence: `README.md`)
- Business Analysis → Excel Report: supplies summaries (evidence: `task4_automation_final_v2.py`)
- Excel Report → Automated Workbook: writes (evidence: `README.md`)
