Publications by R on Redwall Analytics
Evaluating American Funds Portfolio Over Three Market Cycles
Introduction Active funds have done poorly over the last ten years, and in most cases, struggled to justify their fees. A growing list of commentators appropriately advocate for index funds, although sometimes go a little beyond what we believe to be fairly representing the facts. The inspiration for this article is this post by Asset Builder blo...
10426 sym R (5739 sym/6 pcs) 2 img
Using drake for ETL and building Shiny app for 900k CT real estate sales
# R Libraries for this blogdown post # See Github for libraries used in drake project library(data.table) library(DT) knitr::opts_chunk$set( fig.width = 15, fig.height = 8, out.width = '100%') Introduction The State of Connecticut requires each of its 169 municipalities to report real estate sales used in the assessment process. All repor...
9188 sym R (3266 sym/6 pcs) 2 img
Learning SQL and Exploring XBRL with secdatabase.com – Part 1
# Libraries packages <- c("data.table", "DBI", "reticulate", "keyring", "RAthena" ) if (length(setdiff(packages,rownames(installed.packages()))) > 0) { install.packages(setdiff(packages, rownames(installed.packages()))) } invisible(lapply(packages, library, character.only = TRUE)) knitr::opts_chunk$set( comment = N...
11307 sym R (5077 sym/13 pcs) 6 img
Exploring 30 years of local CT weather history with R
# Libraries packages <- c("data.table", "ggplot2", "stringr", "skimr", "janitor", "glue" ) if (length(setdiff(packages,rownames(installed.packages()))) > 0) { install.packages(setdiff(packages, rownames(installed.packages()))) } invisible(lapply(packages, library, character.only = TRUE)) knitr::opts_chunk$set( ...
9579 sym R (11590 sym/14 pcs) 16 img 5 tbl
Building a career changer resume with R {vitae} package
# Libraries packages <- c("vitae", "tibble", "spelling" ) if (length(setdiff(packages, rownames(installed.packages()))) > 0) { install.packages(setdiff(packages, rownames(installed.packages()))) } invisible(lapply(packages, library, character.only = TRUE)) knitr::opts_chunk$set( comment = NA, fig.width = 12, fig.height =...
8506 sym R (3263 sym/6 pcs)
Finding the Dimensions of `secdatabase.com` from 2010-2020 – Part 2
Source: xbrl.org Introduction This is part 2 of a 3-part series on extracting XBRL data from secdatabase.com. In Learning SQL and Exploring XBRL with secdatabase.com – Part 1, we showed how to set up the database connection from RStudio. In this post, we will discuss the basics of XBRL and secdatabase.com’s SQL representation of it. We will ...
16404 sym R (4092 sym/6 pcs) 2 img
Tapping Yelp data with Apache Drill from Mac using {sergeant}
Click to see package details # Libraries packages <- c("tidyverse", "sergeant", "tictoc" ) if (length(setdiff(packages,rownames(installed.packages()))) > 0) { install.packages(setdiff(packages, rownames(installed.packages()))) } invisible(lapply(packages, library, character.only = TRUE)) knitr::opts_chunk$set( comment = NA...
17053 sym R (12610 sym/25 pcs) 14 img 3 tbl
In Search of a Better Home Price Prediction in Greenwich, CT – Part 1
Figure 1: Average Single Family Homes in Towns of Connecticut 1999-2018 Introduction Though losing ground in recent years, Connecticut has long had some of the highest average incomes and home prices in the country. Within the State, some towns have had significantly higher selling prices than others (shown in chart above). In this series, we wi...
22852 sym R (5514 sym/10 pcs) 38 img
Introducing the Redwall IRS SOI Tax Dashboard
Introduction The IRS SOI Tax Statistics is a fabulous seemingly undiscovered data set, which should be frequently referenced in any discussion about income and taxes. We often see median income represented by Census data, but have always been skeptical that most people know their exact income in any given year or would report it according to a un...
10049 sym 2 img
Using Census of Govts to Show that if You Know R, You Know SQL
The Government Finance Database Viewed in RStudio Connections Pane Introduction We have been exploring Willamette University Government Finance Database, a cleaned up and aggregated version of 50 years of annual Census of Governments. For those interested in learning more, please see Willamette’s paper The Government Finance Database: A Common...
10152 sym R (13130 sym/14 pcs) 2 img