This web application facilitates the digitalization of the hospitality process for group accommodation in hostels. It allows users to upload two CSV files containing group information and hostel room details. The application then allocates rooms based on specified criteria and provides allocation details.
Upload CSV Files: Users can upload two CSV files:
Group Information CSV: Contains details about groups such as group ID, number of members, and gender.
Hostel Information CSV: Contains information about hostel rooms including hostel name, room number, capacity, and gender accommodation. Room Allocation Algorithm: Allocates rooms based on the following criteria:
Boys and girls stay in their respective hostels. Room capacity is not exceeded. Output: Displays allocated rooms with details such as group ID, hostel name, and room number. Also provides a downloadable CSV file with allocation details.
Frontend: HTML, CSS, JavaScript (Fetch API) Backend: Python (Flask) Data Processing: Pandas library for Python
Make sure you have Python 3.x installed.
pip3 install Flask pandas
python3 app.py
Open your web browser and go to http://localhost:5000/
Choose your Group Information CSV and Hostel Information CSV files using the file input fields. Click on the "Upload" button to process the files.
Once files are uploaded, allocated rooms will be displayed on the web page. You can download the allocation details as a CSV file using the provided link.
Cross-Origin Request Blocked: If you encounter CORS issues during development, ensure that the frontend (index.html) is served by Flask (app.py). Check the Flask server logs and browser console for any error messages.