title: Performing computations with values of two dataframes
body: <p>I have two pandas data frames.</p>
  
  <p><strong>DataFrame 1</strong></p>
  
  <pre><code>Index_Col    Col1   Col2   Col3   Col4   Col5
  
  Row1         0.64   0.89   0.76   0.22   1.34
  
  Row2         0.54   0.56   0.82   0.46   0.23
  
  and so on.
  </code></pre>
  
  <p>DataFrame 2 has Thresholds for each of the columns in dataframe1 as a range.</p>
  
  <p><strong>DataFrame 2</strong></p>
  
  <pre><code>Column_Name    Group    Min     Max
  
  col1           G1        0.5    1
  
  col2           G1        0.1    2
  
  col3           G2        0.3    0.9
  
  col4           G1        0.3    1
  
  col5           G2        0.7    2
  
  and so on
  </code></pre>
  
  <p>I am trying to compute <code>value = ((value - Min)/(Max - Min))*100</code> for every value in every column of DataFrame1. For example, the value of Row1 of Col1 will be 
  <code>((0.64-0.5)/(1-0.5))*100</code>.</p>
  
  <p>I tried converting everything to lists and compute using multiple for loops. But I would like to know if there's any simpler method.</p>