Displaying Pandas dataframe in tkinter

Question

I'm creating a tkinter gui that will take user input for a variable that then gets passed to SQL and the queried data (in this case a single column data frame and boxplot). However, at this moment I can not find a means of displaying my pandas dataframe in the tk gui. I have not found any module or means of displaying this, and I've spent hours going through possible solutions to no avail. Only thing I need is for the dataframe to display in the gui and be re-rendered each time I change the dataframe through the user input function. My code atm is:

### Starting first GUI/Tkinter Script
##First load libs

import pyodbc
import numpy as np
import pandas.io.sql as sql
import pandas
import matplotlib.pyplot as plt
import pylab 
import matplotlib as mpl
from tkinter import *
import sys

plt.ion()

def userinput():
  global PartN, pp, df
  ##a = raw_input(v.get())
  a = E1.get()
  ##print a
  PartN = a
  conn = pyodbc.connect('DRIVER={SQL Server};SERVER=my server;
  DATABASE=PackingList;UID=myid;PWD=mypword') 
  sqlr = "SELECT partmadeperhour FROM Completions WHERE  PartNumber = ? 
  AND endtime > '2012-12-31 23:59:00' ORDER BY partmadeperhour"
  df = pandas.read_sql_query(sqlr, conn, params=[PartN])
  conn.close()
  print(df)


 stats = df['partmadeperhour'].describe()
  print(stats) 
  print("Part Name is %s" %PartN)
  ##df.plot(kind='box', fontsize='20')
  pp =  df.plot(kind='box', fontsize='20')
  plt.show(block=True)


def clear_textbox():
    E1.delete(0, END)

master = Tk()
master.title('Title')


v = StringVar()
PartN = None

L1 = Label(master, text = 'Name')
L1.pack(side = LEFT)

E1 = Entry(master, textvariable = v, bd = 5)
E1.pack(side = RIGHT)   

b = Button(master, text = 'Submit', command = userinput)
b.pack(side = TOP)

b2 = Button(master, text = 'Clear', command=clear_textbox)
b2.pack(side=BOTTOM)

master.mainloop()

An example of my data frame

       rate
0      [0.25]
1      [0.67]
2      [0.93]
...       ...
1474   [5400.00]

If someone could just point me in the right direction, I don't even need code corrections just yet, I just need to hear someone to say yes it is possible (which I know it is), and to give me some kind of example. Thanks

Brian Tompsett - 汤莱恩 · Accepted Answer · 2015-06-26 09:57:58Z

4

I don't have enough rep to comment, otherwise I would, but I used this video to get a grasp of interacting with pandas/numpy/matplotlib and tkinter. He ends up building a large application with it if you stick through all the videos.

Even though you aren't likely doing the exact same thing, I think there might still be useful methods of interacting with your data and GUI gleamed from the videos.

If the link ever dies, you can search on YouTube "Tkinter tutorial sentdex"

Best of luck.

edited Jun 26, 2015 at 9:57

Brian Tompsett - 汤莱恩

5,92772 gold badges63 silver badges135 bronze badges

answered Jun 26, 2015 at 5:34

Cameron Gagnon

1,66218 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

grlaer Over a year ago

Thank You, this looks like a good place to start. Right now I'm just displaying the dataframe in a text box, which isnt as nice looking as I'd like it to be.

Collectives™ on Stack Overflow

Displaying Pandas dataframe in tkinter

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related