title: Map column if string contain values from other column in Pandas
body: <p>I have two dataframes, first is:</p>
  
  <p>df1</p>
  
  <pre><code>col_one col_two
  ABBC1  (1, 2, 3)
  DFFG2  (3, 5, 1)
  JJKS3  (5, 2, 5)
  </code></pre>
  
  <p>df2</p>
  
  <pre><code>    col_1
  operate ABBC1 1 to 2, JJKS3 3 to 5
  operate JJKS3, FOM
  </code></pre>
  
  <p>Desired output df2:</p>
  
  <pre><code>  col_1                col_2
  operate ABBC1, to 2  (1, 2, 3)
  operate JJKS3, FOM   (5, 2, 5)
  </code></pre>
  
  <p>I have tried multiple ways but the closest I get is:</p>
  
  <pre><code>for values, map_col in df1[['col_one', 'col_two']].values:
      for val in df2['col_1']:
          if ("%s" %values) in df2['col_1'] :
              df2['col_2'] = "%s" %(map_col,)
  </code></pre>
  
  <p>And I thought this will be good, but I got exactly the same values for all rows. </p>
  
  <p>Any help is welcomed. Thanks</p>