title: Search a dataframe and output matched values
body: <p>I have two CSV's (News.csv and Country.csv), I am trying to search for country names in one of the News.csv through a list of country names available in Country.csv. </p>
  
  <p>I am able to find whether there is a match or not and display a boolean value. </p>
  
  <p>News CSV</p>
  
  <p><img src="https://i.imgur.com/nztCgqG.png" alt="News head" title="News head"></p>
  
  <p>Country CSV</p>
  
  <p><img src="https://i.imgur.com/12uxiHb.png" alt="Country head" title="Country head"></p>
  
  <pre><code>news.dropna(inplace = True)
  news.drop_duplicates(keep='first', inplace = True)
  country_list = country['Country'].values
  import warnings
  warnings.filterwarnings("ignore", 'This pattern has match groups')
  news['Test'] = news['Title'].str.contains('|'.join(country_list), case = 
  False, regex = True)
  </code></pre>
  
  <p>After performing the search on the Title column</p>
  
  <p><img src="https://i.imgur.com/8h9tzHR.png" alt="Search" title="Search"></p>
  
  <p>However I would like to display the matched country instead. Moreover, is there a way to query more than 1 column at a time? For instance searching through both Title and Url at once.</p>