title: How can I achieve the SQL equivalent of "Like" using Pandas
body: <p>Can I use regular expressions and isin() to perform the SQL LIKE statement ?</p>
  
  <p>I have a dataframe with the following values:    </p>
  
  <pre><code>my_list=['U*']
  df = pd.DataFrame({'countries':['US','UK','Germany','China']})
  df['node']=0
  print(df)
  df.loc[df['countries'].isin(my_list),'node']=100
  print(df)
  </code></pre>
  
  <p>I wanted the node values for US and UK to be changed to 100.</p>