
In Progress
Posted
Paid on delivery
Need a Python programmer to complete a project. Most of the program is already built. It needs to be completed and optimized to reduce the amount of errors spit out so it can be a repeatable process weekly. Some data is bad data in the database that needs to be cleaned. Attached is the functional Python script that creates 3 files: Rave ready rows Dupes that were eliminated Errors (e.g. signed up for a text message; no phone number) This is an HOA where owner’s register to access private documents. During registration they have the option to opt-in to receive emergency alerts through a company called Rave. The website exports all users and the respective data needed for Rave (See [login to view URL]). We need a program that can be run that will turn the data into the attached [login to view URL] file that will be uploaded to the Rave system to update owner details. The Rave file needs to assign a unique ID to each user which can be the User ID from WordPress, the phone number needs to be in the format of all numbers, no dashes. It is mandatory that all Rave users have a First Name, Last Name, Unique ID, and Unique email address. Phone number is not mandatory but helpful to be able to receive text alerts. There are a couple of hiccups - There are duplicate records for quite a few homeowners due to owners having the capability of having multiple people in the household having a login. Then those people may have listed their significant other as a member under their account. The example below would not be too difficult since they are only two records, so the household member would not need to go to Rave, only the Primary member. - Some owners own multiple properties but only need one login to Rave. - There are household members under primary owners that do not have phone numbers or email addresses. Owners without email address would not need to be included in the rave-people file as we do not want to make up bogus email address for owners. - Where there is only one user, we need to assign a unique ID to the household member that must always be the same ID with each run of the program to convert the file. For example, Teriann would need a unique ID assign that stays the same all the time. - Some users are where there is erroneous data in the database that needs to be cleaned up.
Project ID: 40611321
187 proposals
Remote project
Active 5 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
187 freelancers are bidding on average $138 USD for this job

Hello, As an adept Python Developer with a strong background in JavaScript and PHP, I feel confident that I'm not just perfectly qualified but also the best fit for your project. Throughout my tenure in Software development at Our Software, we've always impressed clients with our ability to deliver functional solutions within strict deadlines, and I'm sure I can replicate the same success for your HOA project. Considering the complexity of your database which includes duplicate records, erroneous data, multiple properties under single logins among others, my keen eye for details comes in handy as it ensures all loopholes are identified and fully addressed. To optimize your project's existing Python script and render it a repeatable process with minimal errors, I propose implementing robust data cleaning methods right from the beginning. By detecting and sanitizing bad data upfront, we can ensure a more efficient and reliable output, thereby minimizing possible errors on rave-people.csv. Additionally, my expertise in maximizing the capabilities of programming languages most especially in Python guarantees a solution capable of handling multifaceted scenarios such as the ones described in your project description. In summary, by entrusting me with your project, you're not just contracting a developer but a committed problem solver who will go above and beyond to make sure the final product meets every single one of your specifications and necessities. Thanks!
$180 USD in 2 days
8.6
8.6

HI there i have checked Attachments both file and project details job is clear so please contact me, thank you
$50 USD in 1 day
8.6
8.6

Hi there, I can see the hidden pain point here: the export is less about generating a CSV and more about making the weekly run trustworthy despite messy household data. I’ve worked on Python data-cleaning and repeatable export scripts, and I can tighten your existing program so it consistently produces the Rave-ready file, dupe report, and error report with cleaner rules for primary users, household members, and missing contact data. I’ll focus on stable unique IDs, phone normalization, duplicate handling across multiple properties, and cleaning bad database values without inventing email addresses. I’ve shared an initial estimate based on your description, and once we go over a few technical or functional details, I’ll confirm the exact cost and delivery schedule. Please send the current script and a sample of the CSV outputs so I can map the rules precisely; How do you want me to resolve cases where one homeowner has multiple logins but only one should be treated as the primary Rave record? Looking forward to your reply so we can finalize the exact plan. Best regards, Asad
$75 USD in 3 days
8.2
8.2

Hi, I can help you enhance the existing script to address the issues with duplicates and missing data fields. By implementing data validation for email addresses and structuring unique IDs, we can streamline the export of your users for Rave. This will improve the accuracy of the data output and reduce errors. With over 5 years of experience in Python development, I’ve dealt with similar data optimization tasks. I’m confident I can improve your process significantly. Let’s connect on Zoom to discuss this further and get you set up for success! Best Regards, Priyanka
$140 USD in 2 days
8.4
8.4

SURELY, I CAN START IMMEDIATELY I have developed and optimized Python data-processing scripts for CSV imports, data cleansing, duplicate detection, and repeatable ETL workflows. I can complete your existing script, implement stable unique ID generation, clean inconsistent data, handle duplicate households and multi-property owners correctly, and ensure the process produces reliable Rave-ready files every week with clear error reporting. I will share similar Python data automation projects in chat. Thanks!! Parminder
$240 USD in 7 days
8.2
8.2

