How pradheepsrinivas16-crypto/data-cleaning-reporting-automation works
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 CLI Workflow · retail_store_sales.csv Raw Sales CSV · Clean_Retail_Store_Sales.csv Cleaned Sales CSV · Cleaning_Audit_Flags.csv Audit Flags CSV
Components 11
Workflow
- Raw Sales CSV
retail_store_sales.csv - CLI Workflow
task4_automation_final_v2.py - Cleaned Sales CSV
Clean_Retail_Store_Sales.csv
Data Quality
- Clean and Recover
task4_automation_final_v2.py - Cleaning Audit
task4_automation_final_v2.py - Data Validation
task4_automation_final_v2.py - Audit Flags CSV
Cleaning_Audit_Flags.csv
Analysis and Reporting
- Business Analysis
task4_automation_final_v2.py - Excel Report
task4_automation_final_v2.py - Automated Workbook
Retail_Data_Automated_Report.xlsx
Other components
- Operator
Connections 11
- Operator → CLI Workflow: runs
README.md - Raw Sales CSV → CLI Workflow: reads
README.md - CLI Workflow → Clean and Recover: cleans
README.md - Clean and Recover → Data Validation: validates
README.md - Clean and Recover → Cleaning Audit: records actions
README.md - CLI Workflow → Business Analysis: analyzes
README.md - CLI Workflow → Excel Report: generates
README.md - Clean and Recover → Cleaned Sales CSV: writes
README.md - Cleaning Audit → Audit Flags CSV: writes
README.md - Business Analysis → Excel Report: supplies summaries
task4_automation_final_v2.py - Excel Report → Automated Workbook: writes
README.md