Connecting And Basic Select

 import pyodbc

import pandas as pd 

# Some other example server values are

# server = 'localhost\sqlexpress' # for a named instance

# server = 'myserver,port' # to specify an alternate port

server = 'tcp:###r' 

database = '####' 

username = '####' 

password = '####' 

cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)

cursor = cnxn.cursor()

df = pd.read_sql_query(

    "SELECT TOP (1000) * from ####", cnxn)

df.tail(10)

Basic Graph

%matplotlib inline

df.index = df['name']

p = df.tail(10).plot.bar()