Question

Python Exercise A dataset contains 3 airline routes and its country of origin and destination. Each airline has its own unique prefix as shown below: Airline Global Airlines Rex Airlines United Airlines Prefix (case sensitive) GL RX UA The dataset is shown below. As you can see, certain prefixes are incorrect for their corresponding airline. Assume that the Airline and Flight number is correct. Please fix the airline prefix (case sensitive) using python (any libraries are permitted). Original dataframe airline_flight origin destination Expected Output airline_flight origin destination 0 Global\GL-233 SG QA 0 Global\GL-233 SG QA 1 Global\gl-234 QA SG 1 Global\GL-234 QA SG 2 Rex\RX-45 IN EG 2 Rex\RX-45 IN EG 3 Rex\rx-46 EG IN 3 Rex\RX-46 EG IN 4 Global\ER-65 QA NZ 4 Global\GL-65 QA NZ 5 United\UA-4 US QA 5 United\UA-4 US QA 6 United\GL-2 US GB 6 United\UA-2 US GB

          Python Exercise
A dataset contains 3 airline routes and its country of origin and destination. Each airline has its own unique prefix as shown below:
Airline
Global Airlines
Rex Airlines
United Airlines
Prefix (case sensitive)
GL
RX
UA
The dataset is shown below. As you can see, certain prefixes are incorrect for their corresponding airline.
Assume that the Airline and Flight number is correct. Please fix the airline prefix (case sensitive) using python (any libraries are
permitted).
Original dataframe
airline_flight origin destination
Expected Output
airline_flight origin destination
0 Global\GL-233 SG QA
0 Global\GL-233 SG QA
1 Global\gl-234 QA SG
1 Global\GL-234 QA SG
2 Rex\RX-45 IN EG
2 Rex\RX-45 IN EG
3 Rex\rx-46 EG IN
3 Rex\RX-46 EG IN
4 Global\ER-65 QA NZ
4 Global\GL-65 QA NZ
5 United\UA-4 US QA
5 United\UA-4 US QA
6 United\GL-2 US GB
6 United\UA-2 US GB

Python Exercise
A dataset contains 3 airline routes and its country of origin and destination. Each airline has its own unique prefix as shown below:
Airline
Global Airlines
Rex Airlines
United Airlines
Prefix (case sensitive)
GL
RX
UA
The dataset is shown below. As you can see, certain prefixes are incorrect for their corresponding airline.
Assume that the Airline and Flight number is correct. Please fix the airline prefix (case sensitive) using python (any libraries are
permitted).
Original dataframe
airlineflight origin destination
Expected Output
airlineflight origin destination
0 Global-233 SG QA
0 Global-233 SG QA
1 Global-234 QA SG
1 Global-234 QA SG
2 Rex-45 IN EG
2 Rex-45 IN EG
3 Rex-46 EG IN
3 Rex-46 EG IN
4 Global-65 QA NZ
4 Global-65 QA NZ
5 United-4 US QA
5 United-4 US QA
6 United-2 US GB
6 United-2 US GB

Added by Jimmy P.

Question

Please give Ace some feedback