Skip to content

Instantly share code, notes, and snippets.

@brandon-segal

brandon-segal/redash2pandas.py

Created October 18, 2019 15:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save brandon-segal/7b39a52b996dc2758f90930aea576dfb to your computer and use it in GitHub Desktop.
Save brandon-segal/7b39a52b996dc2758f90930aea576dfb to your computer and use it in GitHub Desktop.
Download ZIP
Redash To Pandas
Raw
redash2pandas.py
import pandas as pd
QUERY_NUM = {{YOUR_QUERY_NUMBER}}
API_KEY = {{YOUR_API_KEY}}
URL = f'https://redash.xmode.io/api/queries/{QUERY_NUM}/results.csv?api_key={API_KEY}'
df = pd.read_csv(URL)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment