/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 vote200 views1 answer
Random string generate python of 2.7
Python
0 vote224 views1 answer
Jupyter notebook play audio
Python
0 vote234 views1 answer
Python get unique pairs from two lists
Python
14 votes206 views2 answers
Fastapi authentication
Python
0 vote237 views1 answer
Rebuild database from zero django postgres
Python
0 vote215 views1 answer
Problems with flask bootstrap
Python
1 vote217 views1 answer
TypeError: ‘int’ object is not subscriptable Solution
Python
2 votes220 views1 answer
Pytplot arc
Python
2 votes253 views2 answers
Django filter and condition
Python Django
1 vote241 views1 answer
Django admin slug auto populate
Python Django