Python pyodbc + pandas dataframe

read_from_sql.py

# python 3.6+
import pandas as pd
from pyodbc import connect as connect_to_db


# database variables
sql_server  = 'test'
database    = 'test'
username    = 'user'
password    = 'password'
driver      = '{ODBC Driver 17 for SQL Server}'
conn_string = f'DRIVER={driver};SERVER={server};DATABASE={database};UID={username};PWD={password}'

columns = ['revenue', 'price', 'gas_leakage', 'id']

# stablish connection
with connect_to_db(conn_string) as conn:
    query = pd.read_sql_query('select * from table', conn)
    df = pd.Dataframe(query, columns=columns)