![python file peek usage python file peek usage](https://vscode-westeu.azurewebsites.net/assets/docs/python/editing/python-editing.gif)
# Only flights from set of airports and with reasonable delay amount # All rows should not have any null value
![python file peek usage python file peek usage](https://education.arcus.chop.edu/images/python_lab_0.png)
We add the following columns using the assign() method, time of flight in datetime format by combining existing columns:.In this part, we fix existing columns and add new ones that will be useful later on: We also convert flight_number from being integers to being character values with the astype() method, by noting that these are IDs are have no ordered meaning.We choose to filter out flights that have more than 1 day delay. Looking at the mean and median of departure_delay, we see that values are heavily right-skewed, and we have a maximum delay of 1988 (~ 33 hours).We keep flights departing from airports that we want to look at with the function.We remove rows with missing values with the dropna() method.# Compute statistics of columns flights_df_raw.