rueycheng

Google Sheet Functions - Cheatsheet

Based on https://support.google.com/docs/table/25273?hl=en

Array

Name	Syntax	Description
ARRAY_CONSTRAIN	ARRAY_CONSTRAIN(input_range, num_rows, num_cols)	Constrains an array result to a specified size.
BYCOL	BYCOL(array_or_range, LAMBDA)	Groups an array by columns by application of a LAMBDA function to each column.

rueycheng

"""
Bootstrapping sampling distributions of Krippendorff's Alpha

A fast python implementation based on `fast-krippendorff` github repo and
Krippendorff's method.

https://github.com/pln-fing-udelar/fast-krippendorff
http://afhayes.com/public/alphaboot.pdf
"""
import numpy as np

rueycheng

import argparse
import math

from PIL import Image, ImageDraw


def main():
    parser = argparse.ArgumentParser()
    parser.add_argument('-o', dest='output_file', required=True, help='output file')
    parser.add_argument('input_files', metavar='FILE', nargs='+')

rueycheng

diff --git a/include/LightGBM/dataset.h b/include/LightGBM/dataset.h
index 12dbe6c..ef058af 100644
--- a/include/LightGBM/dataset.h
+++ b/include/LightGBM/dataset.h
@@ -88,6 +88,8 @@ class Metadata {
 
   void SetLabel(const label_t* label, data_size_t len);
 
+  void SetOrdering(const label_t* ordering, data_size_t len);
+

rueycheng

Create a blank-page PDF file

https://unix.stackexchange.com/questions/277892/how-do-i-create-a-blank-pdf-from-the-command-line

convert xc:none -page a4 blankpage.pdf

Convert PDF to greyscale

rueycheng

Clear out Git local/remote repos

https://stackoverflow.com/a/13102849

git checkout --orphan new_branch
git add -A                        # add all files and commit them
git commit
git branch -D master              # deletes the master branch
git branch -m master # rename the current branch to master

rueycheng

GNU Make Cheatsheet

Based on https://www.gnu.org/software/make/manual/html_node/Quick-Reference.html

Directives

Directive	Description
define variable define variable = define variable := define variable ::= define variable += define variable ?= endef	Define multi-line variables.
undefine variable	Undefining variables.

rueycheng

"""
This is a tool for extracting tuples directly out of Wikipedia database dumps
by parsing SQL INSERT statements.  For now, the output is in (tab-delimited)
CSV format, where each column indicate a field and each row a record.  The tool works
with gzip'ed files out of the box.

To use this tool, simply go (take `pagelinks.sql.gz` as an example):

    python extract_wp_tuples.py enwiki-20150515-pagelinks.sql.gz
"""