analysis.py

import pandas
import tkinter as tk
from tkinter import filedialog
import os

def analysis():
	path = filedialog.askopenfilename()
	data = pandas.read_excel(path)
	groups = data.groupby('Group')
	table = groups.agg({'Revenue':sum, 'Group': len})
	savename = filedialog.asksaveasfilename()
	savename = savename.split('.')[0] + '.csv'
	table.to_csv(savename)

if __name__ == "__main__":
	window = tk.Tk()
	window.title('Analysis')
	window.geometry("200x150")
	frame = tk.Frame(window)
	frame.grid(row=0, column=0)
	button = tk.Button(frame, text='Generate Table', command=analysis)
	button.grid(row=0, column=1)
	window.mainloop()