Skip to content

A Python-powered sales data cleaner that automates lead organization and revenue reporting using Pandas.

Notifications You must be signed in to change notification settings

mobrahi/my-first-python-project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

ย 

History

5 Commits
ย 
ย 
ย 
ย 
ย 
ย 

Repository files navigation

Sales Analysis Chart

๐Ÿ“ˆ Sales Data & Revenue Analyzer

๐ŸŽฏ The Goal

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.

๐Ÿ›  Tech Used

  • Python 3
  • Pandas Library: Used for data manipulation and cleaning.
  • Matplotlib.pylot Library: Used for lotting bar chart and heatmap

๐Ÿš€ How it Works

  1. Data Ingestion: Simulates a raw export from a CRM.
  2. Deduplication: Automatically identifies and removes duplicate customer entries.
  3. Logic: Filters the data to sum up 'Closed' deals while ignoring 'Pending' ones.
  4. Reporting: Prints a clean summary to the console.

๐Ÿง  What I Learned

  • 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!

About

A Python-powered sales data cleaner that automates lead organization and revenue reporting using Pandas.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published