Hi, I have strong experience with **Python, data processing, CSV automation, and data cleansing**, and I can complete and optimize your existing script to produce reliable, repeatable weekly exports for the Rave system. I'll refine the duplicate-detection logic, implement consistent unique ID generation, clean and validate invalid records, normalize phone numbers, handle multiple-property and household-member scenarios correctly, and minimize errors while maintaining detailed output reports for duplicates and exceptions. The final solution will be well-documented, easy to run, and designed to generate consistent results every time. I'm ready to review your current script and sample data immediately and deliver a stable, production-ready solution. **Best regards,** **Muhammad Rizwan LA**
$100 USD in 2 days
8.2
8.2

Hi! This is something we can definitely handle. One thing that would help before I put together a proper scope: is the source data always that same WordPress export format, or does it vary depending on who runs it? That changes how defensive the cleaning logic needs to be. From what I can see, the core work is tightening the deduplication rules, making the unique ID assignment stable across runs, and filtering out records that shouldn't make it to Rave. We'd clean it up in Python so it runs cleanly every week without babysitting. Happy to dig into the script you already have and pick up from there. Gustavo & the DoTheCode team
$150 USD in 2 days
7.9
7.9

Hi, The core of this is deduplication logic and stable ID assignment, which is exactly the kind of data processing I do in Python. On Upwork I handled a DevOps and Python integration workflow that ran on a repeatable schedule and turned messy inputs into a reliable output, rated 5 stars. One thing I'd pin down first: for the single household member who needs a permanent stable ID, do you want that derived from the WordPress User ID, or a deterministic hash of email or name so it never shifts between weekly runs? That choice drives how I handle owners who lack a WordPress login. I'd start with a milestone on a cleaned, error-reduced export from your sample file so you only pay on a working run. Adil
$147.86 USD in 7 days
7.5
7.5

Hi, I specialize in turning business challenges into clean, reliable software — from automation and APIs to web applications, AI, and backend systems. What sets me apart: I focus on outcomes, not just deliverables. Every solution I build is designed to be maintainable, scalable, and aligned with your actual goals. Let's build something great together. Thanks, Deva
$200 USD in 3 days
7.8
7.8

Hello, Your project is a great fit for our backend automation expertise. At Doomshell Software Pvt Ltd, we have experience developing and optimizing Python-based data processing solutions that deliver reliable, repeatable results. We can help you: • Review and optimize your existing Python script • Improve data validation and minimize processing errors • Clean duplicate and inconsistent records • Implement stable unique ID generation for repeatable weekly runs • Format and transform WordPress export data into the required Rave CSV structure • Generate clear reports for duplicates and errors • Improve performance, maintainability, and documentation Our focus is to deliver a robust solution that automates the workflow while ensuring accurate, clean data for every import. A few questions: Which Python version is the current script using? Approximately how many records are processed each week? Should the unique ID mapping be stored in a local file or database? Best regards,
$140 USD in 7 days
7.4
7.4

HELLO, I have reviewed your requirements and understand that you need to optimize and complete an existing Python data processing script for generating a clean, repeatable Rave import file from HOA user registration data. With 10+ years of experience in Python development, data cleaning, automation, CSV processing, and database-related workflows, I can improve the existing script, reduce errors, handle duplicate records, and create a reliable weekly processing system. WORKING FLOW → Data Analysis → Review existing Python script and source CSV structure. Data Cleaning → Handle missing data, duplicate households, multiple properties, invalid records, and formatting issues. Optimization → Improve processing logic, ID assignment consistency, validation, and error handling. Final Output → Generate accurate Rave-ready CSV, duplicate reports, error logs, and provide documented workflow. I follow Agile methodology, provide COMPLETE SOURCE CODE, 2 YEARS OF FREE ONGOING SUPPORT, and assist from development to final deployment. I eagerly await your positive response. Thanks.
$140 USD in 7 days
7.6
7.6

Hi There! I specialize in Python data automation with 9+ years of experience building reliable CSV processing scripts, data cleansing workflows, and repeatable import/export pipelines. Here’s how I can help: 1. Optimize your Python script for consistent weekly Rave CSV generation. 2. Clean duplicate and invalid records while preserving stable unique IDs. 3. Improve validation, error reporting, and output accuracy with maintainable code. Can you share the current Python script so I can review the existing logic and optimize it efficiently?
$140 USD in 7 days
6.9
6.9

Hi there, I have read and check attachment , I am python hub ,i able to finish in 30 to 40 hours will be finish the project the an documentation , Thank you
$235 USD in 2 days
7.0
7.0

Hi! My name is Marjan and I'm here to offer you my services as a skilled applicant with over a decade of experience working on Freelancer.com. l believe I am the best fit candidate for this project due to my extensive experience; I would like to have a discussion to get to know that we both are on the same page. Once the scope will be locked, I will start working on it right away.
$140 USD in 7 days
6.8
6.8

Hi, I can do it, I can optimize the crawler as I have done several crawlers related task, having 10+years of experience in Python. please ping me to discuss in detail and lets get started. regards, Shalu
$183 USD in 6 days
6.9
6.9

