Skip to content

Instantly share code, notes, and snippets.

@MickeyPvX
MickeyPvX / espn_ffl.py
Last active September 12, 2021 19:35
Python class to pull ESPN Fantasy Football data into a pandas DataFrame
import pandas as pd
import re
from urllib.request import urlopen
from bs4 import BeautifulSoup as soup
from datetime import datetime as dt
class ESPN_FFL(object):
"""Helper class for pulling ESPN Fantasy Football stats for a given season.
@MickeyPvX
MickeyPvX / ms_outlook_interop.py
Created September 12, 2018 13:40
Interact with MS Outlook: download attachments, create MailItems
import os
import pandas as pd
from comtypes.client import CreateObject, GetActiveObject
class OutlookInstance():
"""Class to help with MS Outlook interoperability
Attributes:
outlook (comtypes.POINTER(_Application)): MS Outlook Application
@MickeyPvX
MickeyPvX / dataframe_to_SQLServer.py
Created September 12, 2018 13:33
Two quick functions for converting a Pandas DataFrame to XML, then to an executable query string for SQL Server.
import xml.etree.ElementTree as ET
from collections import OrderedDict
def gen_XML(dFrame, subelement):
"""Function to generate an XML string from a provided pandas DataFrame
# Arguments
dFrame (pandas.DataFrame): DataFrame to be converted to an XML string
subelement (str): Subelement of root to be used...can be just about anything
@MickeyPvX
MickeyPvX / tkinter_add_ons.py
Last active April 4, 2022 14:51
Useful add-ons for tkinter-based GUI applications
import tkinter as tk
import pandas as pd
from tkinter import ttk
class Stdout_to_Widget(object):
"""Class to catch sys.stdout and display real-time to a tkinter Text or Listbox widget
Attributes:
widget (tkinter.Text/tkinter.Listbox): tkinter Text or Listbox to display stdout data
@MickeyPvX
MickeyPvX / NLTK_Simple_BagOfWords.py
Created September 12, 2018 13:22
Builds a simple bag-of-words model using the nltk library
import pandas as pd
import re
import os
import pydotplus
import numpy as np
import datetime as dt
from nltk.corpus import stopwords
from nltk.stem.porter import PorterStemmer
from os.path import join