Dear folks, I need some help with:
I am working with some Hospital data, and I need to calculate Operating Room
Utilization per day
df.groupby(by = ['Actual_Surgery_Day','Actual_Surgery_Room'])
.agg({'Actual_Surgery_Duratation' : 'sum', 'Procedure_Code' : 'count'})
Actual_Surgery_Duratation Procedure_Code
609.0 10
561.0 7
704.0 5
Actual_Surgery_Day Actual_Surgery_Room
20001
20002
20003
..........
20016
2016-01-08
So, I need to calculate a simple following equation **Z=960-x-18(y-1)**
960 min = optimal time (in min) Room Utilization per day
x = Time for all procedures per Day; column - (Actual_Surgery_Duratation)
y = Procedure (amount per day in each Room (- 1), first case); column -
(Procedure_Code)
18 min = break time between each procedure
How do I calculate Room Utilization in %?
**Example**,first row table:
z=960-x-18(10-1)
z=960 min (wanted time) - 609 min (actual time) - 162 (breaktime)
z=189 min time not used
What is the percentage of used time? in % (960 min - 189 min)
I appreciate any help.
Alla
--
https://mail.python.org/mailman/listinfo/python-list
