Databases are important sources that Data Scientists have to deal with. This is a simple tutorial to show how to connect to SQL Server in python and use pandas to assign the results of a query to dataframe. We use SQLAlchemy to create connection to SQL Server Engine. Pandas is an important package used in handling large data sets such as tables from SQL server.
Requirements: The required packages are listed in the requirements.txt file. Pandas; SqlAlchemy; Pyodbc
Additionally you need to create a dsn for the pyodbc. You can find detailed steps and tutorial in the wiki page of this repository. https://github.com/xavier211192/Python_Sql_Server/wiki