Skip to content

Instantly share code, notes, and snippets.

alexshpilkin /
Last active Sep 26, 2021
Data obfuscation on the Russian Central Election Commission website
#!/usr/bin/env python3
#{ SPDX-License-Identifier: CC0-1.0 }
from collections import namedtuple
from fontTools.ttLib import TTFont
from io import BytesIO
from lxml.html import document_fromstring
from lxml.etree import tostring
from re import finditer, compile as re_compile
from requests import get
alexshpilkin /
Created May 6, 2021
Quantiles of the binomial and normal distributions
#!/usr/bin/env python3
# SPDX-License-Identifier: CC0-1.0
from math import exp, factorial, pi, sqrt
def binom(n, k):
if n - k < 0 or n + k < 0:
return 0
assert (n - k) % 2 == 0 and (n + k) % 2 == 0
return factorial(n) / (2**n * factorial((n-k)//2) * factorial((n+k)//2))
def gauss(n, k):
alexshpilkin / grades.js
Created Mar 14, 2021
Google Apps Script program to post student grades
View grades.js
// SPDX-License-Identifier: CC0-1.0
const EMAIL = 3 /* C */, TUTOR = 5 /* E */, PROBLEMS = 7 /* G: */;
function slack(url, payload) {
var token = PropertiesService.getDocumentProperties().getProperty(TOKEN);
if (token === null)
throw new Error('Slack bot token not set');
var req = {headers: {'Authorization': `Bearer ${token}`}};
alexshpilkin /
Last active Jan 8, 2021
Rate-limiting utility for tracing and such
#!/usr/bin/env python3
from time import monotonic
class periodically:
def __init__(self, interval):
self.interval = interval
self._previous = None
def __enter__(self):
if self._previous is not None:
alexshpilkin /
Created Jan 7, 2021
Trio channels with priorities
from heapq import heappush, heappop
from math import inf
from trio import BrokenResourceError, ClosedResourceError, EndOfChannel, WouldBlock
from import ReceiveChannel, SendChannel
from trio.lowlevel import ParkingLot, checkpoint, checkpoint_if_cancelled, cancel_shielded_checkpoint
from trio._channel import MemoryChannelStats
from trio._util import NoPublicConstructor
class MemoryChannelState:
__slots__ = ('data', 'max_buffer_size', 'number', 'open_send_channels',
alexshpilkin /
Created Jun 17, 2019
Pipe video from DVR to GStreamer
#!/usr/bin/env python3
from gi import require_version
require_version('Gst', '1.0')
require_version('Gtk', '3.0')
from gi.repository import GObject, Gst, Gtk
from os.path import abspath
from sys import argv, stderr
from threading import Thread
alexshpilkin / moscow.tsv
Last active May 10, 2019
Administrative divisions of Moscow
View moscow.tsv
45 Город Москва
45 301 муниципальный округ Богородское
45 302 муниципальный округ Вешняки
45 303 муниципальный округ Восточное Измайлово
45 304 муниципальный округ Восточный
45 304 000 106 п Восточный
45 304 000 111 п Акулово
45 305 муниципальный округ Гольяново
45 306 муниципальный округ Ивановское
45 307 муниципальный округ Измайлово
alexshpilkin /
Last active Apr 24, 2019
Add diffs to results posts
#!/bin/sh -eu
# NB: Contains literal tabs
caption() {
python -c '
from os import getenv
from sys import argv
from telegram import Bot
from telegram.error import BadRequest, TimedOut
alexshpilkin / drv.wsdl
Last active Sep 4, 2019
Access SOAP APIs of the Ukrainian DRV with Python and Zeep
View drv.wsdl
<?xml version="1.0" encoding="utf-8"?>
<wsdl:definitions xmlns:soap=""
<s:schema elementFormDefault="qualified" targetNamespace="">
alexshpilkin /
Last active Apr 14, 2019
Aggregate multiple CVK scrapes into precinct histories
#!/usr/bin/env python3
# NB Depends on dict preserving the insert order (CPython >= 3.6, PyPy all)
from csv import DictReader
from datetime import datetime as DateTime
from os import scandir
from simplejsonseq import dump
from sys import argv, stderr, stdout
import ietfcsv # ietf-tab CSV dialect