Dropping duplicates in Pandas excluding one column
<p>This seems simple, but I can not find any information on it on the internet.</p>
<p>I have a dataframe like below:</p>
<pre><code>City    State Zip           Date        Description       
Earlham IA    50072-1036    2014-10-10  Postmarket Assurance: Devices
Earlham IA    50072-1036    2014-10-10  Compliance: Devices
Madrid  IA    50156-1748    2014-09-10  Drug Quality Assurance
</code></pre>
<p>How can I eliminate duplicates that match 4 of 5 columns? The column not matching being <code>Description</code>.</p>
<p>The result would be</p>
<pre><code>City    State Zip           Date        Description       
Earlham IA    50072-1036    2014-10-10  Postmarket Assurance: Devices
Madrid  IA    50156-1748    2014-09-10  Drug Quality Assurance
</code></pre>
<p>I found online that <code>drop_duplicates</code> with the <code>subset</code> parameter could work, but I am unsure of how I can apply it to multiple columns.</p>