Articles by R on Redwall Analytics

Parsing Mass Municipal PDF CAFRs with Tabulizer, pdftools and AWS Textract – Part 1

March 30, 2020 | R on Redwall Analytics

# Libraries
packages <- 
  c("data.table",
    "rlist",
    "stringr",
    "DT",
    "janitor",
    "readxl",
    "xlsx"
    )

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=8, out.width = '100%')

Introduction Redwall Analytics had the pleasure of collaborating with Marc Joffe, of Reason Foundation, in its October 2018 post Replicating Yankee Institute Risk Score Over 15 Years for 150 Connecticut towns. This involved taking a well organized public dataset from the State’s website, and analyzing and building an application to view ... [Read more...]

A Walk Though of Accessing Financial Statements with XBRL in R – Part 1

February 17, 2020 | R on Redwall Analytics

Introduction As financial professionals and analytic software lovers, the ability to efficiently load a large number of financial statements, and conduct an analysis has always been a key objective. In previous posts, Redwall Analytics worked with a 15-year time series of municipal Comprehensive Annual Financial Reports (CAFR) for 15 Fairfield County, ...

[Read more...]

Tracking R&D spending by 700 Listed US Pharma Companies – Part 2

February 17, 2020 | R on Redwall Analytics

# Re-load data previously stored for purposes of this blog post
pharma <- 
  fread("~/Desktop/David/Projects/xbrl_investment/data/pharma_inc.csv")

Introduction In A Walk Though of Accessing Financial Statements with XBRL in R - Part 1, we went through the first steps of pulling XBRL data for a single company from Edgar into R. Although an improvement over manual plugging of numbers into a Excel, there is still a way ...

[Read more...]

How Does Stamford Charter School for Excellence do it?

November 1, 2019 | R on Redwall Analytics

Introduction The State of Connecticut is required to test all of its students over the course of their academic careers. The data by year and school is disclosed as it becomes available at the State Department of Education’s Edsight website. In keeping with its explorations of open CT data, ... [Read more...]

Analyzing 500,000 Connecticut Real Estate Sales over 20 Years

October 24, 2019 | R on Redwall Analytics

Under Construction [Read more...]

Replicating Yankee Institute Risk Score Over 15 Years

October 11, 2019 | R on Redwall Analytics

Warning Signs - Part II As mentioned in part I of this series Connecticut City Unfunded Pension and OPEB Liabilities Over Time, we intend to look at the evolution of city financial vulnerability over time. The metric put forth in the Yankee report ... [Read more...]

Connecticut City Unfunded Pension and OPEB Liabilities Over Time

October 10, 2019 | R on Redwall Analytics

Introduction - Part I Earlier this year, Reviewing Fairfield County Municipal Fiscal Indicators Since 2001 looked at data from 17 annual Connecticut Municipal Fiscal Indicators reports to better understand the current financial condition of all 169 towns. Those reports included only began including the net pension liability over the last three years and ...

[Read more...]

IRS Data shows Connecticut Taxpayers Also Pay Higher Federal Taxes

March 6, 2019 | R on Redwall Analytics

Introduction In this post, we will be using the same dataset as our earlier: IRS Data Shows Growth in Number not Income of Highest Earners since 2005. This dataset encompases 2.2 million rows of five brackets for each zip code from 2005-2016. Using actual tax data, we noted that despite the robust ... [Read more...]

A Through the Cycle Geo-Spatial Analysis of CT Town Finances

February 10, 2019 | R on Redwall Analytics

Introduction In an earlier post, Reviewing Fairfield County Municipal Fiscal Indicators Since 2001, we used 17 years of individual Town Comprehensive Annual Financial Reports (CAFR) aggregated in Connecticut’s Municipal Fiscal Indicator’s to compare 15 Fairfield County towns. The challenge was that the graphs became crowded even with that small number of ... [Read more...]

IRS Data Shows Growth in Number not Income of Highest Earners since 2005

January 27, 2019 | R on Redwall Analytics

Introduction In this study, Redwall Analytics looks at 12 years of adjusted gross income data from over 140 million annual tax returns across the US and compare to Connecticut returns over five income brackets. We find a few suprising trends: Despite being the highest income state, mean income of Connecticut’s $100k ...

[Read more...]

Analysis of Connecticut Tax Load by Income Bracket

January 8, 2019 | R on Redwall Analytics

Introduction This brief study finds that Connecticut residents pay $62-63 billion annually in total taxes (including: Federal, State, Municipal Real Estate, Sales, FICA, Medicare) on adjusted gross income of $165-167 billion (an effective tax rate of 37-38%). Some taxes, such as FICA and Medicare, might be considered forms of savings ...

[Read more...]

Reviewing Fairfield County Municipal Fiscal Indicators Since 2001

December 25, 2018 | R on Redwall Analytics

Introduction In recent weeks, we have been exploring the State of Connecticut’s municipal oversight infrastructure. Every year, each of the 169 towns files an audited Comprehensive Annual Report (CAFR) and the state aggregates these into the Municipal Fiscal Indicators report Municipal Fiscal Indicators - Fiscal Years Ended 2012-2017. The report ... [Read more...]

Introduction to Redwall Analytics Nutmeg Open Data Project

December 20, 2018 | R on Redwall Analytics

Introduction Redwall Analytics has spent the last couple of months gathering data from the State of Connecticut’s relatively new “open data initiative”. In recent months, we have made several posts on LinkedIn describing our explorations and looking at the some of the financial challenges faced by our home state: ... [Read more...]

« 1 2

R-bloggers

R news and tutorials contributed by hundreds of R bloggers

Articles by R on Redwall Analytics

Parsing Mass Municipal PDF CAFRs with Tabulizer, pdftools and AWS Textract – Part 1

A Walk Though of Accessing Financial Statements with XBRL in R – Part 1

Tracking R&D spending by 700 Listed US Pharma Companies – Part 2

How Does Stamford Charter School for Excellence do it?

Analyzing 500,000 Connecticut Real Estate Sales over 20 Years

Replicating Yankee Institute Risk Score Over 15 Years

Connecticut City Unfunded Pension and OPEB Liabilities Over Time

IRS Data shows Connecticut Taxpayers Also Pay Higher Federal Taxes

A Through the Cycle Geo-Spatial Analysis of CT Town Finances

IRS Data Shows Growth in Number not Income of Highest Earners since 2005

Analysis of Connecticut Tax Load by Income Bracket

Reviewing Fairfield County Municipal Fiscal Indicators Since 2001

Introduction to Redwall Analytics Nutmeg Open Data Project

Articles by R on Redwall Analytics

Never miss an update! Subscribe to R-bloggers to receive e-mails with the latest R posts. (You will not see this message again.)

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)