This is the follow up post to my earlier
posts. Today we will extend the last post to further look at having multi line in the graph using matplotlib and tkinter.
Source Code:
import tkinter as tk
from tkinter import filedialog
from matplotlib.backends.backend_tkagg import FigureCanvasTkAgg
from matplotlib.figure import Figure
import pandas as pd
from random import randint
colors = []
for i in range(12):
colors.append('#%06X' % randint(0, 0xFFFFFF))
root= tk.Tk()
canvas1 = tk.Canvas(root, width = 800, height = 300)
canvas1.pack()
label1 = tk.Label(root, text='Data Analyser')
label1.config(font=('Arial', 20))
canvas1.create_window(400, 50, window=label1)
def getExcel ():
global df
import_file_path = filedialog.askopenfilename()
df = pd.read_excel (import_file_path)
global bar1
figure1 = Figure(figsize=(4,3), dpi=100)
subplot1 = figure1.add_subplot(111)
#subplot1.bar(x,y,color = 'lightsteelblue')
bar1 = FigureCanvasTkAgg(figure1, root)
bar1.name='latheesh'
bar1.get_tk_widget().pack(side=tk.LEFT, fill=tk.BOTH, expand=0)
for i in range(0,len(pd.unique(df['Month']))):
x= df['Day'][df['Month']==i+1]
y= df['Count'][df['Month']==i+1]
subplot1.plot(x, y, color=colors[i+1], linestyle='dashed', linewidth = 1, marker='o', markerfacecolor=colors[i+1], markersize=12)
def clear_charts():
bar1.get_tk_widget().pack_forget()
browseButton_Excel = tk.Button(text='Load File...', command=getExcel, bg='green', fg='white', font=('helvetica', 12, 'bold'))
canvas1.create_window(400, 180, window=browseButton_Excel)
button2 = tk.Button (root, text='Clear Chart', command=clear_charts, bg='green', font=('helvetica', 11, 'bold'))
canvas1.create_window(400, 220, window=button2)
button3 = tk.Button (root, text='Exit!', command=root.destroy, bg='green', font=('helvetica', 11, 'bold'))
canvas1.create_window(400, 260, window=button3)
root.mainloop()
Resulted Graph:
Explanation:
The major differences are inclusion of two snippets:
1. Added an array for color codes
from random import randint
colors = []
for i in range(12):
colors.append('#%06X' % randint(0, 0xFFFFFF))
2. Drawing multiple lines, in our case, the month column is the filtered data for drawing multiple lines.For every unique month, it loops the data and plot individual line in the graph.
for i in range(0,len(pd.unique(df['Month']))):
x= df['Day'][df['Month']==i+1]
y= df['Count'][df['Month']==i+1]
subplot1.plot(x, y, color=colors[i+1], linestyle='dashed', linewidth = 1, marker='o', markerfacecolor=colors[i+1], markersize=12)
Hope this helps to understand the basics of drawing graph from Excel. I would recommend you to explore and have hands on further to understand better.
I’d like to grow my readership. If you enjoyed this blog post, please share it with your friends!
Like this:
Like Loading...
Related
SQLZealots 