This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CommitCommentEvent | |
CreateEvent | |
DeleteEvent | |
ForkEvent | |
GollumEvent | |
IssueCommentEvent | |
IssuesEvent | |
MemberEvent | |
PublicEvent | |
PullRequestEvent |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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', |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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, |
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Aberforth Dumbledore | |
Abernathy | |
Abraham Peasegood | |
Abraham Potter | |
Abraxas Malfoy | |
Achilles Tolliver | |
Adalbert Waffling | |
Adrian Pucey | |
Adrian Tutley | |
Agatha Chubb |
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Harry Potter | |
Ron Weasley | |
Hermione Granger | |
Albus Dumbledore | |
Rubeus Hagrid | |
Severus Snape | |
Voldemort | |
Sirius Black | |
Draco Malfoy | |
Fred Weasley |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
PS1="\[\033[36m\]\w\[\033[m\]\[\033[32m\] \[\033[33;1m\](\$(git branch 2>/dev/null | grep '^*' | cut -c 3-))\[\033[m\]\] \$ " |