- Get the Count of beds in each ward.
- Get the count of bed in each room.
- Get the count of the bed under each status.
- Calculate the overall occupancy percentage (total occupied / total bed).
- Calculate occupancy for each ward.
- Calculate occupancy for each room.
- Calculate count of bed with all the different bed statuses for each ward.
- Calculate count of bed with all the different bed statuses for each room.
Completed using jupyter notebook
First, clone the repo
git clone https://github.com/codewithkushagra/sopeonow_backend
Run the following command to install the required dependcy
pip3 install -r requirements.txt
Finally run
jupyter notebook