Tkinter is Python's de-facto standard GUI (Graphical User Interface) package.

It is a thin object-oriented layer on top of Tcl/Tk.

Tkinter is not the only GuiProgramming toolkit for Python. It is however the most commonly used one.

Pandas Pivot Table


Pivot tables are useful with a long list of data in a spreadsheet and presenting the summarized data as a function of one or more columns.

( ie the total sales $ per seller, or the total sales $ of each product or the total sales per week. . . )

If you are familiar with spreadsheets, you are probably thinking about using a pivot table to get the average of the variables for each cluster. In SQL, you would have probably used a GROUP BY statement. If you are not familiar with either of these, you may think of grouping each cluster together and then calculating the average for each of them.

To create a pivot table similar to a spreadsheets, we will be using the pivot_table() method from pandas.

If you are not familiar with using a pivot table in a spreadsheet, you can see the finished tables in the xlsx file using Libre Calc or MS Excel.

The python pandas pivot tables are the same.



Here are some helpful tutorials on some the systems available with Scada123 to try on your own.

You can view videos at:     Youtube Channel Scada LLC

Sort through Topics on the left Menu "Tutorial Menu"

Click on one the Topic Tags that interest you.

License : All programs in the tutorial section are free software. You can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful,  but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more details.