title: Matching pandas substring with dict key and replacing with dict value
body: <p>Assume I have <code>df</code> and <code>d</code> below. I want to, for each row in <code>col</code>, check if there is a match with an item key in <code>d</code>, and if so replace the value in <code>col</code> with the corresponding item value, otherwise drop that row. (There can't be more than one match).</p>
  <pre><code>df = pd.DataFrame({'col': ['sdffzdhellojkh', 'fegky', 'ouewfzdworldqf']})
  
  d = {'fzdhello': 'hello', 'fzdworld': 'world'}
  </code></pre>
  <p>The output in this case would look like:</p>
  <pre><code>df
      col
  0   hello
  1   world
  </code></pre>