The departure_airport_code in flighthistory.csv is expected to be 3 characters long, isn't it? In few cases it's 4 characters long and equals the icao code. Same for arrival_airport_code.

Hi Martin,

I think departure_airport_code is not relevant.   Try to extract only 3 requested variables from flighthistory.csv;  flight_history_id,  actual_runway_arrival, actual_gate_arrival.   You can use MS Excel (data, import, text).    There are many fields with missings and hiddens.   You can try to estimate missing and hidden fields (a bit difficult),  or  put  0s  (errors in predictions wil be high).

regards,

I. Jaganjac.