Automated Multi-Currency Data Cleaning &
Automated Multi-Currency Data Cleaning & Normalization Web Application
Role: Data Analyst / Python Web Developer
Tools Used: Python, Streamlit, Pandas, Data Cleaning, Data Normalization
Project Overview:
Developed an interactive Python web application using Streamlit that automates the extraction, cleaning, and normalization of raw multi-currency transaction datasets.
Key Architecture & Execution Steps:
Raw Data Ingestion: Uploaded unformatted raw transaction records containing mixed currency symbols (e.g., ₦, ,, (.00)) and dates.
Interactive UI Configuration: Designed custom user dropdowns enabling users to select target currency and date columns for automated processing.
Data Sanitization Engine: Processed dirty strings into clean numeric float values using Pandas regex transformation pipelines (raw_total_clean).
Standardization & Export: Outputted standardized ISO-formatted sanitized data tables with immediate downloadable CSV capabilities.
0 likes · 0 views · Oct 24, 2026
Automated Multi-Currency Data Cleaning & Normalization Web Application Role: Data Analyst / Python Web Developer Tools Used: Python, Streamlit, Pandas, Data ...
