/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 vote356 views1 answer
Python split paragraph
Python
0 vote362 views1 answer
Flask request post with json
Python Flask
0 vote285 views9 answers
How to form a list from a file in python
Python
-1 vote309 views2 answers
Python datetime minus datetime
Python
26 votes308 views4 answers
Python send email with attachment
Python
1 vote276 views1 answer
How to bind close button in tkinter
Python
1 vote326 views1 answer
Get device name tensorflow
Python
0 vote320 views1 answer
Ignore bad lines pandas
Python
0 vote298 views1 answer
TypeError at /admin/auth/user/
Python
18 votes337 views10 answers
Stackoverflow
Python