On Apr 2, 2022 20:50, Abdellah ALAOUI ISMAILI
wrote:
i would like to convert in my flask app an SQL query to an plotly pie
chart using pandas. this is my code :
def query_tickets_status() :
query_result = pd.read_sql ("""
SELECT COUNT(*)count_status
Abdellah ALAOUI ISMAILI wrote:
def query_tickets_status() :
query_result = pd.read_sql ("""
SELECT COUNT(*)count_status, status
FROM tickets
GROUP BY status""", con = mydc_db)
return query_result
labels_statut = query_tickets_status['status']
la
i would like to convert in my flask app an SQL query to an plotly pie chart
using pandas. this is my code :
def query_tickets_status() :
query_result = pd.read_sql ("""
SELECT COUNT(*)count_status, status
FROM tickets
GROUP BY status""", con = mydc_db)
