/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

3 votes113 views1 answer
Datetime.timedelta months
Python
0 vote110 views1 answer
Regex remove all html tags except br python
Python
62 votes105 views5 answers
How to pick a random number in a list python
Python
1 vote124 views1 answer
Python write txt utf8
Python
4 votes140 views2 answers
Make a nested list flat python
Python
1 vote113 views1 answer
Add a button on tkinter
Python
24 votes115 views3 answers
Tkinter image
Python
1 vote116 views1 answer
Plot value counta
Python
0 vote142 views1 answer
Huggingface transformers change download path
Python
0 vote126 views2 answers
In file included from psycopg/psycopgmodule.c:28:./psycopg/psycopg.h:35:10: fatal error: Python.h: No such file or directory35 | #include <Python.h>| ^~~~~~~~~~compilation terminated.
Python