/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 vote377 views1 answer
Pyqt5 open tab
Python
1 vote336 views1 answer
Python dictionary with list
Python
1 vote372 views1 answer
3d array into 2d array python
Python
0 vote330 views1 answer
Change to first letter capital list python
Python
39 votes344 views6 answers
Pandas print all columns
Python
24 votes367 views2 answers
Make an executable with visual studio python
Python
3 votes356 views1 answer
Numpy get sum
Python
0 vote360 views1 answer
"ArrayField" is not defined Pylance
Python
0 vote344 views1 answer
Python loading image file requires absolute path
Python
16 votes337 views3 answers
Python average function program
Python