title: Pandas text matching like SQL's LIKE?
body: <p>Is there a way to do something similar to <a href="https://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#operator_like" rel="noreferrer">SQL's LIKE syntax</a> on a pandas text DataFrame column, such that it returns a list of indices, or a list of booleans that can be used for indexing the dataframe? For example, I would like to be able to match all rows where the column starts with 'prefix_', similar to <code>WHERE &lt;col&gt; LIKE prefix_%</code> in SQL.</p>