Sávio Serra savioserra

🏠

Remote Work

Flutter enthusiast. Love to learn new things, share knowledge and a collaborative environment. I want to build solutions that matters.

savioserra / connect_and_load.py

Last active July 19, 2018 20:00 — forked from hunterowens/connect_and_load.py

Pandas and MSSQL

	import pymssql
	import pandas as pd

	## Hey Look, college data
	stmt = "SELECT * FROM AlumniMirror..someTable"

	## instance a python db connection object- same form as psycopg2/python-mysql drivers also
	with pymssql.connect(server="<server address>", user="<user>",password="<password>", port=63642) as conn: # You can lookup the port number inside SQL server.
	# Excute Query here
	df = pd.read_sql(stmt,conn)