/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 votes146 views1 answer
Convert python pandas series dtype to datetime
Python
0 vote135 views1 answer
Django pointfield value format for fixtures
Python Django
0 vote152 views1 answer
Dev.to flask heroku
Python
0 vote108 views1 answer
How to subtract a day from a date?
Python
1 vote84 views1 answer
Make lists for each 2 items in a list
Python
0 vote95 views1 answer
Using pickle to create binary files
Python
-1 vote102 views3 answers
Python remove duplicates from list of dict
Python
1 vote97 views1 answer
Pandas select all columns except one
Python
0 vote115 views1 answer
Mobile number regex python
Python
1 vote129 views4 answers
Seaborn rotate x labels
Python