How to merge data from two different data frames? Python

  dataframe, join, merge, pandas, python

Here’s what I got:

The output result should be a data frame with one column called ‘scarcity’ where if it’s low, the entry will be 0, if it’s high the entry will be 1. However, I tried with join, merge and even concat and I can’t get the desired output. Always a data frame with those columns! Any ideas?

Thank you in advance.

Source: Python Questions