Skip to content

Instantly share code, notes, and snippets.

View satybald's full-sized avatar
🇰🇿
debugging

Sayat satybald

🇰🇿
debugging
View GitHub Profile
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@satybald
satybald / sql_magic.ipynb
Last active May 28, 2018 19:07
sql_magic_conn
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
import pandas as pd
from sqlalchemy.engine import create_engine
# Presto
engine = create_engine('presto://localhost:8080/system/runtime')
#Read Presto Data query into a DataFrame
df = pd.read_sql('select * from queries limit 1', engine)
df.head()
  1. General Background and Overview