/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

10 votes293 views1 answer
Pandas dataframe creation column names
Python
0 vote300 views1 answer
Python docx title
Python
10 votes256 views1 answer
How to check version of pip in anaconda
Python
0 vote260 views1 answer
Python on read text execute command
Python
0 vote327 views1 answer
How to deploy to heroku djangorest framework app
Python Django
0 vote252 views1 answer
Check if array is monotonic python
Python
6 votes313 views3 answers
Flask cors
Python Flask
0 vote290 views1 answer
How to get cube root python
Python
0 vote277 views1 answer
Bfs in python 3
Python
-1 vote275 views1 answer
How to use visualize_runtimes
Python