ALTER PROC [dbo].[Test_procedure]
    @PolicyTypeID int,
    @QuoteStatusID int,
    @CompanyLoationGUID uniqueidentifier
AS
SELECT TOP 10 PolicyNumber, q.PolicyTypeID, q.QuoteStatusID, CompanyLocationGuid
FROM tblQuotes q
WHERE q.PolicyTypeID = @PolicyTypeID
    AND q.QuoteStatusID = @QuoteStatusID
    AND q.CompanyLocationGuid = @CompanyLoationGUID
    AND q.PolicyNumber IS NOT NULL

import pandas as pd
import pyodbc
import uuid

PolicyTypeID = 1
QuoteStatusID = 2
CompanyLoationGUID = uuid.UUID('54A8FCCD-C7FE-4642-9C22-3A25207CDAEE')
#print(type(uuid.UUID(CompanyLoationGUID)))
query = 'EXEC Test_procedure @PolicyTypeID = ?, @QuoteStatusID=?, @CompanyLoationGUID=?'
conn = pyodbc.connect('DRIVER={SQL Server};server=MyServer;DATABASE=MyDB;Trusted_Connection=yes;')

df = pd.read_sql_query(query, conn, params = [PolicyTypeID, QuoteStatusID, CompanyLoationGUID])
print(df)