Publications by hrbrmstr
Amazon Athena {dbplyr} Implicit Usage of Presto Functions and Making JSON Casting Great Again
I was chatting with a fellow Amazon Athena user and the topic of using Presto functions such as approx_distinct() via {d[b]plyr} came up and it seems it might not be fully common knowledge that any non-already translated function is passed to the destination intact. That means you can just “use” approx_distinct() and it will work just fine. H...
3006 sym R (8111 sym/7 pcs)
Getting a Handle on macOS App Entitlements with R
If you’ve been following me around the internets for a while you’ve likely heard me pontificate about the need to be aware of and reduce — when possible — your personal “cyber” attack surface. One of the ways you can do that is to install as few applications as possible onto your devices and make sure you have a decent handle on those...
3634 sym R (8776 sym/8 pcs) 3 img
Fully Native M1/Apple Silicon R Setup
Presented without much commentary since I stopped once {ggrepel} and {graphlayouts} failed (RStudio doesn’t support it yet, either, which I knew). The following steps will get you a fully working and STUPID FAST fully native ARM64 M1/Apple Silicon R setup with {tidyverse} and {rJava}. Just remember, that if you need RStudio (or anything that li...
824 sym Python (2055 sym/1 pcs)
Extracting Heart Rate Data (Two Ways!) from Apple Health XML Export Files Using R (a.k.a. The Least Romantic Valentine’s Day R Post Ever)
Expand for EKG code library(hrbrthemes) library(elementalist) # remotes::install_github("teunbrand/elementalist") library(ggplot2) read_csv( file = "~/Data/apple_health_export/electrocardiograms/ecg_2020-09-24.csv", # this is extracted below skip = 12, col_names = "µV" ) %>% mutate( idx = 1:n() ) -> ekg ggplot() + geom_line_t...
4677 sym R (4337 sym/9 pcs) 10 img
Getting Into the Rhythm of Chart Typography with {ragg} and {hrbragg} (a.k.a. It’s {ragg}-time}
Horrible puns aside, hopefully everyone saw the news, earlier this week, from @thomasp85 on the evolution of modern typographic capabilities in the R ecosystem. Thomas (and some cohorts) has been working on {systemfonts}, {ragg}, and {textshaping} for quite a while now, and the — shall we say tidyglyphs ecosystem — is super-ready for prime ti...
7418 sym R (11404 sym/11 pcs) 14 img
Brimming With Possibilities: Query zqd & Mine Logs with zq from R
Brim Security maintains a free, Electron-based desktop GUI for exploration of PCAPs and select cybersecurity logs: along with a broad ecosystem of tools which can be used independently of the GUI. The standalone or embedded zqd server, as well as the zq command line utility let analysts run ZQL (a domain-specific query language) queries on cyber...
2235 sym R (4854 sym/5 pcs) 4 img
Check ‘Developer Tools’ First To Avoid Heavy-ish Dependencies
Guillaume Pressiat (@GuillaumePressiat) did a solid post & video on using Selenium to scrape a paginated table from understat[.]com/league/EPL/2020 (I just cannot bring myself to provide an active link to any SportsBall site). He does a great job walking folks through acquiring & orchestrating the heavy dependency that is Selenium. I did a quick ...
4422 sym R (8193 sym/8 pcs) 2 img
Quick Hit: Processing macOS Application Metadata Weirdly Fast with mdls and R
(reminder: Quick Hits have minimal explanatory blathering, but I can elaborate on anything if folks submit a comment). I’m playing around with Screen Time on xOS again and noticed mdls (macOS command line utility for getting file metadata) has a -plist option (it probably has for a while & I just never noticed it). I further noticed there’s a...
2338 sym R (9342 sym/7 pcs)
Avoiding The mdls Command Line Round Trip With swiftr::swift_function()
The last post showed how to work with the macOS mdls command line XML output, but with {swiftr} we can avoid the command line round trip by bridging the low-level Spotlight API (which mdls uses) directly in R via Swift. If you’ve already played with {swiftr} before but were somewhat annoyed at various boilerplate elements you’ve had to drag a...
2773 sym R (7054 sym/7 pcs) 4 img
A {swiftr} Brief Interlude While Awaiting {cdcfluview} CRAN Checks
My {cdcfluview} package started tossing erros on CRAN just over a week ago when the CDC added an extra parameter to one of the hidden API endpoints that the package wraps. After a fairly hectic set of days since said NOTE came, I had time this morning to poke at a fix. There are alot of tests, so after successful debugging session I was awaiting ...
2352 sym R (9113 sym/3 pcs) 4 img