/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 vote234 views1 answer
Pandas row printed horizontally
Python
24 votes245 views4 answers
How to code in python
Python
39 votes254 views6 answers
Objects and classes in python
Python
4 votes235 views1 answer
Tkinter text in canvas
Python
0 vote230 views1 answer
Python string: iterate string
Python
3 votes288 views2 answers
Django rest framework simple jwt
Python
17 votes223 views1 answer
Np.save function
Python
-2 votes229 views2 answers
Entered_text_1 = textbox_1.get(1.0, tk.END+"-1c")
Python
3 votes234 views1 answer
How to execute bash commands in python script
Python
0 vote236 views1 answer
Time feature extraction
Python