title: SQL-like statements in pandas?
body: <p>I'm trying to run the following SQL statement (obviously in Python code) in pandas, but am getting nowhere:</p>
  
  <pre><code>select year, contraction, indiv_count, total_words from dataframe
      where contraction in ("i'm","we're","we've","it's","they're")
  </code></pre>
  
  <p>Where <code>contractions</code> is <code>char</code>, and <code>year</code>, <code>indiv_count</code>, and <code>total_words</code> are <code>int</code>.</p>
  
  <p>I'm not too familiar with pandas. How do I create a similar statement in Python?</p>