spinningwren
New Member
- Joined
- Sep 3, 2014
- Messages
- 1
Hello All,
I am trying to identify flight routes, times and number of operations per week. The data I have has been provided with numerous entries, some the same and some slightly differing, where the flight may take off slightly earlier on a Monday than on a Friday. The number of operations is supplied by days of the week where 1 is Monday, 2 is Tuesday etc etc.
<tbody>
</tbody>
I am not interested in flight times on each day, just getting the average time, so I can put it into a time frame and the number of services per week.
Does anyone know how I can do this easily please?
Thanks in advance,
SW
I am trying to identify flight routes, times and number of operations per week. The data I have has been provided with numerous entries, some the same and some slightly differing, where the flight may take off slightly earlier on a Monday than on a Friday. The number of operations is supplied by days of the week where 1 is Monday, 2 is Tuesday etc etc.
Flight Number | Airline | Departure Airport | Arrival Airport | Arrival Time | Days of Operation |
AA123 | AA | BOS | LHR | 08:00 | 123 |
AA123 | AA | BOS | LHR | 07:55 | 1 456 |
AA123 | AA | BOS | LHR | 08:00 | 7 |
<tbody>
</tbody>
I am not interested in flight times on each day, just getting the average time, so I can put it into a time frame and the number of services per week.
Does anyone know how I can do this easily please?
Thanks in advance,
SW