Ch 12: merge

[dfolch]

Chapter 12 typo? The default for merge is intersection, but I think the goal here is to keep all the observations. If this is the correct interpretation, then the resulting quantile map would likely need to be updated too since there are so many zeros.

Original

airbnbs_w_counts = airbnbs_albers.merge(poi_count, left_on="id", right_index=True).fillna({"poi_count": 0})

This results in 4601 observations.

Revision

airbnbs_w_counts = airbnbs_albers.merge(poi_count, left_on="id", how='left', right_index=True).fillna({"poi_count": 0})

This results in 6110 observations.