On Apr 2, 2022 20:50, Abdellah ALAOUI ISMAILI <my.alaoui...@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']
--
https://mail.python.org/mailman/listinfo/python-list
