Can Python be used directly?

[dclong]

1. Can I use Python pandas to manipulate data directly. If so, is there any example on this?

2. Can I use Python visualization libraries (e.g., Bokeh or Plotly) for visualization directly?

[lkraider]

Would be great to integrate Redash with Jupyter: have the query result be a cell input, and export cells as graphs for the dashboard.

[ghost]

@dclong It really depends. There are many workarounds. Here is one simple way to get pandas data frame (if you already have the necessary modules installed):

redash_query_results = get_query_result(1) data = redash_query_results['rows'] # extract raw data from Redash query results

def redash_to_df(raw_data): import pandas as pd return pd.DataFrame.from_records(raw_data)

df = redash_to_df(data)

Also, check this very helpful functions on how to get the return dataframe to Redash data #2078

[lkraider]

Question: How to enable the Python Query Runner on the Docker release?

Answer: Edit docker-compose.production.yml and set in the environment: section:

REDASH_ADDITIONAL_QUERY_RUNNERS: "redash.query_runner.python"

PS: fixed the link https://github.com/getredash/redash/issues/2078

edit: found the answer

[Amirashaker]

i add python as data source to redash but when import mysql.connector module inside redash get me this error Error running query: <type 'exceptions.AttributeError'> 'module' object has no attribute 'connector' how to solve it ??

[ogreyesp]

• Can I use Python pandas to manipulate data directly. If so, is there any example on this?
• Can I use Python visualization libraries (e.g., Bokeh or Plotly) for visualization directly?

Hi, this question is very important from a data scienc purpose. However, this question is not answered by anyone. Is it possible to do this???