conn = pyodbc.connect(conn_str)
sql = """\
DECLARE @cols AS NVARCHAR(MAX),
    @query  AS NVARCHAR(MAX)
select @cols = STUFF((SELECT ',' + QUOTENAME(PatternID)
                    from loglist
                    group by PatternID
                    order by PatternID
            FOR XML PATH(''), TYPE
            ).value('.', 'NVARCHAR(MAX)')
        ,1,1,'')

set @query = 'SELECT FileName,' + @cols + ' from
             (
                select FileName, PatternID, Found
                from loglist
            ) x
            pivot
            (

                sum(Found)
                for PatternID in (' + @cols + ')
            ) p '

execute(@query);
"""
df = pd.read_sql_query(sql, conn)
print(df)
#   FileName  pat1  pat2  pat3  pat4  pat5  pat6
# 0        e   1.0   1.0   1.0   NaN   NaN   NaN
# 1        f   1.0   1.0   1.0   NaN   NaN   NaN
# 2        q   1.0   1.0   1.0   NaN   NaN   NaN
# 3        s   NaN   NaN   NaN   0.0   0.0   0.0