/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

51 votes287 views6 answers
Drop a column in pandas
Python
-1 vote261 views1 answer
Store message sent by user in string discord py
Python
1 vote281 views4 answers
How to input in a list in python
Python
0 vote225 views1 answer
Replace all string in list python
Python
1 vote282 views1 answer
Flask error f = open(f'{getcwd()}/haikus/{haiku}',"r") ^ SyntaxError: invalid syntax
Python
11 votes291 views5 answers
Python sorted lambda
Python
2 votes292 views1 answer
Set index in datarame
Python
0 vote273 views1 answer
List files in http directory python
Python
0 vote284 views2 answers
Count values python
Python
3 votes307 views1 answer
Spam python
Python