Category: R
Everything filed under R.
The Power of Standards and Consistency
I'm going to (eventually) write a full post on the package I'm mentioning in this one : osqueryr ? . The TLDR on osqueryr is that it is an R DBI wrapper (that has just enough glue to also be plugged into dbplyr ) for osquery ? . The TLDR…
Create Code Metrics with cloc
The cloc Perl script (yes, Perl !) by Al Danial ( https://github.com/AlDanial/cloc ) has been one of the go-to tools for generating code metrics. Given a single file, directory tree, archive, or git repo, cloc can speedily give you metrics…
"LMX ot NOSJ!" Interchanging Classic Data Formats With Single blackmagic Incantations
The D.C. Universe magic hero Zatanna used spells (i.e. incantations) to battle foes and said spells were just sentences said backwards, hence the mixed up jumble in the title. But, now I'm regretting not naming the package zatanna and…
Wrangling Data Table Out Of the FBI 2017 IC3 Crime Report
The U.S. FBI Internet Crime Complaint Center was established in 2000 to receive complaints of Internet crime. They produce an annual report, just released 2017's edition , and I need the data from it. Since I have to wrangle it out, I…
Seventeen Minutes From Tweet To Package
The answer was a 1:1 "file upload" curl to httr…
Painless ODBC + dplyr Connections to Amazon Athena and Apache Drill with R & odbc
I spent some time this morning upgrading the JDBC driver (and changing up some supporting code to account for changes to it) for my metis package? which connects R up to Amazon Athena via RJDBC. I'm used to JDBC and have to deal with Java…
Examining POTUS Executive Orders
This week's edition of Data is Plural had two really fun data sets. One is serious fun (the first comprehensive data set on U.S. evictions , and the other I knew about but had forgotten: The Federal Register Executive Order (EO) data…
By Request: Retrieving Your Feedly "Saved for Later" Entries
@mkjcktzn asked if one can access Feedly "Saved for Later" items via the API. The answer is "Yes!", and it builds off of that previous post. You'll need to read it and get your authentication key (still no package ?) before…
Does Congress Really Care About Your Privacy?
Said bad words include "Facebook", "Mark Zuckerberg" and many referrals to entities within the U.S. Government. Given the topic, it cannot be…
Convert epub to Text for Processing in R
Here's one way to do that which doesn't rely on pandoc ( pandoc can easily do this and ships with RStudio but shelling out for this is cheating…