title: find the value of a specific column in dataframe2 using the value of one column in the dataframe1 in pandas
body: <p>I did some search online. I did not find the exact case am looking for.
  I need help. I have two dataframes with one of the columns containing similar items.  </p>
  
  <pre><code>&gt;&gt;&gt; df1
           ID       Item
  0  0667170D      Apple
  1  0644304D     Orange
  2  0655323D  Pineapple
  3  06284A3D     Banana
  &gt;&gt;&gt; df2
            ID    Item
  0   TY671756  Carrot
  1   JG44454D  Banana
  2   07753DDD  Orange
  3   0628456D   Apple
  </code></pre>
  
  <p>I have a forloop that will compare the Item column between the two dataframes and get the ones that match the closest. Ex: I take apple from 'df2' and compare it to the 'Item' column in df1. I find apple and I update it to a new column in df2 as a matched item. Now I would like to find the 'ID' of apple in 'df1' also for the matched item, in this case, apple. I would like to update the 'ID' of apple in df1 into a new column in df2. </p>
  
  <p>Will I be able to do that also in the same forloop? So that I get an updated df2 with both the matched item found in df1 along with its ID number.</p>
  
  <pre><code>list1 = df2['Item']
  list2 = df1['Item']
  
  for i in list1:
     df2['Item'] = [difflib.get_close_matches(i, list2)]
  </code></pre>