Cacher is the code snippet organizer for pro developers

import pyodbc
import pandas as pd


conn = pyodbc.connect('Driver={SQL Server};'
                      'Server=MW-SXD0E-008;'
                      'Database=Balthazzar;'
                      'Trusted_Connection=yes;', autocommit=True)



SQLstring  ="SELECT TOP (100) title, COUNT(title) AS cnt FROM Balthazzar.dbo.a_InputMaster GROUP BY title ORDER BY cnt DESC"


SQL_Query = pd.read_sql_query(SQLstring,conn)

df = pd.DataFrame(SQL_Query)   # gir samme kolonner som for spørringen

print(df.head(n=20)) # se første 20 rader