Question

how to compute the average speed for each location?

for example the pair is the location. how can I get all the locations of 1,2,3,4,5,6,7,8,9,10,11,12,13,14 and the speed for each of them to find the mean.

I tried doing this

df4=df [df [ ['pair', 'speed']]==1].mean() #To get all the pairs with 1's and it's speeds and getting the mean

df4=df [df [['pair','speed']]==2].mean() #To get all the pairs with 2's and it's speeds and getting the mean

.

Unnamed: 0 speed period warning pair 26 2 26 3 26 26 5 27 28 7 28 28 28 29 29 12 29 13 29 29 29 29 29 30 30 10 10 12 13 14 15 16 17 18 14 15 16 17 18 19

Answer 1

To get the mean of speeds where pair is 1, enter following command

df.loc[df['pair']==1,'speed'].mean()

assuming df is the name of dataframe

to get the mean where pair =2, command is

df.loc[df['pair']==2,'speed'].mean().

and so on