main.py

from espn_api.football import League
import CommonFunctions
# gui here
import schedule
import time
import pandas as pd
from tkinter import filedialog
import numpy as np
import matplotlib
import matplotlib.pyplot as plt
import matplotlib.ticker as mtick
import matplotlib.pylab as pl
import tkinter as tk
from tkinter import *
from tkinter import ttk
import matplotlib.cm as cm
from colour import Color
import matplotlib.ticker as ticker
import seaborn as sns
import os
import prffs_library
import glob
from ast import literal_eval
from matplotlib.ticker import (MultipleLocator, AutoMinorLocator)
from matplotlib import rcParams
import xlsxwriter


pd.options.mode.chained_assignment = None  # default='warn'



password = '{71735CA3-D03A-47E3-BB18-B4314B399BB1}'
espn = "AEAI2axDp0zJHsR%2BXUt496H0E1r56UjU7QjY6OBYkXXGFkO%2FWgfyUys%2BVo%2B4Rsz4k9MBskSsCb8Si6mY1bZDdFzekj4vZ0g5RSHx0T7lNpQP%2BnmkKR5B21OJ9%2Bfpfwt4IMyajlCjG8G%2FU1Z6PnEQXS1l9daaP2gF4palYuw9zjNy%2ByI7NXDj0VDRDc2cw17KRwwjeU3NP%2FbsCF2t3PDPBgAplsX%2BhpUmYXnDa1jSQ5h2rRdI7Rrea7GzztnLtg94MfBkQk5QkRrsUFoq2U96iQk7ugXqpoo7u3azVG9EzDiSPw%3D%3D"

pd.set_option('display.max_rows', None)
pd.set_option('display.max_columns', None)
pd.set_option('display.width', 500)
sns.set_theme(style="white", context="talk")
sns.set(font="Verdana")

font = {'family': 'arial',
        'weight': 'normal',
        'size': 12}
matplotlib.rc('font', **font)
rcParams['figure.figsize'] = 6,6


class IoPlot(tk.Tk):   # IoPlot will inherit attributes from the tkinter module. the (tk.TK) is not technically necesary
    def __init__(self, *args, **kwargs):  # this is here to always load the following. always run when IoPlot is called
        tk.Tk.__init__(self, *args, **kwargs)
        #tk.Tk.iconbitmap(self, default='terpylyticsicon.ico')
        tk.Tk.wm_title(self, "Pork Rub Fantasy analytics tool V 1.0")
        container = tk.Frame(self)
        container.pack(side="top", fill="both", expand=True)
        container.grid_rowconfigure(0, weight=0)
        container.grid_columnconfigure(0, weight=0)
        menubar = tk.Menu(container)
        helpmenu = Menu(menubar, tearoff=0)
        helpmsg = str("1. fill ")
        aboutmsg = str("Pork Rub Fantasy Analytics Tool (PRFAT) V 1.0" '\n' "Coded in Python 3 by Iain W. H. Oswald, PhD." '\n' "Github: https://github.com/iWHOswald/")
        abouttitle = str("Pork Rub Fantasy Analytics Tool")
        helptitle = str("Help")
        helpmenu.add_command(label="Help", command=lambda: IoPlot.pophelpmsg(self, helpmsg, helptitle))
        helpmenu.add_command(label="About...", command= lambda: IoPlot.pophelpmsg(self, aboutmsg, abouttitle))
        menubar.add_cascade(label="Help", menu=helpmenu)
        tk.Tk.config(self, menu=menubar)
        self.frames = {}
        for F in (MainWindow, SecWindow):
            frame = F(container, self)
            self.frames[F] = frame
            frame.grid(row=0, column=0, sticky="nsew")
        self.show_frame(MainWindow)


    def show_frame(self, cont):
        frame = self.frames[cont]
        frame.tkraise()

    #   ANOTHER POP MSG
    def popaxismsg(self, data, poptitle, size):
        gridcounter = 0
        popup = tk.Tk()
        popup.wm_title(poptitle)
        popup.resizable(width=700, height=500)
        S = tk.Scrollbar(popup)
        xscrollbar = tk.Scrollbar(popup, orient=HORIZONTAL)
        T = tk.Text(popup, width=size,wrap=NONE, xscrollcommand=xscrollbar.set)
        xscrollbar.config(command=T.xview)
        xscrollbar.pack(side=tk.BOTTOM, fill=tk.X)
        S.pack(side=tk.RIGHT, fill=tk.Y)
        T.pack(side=tk.LEFT, fill=tk.Y)
        S.config(command=T.yview)
        T.config(yscrollcommand=S.set)
        T.pack()
        T.insert(tk.END, data)

        popup.mainloop()

