nonsleepr

import requests
from io import BytesIO
import sys
import json

OFFICEPY_HOST = "service-preview-p1-eastus2.officepy.microsoftusercontent.com"
USER_AGENT = "Microsoft Office/16.0 (Windows NT 10.0; Microsoft Excel 16.0.16827; Pro)"


GREEN = '\033[32m'

nonsleepr

Keybase proof

I hereby claim:

• I am nonsleepr on github.

• I am nonsleepr (https://keybase.io/nonsleepr) on keybase.

• I have a public key ASD2K73fCmJ6Ruf8af6CwpPQKYiBD3vk2tdhKIG1qydczgo

nonsleepr

import trio

from multiplexer import Multiplexer

async def reader(mx, key, timeout=100):
    print(f'Waiting for "{key}"...')
    try:
        with trio.fail_after(timeout):
            value = await mx[key]
            print(f'Got value "{value}" for key {key}')

nonsleepr

# Requires presence of credentials.txt file containing login/password in the following format:
# UserName=my_username&Password=my_password

COMPETITION=diabetic-retinopathy-detection

all: download_files

session.cookie: credentials.txt
        curl -o /dev/null -c session.cookie https://www.kaggle.com/account/login
        curl -o /dev/null -c session.cookie -b session.cookie -L -d @credentials.txt https://www.kaggle.com/account/login

nonsleepr

ngrams.tokenizer <- function(x, n = 2) {
  trim <- function(x) gsub("(^\\s+|\\s+$)", "", x)
  terms <- strsplit(trim(x), split = "\\s+")[[1]]
  ngrams <- vector()
  if (length(terms) >= n) {
    for (i in n:length(terms)) {
      ngram <- paste(terms[(i-n+1):i], collapse = " ")
      ngrams <- c(ngrams,ngram)
    }
  }

nonsleepr

require(plyr)

kfold <- function(df, k, train.f, predict.f) {
  progress.bar <- create_progress_bar("text")
  progress.bar$init(k)
  
  N <- nrow(df)
  subsample.id <- sample(1:k, N, replace = TRUE)
  r <- vector(length = N)
  

nonsleepr

### Set of functions to download datasets from Kaggle

# Usage:
#   
#   > train <- kaggle_get_file("train.csv",
#   +                          competition.name = "titanic-gettingStarted",
#   +                          username = "username",
#   +                          password = "password")
#
#   > head(train, n = 2)

nonsleepr

-- Via http://forums.teradata.com/forum/database/dense-rank

SELECT
    department_number,
    /*** Syntax not implemented in Teradata ***/
    DENSE_RANK() OVER (PARTITION BY department_number ORDER BY salary_amount),
    last_name,
    salary_amount
FROM employee;

nonsleepr

#!/bin/bash
 
#
# Usage:
#    > futurelearn_dl.sh login@email.com password course-name week-id
# Where *login@email.com* and *password* - your credentials
# ,*course-name* is the name from URL
# and *week-id* is the ID from the URL
#
# E.g. To download all videos from the page: https://www.futurelearn.com/courses/corpus-linguistics/todo/238

nonsleepr