/Python/Use sqlalchemy to create sqlite3 database

Use sqlalchemy to create sqlite3 database

from sqlalchemy import create_engine
import pandas as pd
# creates an engine for a database in current directory 
engine = create_engine('sqlite:///yourDatabaseName.sqlite3') 
# creates a dataframe in memory
df = pd.DataFrame({'tablename' : ['Data 1', 'Data 2', 'Data 3']})
# stores the dataframe as a table in the database
df.to_sql('tablename', con=engine)
# queries the table and stores the results in another dataframe
dfOne = pd.read_sql_table('tablename', engine)
# or you can create a custom sql query and store the results in a dataframe
dfTwo = pd.DataFrame(engine.execute("SELECT * FROM tablename").fetchall())

Similar codes

0 vote122 views1 answer
What does filter do in stackapi python
Python
27 votes121 views3 answers
Replace error with nan pandas
Python
0 vote136 views1 answer
Import "reportlab" could not be resolved django
Python
1 vote127 views1 answer
No module named base45 windows
Python
13 votes126 views2 answers
Only keep rows of a dataframe based on a column value
Python
0 vote129 views1 answer
Open chrome with python stack overflow
Python
0 vote162 views1 answer
How to order randomly in django orm
Python Django
3 votes165 views4 answers
Delete row by index pandas
Python
0 vote135 views2 answers
Browser = webdriver.firefox() error
Python
16 votes127 views1 answer
Python reimport module after change
Python