
In Progress
Posted
Paid on delivery
Build Python System to Combine Multiple Datasets, Calculate Distance & Manage Outreach Database (Simple One-Click Use) --- ### Description I am looking for a developer to build a **reusable data pipeline (Python preferred)** that combines multiple spreadsheets of UK businesses, calculates distance from my location, and outputs a clean master database for outreach. This will be used for **email marketing and in-person visits**, so distance and data quality are critical. **Important:** I am not technical and do NOT want to learn Python. The final system must be extremely simple to run (see “Ease of Use” section below). --- ### Core Requirements #### 1. Data Integration * Import multiple Excel/CSV files * Initial datasets include: * Rightmove estate agents * Property Ombudsman * Propertymark * System must support adding more datasets later (e.g. solicitors, surveyors, engineers, etc.) --- #### 2. Standardisation * Standardise fields such as: * Name * Address * Postcode * Email * Phone * Source * Category / Subcategory --- #### 3. Distance Calculation * Convert postcode to coordinates * Calculate distance from: * MK44 1EY * Output: * Distance_Miles * Closest_Distance * Within_Radius (adjustable: 30 / 50 / 70 / 100 miles) --- #### 4. Duplicate Detection * Identify duplicates across datasets * Based on: * name * postcode * address * domain * Do NOT blindly delete duplicates * Either merge or flag them * Preserve source information --- #### 5. Email Workflow **Bounce Handling** * Import CSV from Constant Contact * Match to records * Flag: * Bounced * Needs_New_Email **Unsubscribe Handling** * Import unsubscribe CSV * Flag: * Unsubscribed * Do_Not_Email * These must be excluded from outreach but NOT deleted --- #### 6. Manual Enrichment * System must allow: * adding new leads (e.g. from Google Maps) * importing enrichment data (e.g. [login to view URL] exports) Important: External data must NOT overwrite existing data automatically. Updates must be controlled and reviewed. --- #### 7. Output Final output: [login to view URL] Must support filtering by: * distance (nearest first) * category * source * bounce/unsubscribe status * duplicate flag --- #### 8. Reusability This must NOT be a one-off script. It must: * accept new input files * be rerun easily * update the master database * scale over time --- ### Ease of Use (CRITICAL REQUIREMENT) I do NOT want to interact with Python or use command line tools. The system must be delivered so that I can: 1. Drop files into an “Input” folder 2. Click a single file (e.g. “Run System”) 3. Receive an updated Excel file in an “Output” folder Acceptable formats: * A clickable `.exe` file * OR a simple double-click run file (.bat or similar) The process must feel like using normal software. --- ### Deliverables * Working system (Python-based or equivalent) * One-click run method (as described above) * Example output file * Input/output folder structure * Clear, simple instructions (non-technical) * Explanation of duplicate logic --- ### Nice to Have (Optional) * Fuzzy matching for duplicates * Coverage analysis (identify gaps) * Map view or basic visualisation --- ### Summary I need a system that allows me to: * combine multiple industry datasets * see who is closest to me * focus on realistic travel distance * manage bad emails and unsubscribes * continuously improve my database over time --- ### Please Include in Proposal * Similar work you’ve done * Your proposed approach * Estimated timeframe * How you will make this easy for a non-technical user to run
Project ID: 40387588
33 proposals
Remote project
Active 16 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hello, I have previously built Python-based data pipelines that merge multiple datasets, clean and standardise records, and enrich them with geolocation data for distance-based filtering. I have also implemented deduplication logic and outreach database management workflows for marketing use cases. For your project, I can deliver a fully automated, one-click system that: #Combines multiple Excel/CSV datasets into a single structured database #Standardises fields (name, address, postcode, email, phone, category, source) #Converts UK postcodes to coordinates using Ordnance Survey or [login to view URL] #Calculates distance from MK44 1EY and flags radius ranges (30/50/70/100 miles) #Implements smart duplicate detection (exact + fuzzy matching) with merge/flag logic #Processes email bounces and unsubscribes without deleting records #Supports manual enrichment without overwriting existing verified data The system will be packaged as a simple executable: *Drop files into an Input folder *Double-click “Run System” *Receive a clean [login to view URL] in Output I will also include clear instructions and ensure the system is reusable and scalable as you add more datasets over time. Let’s connect, and I can walk you through a quick prototype using sample data. Best regards, KBarbarius
£30 GBP in 3 days
4.7
4.7
33 freelancers are bidding on average £61 GBP for this job

