title: Compare two dataframe column values and join with condition in python?
body: <p>I need to join the below dataframe based on some condition.</p>
  <pre><code>df1:
      Id             Value
      [101,102,103]   10001
      [101,102,104]   10000
      [101,102,105]   10002
      [101,107,105]   10003
  
  df2:
  
      Id                 Product_Name
      [101,102,103,104]  Shoe
      [101,102,109,104]  jeans
      [101,105,102,108]  make-up
      [101,105,106,118]  shirt
  </code></pre>
  <p>df_output</p>
  <pre><code>Id             Value    Product_Name
  [101,102,103]   10001   Shoe           -- Every value present in df2.Id list
  [101,102,104]   10000   Jeans          -- Every value present in df2.Id list
  [101,102,105]   10002   Make-Up        -- Every value present in df2.Id list
  [101,107,105]   10003   NaN            -- Not Every Value matches in df2.Id list.
  </code></pre>
  <p>I need to join two dataframe df1, df2 based on Id column but every element should be in df.Id list that's when we consider it a match.</p>
  <pre><code>Python Code:
  
  import pandas as pd
  
  df_output = pd.merge(df1, df2, on='Id', how='left')
  </code></pre>