Find Jobs
Hire Freelancers

Data Scientist to append databases

$250-750 USD

Cerrado
Publicado hace 5 meses

$250-750 USD

Pagado a la entrega
I have files that I need to cross append. I need someone with MySQL database that can join databases to fill in data values. where there are currently NULL VALUES There are data records that do not have the 2 letter State abbreviation. If the record has a zip code then you can use the zip code enterprise file that I will give you to see what the State is as that file has the City, County, and State for every zip code. Some of the data is missing zip codes, but there are many records of the SAME NAME at the same postal address where one record has a zip code and another record does not. So can we fill in null zip code fields using exact matches with other records in the same database. THEN if the data records still does not have a zip code BUT has the CITY and STATE can we then use the YP FILE that has zips and match it against the DBE DATA by the Business Name and ADDRESS and if the Business Name and ADDRESS match then insert the zip code into the DBE file that is missing the zip code. After that is done and we are still missing zip codes in the DBE data we can look at the ENTERPRISE FILE and if the city and State are in the DBE data then look at the Enterprise File and just use the first zip code. If the city has more than one zip code, and we are in error it will not matter
ID del proyecto: 37548892

Información sobre el proyecto

73 propuestas
Proyecto remoto
Activo hace 4 meses

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
73 freelancers están ofertando un promedio de $483 USD por este trabajo
Avatar del usuario
I have read through the requirements and I am confident of delivering as needed. However it will be in our mutual interest to study some typical records in database (that meet either one of the three criteria stated) and the zipcode enterprise file, YP file etc. This will enable me to analyse and plan and make an informed commitment. Also please give me an approximate idea of the number of records in the database so that I can approximately judge how long queries will take to execute. Above details will enable me to assess scope of work precisely. I will revise / confirm my bid accordingly. Detailed specifications and inputs will also help me make an informed commitment and deliver as required. I ensure a very thorough job and also support if you need changes / enhancements in future. I look forward to hearing from you and working on the project. You are highly rated with many projects to your credit and I will consider it a privilege to offer my services to you. I look forward to this project as an opportunity to establish a long term association.
$500 USD en 5 días
4,9 (827 comentarios)
8,9
8,9
Avatar del usuario
Good day, Can you please share your file details/website link which you want us to customize to append data to save within database? Also please explain how you want to append data? If you want us to create form having fields and data entered within those fields should be saved within database? Please ignore bid price for now. Regards, Yasir
$500 USD en 7 días
5,0 (78 comentarios)
8,9
8,9
Avatar del usuario
Hey Good afternoon , Just finished reading the brief details . I see you have been looking for someone who has experience with these tech stacks MySQL, Database Programming, Data Processing, Software Architecture and Database Administration. I will request you to review my profile, skills, projects and customer feedbacks to confirm that I will be good fit for this job. I would like you to start the chat so we can discuss the project in detail and we will see how it goes. Questions: 1. These are all the requirements? If not, Please share more detailed requirements. 2. Do you currently have anything done for the job or it has to be done from scratch? 3. What is the timeline to get this done? Why Choose Me? 1. I have done more than 250 major projects only on freelancer.com. 2. I have not received a single bad feedback since last 5-6 years. 3. You will find 5 star feedback on last 100+ major projects which shows my clients are happy with my work. Portfolio: https://www.freelancer.com/u/AwaisChaudhry Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) Thanks and regards, Awais
$750 USD en 12 días
4,9 (106 comentarios)
8,6
8,6
Avatar del usuario
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$500 USD en 7 días
4,9 (494 comentarios)
8,5
8,5
Avatar del usuario
Hello, my name is Raman and I am the founder and CEO of CnELIndia. I understand you are looking for someone with experience in database cross-joining and software architecture to help you with your project of appending databases. With my extensive experience in PHP, WordPress, WooCommerce, Data Scrapping, and React Native, I am confident that I can provide the best solution for your needs. I specialize in PHP, WordPress, WooCommerce, Data Scrapping, and React Native. My team and I have worked on many projects together before and we always deliver on time budget and follow all requirements precisely. We take pride in our work and strive to provide excellent service to our customers. We would be delighted to discuss further how we can help you tackle this project. Please feel free to contact me if you have any questions or would like more information about our services.
$500 USD en 7 días
4,9 (308 comentarios)
8,4
8,4
Avatar del usuario
Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks. ..
$750 USD en 4 días
4,8 (86 comentarios)
7,9
7,9
Avatar del usuario
Hello, I'd be glad to co:plete your data based on your difference DB tables. Looking forwad to chat with you soon for more details. Best regards.
$450 USD en 2 días
5,0 (61 comentarios)
7,3
7,3
Avatar del usuario
Hi there, I hope this message finds you well. I have carefully reviewed the project details you provided and I believe I can assist you with your requirements. To begin with, I have extensive experience working with MySQL databases and joining databases to fill in data values. I can help you cross append the files and address the issue of NULL VALUES. Regarding the missing 2 letter State abbreviation, I can utilize the zip code enterprise file you will provide to determine the State for each record that has a zip code. By matching the zip code with the City, County, and State information in the file, we can accurately fill in the missing State abbreviations. For the records that are missing zip codes, but have multiple records with the same name and postal address, I can perform exact matches within the same database to fill in the null zip code fields. This will ensure that all relevant records have the necessary zip code information. In cases where the data records still do not have a zip code but have the CITY and STATE information, I can utilize the YP FILE, which contains zip codes, to match the Business Name and ADDRESS in the DBE DATA. If there is a match, I will insert the corresponding zip code into the DBE file that is missing the zip code. If there are still missing zip codes in the DBE data after the above steps, we can refer to the ENTERPRISE FILE. By checking if the city and State are present in the DBE data, we can use the first zip code listed in the...
$500 USD en 15 días
5,0 (33 comentarios)
7,3
7,3
Avatar del usuario
Dear Sir, Are you looking for a solution to seamlessly cross appending files and filling in NULL VALUES in your database? My name is Smith and I have the necessary skills in Data Processing, Database Administration, Database Programming, MySQL, and Software Architecture to complete this project for you. Here are the steps I will take to complete the project: 1. Utilize MySQL database to join databases and fill in data values where there are currently NULL VALUES. 2. Use the zip code enterprise file provided to determine the State for data records that do not have the 2 letter State abbreviation. 3. Identify and fill in null zip code fields using exact matches with other records in the same database. 4. Utilize the YP FILE to match Business Name and ADDRESS to insert the zip code into the DBE file that is missing the zip code. 5. Look at the ENTERPRISE FILE and use the first zip code for data records still missing zip codes in the DBE data if the city and State are in the database. Furthermore, I am willing to provide a free demonstration of the solution even before the project is awarded. This will give you a better understanding of how the solution will work for your specific data cross appending needs. Thank you for considering my proposal. I look forward to the opportunity to collaborate with you on this project. Sincerely, Smith
$500 USD en 7 días
5,0 (52 comentarios)
6,9
6,9
Avatar del usuario
Hi, I have read the details I believe I can do this job. While I believe I have some queries which need to be clarified. For that I would request you to start the chat so we could clarify those I have good experience with MySQL, Database Administration, Software Architecture, Database Programming and Data Processing. We can discuss the timeline and budget after that. You can see all my skills, experience, customer reviews and relevant jobs from my profile. My portfolio: https://www.freelancer.com/u/AITSoft Shamshad
$750 USD en 29 días
4,9 (46 comentarios)
6,9
6,9
Avatar del usuario
Hello, Greetings of the Day!! Yes, I will surely help you and I am ready to work on this project. I already worked on a similar project and will perform the following tasks perfectly. * Can we have a quick chat, so that we can discuss further details and I can show you my previous/recent work ? * I have full-time and required skills to carry out your project with high quality on time. My expertise is well-matched with your requirements. I am working on UI/UX design/development, Frontend development, Backend development, Database development, API Integration/Development, CMS/CRM development, E-Commerce development, Server development, Flutter/React native app development, SEO/Digital Marketing Expert, AI/ChatGPT, All payment gateways integration/setup. Let's get in touch via chat, Waiting for your positive response. Rekha Thakur
$750 USD en 20 días
5,0 (29 comentarios)
6,8
6,8
Avatar del usuario
Hello, I can efficiently cross-append your files in MySQL, filling NULL values for zip codes. Using the zip code enterprise file and YP file, I'll match and insert missing zip codes based on exact matches with other records in the same database. This comprehensive approach ensures accurate data enrichment, addressing missing zip codes systematically. Best regards, Abbas
$750 USD en 7 días
4,8 (75 comentarios)
7,2
7,2
Avatar del usuario
Hello, Hope you are doing great, I have a 9+ year experience in web development/ database development, MySQL Administration and Programming. I understand from your project description that you need someone to append databases and fill in missing values where there are currently NULL VALUES. If so then I can help you with my expertise in database administration and programming. I have the necessary skills and experience to tackle this project efficiently. Moreover, I guarantee top quality work will be delivered within the desired time frame without compromising on the budget or accuracy. Please feel free to contact me if you would like more information or if you would like me to submit my portfolio for your consideration. Thanks Gaurav D.
$500 USD en 7 días
5,0 (65 comentarios)
7,0
7,0
Avatar del usuario
Good Day, Can you provide more details about the database schema and existing joins in place? Are there any specific constraints or considerations for data matching (e.g., partial matches, duplicate entries)? By successfully completing this project, you can expect: A complete and unified dataset with minimal missing values, improving data integrity and analysis accuracy. Enhanced data usability for further analysis, reporting, and decision-making. Optimized data storage by eliminating redundancy and reducing null values. Please start chat to work together.I can start work immediately . Thanks, Muhammad Abrar PS: Portfolio can be shared on your request thru' chat
$500 USD en 7 días
5,0 (14 comentarios)
6,2
6,2
Avatar del usuario
Hello! My name is Baber and I am a data scientist with 3+ years of experience in the field. I have a proven track record of success in using data to drive business decisions and drive growth. I understand that you are looking for someone to append databases, and I believe I am the perfect fit for this project. With my extensive experience working with a variety of data tools and technologies, including Python, SQL, and Excel, I am well equipped to handle the task at hand. I would be more than happy to discuss this project further if given the chance. In the meantime, please feel free to contact me if you have any questions or would like more information about my skillset.
$250 USD en 2 días
5,0 (79 comentarios)
6,2
6,2
Avatar del usuario
Hello there! I understand that you are looking for someone to append databases and I believe that I am the best fit for this job due to my extensive knowledge in database administration, database programming, MySQL, software architecture, artificial intelligence and mobile development. I believe that my skillset make me an ideal candidate for this project as I have the necessary tools to join databases together to fill in missing data values where there are currently NULL VALUES. Additionally, if any data records still do not have a zip code but have the CITY and STATE then I can use the YP FILE to search through for matches against the DBE DATA by BUSINESS NAME and ADDRESS so that zip codes can be inserted into the DBE file if needed.
$250 USD en 7 días
4,8 (34 comentarios)
6,4
6,4
Avatar del usuario
Hello! I took a delightful dive into your project description, and boy oh boy, it seems like my skills are a perfect match for this gig! I am an expert which have many years of experience on Data Processing, Software Architecture, MySQL, Database Administration, Database Programming Quickly come hop into chat and chat it up to unravel more awesomeness! Let's bring your vision to life. Regards ,Christopher
$500 USD en 6 días
5,0 (22 comentarios)
6,0
6,0
Avatar del usuario
Please check my profile. You want to fill empty values by joining database. I am database designer and develoer and am very familiar with this kind of works. Please contact me for more details. Thank you.
$400 USD en 4 días
5,0 (4 comentarios)
6,0
6,0
Avatar del usuario
I have gone through your whole description. I can join databases to fill in data values with mentioned requirements. Give me chance to show you good result. Thanks... I will deliver within 3 days Contact me I am available
$350 USD en 3 días
5,0 (57 comentarios)
5,5
5,5
Avatar del usuario
Hi, how are you today? Your project caught my attention and I'd like to work with you. I can help you merge and amortize the database to fill the missing data based on the provided additional records. Send me a message so we can get started asap.
$550 USD en 5 días
4,9 (26 comentarios)
5,7
5,7

Sobre este cliente

Bandera de UNITED STATES
North Caldwell, United States
5,0
482
Forma de pago verificada
Miembro desde feb 14, 2009

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.