Hi there, I understand you're looking to complete and optimize your existing Python automation so it can reliably transform your HOA registration export into a clean, Rave-ready import file with consistent results every week. With experience in Python, data processing, data cleansing, and automation, I am confident I can refine the existing script to minimize errors, handle duplicate and inconsistent records, and produce accurate, repeatable outputs. My approach is to first review the current script and data flow, identify the causes of recurring errors, and optimize the processing logic while preserving the existing workflow. I'll implement robust duplicate resolution for households and multiple-property owners, normalize phone numbers, validate mandatory fields, generate stable unique IDs for records without WordPress IDs, and build configurable data-cleaning rules for known database inconsistencies. The solution will produce the three required outputs (Rave-ready records, duplicate report, and error report), include comprehensive validation, improved logging, and well-commented code so the weekly process remains reliable and easy to maintain. Could you clarify how household members should be identified when assigning stable unique IDs; do you have an existing field that uniquely identifies them, or should the script generate and persist these IDs in a local mapping file for future runs? I'm ready to start immediately. Warm Regards, Aneesa.
$100 USD in 2 days
7.0
7.0

Hello, I'll complete and optimize your Python script to clean HOA registration data and generate clean Rave files weekly. I'll deduplicate household members keeping only primary owners, consolidate multiple properties under single logins, filter out records missing required fields like email or phone, and assign stable unique IDs to household members that persist across runs. I'll also build error handling to catch bad database entries and separate them into clear reports so you can review and fix issues manually. The script will output your three files reliably each week with minimal errors. What's your preferred method for identifying primary owners versus household members registration order, a specific database field, or account type flag? Let's discuss in chat as I have some queries to ask regarding the project to proceed further. ~ Joya
$140 USD in 7 days
7.1
7.1

As an experienced Python developer, I have a passion for optimizing and improving existing codes. Over the years, I have developed a keen ability to identify bugs and inefficiencies in codes through effective debugging and clean code writing. Your project is no exception, and I am confident that I can deliver a refined solution that will significantly reduce errors, making it a repeatable process. My extensive experience with database management is particularly relevant to your project's needs. I understand the importance of data integrity and how it directly affects the output for systems like Rave. With my knowledge, we'll be able to tackle the various hiccups you've mentioned efficiently - from eliminating duplicates to dealing with erroneous data and assigning unique IDs. In addition, my skill set extends beyond just python; as a full-stack developer well-versed in web development (Python, Django), mobile apps (Python), and cloud (AWS), I bring a holistic approach to projects. This means that not only will I optimize your existing script but also ensure its seamless integration with your WordPress website holding user data. With me onboard, you can rest assured about the reliability, performance, and maintainability of your solution. Looking forward to discussing more details about your project!
$30 USD in 7 days
7.1
7.1

Hello! I noticed the current solution is written in Python, but I would recommend implementing it in **PHP**. I have 15+ years of PHP development experience, and this type of CSV processing, data validation, duplicate detection, and report generation is a perfect fit for PHP. I can build a reliable script that cleans the data, handles duplicate households and multiple properties, generates stable unique IDs, produces all required output files, and can be run every week with consistent results.
$250 USD in 7 days
6.7
6.7

Hello. This is IntelliForge from Fabbrico, Italy. For handling duplicate household members, how do you want the program to prioritize which user is considered the “Primary” member? That decision shapes the deduplication logic and unique ID assignment. - Data Cleaning & Validation: I will enhance the existing Python script to identify and clean bad data entries, ensuring only valid users with mandatory fields (First Name, Last Name, Unique ID, email) are included. This reduces errors and improves repeatability. - Deduplication Logic: I will implement a robust household-level deduplication that keeps only primary members for Rave export, handling multiple properties and linked household members without phone/email as per your rules. - Stable Unique ID Assignment: I will ensure each user’s unique ID remains consistent across runs by using a reliable key (e.g., WordPress User ID) and storing mappings if needed. - Phone Number Formatting & Export: Phone numbers will be normalized to digits-only format, and the final CSV will meet Rave’s requirements for upload. Do you have a preferred method or existing mapping for identifying primary household members? Also, should the script generate logs or reports for errors and duplicates for your review? Let’s connect to clarify these points and get your export process running smoothly and reliably every week. Looking forward to working together!
$140 USD in 2 days
6.5
6.5

North Myrtle Beach, United States
Payment method verified
Member since Aug 20, 2007
$30-5000 USD
$30-100 USD
$30-5000 USD
$30-5000 USD
$30-5000 USD
₹750-1250 INR / hour
₹1500-12500 INR
$10-30 USD
€60 EUR
₹12500-37500 INR
€30-250 EUR
$750-1500 USD
$30-250 USD
$250-750 USD
$2-8 USD / hour
£20-250 GBP
₹12500-37500 INR
$2-8 USD / hour
₹12500-37500 INR
₹12500-37500 INR
$10-30 USD
$1000-1200 USD
$250-750 USD
$30-250 USD
€60 EUR