title: Find the most similar row using Python
body: <p>I have two data frames (df1 and df2). In the df1 I store one row with a set of values and I want to find the most similar row in the df2.</p>
  
  <pre class="lang-py prettyprint-override"><code>import pandas as pd
  import numpy as np
  
  # Df1 has only one row and four columns.
  df1 = pd.DataFrame(np.array([[30, 60, 70, 40]]), columns=['A', 'B', 'C','D'])
  
  # Df2 has 50 rows and four columns
  df2 = pd.DataFrame(np.random.randint(0,100,size=(50, 4)), columns=list('ABCD'))
  </code></pre>
  
  <p>Question: Based on the df1 what is the most similar row in df2?</p>