WebR 0.1.0 was released! I had been git-stalking George (the absolute genius who we all must thank for this) for a while and noticed the GH org and repos being updated earlier this week, So, I was already pretty excited. It dropped today, and you can hit that link for all the details and other… Continue reading

2022 Hanukkah of Data • Puzzle 2

Ref: https://rud.is/b/2022/12/19/2022-hanukkah-of-data-puzzle-1/ library(tidyverse) cust <- read_csv(“~/Downloads/noahs-csv/noahs-customers.csv”) orders_items <- read_csv(“~/Downloads/noahs-csv/noahs-orders_items.csv”) orders <- read_csv(“~/Downloads/noahs-csv/noahs-orders.csv”) products <- read_csv(“~/Downloads/noahs-csv/noahs-products.csv”) orders_items |> left_join(products) -> oip orders |> left_join(oip) -> orders orders |> filter( 2017 == lubridate::year(ordered), grepl(“cleaner|bagel”, desc, ignore.case=TRUE) ) |> group_by(customerid, orderid) |> summarise( ord = paste0(desc, collapse=”; “), n = n() ) |> arrange(desc(n)) # look for bagel… Continue reading