/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 vote216 views1 answer
Python download sklearm model.joblib from google stroage
Python
0 vote200 views1 answer
Qaction disacble python
Python
72 votes247 views6 answers
Python online
Python
1 vote512 views2 answers
SyntaxError: Non-UTF-8 code starting with
Python
0 vote203 views1 answer
Return tuples form functions in Python
Python
1 vote187 views1 answer
Check where bool in a list python
Python
0 vote234 views1 answer
Tkinter get child in frame
Python
17 votes194 views2 answers
WARNING: You are using pip version 19.2.3, however version 21.2.4 is available.
Python
4 votes208 views3 answers
Gui python
Python
11 votes199 views3 answers
How to get the length of a string in python
Python