📊 Agent Sales Data Collector (Streamlit)

📌 Overview

This project implements a sales data collection and summary tool using Python and Streamlit. It allows users to upload transaction records, validates file naming conventions, and generates monthly summaries by agent and year.

🎯 Purpose

To demonstrate how Python can be used to streamline sales data intake and reporting. The project emphasizes python dictionaries handling, aggregation logic, and user-friendly interface.

🗃️ Files Included

• Khue_Agent Sales.py — Final Python script for the sales data interface
• sample_sales_data/ — Folder containing sample CSV files for testing

🛠️ Technologies Used

• Python
• Streamlit
• os for file handling

📈 Key Features

• Upload interface for agent sales CSV files
• Validates file naming format: SalesYYYYMM.csv
• Aggregates sales by agent, month, and year
• Displays summary tables and export options
• Designed for clarity and operational reporting

🚀 How to Run

1. Install Streamlit and pandas: pip install streamlit
2. Run the app: streamlit run Khue_Agent Sales.py
3. Upload sales files from the sample_sales_data folder and save the sale data for their corresponding month and year
4. View monthly summaries for each agent by year.

🙋‍♀️ Author

Khue Tram — exploring business analytics through SQL, NoSQL, and Python tools, with a focus on turning data into strategic insight.
GitHub Profile
LinkedIn Profile