To generate the report, first download the cleaned 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(“classonefinal.csv”)

df <- df %>% mutate(SALE_YEAR = ifelse(!is.na(SALE_PRICE), YEAR, NA), TAX_YEAR = YEAR, ASSESSED_VALUE = AVTOT, MARKET_VALUE = FULLVAL)

df <- df %>% mutate_at(c(“ASSESSED_VALUE”, “SALE_PRICE”, “MARKET_VALUE”), as.numeric)

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

cmfproperty::make_report(ratios, jurisdiction_name = “New York City”, output_dir = “your output directory”) 

Below is a pre-generated example report:

Report