Property Tax Fairness
From the Center for Municipal Finance

To generate the report, first download the data. This dataset is a cleaned public dataset we can use.

After downloading the dataset, please run the below R code, for example in RStudio. Remember to replace your output directory” with the path where you want to save the generated report.

library(tidyverse)
library(data.table)
library(cmfproperty)

df <- fread( “final-PHiladelphia.csv”)

df <- df %>% mutate(SALE_YEAR = sale_year, TAX_YEAR = year_assessed, ASSESSED_VALUE = assmt_at_sale, SALE_PRICE = sale_price, RATIO = ASSESSED_VALUE / SALE_PRICE)

ratios <- cmfproperty::reformat_data(dfsale_col = “SALE_PRICE”assessment_col = “ASSESSED_VALUE”sale_year_col = “SALE_YEAR”)

cmfproperty::make_report(ratiosjurisdiction_name = “Philadelphia County”output_dir = your output directory”) 

Below is a pre-generated example report:

Report