title: while iterating over a pandas Series, query an SQLite database with each member of the Series
body: <p>I have a pandas Series made from the following python dictionary, so:</p>
  <pre><code>gr8 = {'ERF13' : 'AT2G44840', 'BBX32' : 'AT3G21150', 'NAC061' : 'AT3G44350', 'NAC090' : 'AT5G22380', 'ERF019' : 'AT1G22810'}
  gr8obj = pd.Series(gr8)
  </code></pre>
  <p>( where I have previously imported pandas as pd )</p>
  <p>I have an SQLite database, AtRegnet.db</p>
  <p>I want to iterate over the pandase Series, gr8obj, and query the database, AtRegnet.db, for each member of the series.</p>
  <p>This is what I have tried:</p>
  <pre><code>for i in gr8obj:
      resdf = pd.read_sql('SELECT * FROM AtRegNet WHERE TargetLocus = ?' (i), con=sqlite3.connect(&quot;/home/anno/SQLiteDBs/AtRegnet.db&quot;))
      fresdf = resdf.append(resdf)
  
  fresdf
  </code></pre>
  <p>( the table in the AtRegnet.db that I want is AtRegNet and the column I am searching on is called TargetLocus. )</p>
  <p>I know that when I work on the SQLite3 database directly with a SQL command,</p>
  <pre><code>select * from AtRegNet where TargetLocus=&quot;AT3G23230&quot;
  </code></pre>
  <p>that I get back 80 lines from the database. (AT3G23230 is one of members of gr8obj)</p>