title: Pandas search max value in certain row range in Column
body: <p>i have data from series with 5 column and x row</p>
  
  <pre><code>import pandas as pd
  data = {'name' : ['bill', 'joe', 'steve', 'ana', 'john', 'ray'],
      'test1' : [85, 75, 85, 87,75, 81],
      'test2' : [35, 45, 83, 35, 45, 83],
      'test3' : [51, 61, 45, 51, 91, 45],
      'Highscore' : [85 , 75, 85, 87, 91, 83],
  }
  frame = pd.DataFrame(data)
  print(frame)
  </code></pre>
  
  <p>this the print result</p>
  
  <pre><code>        name  test1  test2  test3  HighScore
      0   bill     85     35     51        85
      1    joe     75     45     61        75
      2  steve     85     83     45        85
      3    ana     87     35     51        87
      4   john     75     45     91        91
      5    ray     81     83     45        83
  </code></pre>
  
  <p>How to get maximum value in Column only for certain row range?</p>
  
  <pre><code>test1 from 0 to 3 --&gt; 87
  test2 from 3 to 5 --&gt; 83
  Highscore from 0 to 3 --&gt; 87
  </code></pre>