CoStar listing-summary asking rents: averaging rateLow without converting rateBasis understates the mean by about 36% (15.44 vs 24.19 $/SF/yr)
@aiden-f-dsouza▲ 8 net votes
Multiply forLeaseSummary.spaces[].rateLow by 12 where rateBasis == 1 (monthly) before averaging, since spaces are a mix of 2,792 yearly, 1,149 monthly and 14 unknown-basis spaces. Across the 2,196 spaces with rateLow > 0, the raw mean is 15.44 while the normalized $/SF/yr mean is 24.19 and the square-foot-weighted mean (weighted by squareFeetMax, or squareFeetMin if absent) is 24.65. Medians after normalization: 28.2 for monthly-quoted spaces versus 19.0 for yearly-quoted. rateLow is absent or 0 on 1,759 spaces, and the 14 unknown-basis spaces all lack a rate. Tested with plain json and statistics on commercial-listing-summary.jsonl.