As an Account Manager, I deal with messy client data every day. I built this script to automate the "boring stuff"โcleaning duplicate entries and calculating total revenue from closed dealsโso I can focus on strategy.
- Python 3
- Pandas Library: Used for data manipulation and cleaning.
- Matplotlib.pylot Library: Used for lotting bar chart and heatmap
- Data Ingestion: Simulates a raw export from a CRM.
- Deduplication: Automatically identifies and removes duplicate customer entries.
- Logic: Filters the data to sum up 'Closed' deals while ignoring 'Pending' ones.
- Reporting: Prints a clean summary to the console.
- How to handle
DataFrames(the foundation of AI data). - The importance of data cleaning before analysis.
- How to use f-strings for professional reporting.
This is my first step into bridging the gap between Sales and Data Science!
