In this homework, you are going to solve the following issue, 5. In the RecentDelays column, the values have been entered into the DataFrame as a list. We would like each first value in its own column, each second value in its own column, and so on. If there isn't an Nth value, the value should be NaN. Expand the Series of lists into a DataFrame named delays, rename the columns delay_1, delay_2, etc. and replace the unwanted RecentDelays column in df with delays. 

CODE:

import numpy as np 

import pandas as pd 

df = pd.DataFrame({'From_To': ['LoNDon_paris', 'MAdrid_miLAN', 'londON_StockhOlm', 'Budapest_PaRis', 'Brussels_londOn'], 'FlightNumber': [10045, np.nan, 10065, np.nan, 10085], 'RecentDelays': [[23, 47], [], [24, 43, 87], [13], [67, 32]], 'Airline': ['KLM(!)', ' (12)', '(British Airways. )', '12. Air France', '"Swiss Air"']})

 

Task 1 -  In the RecentDelays column, the values have been entered into the DataFrame as a list. We would like each first value in its own column, each second value in its own column, and so on. If there isn't an Nth value, the value should be NaN. Expand the Series of lists into a DataFrame named delays, rename the columns delay_1, delay_2, etc.

 

Task 2 - add the 3 delay columns in the orginal data

  Task 3 - Replace the unwanted RecentDelays column in df with delays. Task 4 - Order the columns in the following order 'FlightNumber', 'delay_1','delay_2','delay_3','Airline','From','To' Task 5 - Fix the issue in the last column "From_To" so that the result looks as in expected output 

Jupyter Notebook

Transcribed Image Text:

Expected output: The output should look like below In [23]: df2 Out [23]: 0 1 2 3 4 delay_1 delay_2 delay_3 47.0 NaN 43.0 23.0 NaN 24.0 13.0 67.0 NaN 32.0 NaN NaN 87.0 NaN NaN Expected output: The output should look like below In [23]: df2 Out [23]: 0 1 2 3 4 delay_1 delay_2 delay_3 47.0 NaN 43.0 23.0 NaN 24.0 13.0 67.0 NaN 32.0 NaN NaN 87.0 NaN NaN

Answer rating: 100% (QA)

Here is the code to solve the problem Python import numpy as np import pandas as pd df pdDataFrameFr... View the full answer