Hello, I have thoroughly reviewed the project requirements for building a Python Data Aggregation & Distance Calculation Tool. I understand the need for a reusable data pipeline that combines multiple datasets, calculates distances, and manages an outreach database efficiently. Let's chat and discuss it further. To handle your project, I will start with developing a Python-based system that integrates multiple Excel/CSV files, standardizes fields, calculates distances from a specified location, detects and handles duplicates, manages email workflows, allows manual enrichment, and generates a master database with filtering capabilities. My approach involves using Python libraries such as Pandas for data manipulation, Geopy for distance calculations, and Tkinter for creating a user-friendly interface. The deliverables for this project will include a fully functional system, a one-click run method, an example output file, folder structure, clear instructions, and an explanation of duplicate logic. Before signing-off my bid, I would like to ask a question, i.e., how often do you anticipate updating the datasets for this tool? Best Regards, Aneesa.
£30 GBP in 1 day
6.9
6.9

As a full-stack developer with extensive experience in software architecture and web scraping, I am confident that I can deliver a high-quality solution for your Python data aggregation and distance calculation tool project. Throughout my 6-year career, I've built numerous custom solutions including CRMs similar to what you're describing, bringing together diverse datasets and streamlining databases. My expertise is not limited to Python; I can also utilize my strong skills in PHP and Laravel to ensure smooth data integration and thorough cleansing processes. Additionally, React JS, HTML5, and CSS3 will ensure an intuitive, user-friendly frontend for your "non-technical" requirement. I'm also experienced in utilizing databases like MySQL and SQLite effectively. Overall, my technical proficiency combined with my commitment to clean code practices makes me a reliable choice for this project. My turnaround time is prompt, progress updates are regular, and I provide reliable post-launch support. Let's discuss in detail how I can tailor this application precisely to your needs for better management of bad emails or unsubscribes and the continuous improvement of your outreach database over time.
£30 GBP in 1 day
5.9
5.9

Hello sir, Did go through your job description and glad to share that I have enormous experience in working with Python Data Aggregation & Distance Calculation Tool I'm a seasoned programmer and Engineer with quality experience in Flutter, React, Node.JS, SpringBoot, Frontend and Backend Development, Python, Matlab, R studio, C, C++, C#, OpenCV, OpenGL, Tesseract OCR, google vision, Statistical programming/R progamming data analysis Computing for Data Analysis Time Series & Econometric, Machine learning, AI, Deep learning, Matlab and Mathematica, 3D modeling, CAD/CAM,AutoCAD, 2D, Architectural Engineering, SolidWorks, Unity 3D, PCB, Electronics, Arduino, Automation, Embedded and Firmware , IOT, Electrical/Mechanical Engineering I am a TOP Rated Freelancer, and you can check my reviews here as well: https://www.freelancer.com/u/mzdesmag. Looking forward to potentially working together on this project. Thanks and Best regards, Adekunle.
£33 GBP in 1 day
5.6
5.6

Hey! I have gone through your description. I have experience in Python automation, data processing, Excel systems, and building reusable business databases. I have strong command on Python, pandas, Excel VBA, CSV/Excel integration, geolocation APIs, and automation tools for creating one-click desktop solutions. I can build you a complete reusable system that combines multiple datasets, standardizes records, calculates distance from MK44 1EY, detects and flags duplicates, manages bounced/unsubscribed contacts, supports manual enrichment, and generates a clean master outreach database in Excel. The system will be designed for long-term use and easy scaling with future datasets. Most importantly, I understand you need a non-technical solution. I will deliver it with a simple one-click run method (.exe or double-click file), where you only place files in the Input folder and receive the updated master database in the Output folder. No Python knowledge or command line use required. I can also include optional features like fuzzy duplicate matching, coverage analysis, and map-based insights. I will provide clear instructions, sample outputs, and full explanation of the duplicate logic. I can provide you with quality work that meets all your requirements with full accuracy and on time. Looking forward to see your interest. Thank-you.
£35 GBP in 1 day
5.2
5.2

