/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

35 votes188 views6 answers
For in range loop python
Python
0 vote164 views1 answer
Python default parameters depend on other paramters
Python
3 votes252 views3 answers
List slicing in python
Python
0 vote198 views1 answer
Hex string to hex number
Python
0 vote254 views1 answer
Programação funcional python - lambda
Python
0 vote179 views2 answers
Check if variable is function python
Python
1 vote189 views1 answer
Pip install django celery results
Python
2 votes173 views5 answers
Django documentation
Python
0 vote235 views1 answer
Django.db.utils.ProgrammingError: relation "users" does not exist in django 3.0
Python Django
0 vote178 views1 answer
Pandas df make set index column
Python