notebook.community

Edit and run



In [27]:

    
%matplotlib inline

import matplotlib
import pyodbc, pandas
import matplotlib.pyplot as plt
import numpy as np



In [28]:

    
conn = pyodbc.connect(r'DRIVER={SQL Server Native Client 11.0};SERVER=localhost\SQLExpress,34057;DATABASE=Sandbox;UID=genadmin;PWD=password')
sql = "select top 100 Id, ChangeDateTimeUTC, ChangeType, OrderStatus, EscrowStatus, State from dbo.Orders"
data = pandas.read_sql(sql, conn)



In [29]:

    
series = pandas.Series(3 * np.random.rand(4), index=['a', 'b', 'c', 'd'], name='series')



In [30]:

    
series.plot(kind='pie', figsize=(6, 6))









    Out[30]:





<matplotlib.axes._subplots.AxesSubplot at 0x889e208>