class SecWindow(tk.Frame):

    def __init__(self, parent, controller): # setup the layout of the page
        tk.Frame.__init__(self, parent)


class MainWindow(tk.Frame):

    def __init__(self, parent, controller): # setup the layout of the page
        tk.Frame.__init__(self, parent)
        self.league_loaded = 0
        gridcounter = 0  # This is what allows you to easily add new grid elements; just add gridcounter +=1
        df_og = pd.read_csv('917761_2022_team_stats.csv')
        max_week = df_og['Week'].max()
        arr = []
        #for i in df_og['']
        for i in range(max_week):
            arr.append(i+1)
        print(arr)

        print('weeks played in season: ' + str(max_week))
        league = League(league_id=917761, year=2022)
        self.button_list = []
        self.stats = ['Most points',"QB", "RB", "WR", "TE", 'DST/HC','Most points in loss','2nd highest points in loss',
        'Least points', 'largest margin-of-victory','side points']
        # this stuff takes care of setting up the data set entry drop down menu. Location etc #

        self.league_id_lbl = Label(self, text="League ID:")
        self.league_id_lbl.grid(sticky=W, row=gridcounter, column=0)
        self.league_id = Entry(self, width=10)
        self.league_id.insert(0,917761)
        self.league_id.grid(sticky=W, row=gridcounter, column=1)
        gridcounter = gridcounter + 1
        self.league_id_lbl = Label(self, text="username:")
        self.league_id_lbl.grid(sticky=W, row=gridcounter, column=0)
        self.username = Entry(self, width=10)
        self.username.insert(0,espn)
        self.username.grid(sticky=W, row=gridcounter, column=1)
        gridcounter = gridcounter + 1
        self.league_id_lbl = Label(self, text="password:")
        self.league_id_lbl.grid(sticky=W, row=gridcounter, column=0)
        self.password = Entry(self, width=10)
        self.password.insert(0,password)
        self.password.grid(sticky=W, row=gridcounter, column=1)
        gridcounter = gridcounter + 1
        self.league_id_lbl = Label(self, text="Year:")
        self.league_id_lbl.grid(sticky=W, row=gridcounter, column=0)
        self.year = Entry(self, width=10)
        self.year.insert(0,2022)
        self.year.grid(sticky=W, row=gridcounter, column=1)
        gridcounter = gridcounter + 1


        self.pull_data = ttk.Button(self, text="Pull data",command=lambda: prffs_library.pull_all_data(917761, espn, password,0,int(self.year.get())))
        self.pull_data.grid(sticky=NW, row=gridcounter, column=0, pady=4, padx=4)
        self.agg_data = ttk.Button(self, text="Combine data",command=lambda: prffs_library.year_aggregator(917761))
        self.agg_data.grid(sticky=NW, row=gridcounter, column=1, pady=4, padx=4)

        gridcounter = gridcounter + 1

        var = IntVar()
        self.week = Label(self, text="Weeks:")
        self.week.grid(sticky=W, row=gridcounter, column=0)
        wkvar = StringVar()
        wkvar.set(1)
        self.week = OptionMenu(self, wkvar, *arr)
        self.week.grid(sticky=W, row=gridcounter, column=1)

        self.recent_week = arr[-1]
        print(self.recent_week)


        #self.week = Entry(self, width=10)
        #self.week.insert(0,1)
        #self.week.grid(sticky=W, row=gridcounter, column=1)
        gridcounter = gridcounter + 1
        self.plot_list = []
        for counter, value in enumerate(self.stats):
            #self.stat = ttk.Button(self, text=value,
            #                                       command=lambda: MainWindow.button_lister(self, counter))
            self.stat = Radiobutton(self, text=value, variable=var, value=counter)
            self.stat.grid(sticky=W, row=gridcounter, column=1)
            self.plot = ttk.Checkbutton(self, text="Plot")
            self.plot.state(['!alternate'])
            self.plot.state(['!selected'])
            self.plot.grid(sticky=W, row=gridcounter, column=0)

            self.button_list.append(counter)
            self.plot_list.append(self.plot)

            gridcounter = gridcounter + 1

        self.get_stats = ttk.Button(self, text="Plot",command=lambda: MainWindow.plot_organizer(self,self.plot_list,var.get(),wkvar.get(),0))
        self.get_stats.grid(sticky=NW, row=gridcounter, column=0, pady=4, padx=4)
        self.get_stats = ttk.Button(self, text="time dep plot",command=lambda: MainWindow.time_plot_organizer(self,self.plot_list,var.get(),wkvar.get(),0,self.year.get(),self.league_id.get()))
        self.get_stats.grid(sticky=NW, row=gridcounter, column=2, pady=4, padx=4)

        self.get_stats = ttk.Button(self, text="get stats",command=lambda: MainWindow.button_lister(self,var.get(),wkvar.get(),0))
        self.get_stats.grid(sticky=NW, row=gridcounter, column=1, pady=4, padx=4)
        gridcounter = gridcounter + 1
        self.get_stats = ttk.Button(self, text="cumulative pts",command=lambda: MainWindow.cum_points(self,self.plot_list,var.get(),wkvar.get(),self.year.get(),self.league_id.get()))
        self.get_stats.grid(sticky=NW, row=gridcounter+1, column=0, pady=4, padx=4)
        self.get_stats = ttk.Button(self, text="save deep",command=lambda: MainWindow.deep_points(self,self.plot_list,var.get(),wkvar.get(),self.year.get(),self.league_id.get()))
        self.get_stats.grid(sticky=NW, row=gridcounter+1, column=1, pady=4, padx=4)

        self.get_stats = ttk.Button(self, text="save wkly plot",command=lambda: MainWindow.plot_organizer(self,self.plot_list,var.get(),wkvar.get(),1,self.year.get(),self.league_id.get()))
        self.get_stats.grid(sticky=NW, row=gridcounter, column=1, pady=4, padx=4)




    def button_lister(self, value,week):
        print(value)
        print('getting stats for week: ' + str(week))
        if week != "cum":
            prffs_library.side_points_tabulator('917761_2022_team_stats.csv', int(week), int(week)+1, 2, value)
            print('DF #: ' +  str(value))
        else:
            prffs_library.side_points_tabulator('917761_2022_team_stats.csv', int(week), int(week)+1, 2, value)

    def deep_points(self,df,current_week,var,year,leagueid):
        data_array = []
        data_array_2 = []
        temp_df = []
        print('recent week: ' + str(self.recent_week))
        df_file = pd.read_csv(str(leagueid) + "_" + str(year) + '_team_stats.csv')
        max_week = int(df_file['Week'].max())
        #for i in range(1,self.recent_week+1):
        for i in range(1,max_week+1):
            print(i)
            print('shet')
            df_temp = prffs_library.side_points_tabulator(str(leagueid) + "_" + str(year) + '_team_stats.csv', i, i + 1, 5, var)
            df_temp_counter = prffs_library.side_points_tabulator(str(leagueid) + "_" + str(year) + '_team_stats.csv', i, i + 1, 6, var)
            data_array.append(df_temp)
            data_array_2.append(df_temp_counter)
        deep_data = pd.concat(data_array).reset_index()
        cum_points = pd.concat(data_array_2).reset_index()
        cum_points['cumulative side pts'] = 0
        for i in cum_points['Owner']:
            df_temp = cum_points[cum_points['Owner'] == i]
            df_temp['cumulative side pts'] = df_temp['Side points'].cumsum()
            print(df_temp)
            temp_df.append(df_temp)
        cum_points_final = pd.concat(temp_df).reset_index()

        #data_end = data_end.groupby(["Team ID", "Owner"], as_index=False)["Side points"].sum()
        #data_end = data_end.sort_values('Side points', ascending=False)
        writer = pd.ExcelWriter(str(leagueid) + "_" + str(year) + '_deep-stats.xlsx', engine='xlsxwriter')
        deep_data.to_excel(writer, sheet_name='Deep stats')
        cum_points_final.to_excel(writer, sheet_name='Cumul side points')
        writer.save()







    def cum_points(self,df,var,wkvar,year,leagueid):
        data_array = []
        df_arr = []
        for i in range(1,self.recent_week+1):
            data = prffs_library.side_points_tabulator(str(leagueid) + "_" + str(year) + '_team_stats.csv', i, i + 1, 4, var)
            data_array.append(data)
        data_end = pd.concat(data_array).reset_index()

        data_end = data_end.groupby(["Team ID", "Owner"], as_index=False)["Side points"].sum()
        data_end = data_end.sort_values('Side points', ascending=False)
        data_end.to_csv('asdf.csv')
        df_arr.append(data_end)

        MainWindow.plotter(self, df_arr, 0,1)

    def plot_organizer(self,plot_list, value, week,save,year,leagueid):
        df_list = []
        for counter, i in enumerate(plot_list):
            if str(i.state()) == "('selected',)":
                if counter != 10:
                    df = prffs_library.side_points_tabulator(str(leagueid) + "_" + str(year) + '_team_stats.csv', int(week), int(week)+1, 3, counter)
                    print(df)
                elif counter == 10:
                    df = prffs_library.side_points_tabulator(str(leagueid) + "_" + str(year) + '_team_stats.csv', int(week), int(week)+1, 4, counter)
                    print('DF #: ' + str(counter))
                df_list.append(df)
        MainWindow.plotter(self, df_list, week,save)

    def time_plot_organizer(self,plot_list, value, week,year,leagueid):
        df_time_list = []
        for j in range(1,len(week)):
            df_list = []
            for counter, i in enumerate(plot_list):
                if str(i.state()) == "('selected',)":
                    if counter != 10:
                        df = prffs_library.side_points_tabulator(str(leagueid) + "_" + str(year) + '_team_stats.csv', int(j), int(j)+1, 3, counter)
                        print(df)
                    elif counter == 10: # this is for side points
                        df = prffs_library.side_points_tabulator(str(leagueid) + "_" + str(year) + '_team_stats.csv', int(j), int(j)+1, 4, counter)
                        print('DF #: ' + str(counter))
                    df_list.append(df)
            print(df_list)
            df_time_list.append(df_list)
        print('df_time_ist')
        print(df_time_list)
        exit()
        MainWindow.plotter(self, df_list, week)



    def name_fix(self,df):
        for i in df['Owner']:

            df["Owner"].replace({i: i.split()[0]}, inplace=True)
        print(df)
        return df

    def plotter(self, df_array,week,save):

        # style stuff
        sns.set_theme(style="white", context="talk")
        sns.set(font="Verdana")

        font = {'family': 'arial',
                'weight': 'normal',
                'size': 12}
        matplotlib.rc('font', **font)
        # style stuff


        num_plots = len(df_array)
        print('number of plots to generate: ' + str(num_plots))
        df_names = []
        if num_plots > 0:
            fig, axs = plt.subplots(2, 1, sharex=True, sharey=True,figsize=(6, 6))
            for i in range(len(df_array)):
                MainWindow.name_fix(self, df_array[i])
                axis = plt.subplot2grid((num_plots, 1), (i, 0))

                axis.axhline(0, color="k", clip_on=False)
                if week == 0:
                    sns.barplot(x=df_array[i]['Owner'], y=df_array[i]['Side points'], palette="rocket", ax=axis)
                else:
                    sns.barplot(x=df_array[i]['Owner'], y=df_array[i].iloc[:, -2], palette="rocket", ax=axis)

                if 'week' in str(df_array[i].columns[-2]):
                    axis.set_title(str(df_array[i].columns[-2]).replace('(week)','') + ' (Week ' + str(week)+")")
                elif 'Plus/Minus' in str(df_array[i].columns[-2]):
                    axis.set_title(str(df_array[i].columns[-2]).replace('Plus/Minus','Margin of victory') + ' (Week ' + str(week)+")")
                elif week == 0:
                    axis.set_title('Cumulative side points (Through week ' + str(self.recent_week) + ')')
                else:
                    axis.set_title(str(df_array[i].columns[-2]) + ' (Week ' + str(week)+")")

                # add text above histograms
                for p in axis.patches:
                    axis.annotate("%.2f" % p.get_height(), (p.get_x() + p.get_width() / 2., p.get_height()),
                                   ha='center', va='center', fontsize=10, color='black', xytext=(0, 5),
                                   textcoords='offset points')
                axis.set_xticklabels(axis.get_xticklabels(), rotation=45)
                sns.despine(bottom=True)
                plt.tight_layout(h_pad=2)
                df_names.append(df_array[i].columns[:-2].values)
            if len(df_array) > 1:
                filename = str(df_array[0].columns[-2]).replace('/', '-') + '_' + str(df_array[1].columns[-2]).replace('/', '-')
            else:
                filename = str(df_array[0].columns[-2]).replace('/', '-')
            if save == 1:
                plt.savefig('2022_week'+str(week)+'_'+ filename +'.png',dpi=300)
            else:
                plt.show()

            #plt.savefig('week'+str(week)+'_'+ filename +'.png',dpi=300)
            plt.show()


    def tdep_plotter(self,df,week,team,division,cumulative,):
        df_teams = df[df['Team id'] == team]
        print(df_teams)


