/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 vote347 views3 answers
How to add trailing zeros in python
Python
23 votes319 views1 answer
Cv2.rectangle
Python
0 vote463 views2 answers
Class range python code
Python
1 vote330 views1 answer
Python set timezone of datetime
Python
1 vote314 views1 answer
Lausd clever
Python
0 vote316 views1 answer
How to limit a command to a role in discord.py
Python
0 vote338 views1 answer
Python format() function uses.
Python
1 vote310 views1 answer
Python remove all except numbers
Python
0 vote333 views1 answer
Convert pascal annotation to yolo
Python
0 vote318 views1 answer
Calculate speed with time in datetime python
Python