title: Replace string in Pandas column by substring from list
body: <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>