Problem Statements for JoinsΒΆ
Let us understand how to join Data Frames by using some problem statements. We will use 2008 January airtraffic data along with Airport Codes.
Get number of flights departed from each of the US airport.
Get number of flights departed from each of the state.
Get the list of airports in the US from which flights are not departed.
Check if there are any origins in airtraffic data which do not have record in airport-codes.
Get the total number of flights from the airports that do not contain entries in airport-codes.
Get the total number of flights per airport that do not contain entries in airport-codes.