title: Insert a pandas dataframe into a SQLite table
body: <p>So I have a dataframe imported from excel and an SQL Table with matching columns. So far I have been updating the table using the columns as lists:</p>
  
  <pre><code>Schedule_Frame = DataFrame(Sheet_Schedule)
  
  Column_ID=Schedule_Frame['ID']
  
  Column_list=list(Column_ID)
  
  
  for i in range(len(Column_list)):
  
  miCursor.execute("UPDATE SCHEDULE SET ID=? WHERE rowid=?",(Column_list[i],i))
  </code></pre>
  
  <p>However, since what I have in SQLite is a table that matches my dataframe columns, I am sure that there is a way to update the whole SQLite table using my frame.</p>
  
  <p>Any ideas how to do it?</p>
  
  <p>Thanks a lot!!</p>