Scrape & Deduplicate Contact Records
Budget: $30 – $250 AUD
I need a clean, ready-to-use Excel spreadsheet of locksmith contacts gathered from these two public directories:
• https://masterlocksmiths.com.au/directory
• https://www.lga.org.au/map
There are roughly 2,000 listings between the two sites. Please capture every available record, then merge the data so that any entries sharing the same email address are treated as duplicates and removed.
Columns required in the final file: Name, Address, Email, Phone Number—nothing more and nothing less. The finished spreadsheet should open smoothly in Excel with consistent formatting and no blank rows or stray characters.
A quick scrape with Python (BeautifulSoup, Scrapy, or similar), followed by a solid dedupe pass in Pandas or your preferred toolset, is fine by me as long as the end result is accurate.
Deliverable
• One Excel (.xlsx) file containing the fully deduplicated list of contacts.
I’ll spot-check the sheet against the live sites, so completeness and the email-based deduplication rule are the key acceptance criteria. Let me know if anything on the sites looks ambiguous before you start, otherwise I’m ready for your first draft.
• https://masterlocksmiths.com.au/directory
• https://www.lga.org.au/map
There are roughly 2,000 listings between the two sites. Please capture every available record, then merge the data so that any entries sharing the same email address are treated as duplicates and removed.
Columns required in the final file: Name, Address, Email, Phone Number—nothing more and nothing less. The finished spreadsheet should open smoothly in Excel with consistent formatting and no blank rows or stray characters.
A quick scrape with Python (BeautifulSoup, Scrapy, or similar), followed by a solid dedupe pass in Pandas or your preferred toolset, is fine by me as long as the end result is accurate.
Deliverable
• One Excel (.xlsx) file containing the fully deduplicated list of contacts.
I’ll spot-check the sheet against the live sites, so completeness and the email-based deduplication rule are the key acceptance criteria. Let me know if anything on the sites looks ambiguous before you start, otherwise I’m ready for your first draft.