import pandas as pd
from pandas import datetime
import seaborn as sns
from ipywidgets import interact
import matplotlib.pyplot as plt
%matplotlib inline
import pyodbc
import adodbapi
%load_ext sql
import numpy as np

# MSSQL Management Studio Connection

conn = pyodbc.connect('Driver={SQL server};'
                      'server=DESKTOP-DS7J579\PYTHON_DA;'
                      'Database=AdventureWorks2012;'
                      'uid=PyXXXXXXXX;'
                      'pwd=PyXXXXXXXX;'
                      'trusted_connection=yes')
cursor = conn.cursor()

# Sample SQL Data pull

df = pd.read_sql_query('select FirstName,'
                       'LastName,'
                       'City,'
                       'StateProvinceName '
                        'from Sales.vIndividualCustomer',conn)