/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

5 votes225 views3 answers
Pandas drop rows with value in list
Python
6 votes206 views3 answers
Django models filter
Python
8 votes164 views2 answers
How to detect mouse click in pygame
Python
0 vote166 views1 answer
TypeError: attrib() got an unexpected keyword argument 'convert'
Python
1 vote162 views1 answer
How to print x in python
Python
0 vote157 views1 answer
Close python window after execution
Python
0 vote162 views1 answer
How to find determinant in numpy
Python
1 vote183 views2 answers
Operators in python
Python
0 vote154 views1 answer
Mk virtual env
Python
3 votes166 views1 answer
Python how to find gcd
Python