Find Jobs
Hire Freelancers

Data Scientist to append databases

$250-750 USD

Closed
Posted 5 months ago

$250-750 USD

Paid on delivery
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
Project ID: 37548892

About the project

73 proposals
Remote project
Active 4 mos ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
73 freelancers are bidding on average $483 USD for this job
User Avatar
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 in 5 days
4.9 (827 reviews)
8.9
8.9
User Avatar
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 in 7 days
5.0 (78 reviews)
8.9
8.9
User Avatar
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 in 12 days
4.9 (106 reviews)
8.6
8.6
User Avatar
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 in 7 days
4.9 (494 reviews)
8.5
8.5
User Avatar
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 in 7 days
4.9 (308 reviews)
8.4
8.4
User Avatar
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 in 4 days
4.8 (86 reviews)
7.9
7.9
User Avatar
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 in 2 days
5.0 (61 reviews)
7.3
7.3
User Avatar
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 in 15 days
5.0 (33 reviews)
7.3
7.3
User Avatar
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 in 7 days
5.0 (52 reviews)
6.9
6.9
User Avatar
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 in 29 days
4.9 (46 reviews)
6.9
6.9
User Avatar
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 in 20 days
5.0 (29 reviews)
6.8
6.8
User Avatar
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 in 7 days
4.8 (75 reviews)
7.2
7.2
User Avatar
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 in 7 days
5.0 (65 reviews)
7.0
7.0
User Avatar
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 in 7 days
5.0 (14 reviews)
6.2
6.2
User Avatar
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 in 2 days
5.0 (79 reviews)
6.2
6.2
User Avatar
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 in 7 days
4.8 (34 reviews)
6.4
6.4
User Avatar
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 in 6 days
5.0 (22 reviews)
6.0
6.0
User Avatar
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 in 4 days
5.0 (4 reviews)
6.0
6.0
User Avatar
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 in 3 days
5.0 (57 reviews)
5.5
5.5
User Avatar
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 in 5 days
4.9 (26 reviews)
5.7
5.7

About the client

Flag of UNITED STATES
North Caldwell, United States
5.0
482
Payment method verified
Member since Feb 14, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.