Python pandas: remove everything after a delimiter in a string
<p>I have data frames which contain e.g.:</p>
<pre><code>&quot;vendor a::ProductA&quot;
&quot;vendor b::ProductA&quot;
&quot;vendor a::Productb&quot;
</code></pre>
<p>I need to remove everything (and including) the two :: so that I end up with:</p>
<pre><code>&quot;vendor a&quot;
&quot;vendor b&quot;
&quot;vendor a&quot;
</code></pre>
<p>I tried str.trim (which seems to not exist) and str.split without success.
what would be the easiest way to accomplish this?</p>