jennynz

# Given a dataframe called `df` which you've wrangled to have the columns:
# - org (str)
# - year (int or float)
# - bin (str) (e.g. Under 1 day, 1 day to 1 week)
# - percent (float)
# Here's the matplotlib code to generate the datavis in this blog post:
# https://levelup.gitconnected.com/how-does-pr-review-wait-time-affect-your-open-source-project-d79bd0af0ea3

import pandas as pd
import matplotlib.pyplot as plt

jennynz

import requests
import boto3
import json
import os

from datetime import datetime, timedelta

# Example: getting data for vuejs/vue from the last 90 days
ORG_NAME = "vuejs"
REPO_NAME = "vue"

jennynz

CommitCommentEvent
CreateEvent
DeleteEvent
ForkEvent
GollumEvent
IssueCommentEvent
IssuesEvent
MemberEvent
PublicEvent
PullRequestEvent

jennynz

# List of common bots on GitHub
# Doesn't include ones that would already be filtered out by the is_bot function
# but it won't hurt to also include them in here

GITHUB_BOTS = [
    'netlify',
    'linear-app',
    'codeclimate',
    'renovate',
    'renovate-approve',

jennynz

SELECT
  repo.name as repo,
  type,
  created_at,
  actor.login,
  JSON_VALUE(payload, '$.action') as action,
  -- *** PR columns
  JSON_VALUE(payload, '$.pull_request.node_id') as pr_node_id,
  JSON_VALUE(payload, '$.pull_request.state') as pr_state,
  JSON_VALUE(payload, '$.pull_request.user.login') as pr_user_login,

jennynz

Aberforth Dumbledore
Abernathy
Abraham Peasegood
Abraham Potter
Abraxas Malfoy
Achilles Tolliver
Adalbert Waffling
Adrian Pucey
Adrian Tutley
Agatha Chubb

jennynz

2nd Hand Brooms
Amanuensis Quills
Apothecary
Bluebottle
Broomstix
Cleansweep Broom Company
Comet Brooms Trading Company
De Vine and Daughters Crystal Balls
Dervish and Banges
Diagon Alley Apothecary

jennynz

Harry Potter
Ron Weasley
Hermione Granger
Albus Dumbledore
Rubeus Hagrid
Severus Snape
Voldemort
Sirius Black
Draco Malfoy
Fred Weasley

jennynz

# If you come from bash you might have to change your $PATH.
# export PATH=$HOME/bin:/usr/local/bin:$PATH

# Path to your oh-my-zsh installation.
export ZSH="/Users/jenny.sahng/.oh-my-zsh"

# Set name of the theme to load --- if set to "random", it will
# load a random theme each time oh-my-zsh is loaded, in which case,
# to know which specific one was loaded, run: echo $RANDOM_THEME
# See https://github.com/robbyrussell/oh-my-zsh/wiki/Themes

jennynz

PS1="\[\033[36m\]\w\[\033[m\]\[\033[32m\] \[\033[33;1m\](\$(git branch 2>/dev/null | grep '^*' | cut -c 3-))\[\033[m\]\] \$ "