/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

2 votes222 views2 answers
Pd.dataframe initial columns
Python
0 vote184 views1 answer
Df index start from 1
Python
1 vote173 views1 answer
Python - How To Ways to Remove xa0 From a String
Python
4 votes183 views5 answers
Urllib
Python
0 vote202 views3 answers
How to take a screenshot using python
Python
0 vote219 views1 answer
How to plot a linear equation in matplotlib
Python
0 vote193 views1 answer
Hidden semi markov model python from scratch
Python
0 vote189 views1 answer
How do i activate python on windows
Python
0 vote183 views1 answer
Local to ISO 8601:
Python
0 vote175 views1 answer
Python disable logging on unittest
Python