aflansburg

# import libs
import pandas as pd
import numpy as np
import seaborn as sns
import matplotlib.pyplot as plt

# this function will create a boxplot + histogram plot using Seaborn's Jointgrid
# we'll also provide Type annotations to provide hints to future users
def dual_plot(series: pd.Series, figsize: tuple = (16,8),
              bins: int = None, return_plot: bool = False,

aflansburg

# function to iterate over specified variables and view their value counts

# add typing to help understand our function if reused elsewhere
from typing import List
def value_count_rep(columns: List, df: pd.DataFrame) -> None:
    '''
    Parameters: List of columns to iterate over
    Returns:    No return value. Prints the value counts of each column(feature) to stdout
    '''
    for column in columns:

aflansburg

# https://www.python.org/dev/peps/pep-0634/
# PEP 634 proposed (and was accepted) Structural Pattern Matching (switch/case)
# for Python (available in 3.10) - as of this Gist,
# prerelease 3.10.0b2 is available

import inspect

F = [
  lambda x,y: x+y,
  lambda x: x+1,

aflansburg

## handy multi-plot function for showing mode, median, and mean lines in a distplot 
## (but using histplot since distplot is deprecated)
## Author - Abram Flansburg
## Intended for use in Jupyter / iPython
def skewness_plot(series):
    """
    Plots a series using the histogram plot with kde and plots, mean, mode, and median lines.
    *** Dependencies ***
    Series must be a pandas.Series
    Seaborn must be imported as sns

aflansburg

// In this scenario - a Cloudwatch Subscription Filter is hooked up to a Node.js lambda's ARN 
// (see AWS docs around Log Group subscription filters)
// Will need a webhook for the appropriate Slack channel

const https = require('https');
const zlib = require('zlib');

const options = {
    hostname: 'hooks.slack.com',
    path: 'SLACK_WEBHOOK_URL',

aflansburg

# Not my original function - looking for citation
def missing_check(df):
    null_val_sum = df.isnull().sum()
    total = df.isnull().sum().sort_values(ascending=False) # total null values
    percent = (null_val_sum/df.isnull().count()).sort_values(ascending=False)
    missing_data = pd.concat([total, percent], axis=1, keys=['Total', 'Percent'])
    return missing_data
'''
Example:
missing_data(df_with_nulls)

aflansburg

# imagine this lives at app/lib/complicated_data
module ComplicatedData
  def generate_complicated_plot_data(start_date: 30.days.ago, end_date: Date.today, type: nil)
    # implementation
  end
  
  # module_function ensures the method cannot be overridden or extended
  module_function :generate_complicated_plot_data
end

aflansburg

# radius of earth in meters
R = 6371000;

def haversine(coord1:, coord2:)
  # first add our own radians function since Ruby Math does not have one
  radians = -> (degrees) { degrees * (Math::PI / 180)}

  # convert latitude degrees to radians
  phi_1 = radians.call(coord1[:latitude]);
  phi_2 = radians.call(coord2[:latitude]);

aflansburg

// see the Haversine formula description here
// https://community.esri.com/t5/coordinate-reference-systems/distance-on-a-sphere-the-haversine-formula/ba-p/902128
function haversine(coord1, coord2){
  // radius of earth in meters
  const R = 6371000;

  // convert latitude degrees to radians
  const phi_1 = Math.radians(coord1.latitude);
  const phi_2 = Math.radians(coord2.latitude);

aflansburg

function timestampIt(){
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0]; // this will assign the first sheet
  var cell = sheet.getRange('A1');
  var d = new Date();
  d.setHours(d.getHours() +1);
  var user = Session.getActiveUser().getUserLoginId();
  user = String(user);
  user = user.replace('@gmail.com', '');
  cell.setValue('Last updated: ' + d.toLocaleString() + ' by ' + user);