-
The Book Donation Camp, organized by the Bookworm club, collects books and notebooks, assesses their condition, and categorizes them as Fit, Needs Mending, or Unfit. Unfit books are repurposed into paper bags and envelopes.
-
The club intends to create a software that stores data about the camp using Pandas, with details stored in a CSV file. Item categories include Books (Academic or Non-Academic) and Notebooks, with corresponding item IDs and conditions.
-
After items are refurbished, data is stored in another CSV file with headings: Item ID, Item Name, Item Category, Quantity, and Price. Item Category can be Paper bags, Notebook, or Books, with Class entered for Books.
-
An orders CSV file is created to store Item Category, Item Name, Quantity, and Price. The refurbished CSV updates the quantity for orders.
-
Data visualization is essential for effective decision-making. Plots should be created to show sales, items refurbished, and items collected.