This is how to connect to any sql server in less than 60 seconds using the SQL Alchemy python library.
Source code:
Libraries
import pandas as pd
import sqlalchemy
from sqlalchemy import create_engine
Creating SQL Alchemy engine object
engine = create_engine('postgresql://postgres:youtube@localhost:5432/eSports.val')
Initiailizing connection to database
conn = engine.connect()
SQL query as a string to pass into pd.read_sql function
sql = "SELECT * FROM players"
Creating dataframe using sql statement and db connection
df = pd.read_sql_query(sql,conn)
Негізгі бет Ғылым және технология Connect to Any SQL Server in 60 seconds with SQL Alchemy!!
Пікірлер: 7