GeoRegionValuePlot
Tabular
ConstructColumns
Import

Social Sciences
Structured Data Processing
Finance & Economics
Geography
Data Science
Visualization & Graphics

Visualize Rents Across a Region

Use public data to map fair market rent in the Midwest

Open in Cloud
Download Notebook

Import fair market rent data for 2024 from a government website:

In[1]:=

newdata=Import["https://www.huduser.gov/portal/datasets/fmr/fmr2024/FMR2024_final_revised.xlsx","Tabular"]〚1〛

Out[1]=

This is the source of information for the data source entity Fair Market Rents:

In[2]:=

Fair Market Rents

DATA SOURCE

["NonMissingPropertyAssociation"]

Out[2]=



citation

U.S. Department of Housing and Urban Development,Fair Market Rents,

entity type list



data source

,

name

Fair Market Rents,

organization name

U.S. Department of Housing and Urban Development,

source name

Fair Market Rents,

URL



http://www.huduser.org/portal/datasets/fmr.html



Use the semantic interpreter to assign each county a unique entity:

In[3]:=

Interpreter["AdministrativeDivision"]["Autauga County, AL"]

Out[3]=

Autauga County, Alabama, United States

Select data for a specific region:

In[4]:=

midwestdata=Selectnewdata,MemberQ

US Midwest states

ADMINISTRATIVE DIVISIONS

["StateAbbreviation"],#stusps&

Out[4]=

Assign quantity values for two-bedroom rents in each county:

In[5]:=

newInterpreted=ConstructColumns[midwestdata,{"County"Function[Interpreter["AdministrativeDivision"][#countyname<>", "<>#stusps]],"2BR"Function[Quantity[#"fmr_2","USDollars"/"Months"]]}]//Select[!FailureQ@#County&]

Out[5]=

Visualize the data:

In[6]:=

GeoRegionValuePlot[Rule@@@FromTabular[newInterpreted,"Matrix"],PlotLabel"2024 Fair Market 2BR Rent"]

Out[6]=

Add tooltips for each county:

In[7]:=

GeoRegionValuePlotRule@@@FromTabular[newInterpreted,"Matrix"],



Out[7]=

Source Metadata

Citation: U.S. Department of Housing and Urban Development, Fair Market Rents

Related Symbols

GeoRegionValuePlot
Tabular
ConstructColumns
Import

Publisher Information

Contributed by: John McNally