title: Finding partial matches between two different dataframes' columns, and assigning values when matches are found
body: <p>I want to fill <code>df1</code> dataframe's "Category" column with the correct values from <code>df2</code> dataframe's "Category" column.</p>
  
  <pre><code>import pandas as pd
  
  df1 = pd.DataFrame({"Receiver": ["Insurance company", "Shop", "Pizza place", "Library", "Gas station 24/7", "Something else", "Whatever receiver"], "Category": ["","","","","","",""]}) 
  df2 = pd.DataFrame({"Category": ["Insurances", "Groceries", "Groceries", "Fastfood", "Fastfood", "Car"], "Searchterm": ["Insurance", "Shop", "Market", "Pizza", "Burger", "Gas"]})
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>df1
  Receiver                Category
  0   Insurance company   
  1   Shop    
  2   Pizza place 
  3   Library 
  4   Gas station 24/7    
  5   Something else  
  6   Whatever receiver   
  
  df2
      Category    Searchterm
  0   Insurances  Insur
  1   Groceries   Shop
  2   Groceries   Market
  3   Fastfood    Pizza
  4   Fastfood    Burger
  5   Car         Gas
  </code></pre>
  
  <p>I want to compare <code>df1["Receiver"]</code> to <code>df2["Searchterm"]</code> row by row, and <strong>where the latter even partially matches the former</strong>, assign that row's <code>df2["Category"]</code> to <code>df1["Category"]</code>.</p>
  
  <p>For example, "Pizza" in <code>df2["Searchterm"]</code> partially matches "Pizza place" in <code>df1["Receiver"]</code>, so I want to assign "Fastfood" (which is Pizza's category in <code>df2["Category"]</code>) to the "Pizza place"'s category in <code>df1["Category"]</code>.</p>
  
  <p><strong><em>The desired output would be:</em></strong></p>
  
  <pre><code>df1
  Receiver                Category
  0   Insurance company   Insurances
  1   Shop                Groceries
  2   Pizza place         Fastfood
  3   Library             
  4   Gas station 24/7    Car
  5   Something else      
  6   Whatever receiver   
  </code></pre>
  
  <p>So how can I fill <code>df1["Category"]</code>with the right categories? Thank you.</p>