To generate the report, first Download 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(readstata13)
library(cmfproperty)

df <- read.dta13(“Miami_Merge_Final_Sales.dta”)

df <- df %>% select(parcel_id, file_t, asmnt_yr, jv, jv2, lnd_sqfoot, eff_yr_blt, sale_prc1, sale_yr1, census_bk, year)

df <- df %>% rename(SALE_PRICE = sale_prc1, SALE_YEAR = sale_yr1, TAX_YEAR = year, ASSESSED_VALUE = jv2)

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 = “Miami City”, output_dir = “your output directory”) 

Below is a pre-generated example report:

Report