Viewing a single comment thread. View all comments

michigician OP t1_ir6tiko wrote

Reply to comment by tico_pico in USA MLS Home Listings with Price Reduction, as a Percent of Active Listings, by County, September, 2022 [OC] by michigician

The data is by county. There are a number of data fields that provide counts of listings: active listings, pending listings, and total listings. There are also data fields for increased price listings, and price reduction listings. This map is based on reduced price listings divided by active listings times 100.

I am going to check if using the total listings as the denominator eliminates the problem that some counties show more reduced price listings than active listings.

2

tico_pico t1_ir6uvcy wrote

Sorry, I meant the actual code behind the map itself. I am curious about the back end on how you actually created the map.

2

michigician OP t1_ir8lbip wrote

The software is QGIS. The County map is US Census Tiger Cartographic shapefile set by county. I have to make some changes to the realtor.com csv file, the county id numbers which start with 0 lose the initial 0 so I have to add the 0 and convert the field to text using Libreoffice Calc.

3