/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 vote281 views1 answer
What data types store value by index in python
Python
2 votes323 views2 answers
Python last index of item in list
Python
0 vote328 views1 answer
Django list view
Python Django
3 votes290 views1 answer
Len python meaning
Python
0 vote296 views1 answer
Python write into file at position
Python
0 vote321 views4 answers
Python convert dict_keys to list
Python
0 vote335 views1 answer
What does json.loads do
Python
0 vote265 views1 answer
Unhapppy man with monwy
Python
0 vote301 views1 answer
How append a directory based on current directory python
Python
1 vote300 views1 answer
Know menu's height tkinter
Python