Pandas and MSSQL

connect_and_load.py

import pymssql
import pandas as pd

## instance a python db connection object- same form as psycopg2/python-mysql drivers also
conn = pymssql.connect(server="172.0.0.1", user="howens",password="some_fake_password", port=63642)  # You can lookup the port number inside SQL server. 

## Hey Look, college data
stmt = "SELECT * FROM AlumniMirror..someTable"
# Excute Query here
df = pd.read_sql(stmt,conn)

df.head(5)

requirements.txt

pymssql==2.1.0
pandas==0.14.0

Exactly what I was looking for - thanks!

Boom! Thanks!

The only downside is that you have to provide the password in the code. Not very nice.

@drorata you could always have a line like
password = input("Enter password")
if you're averse to hard-coding it

correction: 'raw_input()' not 'input()'

Maybe the "Right" way would be to make the password an environment variable?

Or use a config file and the configparser module.

Hi! I would sugest you to wrap the conn variable inside a with statement as described in the docs! 😃

Do you by chance know how to make this work with SQLAlchemy?

you could just beam the password into the computer

correction: 'raw_input()' not 'input()'

Actually, you are correct the first time. It is now input().
https://stackoverflow.com/questions/4915361/whats-the-difference-between-raw-input-and-input-in-python3-x

Awesome, thanks!