How to Deduplicate Property Owner Records Across Multiple Lead Lists with Python and pandas

All names, addresses and IDs in the examples are fictional. Why the same owner shows up on more than one lead list Real estate teams often pull several lead lists for the same area: an absentee owner