Guest User

Untitled

a guest
Aug 10th, 2018
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. import pandas as pd
  2. import pyodbc
  3.  
  4. server = "servername"
  5. db = "databasename"
  6. username = "username"
  7. password="password"
  8. con = pyodbc.connect('Driver={SQL Server Native Client 11.0};SERVER=' + server + ';DATABASE=' + db+';User='+
  9. username+';Password='+password+';Trusted_Connection=yes;')
  10. query = "your query"
  11. df = pd.read_sql(query, con)
  12. print(df)
Add Comment
Please, Sign In to add comment