title: Python - Panda - Get last non empty value
body: <p>Consider I have one DataFrame like this:</p>
  
  <pre><code>ID,    name,  result_1,   result_2
  1 ,    John,       8.9,        1.1
  2 ,    John,       3.3,          
  3 ,    John,          ,        9.9
  4 ,    Mark,       8.8,        4.5
  5 ,    Mark,       5.5,   
  </code></pre>
  
  <p>What I need to retrieve is the 'result_1' and 'result_2' values of the greatest ID, considering non-empty 'results'. 
  My final DataFrame must be a 2 line table like this:</p>
  
  <pre><code>name,  result_1,   result_2
  John,       3.3,        9.9
  Mark,       5.5,        4.5
  </code></pre>
  
  <p>Thanks in advance. </p>