/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 vote121 views1 answer
Networkx path between two nodes
Python
1 vote93 views2 answers
All column except pandas
Python
1 vote98 views1 answer
Python png library
Python
6 votes95 views3 answers
Python numphy how to use fractions
Python
0 vote55 views1 answer
Create bbox R sp
Python
0 vote113 views1 answer
_rocketcore pypi
Python
0 vote93 views1 answer
Print each item in list python single statemnt
Python
1 vote103 views1 answer
Python check if two lists intersect
Python
5 votes95 views2 answers
Python plot two lines on same graph
Python
1 vote134 views1 answer
Serving static audio files with flask in react
Python Flask