| select pip_version, distro_name, distro_version, libc_version, (download_count / total * 100) as percent | |
| from ( | |
| SELECT REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(LOWER(details.distro.name), " (gnu/)?linux", ""), "^red.?hat.*", "redhat"), "os x","macos") AS distro_name, | |
| details.distro.version as distro_version, | |
| details.distro.libc.version as libc_version, | |
| details.installer.version as pip_version, | |
| COUNT(*) AS download_count, | |
| SUM(COUNT(*)) OVER () AS total | |
| FROM `the-psf.pypi.downloads*` | |
| WHERE |
| select pip_version, distro_name, distro_version, (download_count / total * 100) as percent | |
| from ( | |
| SELECT REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(LOWER(details.distro.name), " (gnu/)?linux", ""), "^red.?hat.*", "redhat"), "os x","macos") AS distro_name, | |
| details.distro.version as distro_version, | |
| details.installer.version as pip_version, | |
| COUNT(*) AS download_count, | |
| SUM(COUNT(*)) OVER () AS total | |
| FROM `the-psf.pypi.downloads*` | |
| WHERE | |
| details.installer.version IS NOT NULL |
| select distro_name, distro_version, libcv, (download_count / total * 100) as percent | |
| from ( | |
| SELECT REGEXP_REPLACE(REGEXP_REPLACE(REGEXP_REPLACE(LOWER(details.distro.name), " (gnu/)?linux", ""), "^red.?hat.*", "redhat"), "os x","macos") AS distro_name, | |
| details.distro.version as distro_version, | |
| details.distro.libc.version as libcv, | |
| COUNT(*) AS download_count, | |
| SUM(COUNT(*)) OVER () AS total | |
| FROM `the-psf.pypi.downloads*` | |
| WHERE | |
| details.distro.name IS NOT NULL |
| """ Analyzes output from NZ death registry search. | |
| Input is some death records from printable (all) version of search on | |
| https://bdmhistoricalrecords.dia.govt.nz | |
| """ | |
| import re | |
| from datetime import datetime | |
| import calendar |
| -- Init file for Hammerspoon: https://www.hammerspoon.org | |
| function fill_screen(framer) | |
| -- Make window with current focus fill frame from `framer`. | |
| local win = hs.window.focusedWindow() | |
| local f = win:frame() | |
| local max = framer:frame() | |
| f.x = max.x | |
| f.y = max.y |
| -- Init file for Hammerspoon: https://www.hammerspoon.org | |
| function fill_screen(framer) | |
| -- Make window with current focus fill frame from `framer`. | |
| local win = hs.window.focusedWindow() | |
| local f = win:frame() | |
| local max = framer:frame() | |
| f.x = max.x | |
| f.y = max.y |
I have Jupytext installed on all my machines, and configured so I always save notebooks to RMarkdown - see https://github.com/matthew-brett/cfd2019#configuring-jupyter-to-save--load-in-r-markdown.
This means I can edit notebooks in Vim and Atom, and it is much easier to use
version control on the plain-text .Rmd files.
| .ipynb_checkpoints/ | |
| *.Rmd |