A desktop-based Library Management System built with Python, Tkinter, Pandas, and OpenPyXL. This application simplifies library operations by allowing users to manage books, issue and return books, search records, and store all data in Excel files.
- 📖 Add new books to the library
- 🔍 Search books by Title, Author, Genre, or ISBN
- 📑 Sort books by Title, Author, Year, Genre, Status, or Cost
- 📤 Issue books to users
- 📥 Return books and update availability
- 💾 Store all data permanently in Excel files
- 📊 Display books and transactions using a user-friendly GUI
- ✅ Automatic validation of user inputs
- Python 3
- Tkinter
- Pandas
- OpenPyXL
- Excel (.xlsx)
Library-Management-System/
│── main.py
│── library_system.xlsx
│── README.md
│── requirements.txt
- Clone the repository:
git clone https://github.com/your-username/Library-Management-System.git- Navigate to the project folder:
cd Library-Management-System- Install the required libraries:
pip install pandas openpyxl- Run the project:
python main.py- Book Management
- Search & Sorting
- Issue Book
- Return Book
- Transaction History
- Excel Data Storage
- User Login System
- Barcode/QR Code Support
- Cloud Database Integration
- Multi-user Access
- Fine Calculation Improvements
- Report Generation
This project demonstrates:
- Python GUI development with Tkinter
- Data handling using Pandas
- Excel file management with OpenPyXL
- CRUD operations
- Object-Oriented Programming
- File handling and data persistence
Ganesh Kondekar
B.Tech Information Technology Student
This project is created for educational and learning purposes.