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(“merged.csv”)

df <- df %>% mutate(SALE_YEAR = RollYear, ASSESSED_VALUE = netTaxableValue, SALE_PRICE = TotalLandImpValue)

df <- df %>% mutate_at(c(‘ASSESSED_VALUE’, ‘SALE_PRICE’, ‘SALE_YEAR’), as.numeric)

df <- df[c(‘SALE_PRICE’, ‘SALE_YEAR’, ‘TAX_YEAR’, ASSESSED_VALUE’)]

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

cmfproperty::make_report(ratios, jurisdiction_name = “Los Angeles County”, output_dir = “your output directory”) 

Below is a pre-generated example report:

Report