/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 vote276 views1 answer
2D array questions python
Python
0 vote303 views1 answer
Python - Comment convertir le texte en discours
Python
1 vote322 views5 answers
Embed python discord
Python
0 vote330 views1 answer
Tuto date and time python
Python
1 vote301 views1 answer
Check if any values overlap in numpy array
Python
0 vote282 views1 answer
Numpy convert 1d to 2d
Python
0 vote305 views2 answers
How to decode hexadecimal in python
Python
0 vote264 views1 answer
Get request failed python 443
Python
0 vote284 views2 answers
How to create an empty 2d list in python
Python
1 vote318 views1 answer
Changing instance through dict changes all instances
Python