Skip to content

Instantly share code, notes, and snippets.

(define (term? expr)
(or (symbol? expr) (number? expr)))
(define/match (expr? expr)
[((list (or '+ '- '*) (? expr?) ...)) #t]
[((? term?)) #t]
[(_) #f])
@cpcloud
cpcloud / stupidb.py
Last active November 21, 2018 20:09
A really slow database implemented using generators
import abc
import copy
from collections import defaultdict
from pprint import pprint
from typing import (
Any,
Callable,
Dict,
Hashable,
@cpcloud
cpcloud / sample3.txt
Created October 3, 2018 21:06
Result of Ibis Query
night_owl total night_owl_perc
0 422315 2541639 0.166159
@cpcloud
cpcloud / sample2.py
Created October 3, 2018 20:08
Ibis Night Owl Query
con = ibis.bigquery.connect(billing_project, 'bigquery-public-data.samples')
t = con.table('github_nested')
expr = (
t.mutate(
# get the hour in UTC during which a repo was created
hour=lambda t: t.created_at
.to_timestamp('%Y/%m/%d %T %z')
.hour(),
# compute the UTC offset to adjust in the next expression
utc_offset=lambda t: t.created_at.split(' ')[2].cast('int64') // 100)
@cpcloud
cpcloud / sample1.sql
Created October 3, 2018 20:06
Buggy SQL Query
SELECT *,
acq_ipos / num_investments AS acq_rate
FROM (
SELECT CASE WHEN i.investor_name IS NULL THEN ‘NO INVESTOR’
ELSE i.investor_name
END AS “Investor name”,
COUNT(DISTINCT c.permalink) AS num_investments,
COUNT(DISTINCT
CASE WHEN c.status IN (‘ipo’, ‘acquired’) THEN c.permalink
END) AS acq_ipos
@cpcloud
cpcloud / reduced_size.sh
Last active June 28, 2018 18:06
Bash script to demonstrate the difference in size when stripping symbols and using -Os
#!/bin/bash
set -eo pipefail
function env_exists() {
conda env list | cut -d ' ' -f 1 | grep -v '#' | grep "${1}" 1> /dev/null
}
envname="skimage-test-opt"
@cpcloud
cpcloud / bqshell.py
Created April 11, 2018 18:41
Simple BigQuery shell using ibis
import pandas as pd
import ibis
import click
from prompt_toolkit import prompt
from prompt_toolkit.layout.lexers import PygmentsLexer
from pygments.lexers.sql import PostgresLexer
@click.command()
@cpcloud
cpcloud / streaming_arrow.py
Last active June 2, 2022 02:21
Streaming Arrow
import random
import time
from collections import deque
from threading import Thread
import zmq
import numpy as np
import pandas as pd
@cpcloud
cpcloud / whaaaaa.py
Created February 23, 2018 22:22
Goofing off
In [6]: from slumba.miniast import *
In [7]: from slumba.source import sourcify
In [8]: myfunc = def_.silly_func(arg.a)(
...: if_(
...: load.a == 1,
...: return_(load.a + 2),
...: return_('Foo')
...: )
@cpcloud
cpcloud / arrow_streamz.py
Last active February 20, 2018 19:04
0cp: Arrow + streamz + 0mq
import random
import time
from collections import deque
from threading import Thread
import zmq
import numpy as np
import pandas as pd