Filter one dataframe using multi-index of another dataframe <p>I have the following two dataframes DF1 and DF2. I would like to filter DF1 based on the multi-index of DF2.</p> <pre><code>DF1: Value Date ID Name 2014-04-30 1001 n1 1 2014-05-31 1002 n2 2 2014-06-30 1003 n3 3 2014-07-31 1004 n4 4 DF2 (index = Date, ID, Name): Date ID Name 2014-05-31 1002 n2 2014-06-30 1003 n3 What i would like is this: Value Date ID Name 2014-05-31 1002 n2 2 2014-06-30 1003 n3 3 </code></pre> <p>To do this i simply use:</p> <pre><code>f_df = df1.ix[df2.index] </code></pre> <p>However, when doing this what i am getting is this (notice the tuple index)</p> <pre><code> Value (2014-05-31, 1002, n2) 2 (2014-06-31, 1003, n3) 4 </code></pre> <p>How can i achieve what i am looking for? which is a resulting dataframes without a tuple index?</p>