statsnp
statsnp OP t1_j986ed2 wrote
Reply to comment by Crank810 in [OC] Median 1 Bedroom Apartment Rent And Per Capita Income For US Cities by statsnp
Median Income Data only exists for Median Household income (at least reliable data I could find). So because I assumed one person would live in a one bedroom apartment, and median household income often represents more than one earning resident I chose Average Income to estimate the income per one person.
In the future I may investigate using median household then normalize by the number of workers per household. This might be more representative of a median income, but requires more statistical analysis.
statsnp OP t1_j953yu3 wrote
This is a Tableau visualization showing Median 1 Bedroom, 1 Bathroom prices and Per Capita Income for the 25 most populous cities in the United States.The Apartment Prices were scraped from Jan 23-25, 2023 Zumper 1 Bed, 1 Bath Apartment Listings (See code), and Per Capita Income were taken from: https://www.statista.com/statistics/205618/per-capita-income-in-the-top-20-most-populated-cities-in-the-us/ .
It should be noted that the apartment data is from January 2023 while the Per Capita Income was calculated using 2020 U.S. Census data (which is the most recent comprehensive US income public data). It should also be noted that the Per Capita Incomes represents the average income earned per person in a geographical region, and serves only as an estimate for the average income for residents.
The complete Web Scraping, Data Analysis and Tableau code can be found in the Github Repo: https://github.com/jrongtt/ApartmentDashboardFor those interested, I also created a Tableau dashboard that includes a geographic heat map of the median apartment prices: https://jrongtt.github.io/tab.html .
Submitted by statsnp t3_1165grn in dataisbeautiful
statsnp t1_j94rsng wrote
Reply to comment by ls65536 in [OC] SailNavSim boat positions density heatmap by ls65536
great visualization, and cool website! I had never heard of a sailing navigation simulator.
statsnp OP t1_j98o205 wrote
Reply to comment by PredictorX1 in [OC] Median 1 Bedroom Apartment Rent And Per Capita Income For US Cities by statsnp
This, is a good idea! I think I'll make one