/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

13 votes190 views3 answers
Django form example
Python Django
10 votes141 views4 answers
How to check if Python is 32 or 64 bit
Python
3 votes135 views3 answers
Convert pyqt5 ui file to python file
Python
0 vote103 views1 answer
Nrf24l01 arduino raspberry pi
Python
4 votes141 views2 answers
Code server
Python
0 vote135 views1 answer
Count total number of null, isna sum python
Python
0 vote135 views1 answer
Moving averages python
Python
0 vote141 views1 answer
Django prepopulated_fields
Python
0 vote158 views1 answer
Como calcular el rango en python
Python
0 vote162 views1 answer
Print choicefield data from database in django
Python Django