title: How can I get list of values with specific index, column from another df without using iteration?
body: <p>I have two dataframes df1, df2. </p>
  
  <pre><code>df1=pd.DataFrame(columns=['name','yr'])
  df1.name=['a','b','c','b','d','a']
  df1.yr=[2017,2016,2017,2018,2018,2019]
  df2=pd.DataFrame(index=[2016,2017,2018,2019],columns=['a','b','c','d'],data= np.random.randn(4,4))
  </code></pre>
  
  <p>What I want is add new column 'z' with values from df2, corresponding 'name' and 'year'.</p>
  
  <p>iteration using for statement is not my consideration.</p>
  
  <p>*added)
  'merge' cannot be used because matching data in df1 is in index&amp;column of df2</p>