/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 vote105 views1 answer
Pandas change period to daily frequency
Python
0 vote145 views1 answer
How to insert item at specifc index python
Python
0 vote107 views1 answer
Python ffmpeg get video fps
Python
1 vote114 views2 answers
Python frame in a frame
Python
0 vote156 views1 answer
Connect spark to postgres; connect spark to database
Python
1 vote105 views1 answer
Python threading vs multiprocessing
Python
0 vote168 views1 answer
Discord bot python meme command
Python
0 vote141 views2 answers
Django APIView Pagination
Python Django
0 vote107 views1 answer
How to create enter pressed for qlineedit in pyqt5
Python
0 vote63 views1 answer
Pymongo dynamic structure
Python