Project Based Learning

Project I: Online Shopping Platform

Murugan’s online shopping platform APPAREL EASY should be designed to store and analyse merchandise and sales data using Python Pandas.

### Main idea
- The platform has two broad categories: Men and Women.
- Under each category, the sub-categories are Clothing, Footwear, Accessories.
- Two mega events are to be handled:
- Festive Sale (FEST): from a month before Diwali to Christmas
- End of Season Sale (EOS): in February and August
- Records must be maintained for:
- monthly revenue generation sales
- category-wise sales
- discounts offered by manufacturers, payment sites, or portal promotions
- customers visiting the site and customers placing orders

### Required data fields
The details of Men’s and Women’s apparels should be stored in a data file with fields such as:
- Apparel Code
- Name
- Category
- Size
- Price
- Customer Name
- Payment Mode
- Discount Code

### Category-wise items
- If Category = Men, apparels may include:
- Men’s Trousers
- Men’s Shirt
- Men’s Jeans
- Men’s T-shirt
- If Category = Women, apparels may include:
- Skirts
- Top
- Pants
- Jeans
- Kurta

### Payment mode rules
- If Payment Mode is Credit Card or Debit Card:
- credit/debit card number
- name
- CVV
- validity
should be entered.
- If Payment Mode = COD (Cash on Delivery), then no card details are required.

### Sale selection and discount
- Merchandise to be put on sale should be selected randomly.
- The selected merchandise should be not more than 70% of the total merchandise.
- Discount code can be:
- FEST → 10% discount
- EOS → 15% discount

### What should be implemented
- Visualise the data structure as required.
- Implement the system using Python Pandas.
- Design software to store merchandise details and place them online for sale.
- Maintain records of:
- customers visiting the e-commerce site
- number of customers placing orders
- Plot the collected data appropriately so that Murugan can make better marketing and promotion decisions.

So, in short, the project is about building a data-driven e-commerce management system for apparel sales with customer tracking, discount handling, and graphical analysis.

Project II: Automating a Books Donation Camp

The Bookworm club organises a Book Donation Camp every year to collect books and notebooks, refurbish them, and sell the usable items. The software is to be built using Pandas and data should be stored in CSV files.

### Purpose of the project
- Collect books and notebooks
- Check their condition
- Refurbish the useful ones
- Sell the refurbished items
- Store, retrieve, and visualise the data efficiently

### Collection details
The collection details are stored in a CSV file with these column headings:
- Item category
- Item ID
- Item name
- Item type
- Condition

### Rules for books
- If Item Category = Book:
- Item Type can be Academic or Non Academic
- Item ID should start with 'B'
- For Academic books, the class must be entered

### Rules for notebooks
- If Item Category = Notebook:
- Item can be Single line, Four Line, Five Line
- Item ID should start with 'N'

### Condition of items
Condition can only be:
- Fit
- Needs Mending
- Unfit

### Refurbished data
After refurbishing, the data are stored in another CSV file with headings:
- Item id
- Item name
- Item Category
- Quantity
- Price

Here:
- Item Category can be Paper bags, Notebook, Books
- In case of books, Class is also to be entered

### Order data
Another CSV file is used to store orders with:
- Item Category
- Item name
- Quantity
- Price

When an order is placed, the quantity in the refurbished CSV must be updated.

### Visualisation
Different data should be plotted using suitable plots to show:
- sales
- items refurbished
- items collected

So, this project is about managing a donation camp by collecting, refurbishing, selling, updating quantities, and visualising the data using Pandas.