#prffs_library.scheduler(917761, espn, password,2021,10,1) # args = leagueID, ID, PW, YEAR, WEEK, time interval
#while True:
#    schedule.run_pending()
#    time.sleep(1)



def plot_intergame_data(df,matchup_id):

    df = pd.read_csv(df,encoding='utf-8-sig')
    name_arr = []
    if matchup_id != 10:
        df = df[df['matchup ID'] == matchup_id]
    for i in df['Team']:
        name_arr.append(i.rstrip().lstrip())

    df_matchup = df.drop(['team ID'],axis=1)
    df1_transposed = df_matchup.T
    df1_transposed = df1_transposed.rename(columns={df1_transposed.columns[0]:name_arr[0],df1_transposed.columns[1]:name_arr[1]})
    df1_transposed = df1_transposed.drop(['Team','matchup ID','0']).reset_index()
    df1_transposed = df1_transposed.melt('index', var_name='cols', value_name='vals')
    print(df1_transposed)

    ###############
    # plot the data

    g = sns.lineplot(x="index", y="vals",hue='cols',palette='magma', data=df1_transposed,markers=True,dashes=False,style='cols',markersize=14,
                     markeredgecolor='black')
    t = sns.lineplot(x="index", y="vals",hue='vals',palette='magma',style='cols', data=df1_transposed,markers=True,dashes=False,markersize=14,
                     markeredgecolor='black')

    sns.despine(bottom=True)

    g.xaxis.set_major_locator(ticker.MultipleLocator(1000))
    g.xaxis.set_major_formatter(ticker.ScalarFormatter())
    g.set_xlabel("Game time (minutes)")

    g.set_ylabel("Points")
    if matchup_id == 10:

        g.legend(loc='lower right',
                 labels=['All teams'],frameon=False)
    else:
        g.legend(loc='lower right',
                 labels=[name_arr[0], name_arr[1]],frameon=False)


    plt.show()
    plt.tight_layout(h_pad=2)

    #plt.savefig(str(matchup_id)+"_t-dep.png", dpi=300)

