Import from SQL Server into Pandas Dataframe

Python

 1|  import pandas as pd
 2|  import pyodbc as db
 3|  
 4|  #Connect to SQL Server using ODBC Driver 13 for SQL Server.
 5|  #You may need to declare a different driver depending on the server you are connecting to.
 6|  conn = db.connect('DRIVER={ODBC Driver 13 for SQL Server};SERVER=ST787554;Trusted_Connection=yes;DATABASE=Orders')
 7|  
 8|  #Declare SQL Query
 9|  qry = 'SELECT * FROM SALE_ITEMS'
10|  
11|  #Run query and import data into Pandas dataframe
12|  sale_items = pd.read_sql(qry, conn)
analyseup
Pandas | Import | Sql
Did you find this snippet useful?

Sign up for free to to add this to your code library

Remove Stop Words from Text in DataFrame Column
Python

Pandas | Nltk | Nlp

133
LightGBM Custom Loss Function
Python

LightGBM | Loss function

121
Tuning XGBoost Hyperparameters with Grid Search
Python

XGBoost | Tuning

117
How to Convert DataFrame Values Into Percentages
Python

Lambda | Percentages | Pipe

109
How to Scale Data Using Standard Scaler But Keep Column Names
Python

Scaler | Standard

79
LightGBM Hyperparameter Tuning with GridSearch
Python

Python | LightGBM | Hyperparameter tuning | Gridsearch

77
Calculating Root Mean Squared Error (RMSE) with Sklearn and Python
Python

Rmse

77
Dynamically Create Columns in Pandas Dataframe
Python

Pandas | Columns

61
How to Train a Catboost Classifier with GridSearch Hyperparameter Tuning
Python

Catboost | Hyperparameter tuning

60
Overwriting a Python Logging File Instead of Appending
Python

Logging

55