Re: flask app convert sql query to python plotly.

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

Re: flask app convert sql query to python plotly

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