Replace string in Pandas column by substring from list
<p>I have a DF:</p>

<pre><code>DF
camp, value
asd_abcd_gr_yxz_aaaa, 5
efgh_kr_ijk, 10
hjssaasd_kr_adsad, 15
asdas_kr_asd, 2
asd_fr_asda_bb_bbbbbbb, 12
adklasdj_gr_asdsad, 3
</code></pre>

<p>and much longer.</p>

<p>After comparing with elements in list <code>[_gr_, _kr_, _fr_, etc..]</code> I want the result to be</p>

<pre><code>DF
camp, value
gr, 8
kr, 27
fr, 12
</code></pre>

<p>preferably as short as possible without looping through the DF. The list is much longer than <code>_gr_, _kr_, _fr_</code></p>

<p>Thanks in advance!</p>