/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

1 vote203 views3 answers
Merge multiple excel files with multiple worksheets into a single dataframe
Python
2 votes205 views2 answers
Add text to plot python
Python
7 votes200 views2 answers
Python encode comment
Python
0 vote202 views1 answer
Tkinter mouse loading cursor
Python
0 vote199 views1 answer
Star program in python using for loop
Python
0 vote213 views1 answer
Python loop over s3 objects]
Python
0 vote149 views1 answer
Matplotlib grid color
Python
0 vote199 views1 answer
Counter python time complexity
Python
2 votes210 views1 answer
Python two string equal
Python
2 votes215 views2 answers
Pandas read excel certain columns
Python