/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 vote214 views0 answer
Python
2 votes169 views1 answer
Python apply a function to a list inplace
Python
0 vote177 views1 answer
Text generate gpt 2 huggingface
Python
0 vote188 views1 answer
How to get a mock image in django?
Python
5 votes210 views1 answer
How to override save method in django
Python Django
0 vote192 views1 answer
Change a color on touch roblox
Python
0 vote217 views1 answer
Django template limit string length
Python Django
-1 vote213 views2 answers
Design patterns in python
Python
0 vote176 views1 answer
How to convert word to number in python pandas
Python
7 votes167 views6 answers
Get weekday from date python
Python