Sorting Tkinter Treeview columns in ascending or descending order using Pandas DataFrame Part I

00:00 Introduction to applications
01:39 Layout and importing libraries
02:15 Creating Pandas DataFrame using Excel file by read_excel()
03:21 Creating Treeview inside the function my_disp()
10:56 my_sort() to apply sorting to Tkinter columns
Download Source code from here
www.plus2net.com/python/tkint...
Web site: www.plus2net.com
KZbin: / @plus2net1
Facebook: / plus2net
Instagram: / plus2net.in
LinkedIn: / plus2net
#sortTreeview #DataFRameSorting #TreeviewSorting #Treeview #plus2net #python #Tkinter

[@miasevda4728]

Sir your videos are just amazing i can never thank you enough From Algeria.👏

[@plus2net1]

Glad to know that, thanks

[@shajipalayoor1638]

Sir please post one video generating report with columns bold heads, italic columns, I meant fully formatted text report in python

[@aswathysivadasan8365]

Sir how we can add the data from one treeview table to the other treeview table suppose we select a row from the 2nd table and how we can add it to the 1st table in a particular row

[@plus2net1]

On selection of row you can read the data like this p_id = trv.selection()[0] # collect selected row id print(trv.item(p_id)) # Dictionary of all options print(trv.item(p_id)['values']) # List of values. These values you can then insert to 1st Treeview by using insert(), further featurs like not allow insert if already exist etc can be added.

[@Damianoos1]

IT will be working with treeviw table connected with mysql database ?

[@plus2net1]

Yes, sorce can be from MySQL, SQLite , CSV , Excel or from any other formats. The Here the DataFrame is creatd by reading excel file, the same dataframe can be created by using any other source.

[@PANDURANG99]

How to use it for database

[@plus2net1]

Source can be anything, once a dataframe is created from Excel or CSV or from MySQL database , that can be used. Here different sources are used . www.plus2net.com/python/tkinter-treeview-dynamic.php

[@prathmeshgulhane6351]

Bro i have 1doubt

[@plus2net1]

Yes please

[@prathmeshgulhane6351]

@@plus2net1 I am creating the tkinter gui To calculate mean In which I want to take input from the user like the array type this 10,20,30 in the one entry widget and but i am not getting how do i take such input like the ☝ I will be grateful for your help sir

[@plus2net1]

@@prathmeshgulhane6351 Take the inputs like 10,23,30 and crate a list by using split(), here my_list is the input string my_list=my_list.split(',') Once you have to list you can convert each element to integer by using map() my_list=map(int,my_list) Then get the mean like this print("Mean value : ", sum(my_list)/len(my_list))

[@prathmeshgulhane6351]

@@plus2net1 sir i tried and messed up All and not getting it Can u please 🙏 fix my code: from tkinter import * root = Tk() root.geometry("500x500") def Calcu(): a =(map(int,input().split())) a.StringVar() ent = Entry(root) ent.pack() btn = Button(root,text = "Calculate",command = Calcu ) btn.pack() root.mainloop()

[@plus2net1]

Ok, tomorrow