Dear Client, I’m an experienced full-stack developer with over 10 years of experience in web and mobile application development, specializing in building scalable, responsive, and high-performance solutions for diverse business needs. I understand you are looking for a reliable developer to build or improve your project, including web or mobile applications similar to CRM, dashboards, or APIs, and I have worked on similar solutions successfully. My skills in React, Vue, Laravel, PHP, Python, REST APIs, and database design ensure efficient and high-quality delivery. Feel free to share more details or ask questions. I’m ready to refine my approach to match your exact requirements. Looking forward to working with you. Best regards, Md Ruhul Ajom
£45 GBP in 3 days
5.0
5.0

I am a Python developer with strong experience in data aggregation, cleaning, and building efficient data pipelines. I can combine multiple datasets while ensuring accuracy and removing duplicates to create a reliable master database. For distance calculations, I use geocoding and proximity logic to identify nearby businesses within a defined radius. I also handle email validation, unsubscribe tracking, and bounce filtering to support smooth outreach workflows. To keep things simple for you, I will deliver a user-friendly application with a drag-and-drop interface, eliminating the need for command-line use. The system will be scalable, easy to update, and designed for long-term use. I can complete this within 2–3 weeks and provide ongoing support as needed.
£33 GBP in 7 days
4.5
4.5

As a highly skilled and experienced data analyst with a specialization in Python, I am uniquely qualified to take on your project. Throughout my 6+ year career, I've successfully completed over 850 complex projects, many of which included data aggregation and distance calculations - similar to what you are seeking. I possess a thorough understanding of tools such as Pandas, Numpy, and Geopy that are essential for providing clean, quality data outputs. With regard to usability, rest assured that you will not be required to learn any Python or use command line tools. Instead, I envision a solution for you that makes the process merely dropping files into an "Input" folder and clicking a single file (e.g. “Run System”), after which you'll receive an updated Excel file in the located “Output” folder - as simple as using normal software. This would be either delivered as a clickable `.exe` file or a double-click run file (such as .bat) for ease of administration. I pride myself on delivering projects with ultimate ease-of-use and 100% satisfaction. Let's discuss your project's specific timeframe and budget further to develop an effective solution that ensures accurate distance calculation, simplified data management, and unerring duplicate detection while empowering you with greater efficiency in your outreach programs.
£66 GBP in 2 days
3.9
3.9

Hello, I have extensive experience with Python data pipelines, pandas for Excel/CSV processing, and geolocation libraries for distance calculations. I've built similar data integration systems that merge multiple spreadsheets, deduplicate records, and output clean master databases. For your outreach system, I'd create a simple one-click executable that handles all the technical complexity behind the scenes, requiring zero Python knowledge from you. I could implement automatic postcode-to-distance calculation using UK geocoding APIs. Let's discuss!
£50 GBP in 1 day
3.7
3.7

Hello there, I hope you’re doing well. I’ve read your project Python Data Aggregation & Distance Calculation Tool, and I’m confident I can deliver exactly what you need. I bring over 7 years of hands-on experience working with Excel, Data Processing, Web Scraping, and I have also completed similar projects with great results recently. You can expect timely delivery, clear communication, and work until you’re 100% satisfied. I have already started working on your project. Please award me and let me know if you have any other requirements. Best regards, Ismail
£30 GBP in 2 days
2.5
2.5

Combining estate agent datasets and calculating the exact distance from MK44 1EY while keeping the tech completely invisible to you is exactly what I do. Your idea to use a simple input folder and a one click executable is the perfect way to handle this without any friction. Ill build the Python pipeline to grab your CSV files, standardize the messy fields, and calculate the miles using a reliable geocoding method. Then ill package the entire script into a standalone runnable file just like I did for a recent Windows desktop tool I built. You just drop your Rightmove and Constant Contact files into the folder, click the app, and grab your clean master Excel sheet with all duplicates and bounces flagged. Ill also set up the exact folder structure for you out of the box along with a quick text setup guide. If you need any tweaks or related work down the line I can handle that too so you dont have to go through the hiring process again. Drop me a message and we can get this rolling.
£30 GBP in 1 day
2.3
2.3

the tricky part with combining multiple datasets is usually the key matching when column names dont line up. id use pandas for the merge logic, geopy or haversine for the distance calc, and sqlite for the outreach db so you can query and track contacts without touching excel every time. can start today and have a working version ready by tomorrow evening. what formats are your input files in, csv or excel? and roughly how many records are we talking?
£35 GBP in 3 days
1.9
1.9

