/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 vote189 views1 answer
Pandas pull value from column
Python
1 vote225 views1 answer
Drop duplicate rows pandas except nan
Python
0 vote200 views1 answer
Paramhans ramchandra das
Python
0 vote230 views1 answer
Seaborrn set figsize
Python
5 votes261 views1 answer
Pip3 install pyaml
Python
0 vote245 views1 answer
Sort a set in python
Python
0 vote234 views1 answer
Python check mognodb size
Python
0 vote215 views1 answer
Assert var == 0
Python
-2 votes151 views1 answer
Python underscore
Python
0 vote214 views1 answer
File "main.py", line 106 '@'tasks.loop(hours=1.0) #without quotation marks Reddit won't let me use the at sign without them
Python