title: Python "InterfaceError: Error binding parameter 2 - probably unsupported type."
body: <p>When I run the following code, I keep getting the "InterfaceError: Error binding parameter 2 - probably unsupported type" error, and I need help identifying where the problem is. Everything works fine up until I try to send the data to sql through.</p>
  
  <pre><code>anagramsdf.to_sql('anagrams',con=conn,if_exists='replace',index=False)
  cdf=pd.read_sql("select (distinct ID) from anagrams;",conn)
  </code></pre>
  
  <hr>
  
  <pre><code>import pandas as pd
  import sqlite3
  
  conn = sqlite3.connect("anagrams")
  xsorted=sorted(anagrams,key=sorted)
  xunique=[x[0] for x in anagrams]
  
  xunique=pd.Series(xunique)
  xanagrams=pd.Series(anagrams)
  anagramsdf=pd.concat([xunique,dfcount,xanagrams],axis=1)
  anagramsdf.columns=['ID','anagram_count','anagram_list']
  
  c=conn.cursor()
  c.execute("create table anagrams(ID, anagram_count, anagram_list)")
  conn.commit()
  
  anagramsdf.to_sql('anagrams',con=conn,if_exists='replace',index=False)
  cdf=pd.read_sql("select (distinct ID) from anagrams;",conn)
  
  cdf=pd.read_sql("select max(anagram_count) from anagrams;",conn)
  cdf
  def print_full(x):
      pd.set_option('display.max_rows', len(x))
      print(x)
      pd.reset_option('display.max_rows')
  
  cdf=pd.read_sql("select * from anagrams where anagram_count=12;",conn)
  pd.set_option('max_colwidth',200)
  </code></pre>
  
  <p>Full traceback error:</p>
  
  <pre><code>Traceback (most recent call last):
    File "sqlpandas.py", line 88, in &lt;module&gt;
      anagramsdf.to_sql('anagrams',con=conn,if_exists='replace',index=False)
    File "/Users/andrewclark/anaconda/lib/python2.7/site-packages/pandas/core/generic.py", line 982, in to_sql
      dtype=dtype)
    File "/Users/andrewclark/anaconda/lib/python2.7/site-packages/pandas/io/sql.py", line 549, in to_sql
      chunksize=chunksize, dtype=dtype)
    File "/Users/andrewclark/anaconda/lib/python2.7/site-packages/pandas/io/sql.py", line 1567, in to_sql
      table.insert(chunksize)
    File "/Users/andrewclark/anaconda/lib/python2.7/site-packages/pandas/io/sql.py", line 728, in insert
      self._execute_insert(conn, keys, chunk_iter)
    File "/Users/andrewclark/anaconda/lib/python2.7/site-packages/pandas/io/sql.py", line 1357, in _execute_insert
      conn.executemany(self.insert_statement(), data_list)
  sqlite3.InterfaceError: Error binding parameter 2 - probably unsupported type.
  </code></pre>
  
  <p>Snippet from Dataframe:</p>
  
  <pre><code>             ID  anagram_count           anagram_list
  0            aa              1                  (aa,)
  1      anabaena              1            (anabaena,)
  2      baaskaap              1            (baaskaap,)
  3      caracara              1            (caracara,)
  4      caragana              1            (caragana,)
  </code></pre>