Skip to content

Instantly share code, notes, and snippets.

library(tidyverse)
library(rvest)
library(cropcircles)
library(magick)
library(gt)
library(gtExtras)
data <- read_html("https://sport.orf.at/stories/3111293/") |>
html_elements("section") |>
html_table() |>
@mschnetzer
mschnetzer / teilzeit.R
Created April 7, 2023 09:28
Geschlechtsspezifische Unterschiede bei den Gründen für Teilzeit (https://twitter.com/matschnetzer/status/1625529059722641411)
library(tidyverse)
library(waffle)
library(msthemes)
library(viridis)
library(haven)
library(MetBrewer)
mz <- read_dta("mz2019.dta")
mz |> select(gewjahr, bsex, dteil) |>
librarian::shelf(tidyverse, STATcubeR, janitor, ggbump, ggtext, colorspace, futurevisions, msthemes)
# Set date language to German
Sys.setlocale(locale = "de_AT")
# Load latest data from Statistics Austria API
database <- "str:database:devpi15"
fields <- sc_schema_db(database) |> sc_schema_flatten("FIELD")
measures <- sc_schema_db(database) |> sc_schema_flatten("MEASURE")
db_schema <- sc_schema_db(database)
@mschnetzer
mschnetzer / ageinc.R
Last active December 24, 2022 08:19
Durchschnittliches Alter und Einkommen auf Gemeindeebene (https://twitter.com/matschnetzer/status/1606233928745988096)
library(tidyverse)
library(sf)
library(msthemes)
library(raster)
library(rmapshaper)
library(smoothr)
library(patchwork)
library(showtext)
select <- dplyr::select
@mschnetzer
mschnetzer / atdist.R
Created December 22, 2022 19:37
Wenn Österreich so verteilt wäre wie Vermögen (https://twitter.com/matschnetzer/status/1605844993683337216)
library(tidyverse)
library(msthemes)
library(sf)
library(showtext)
font_add_google("Roboto Condensed", "Roboto")
font_add_google("Playfair Display", "Playfair")
font_add_google("Roboto Mono", "Mono")
showtext_opts(dpi = 320)
showtext_auto()
@mschnetzer
mschnetzer / arbeitszeit_2019.R
Created December 20, 2022 20:12
Arbeitszeitrealitäten und -wünsche im Mikrozensus 2019 (https://twitter.com/matschnetzer/status/1605221105522073600)
library(tidyverse)
library(haven)
library(msthemes)
library(gganimate)
mz <- read_dta("mz2019.dta")
mz |> filter(xerwstat == 1, dbers <6, dstd < 999, balt %in% 20:69, aquartal == 4) |>
select(asbper, gewjahr, bsex, balt, dstd, dwstd) |>
mutate(status = case_when(
@mschnetzer
mschnetzer / gpghex.R
Last active December 15, 2022 20:12
3D-Grafik der geschlechtsspezifischen Lohnunterschiede in Österreich (https://twitter.com/matschnetzer/status/1603058949191778304)
librarian::shelf(tidyverse,pdftools,sf,msthemes,rayshader,wesanderson)
# Download PDF from Statistik Austria: https://www.statistik.at/fileadmin/publications/Lohnsteuer-2021.pdf
rawpdf <- pdf_text("Lohnsteuer-2021.pdf")
# Manual editing to obtain the required data from the two-column table
tmppdf <- rawpdf[67:68] |> strsplit('\n') |> unlist()
df <- tmppdf[c(11:55,67:86)] |> as.data.frame() |> setNames("string") |>
separate(string, into = c("gem","male","female", "gem2", "male2", "female2"), sep = "\\s\\s+")
@mschnetzer
mschnetzer / heat_record.R
Last active December 12, 2022 19:25
Year of highest temperatures ever recorded by a country (https://twitter.com/matschnetzer/status/1602260127536799745)
library(tidyverse)
library(rvest)
library(stringi)
library(janitor)
library(countrycode)
library(MetBrewer)
library(msthemes)
library(patchwork)
url <- "https://en.wikipedia.org/wiki/List_of_weather_records#Highest_temperatures_ever_recorded"
@mschnetzer
mschnetzer / socialhousing.r
Last active December 12, 2022 09:48
Anteil an sozialem Wohnbau in österreichischen Städten (https://twitter.com/matschnetzer/status/1601228388659654657)
library(tidyverse)
library(pdftools)
library(msthemes)
library(sf)
library(ggforce)
library(ggrepel)
sf::sf_use_s2(FALSE)
# Download PDF from https://www.staedtebund.gv.at/services/publikationen/staedte-in-zahlen-oestiz/ and extract page 55
rawpdf <- pdf_text("https://www.staedtebund.gv.at/ePaper-oestiz/ausgaben-pdf/OESTIZ_2020.pdf")
# This code is adapted from original code by @cnicault https://github.com/cnicault/tidytuesday/tree/master/2021/2021-21-ask_a_manager
library(tidyverse)
library(readxl)
library(scales)
library(ggbump)
library(glue)
library(showtext)
library(msthemes)