import database in python using sqlalchemy

Asir In Tisar answered on April 27, 2022 Popularity 8/10 Helpfulness 5/10

answer import database in python using sqlalchemy

import database in python using sqlalchemy

Comment

import sqlalchemy as db
import pandas as pd
engine = db.create_engine('sqlite:///traffic.sqlite') # just for example

# AFTER those 3 lines, there are several ways

# one way to do it by using context manager
with engine.connect() as con:
	dbqu=con.execute("SELECT * FROM employee")
    df=pd.DataFrame(dbqu.fetchall())
    
# another alternate way is pretty simple by using pandas
df= pd.read_sql_query("SELECT * FROM employee", engine)

# the last tedious way--
con=engine.connect()
dbqu=con.execute("SELECT * FROM employee")
df=pd.DataFrame(dbqu.fetchall())
con.close() # WARNING- don't forget to close the connection in this last format

Popularity 8/10 Helpfulness 5/10 Language python

Source: Grepper

Tags: database dataframe import python sqlalchemy using

Link to this answer
Share Copy Link

Contributed on Apr 27 2022

Asir In Tisar

0 Answers Avg Quality 2/10

import database in python using sqlalchemy

Contents

More Related Answers

import database in python using sqlalchemy

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.