title: How to compare two columns both with list of strings and create a new column with unique items?
body: <p>I have two columns both with list of strings. Basically one column <code>df['products']</code> which are in all capitals. The other column is product description <code>df['desc']</code>. </p>
  
  <p>I want to check what all items in <code>df['products']</code> are present in <code>df['desc']</code> and make a new column out of it. </p>
  
  <p>I tried the following code:</p>
  
  <pre><code>df['uniq'] = df.apply(lambda x : [i for i in x['products'] if i.lower() in x['desc']])
  </code></pre>
  
  <p>I checked the other similar questions and built the above code, but it's not working. </p>
  
  <p>The data looks something like this:</p>
  
  <p><a href="https://i.stack.imgur.com/mpt0Y.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mpt0Y.png" alt="enter image description here"></a></p>