/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 vote209 views1 answer
Insert-cells-in-empty-pandas-dataframe
Python
0 vote212 views2 answers
Wsl python image
Python
33 votes218 views10 answers
Elon musk
Python
1 vote148 views1 answer
Make each element in a list occur once python
Python
1 vote186 views1 answer
How to make a breakable loop in python
Python
0 vote200 views1 answer
Replace \u00a0
Python
0 vote220 views1 answer
Mount gdrive in pyton
Python
4 votes250 views1 answer
How to get the parent class using super python
Python
0 vote207 views1 answer
Create dictionary python having hash value
Python
0 vote216 views1 answer
Character limit python system
Python