Discussions

Hello,

I have a few questions regarding the Rental Data.

1. When merging the Rental Data with the Listing and Property Mapping by ID, some listings aren't matched, so then a listing doesn't have a UNIT_ID or PROPERTY_ID. What are possible reasons for this?
2. I'd like to merge the data with another dataset both spatially and temporally, so I'm trying to better understand the time variables here. If I want to know how long a unit has been on the market, is it recommended to look at the max and min of DATE_POSTED and take that difference? Or should SCRAPED_TIMESTAMP be incorporated in some way?
3. For some units, the DATE_POSTED variable changes often. For example, it may have two rows for the same unit where one has a DATE_POSTED of April 5, 2018 and the other April 12, 2018. Does this mean the unit was reposted or something changed from the previous posting? I think I'm trying to understand how the DATE_POSTED variable is generated and why it may change in situations that don't appear to be brand new listings.

Thank you, and please let me know if clarification is needed.