How to connect to SQL Server and query data using Python ODBC Module and Pandas

How to connect to SQL Server and query data using Python ODBC Module and Pandas

Not much to write but here is the quick video on this topic. I must admit that I would like to keep my data at the source in this case i.e. SQL Server and not a big fan of CSV and Excel sheets flying around.  pyodbc module is a powerful tool and it connects to SQL server seamlessly and with pandas it is even easier to get the data directly into a Data Frame.