#for i in range(0,5):
#    plot_intergame_data('917761_2021_6_TDEP.csv',i)
#plot_intergame_data('917761_2021_8_TDEP.csv',10)

def plot_tdependent_data(df,y):

    # this function interpolates between two colors to generate a gradient for the bar graph

    bar_colors = [0,0,0,0,0,0,0,0,0,0,0,0] #initialize an array to store the color values
    #dark_green = Color("#003e17")  #your first color as hex code
    #colors = list(dark_green.range_to(Color("#f4ec16"), 8)) #generate a list of colors for the bar graph
    dark_green = Color("blue")
    colors = list(dark_green.range_to(Color("red"), 12))
    for i in range(len(colors)): # iterate and transpose the values in the list to an array
        bar_colors[i] = str(colors[i])[:-3]
    print(bar_colors) #sanity check to make sure your values look reasonable
    #bar_colors = ['blue','green','purple','black','yellow',]


    df = pd.read_csv(df,encoding='utf-8-sig')
    name_arr = []
    for i in df['Owner']:
        name_arr.append(i.rstrip().lstrip())
    name_arr = name_arr[0:11]

    df = df[['Team ID', 'Owner','Week','Division','Wins','Losses','Ties','Cumulative points']]
    df_arr = []
    for i in df['Team ID']:
        df_temp = df[df['Team ID'] == i]
        if y == 'cum points':
            y_val = 'Cumulative points'
            df_temp = df_temp[['Week',y_val,'Owner']]
            df_arr.append(df_temp)
    print(df_arr)

    ###############
    # plot the data
    for i in range(len(df_arr)):
        g = sns.lineplot(x=df_arr[i]['Week'], y=df_arr[i][y_val],style=df_arr[i]['Owner'],markers=True,dashes=False,markersize=12,markeredgecolor='black')

    sns.despine(bottom=True)

    g.xaxis.set_major_locator(ticker.MultipleLocator(1000))
    g.xaxis.set_major_formatter(ticker.ScalarFormatter())
    g.set_xlabel("Week")

    g.set_ylabel("Points")
    g.legend(loc='lower right',
             labels=name_arr,frameon=False)


    plt.show()
    plt.tight_layout(h_pad=2)

    #plt.savefig(str(matchup_id)+"_t-dep.png", dpi=300)


#plot_tdependent_data('917761_2021_team_stats.csv','cum points')


draft_years = ['917761_2021draft_stats_py.csv','917761_2020_draft_stats.csv']
# analysis('917761_2020draft_stats.csv')


### CALCULATE SIDE POINTS ON PER-WEEK BASIS ###
### ARGS = team_stats CSV, START WEEK, END WEEK ###
# file, start, end,save_data,position
#side_points_tabulator('917761_2021_team_stats.csv', 1,5,1,0)


#week_scores(917761, espn, password,2021,4)

# side poitn graphs
#side_point_graphs('side-point-deep-stats-2021.csv', 1)

### PULL SEASONAL DATA ###
#pull_all_data(917761, espn, password,0)

### DRAFT ANALYSIS IN CSV ###
# draft_decompose(draft_years,4)

app = IoPlot()
app.geometry("500x600")
app.mainloop()