title: How to create multiple tables in a .db file with pandas / sqlalchemy
body: <p>I have a function that loops through and returns me 3 separate <code>dataframe</code> objects.</p>
  
  <p>How do I put these 3 <code>dataframe</code> objects into 1 <code>.db</code> file with 3 separate <code>tables</code>?</p>
  
  <p>The below code is what I am currently using. It loops through each of the items I have, do the needful and return me a <code>Dataframe</code> object that I can put to sql after that. </p>
  
  <pre><code>for each_item in items:
      engine = create_engine("sqlite:///" + my_variable_database_name + ".db", echo=False)
      connection = engine.connect()
      pandas.DataFrame.to_sql(my_function(each_item), each_item, con=engine, if_exists="replace")
      connection.close()
      print(each_item + " has been completed successfully.")
  print("All completed.")
  </code></pre>
  
  <p>How should I go about doing this? </p>