There are a couple of different ways to merge data in Python, the default is an inner merge where the merge will occur on values that exist in both the left and right DataFrames. However ...

joined_df = pd.merge(mydf, mylookup, left_on= "OP_UNIQUE_CARRIER", right_on="Code") joined_df.head(10) If we run these lines in the Python 3 console, we get: martinheller@Martins-Retina-MacBook ...