avgwaittimeandduration.py

average_wait=pd.Series(df.mean(), name="Average Wait Time")
print(average_wait)

#example output
#Astro Orbitor                                     12.453125
#Buzz Lightyear Astro Blasters                     17.953125

duration = pd.Series(ride_durations, name="Ride Duration")
print(duration)

#example output
#Millennium Falcon FASTPASS Kiosk                                   0.00
#Buzz Lightyear Astro Blasters FASTPASS Kiosk                       1.00

pd.concat([average_wait, duration], axis=1)

#example output
#                                       Average Wait  Time	Ride Duration
# "it's a small world" Holiday Lighting	NaN	                5.00
# A Christmas Fantasy Parade	          NaN	                27.00
# Alice in Wonderland	                  NaN	                4.00
# Astro Orbitor	                        12.453125	          1.50

#We need to remove rows with null values
ride_by_wait_time_duration = pd.concat([average_wait, duration], axis=1).dropna()
print(ride_by_wait_time_duration)