Ranking cities by rent to sales price ratio (aka The 1% rule)

For my own investments, I wanted a list of cities with the highest rent to sales price ratio (aka The 1% Rule) as a starting point for research. After some searching, I didn‘t find what I was looking for, so I made it myself! Sharing here to hopefully be useful to the community.

I started by plotting rent prices by city:

Then I plotted sale prices by city:

Then I plotted the ratio of the two:

Listing the top 30 in table format looks like:

If variations of this data would be helpful, let me know. Now that I have all the data downloaded, it is pretty easy to make quick changes and share the results.