/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

1 vote335 views1 answer
Add background image in django uploaded file
Python
92 votes315 views6 answers
Turn python script into exe
Python
2 votes335 views1 answer
Add a list in python
Python
1 vote318 views1 answer
Only include top ten items django for loop
Python
0 vote299 views1 answer
Pop function second argument in python
Python
1 vote265 views1 answer
Not bitwise operator python
Python
0 vote310 views1 answer
ImportError: cannot import name 'Request' from 'urllib2' (unknown location)
Python
19 votes305 views1 answer
Get requests from python
Python
8 votes352 views4 answers
Python split sentence into words
Python
0 vote357 views1 answer
Creating empty set and append python
Python