Skip to content

Instantly share code, notes, and snippets.

import openpyxl
from pathlib import Path
import requests
import os,sys,random
from SPARQLWrapper import SPARQLWrapper, JSON
url = "https://www.rki.de/DE/Content/InfAZ/N/Neuartiges_Coronavirus/Daten/Impfquotenmonitoring.xlsx;jsessionid=159D4550C958EDFAA9A49921FA132A35.internet122?__blob=publicationFile"
r = requests.get(url, allow_redirects=True)
open('Impfquotenmonitoring.xlsx', 'wb').write(r.content)
xlsx_file = Path(os.getcwd(), 'Impfquotenmonitoring.xlsx')
import re, feedparser
entries = feedparser.parse(
'http://www.texxas.de/searchXml/Tagesthemen_tv.xml'
).entries
for entry in entries:
if re.search(r'heute.*Tagesthemen', entry.title) is not None:
when = entry.title.split(' | ')[1]
print("Die Tagesthemen kommen " + when + " in der ARD.")
break
else:
live_loop :soup do
use_real_time
sleep 6.856
end
live_loop :nutz do
sample :loop_amen_full
sync :soup
end

Keybase proof

I hereby claim:

  • I am johl on github.
  • I am johl (https://keybase.io/johl) on keybase.
  • I have a public key ASAHm0cmAXI2wG5Ejw6DVvSU4LZHSuc6kYJ4J2_Oj5SdLQo

To claim this, I am signing this object:

#defaultView:Map
# "Abseits der Städte, in Dörfern, die mit 'ow' oder 'itz' enden" -- Grim104
SELECT ?item ?itemLabel ?coord
WHERE
{
?item wdt:P31/wdt:P279* wd:Q486972;
wdt:P17 wd:Q183;
rdfs:label ?itemLabel;
wdt:P625 ?coord;
FILTER (lang(?itemLabel) = "de").
<?php print(base64_decode('QmVpIFdpa2ltZWRpYSBEZXV0c2NobGFuZCB6dSBhcmJlaXRlbiwgYmVkZXV0ZXQgbWVociBhbHMgbnVyIGFuZ2VzdGVsbHQgenUgc2VpbiAtLSB3aXIgc2luZCBUZWlsIHZvbiBldHdhcywgZGFzIGdyw7bDn2VyIGlzdCBhbHMgd2lyIGFsbGUgenVzYW1tZW4uIERlaW5lIEFyYmVpdCBhbHMgVm9yc3RhbmQgaGF0IHp1IGRpZXNlbSBHZWbDvGhsIGJlaWdldHJhZ2VuIHVuZCBlcyB2aWVsbGVpY2h0IGF1Y2ggZXJzdCBtw7ZnbGljaCBnZW1hY2h0IG9kZXIgaW4gZGllIHJpY2h0aWdlbiBCYWhuZW4gZ2VsZW5rdC4gQWxsZXMgR3V0ZSwgUGF2ZWwhCg=='));
?>
{-# LANGUAGE OverloadedStrings #-}
import Data.ByteString.Char8 ()
import qualified Data.ByteString as B
import Data.ByteString.Base64 (decode)
import Data.Bits (xor)
Right key = decode "kTSFoLQRrR+hWJlLjAwXqOH5Z3ZLDWray5mBgNK7lLuHdTwab8m/v96y"
encrypt = B.pack . B.zipWith xor key
@johl
johl / melons.py
Last active December 20, 2015 15:09
import requests
def count(data, item):
return map(lambda x: x['item'], data).count(item)
r = requests.get("http://melon.meatloaf.ml/api/all")
data = r.json()
meatloafCount = count(data, 'meatloaf')
melonCount = count(data, 'melon')
print 'At OHM2013, %d meatloafs and %d melons were eaten.' % (meatloafCount, melonCount)
@johl
johl / wikidata.io
Last active December 17, 2015 19:49
Wikidata := Object clone
Wikidata get := method(item,
url := URL clone with("http://www.wikidata.org/w/api.php?action=wbgetentities&ids=" .. item .. "&format=json");
data := url fetch;
Yajl clone parse(data) root at(0) at("entities") at(item);
)
Wikidata get("q42") at("claims") keys map(property, Wikidata get(property) at("labels") at("en") at("value"))
from __future__ import print_function
import json
import re
import sys
import urllib2
if len(sys.argv) < 2:
sys.exit('Abfrage mit: %s Substantiv' % sys.argv[0])
substantiv = sys.argv[1]
try:
r = urllib2.urlopen(