/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 vote138 views1 answer
Django model plural
Python
0 vote164 views1 answer
Python multiline comment using docstrings
Python
0 vote146 views1 answer
Python garbaze collection
Python
4 votes198 views4 answers
E in python
Python
0 vote143 views1 answer
Fake-useragent proxy webscraping browser change
Python
0 vote182 views1 answer
Request.build_absolute_uri django
Python Django
7 votes165 views1 answer
Python title case
Python
62 votes143 views5 answers
How to pick a random number in a list python
Python
0 vote159 views1 answer
Dataframe python diplay 2 tables on same line
Python
0 vote132 views1 answer
Python convert png to jpg
Python