flask app convert sql query to python plotly.
Albert-Jan Roskam
sjeik_appie at hotmail.com
Mon Apr 4 13:42:44 EDT 2022
On Apr 2, 2022 20:50, Abdellah ALAOUI ISMAILI <my.alaoui.ia at gmail.com>
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, status
FROM tickets
GROUP BY status""", con = mydc_db)
return query_result
labels_statut = query_tickets_status['status']
values_statut = query_tickets_status['count_status']
======
I think you mean:
labels_statut = query_tickets_status()['status']
values_statut = query_tickets_status()['count_status']
More information about the Python-list
mailing list