Automatization of BoxPlot graph usin Python MatPlotLib and Excel

Feb 10, 2022 1 min read

BoxPlotGraphAutomation

Automatization of BoxPlot graph usin Python / Excel.

This file is an automation of BoxPlot-Graph using python graph library matplotlib, excel files reader library and Tkinter library as graph interface.

The data comes from a excel file and are used to create a BoxPlot, showing average and median values of each bar.

Theare are an option to include a reference bar that have to be named as “reference” or “referencia” or “REF”, this reference bar will be showed in red and can be select to add a line with reference mean in the user interface. The standart excel file to be used together with this python file are here in the repository.
TIP: make sure that all unused coluns are empty to avoid error or unespected data on the graph.

John was the first writer to have joined pythonawesome.com. He has since then inculcated very effective writing and reviewing culture at pythonawesome which rivals have found impossible to imitate.