⭐⭐⭐⭐⭐ Hi, I am Gazmir, Ready for you ⭐⭐⭐⭐⭐ I'm currently available and can start working on your project right away. I will build a packaged Python-based data pipeline that automatically merges your spreadsheets, standardises business records, calculates distance from MK44 1EY using geocoding, handles deduplication with safe merge/flag logic, and generates a clean filtered Excel master database, all wrapped in a one-click executable so you can simply drop files into an input folder and run it without any technical steps. I’m confident I can deliver it on time and within your budget. Looking forward to the opportunity! Warm regards, Gazmir
£30 GBP in 3 days
1.6
1.6

Hi, I’ve reviewed your project and I can build this as a fully automated Python-based data pipeline with a simple one-click interface for non-technical use. I’ve worked on similar data aggregation and enrichment systems involving Excel/CSV processing, deduplication logic, geocoding (postcode → coordinates), and distance-based ranking for outreach databases. Approach: Python (Pandas + Geopy + Fuzzy matching) with a packaged executable (PyInstaller) so you can run it via a single “Run System” file without needing Python or command line. Input/output folder automation will handle everything. Timeline: 3–5 days Delivery: One-click tool + structured Excel output + clear setup guide I can also include duplicate detection logic, bounce/unsubscribe handling, and scalable dataset support as requested. Ready to start immediately.
£33 GBP in 7 days
1.0
1.0

Hey , I just went through the project description, and I see you are looking for someone experienced in Data Engineer, Data Processing, Web Scraping, Data Analysis, Software Architecture, Database Programming, Python, Excel, Database Development and Data Integration. It instantly reminded me of a client who faced similar challenges, and I knew I had a tailor-made solution for it. Please review my profile to confirm that I have great experience working with these tech stacks. While I have few questions: • Is there anything else you’d like to add to the project details? • What’s the top hurdle you’re facing with this project? • What is the timeline to get this done? Why Choose Me? 250+ Projects. 5 Years. Zero Misses. My reputation is built on a single metric: Flawless Execution. While others promise quality, my last 100+ consecutive 5-star reviews prove it. I don’t just finish the job; I set the standard. Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) The portfolio here is just the tip of the iceberg. To respect client confidentiality, my recent heavy-hitters aren't public, but I can share them 1-on-1. Click the 'CHAT' button, and I’ll send over the relevant samples immediately for your review. Regards, Abdul Haseeb Siddiqui.
£30 GBP in 4 days
3.2
3.2

Hi there, THE CHALLENGE is to develop a Python-based data aggregation and distance calculation tool that seamlessly integrates multiple datasets, standardizes fields, calculates distances accurately, detects and manages duplicates, handles email workflows efficiently, enables manual enrichment, and provides user-friendly output functionalities. One of the key technical challenges will be ensuring the system's reusability and scalability over time, allowing for easy updates and additions of new datasets without compromising data integrity. To address this, I will implement a modular and flexible architecture that can adapt to evolving requirements, while also prioritizing a simple one-click execution method for non-technical users to interact with the system effortlessly. Regards, Matheus
£33 GBP in 7 days
0.6
0.6

Hello, I understand the task and will ensure your expectations are me. I am an experienced freelancer with 4 years of experience in Python, Software Architecture. See my profile for recent work. Please connect in chat so we can discuss. Warm regards, Syeda Tahreem
£30 GBP in 7 days
0.0
0.0

Bedford, United Kingdom
Payment method verified
Member since Feb 4, 2019
$10 USD
£50-55 GBP
$10-30 USD
£20 GBP
£20-25 GBP
₹37500-75000 INR
₹12500-37500 INR
₹750-1250 INR / hour
₹12500-37500 INR
$10-30 USD
$30-250 USD
$30-250 USD
$8-15 CAD / hour
₹750-1250 INR / hour
$10-30 USD
$15-25 USD / hour
₹1500-12500 INR
£250-750 GBP
€12-18 EUR / hour
$30-250 USD
$15-25 USD / hour
₹750-1250 INR / hour
$10-200 USD
£2-5 GBP / hour
$250-750 USD