title: Reduces dataframe based on maximum and duplicate rows
body: <p>I would like to reduce this dataframe with multiple rows with the same name, but with different values to a dataframe containing only 1 row per name with the maximum value.</p>
  <pre><code>df = pd.DataFrame([{&quot;Name&quot;: &quot;Foo&quot;, &quot;Value&quot;: 1}, {&quot;Name&quot;: &quot;Foo&quot;, &quot;Value&quot;: 3}, {&quot;Name&quot;: &quot;Bar&quot;, &quot;Value&quot;: 1},{&quot;Name&quot;: &quot;Bar&quot;, &quot;Value&quot;: 4}])
  </code></pre>
  <p>Dataframe wanted:</p>
  <pre><code>df_filtered = pd.DataFrame([{&quot;Name&quot;: &quot;Foo&quot;, &quot;Value&quot;: 3}, {&quot;Name&quot;: &quot;Bar&quot;, &quot;Value&quot;: 4}])
  </code></pre>
  <p>I started with df.groupby however it didn't feel natural.</p>