This repository contains my Python, Data Structures in Python (DSA), Web Development, and SQL programs from my college coursework.
Here, I practice coding exercises, assignments, and small projects as part of my learning journey in the Artificial Intelligence & Data Science (AI&DS) program.
| 🧩 Domain | 📘 Description |
|---|---|
| 🐍 Python Programming | Core Python, OOP concepts, file handling, exception handling, and JSON operations. |
| 🧠 Data Structures & Algorithms (DSA) | Implementation of lists, stacks, queues, linked lists, trees, sorting and searching algorithms using Python. |
| 🌐 Web Development | Web applications using Flask, Streamlit, and HTML/CSS for dashboards and user interfaces. |
| 💾 SQL & Database Management | SQL queries, CRUD operations, and database integration with Python using MySQL. |
I practice and run Python programs using the following IDEs and compilers provided by my college:
| 🧠 IDE / Tool | 💡 Description | 🔗 Link |
|---|---|---|
| 🪶 Thonny | Beginner-friendly Python IDE (libraries: math, os, json) |
thonny.org |
| 🧩 PyCharm | Advanced Python IDE for professional use (libraries: pandas, numpy, matplotlib) |
jetbrains.com/pycharm |
| 💻 VS Code | Lightweight editor with Python extensions (libraries: streamlit, threading, flask, altair) |
code.visualstudio.com |
| 🧮 MySQL Workbench | SQL IDE for designing and managing databases used with Python CRUD programs | dev.mysql.com/workbench |
Created a simple calculator using if-else and while loops.
- 🎯 Guess the number game.
- 💬 Simple chatbot that replies to user input.
- 🔐 Passcode verification program.
- ⚖️ BMI calculator using height and weight.
- 📚 Student details stored using Python dictionary.
- 🏆 Calculated student ranks using Object-Oriented Programming.
- 📊 Displayed student data in a formatted table.
💻 Created a Streamlit-based web app to view and analyze bank statements interactively.
🏧 Simulated ATM operations using:
- 🧱 Python OOP
- 🌐 Flask Web App
- 🚀 Streamlit Dashboard
🚙 Displayed car and bike details using Multiple Inheritance in Streamlit.
💾 Created a console-based Bank Management System using:
- Python file handling
- JSON storage for persistent data
✅ Features: - Add new account
- View all accounts
- Update existing details
- Delete account safely
⚙️ Focused on exception handling and data persistence
🩺 Built a live hospital monitoring system featuring:
- Sensor Data Reading – Generates live vitals like heart rate, temperature, and oxygen.
- Doctor Notification System – Detects abnormal readings and triggers real-time alerts.
- Data Logging – Records recent health data for trend analysis.
💾 Built a CRUD-based Student Management System using Python and MySQL Workbench. ⚙️ Performed add, view, update, and delete operations using mysql.connector and SQL queries.
💾 Developed Python applications with MySQL backend:
- Bank Management System: Supported account creation, viewing, updating, deletion, and withdrawals with PIN authentication.
- Hospital Management System: Enabled patient registration, record updates, department-wise appointments, and automated doctor scheduling with secure access.
🏥 Built a Hospital Appointment System using Streamlit and MySQL.
🩺 Supports patient registration, appointment booking, and doctor login with real-time database updates.