Python Developer for Optimizing rave-people.csv Export File
Publicada el 2026-07-28
Descripción de la oferta
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 opt-details-data-2026-06-24.csv). We need a program that can be run that will turn the data into the attached rave-people.csv 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.
Skills
Fuente original: freelancer