title: pandas: search column values from one df in another df column that contains lists
body: <p>I need to search the values from the df1['numsearch'] column into the lists in df2['Numbers']. If the number is in those lists, then I want to add values from the df2['Score'] column to df1. See desired output below.</p>
  <pre><code>df1 = pd.DataFrame(
      {'Day':['M','Tu','W','Th','Fr','Sa','Su'],
       'numsearch':['1','20','14','99','19','6','101']
      })
  
  df2 = pd.DataFrame(
      {'Letters':['a','b','c','d'],
       'Numbers':[['1','2','3','4'],['5','6','7','8'],['10','20','30','40'],['11','12','13','14']],
       'Score': ['1.1','2.2','3.3','4.4']})
  
  
  desired output
    Day  numsearch            Score
  0   M          1             1.1
  1  Tu         20             3.3
  2   W          4             4.4
  3  Th         99          &quot;No score&quot;
  4  Fr         19          &quot;No score&quot;
  5  Sa          6             2.2 
  6  Su        101          &quot;No score&quot;
  </code></pre>
  <p>I have written a for loop that works with the test data.</p>
  <pre><code>scores = []
  for s,ns in enumerate(ppr_data['SN']):
      match = ''
      for k,q in enumerate(jcr_data['All_ISSNs']):    
          if ns in q:
              scores.append(jcr_data['Journal Impact Factor'][k])
              match = 1
          else:
              continue
      if match == &quot;&quot;:
          scores.append('No score')
          match = &quot;&quot;
  df1['Score'] = np.array(scores)
  </code></pre>
  <p>In my small test, but above code works, but when working with larger data files, it is creating duplicates. So this clearly isn't the best way to do this.</p>
  <p>I'm sure there's a more pandas-proper line of code that ends in <code>.fillna(&quot;No score&quot;)</code> .</p>
  <p>I tried to use a <code>loc</code> statement, but I get hung up on searching the values of one dataframe in a column that contains lists.</p>
  <p>Can anyone shed some light?</p>