dirkschumacher

# LICENSE MIT
# Data from RKI with special Terms

library(dplyr)
library(readr)
library(tidyr)

# go to https://survstat.rki.de/Content/Query/Create.aspx
# Selected calendar weeks for rows and diseases for columns.
# had to manually edit, because not a valid csv

dirkschumacher

# Bug report

# It seems variable bounds are ignored when using binary variables "B".
# It works as expected if variables of type "I" are used

library(ROI)
library(ROI.plugin.glpk)

# max: x1 + x2 + x3 + x4
# s.t. x1 + x2 + x3 + x4 <= 4

dirkschumacher

Keybase proof

I hereby claim:

• I am dirkschumacher on github.
• I am dirks (https://keybase.io/dirks) on keybase.
• I have a public key ASDroBuw_-Dy6s_YoGdf-7cyfLipgEXNflEyoE27_cc14Ao

To claim this, I am signing this object:

dirkschumacher

# Use this code if you use the official BVG Berlin app
# I only tested it with credit card billing

# The BVG sends you an email for every purchase you make. 
# The following code tries to find all those mails and analyzes them.

library(gmailr)
library(purrr)
library(stringr)
library(lubridate)

dirkschumacher

= The news reads us data in Neo4J
Data by: http://newsreadsus.okfn.de/
== Intro
Interesting data created by http://newsreadsus.okfn.de/.
I converted the data from the links.json file and converted it into two simple csv files.

//setup
[source,cypher]
----
LOAD CSV FROM "https://dl.dropboxusercontent.com/s/riz5hp32mz0jzed/sites.csv?dl=1" AS csvline

dirkschumacher

= Donations to German parties
data from here: https://github.com/pudo/kompromatron
== Sample Data Set

//setup
[source,cypher]
----
LOAD CSV WITH HEADERS FROM "https://raw.githubusercontent.com/pudo/kompromatron/master/data/spenden.csv" AS data
WITH data SKIP 0 LIMIT 375
MERGE (p:Party { name: data.partei_name, acronym: data.partei_acronym})