A robust Python automation script designed to process, clean, and analyze raw financial transaction data. This tool simulates a real-world ETL (Extract, Transform, Load) process commonly used in Fintech environments to handle inconsistent data sources.
- Data Cleaning: Automatically detects and removes records with missing critical values (Dates, Amounts).
- Error Handling: Safely converts data types, managing non-numeric errors in financial fields.
- Business Logic: Filters transactions by currency (EUR) and categorizes unlabeled records.
- Reporting: Generates a statistical summary (Total Volume) and exports a clean Excel report.
- Language: Python 3.10+
- Data Manipulation: Pandas, NumPy
- Export Format: Excel (.xlsx)
- Place your raw data in
transactions.csv. - Run the script:
python main.py