Find Jobs
Hire Freelancers

merge two csv data and compare with sql data set using python

$30-250 USD

Đã đóng
Đã đăng vào gần 4 năm trước

$30-250 USD

Thanh toán khi bàn giao
I have two CSV files and I want to compare the 'id' field in my CSV files with the id col in my DB and remove all the ids that have a match in the DB & create two files, one containing the matches and the other containing the non-matches. In SQL it's a straight forward join but I'm quite confused after doing a bit of research on how to get it done using pandas.
Mã dự án: 26918791

Về dự án

41 đề xuất
Dự án từ xa
Hoạt động 4 năm trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
41 freelancer chào giá trung bình $95 USD cho công việc này
Avatar người dùng
*** Python Script to compare csv data and Sql DB *** I read your project description very carefully. I have a deep understanding and experience in the areas of Python that you mentioned. I've previously worked on the exact same project for another employer. Pandas & SQL : https://www.freelancer.com/projects/sql/Inserting-Pandas-dataframe-SQL-server/reviews Check my past reviews and profiles So, I would like to go through more specific discussions with you to provide successful results. Thank you, from Mohamed F.
$35 USD trong 1 ngày
5,0 (238 nhận xét)
7,4
7,4
Avatar người dùng
Hi, Greetings! ✅checked your project details: merge two csv data and compare with sql data set using python ✅Completed Time: In project deadline We have worked on 650 + 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 Digital screencast
$220 USD trong 4 ngày
4,9 (211 nhận xét)
7,7
7,7
Avatar người dùng
@@@@ Hello! @@@@ My name is konstiatyn who is professional in PYthon, SQL , Software architecture and SQLite. I am very interested in your project”merge two csv data and compare with sql data set using python”. I have gone through your description carefully and understand what u need. I have ever done similar project. I’ll never let u down and waste your golden time. I don’t also bid on any projects which I am not sure to do. Please ping me to discuss in detail over chat. Best regards.
$140 USD trong 3 ngày
4,7 (25 nhận xét)
6,5
6,5
Avatar người dùng
Its an easy task for me. To read mysql data, i will use mysql connector to read csv file i will use pandas. I can do match operation based on the data that i read and create two csv file as you expect. I assure you i can give you high quality work. I am familiar in pandas dataframe as well. Kindly cosnider my proposal.
$70 USD trong 1 ngày
5,0 (32 nhận xét)
6,4
6,4
Avatar người dùng
Hi, I have read your job description. You want to separate out all the IDs into matching and non-matching CSV files by comparing them with DB data using python. A simple yet effective solution to this might be reading from database using Pandas and extracting matching columns using merge or concat or join methods. I am seasoned Data Science professional with more than 4 years of experience in Data Industry. Please get in touch so that we can discuss further.
$70 USD trong 1 ngày
5,0 (52 nhận xét)
6,4
6,4
Avatar người dùng
Hi, I'm a python expert with a lot of experiences. I can create a script to compare the 'id' field in CSV files with the id col in DB and remove all the ids that have a match in the DB & create two files, one containing the matches and the other containing the non-matches. Hope your kind contact. Best regards.
$60 USD trong 1 ngày
4,9 (28 nhận xét)
6,1
6,1
Avatar người dùng
Hello,i am a python expert,I just checked your project carefully. so it is very motivated and interesting for me. It is an ideal match for my skill and experience. let us discuss more details. Thanks.
$150 USD trong 1 ngày
4,5 (34 nhận xét)
6,3
6,3
Avatar người dùng
Hello, After reviewing the detail carefully i understood that you need to merge two csv data and compare with sql data set using python and i think I am the perfect person for this job . I have a strong team having experience of more than 5 years. I do not want to waste your time so please give me a chance to show my skills. I will make sure you will never regret after working with me. I will surely complete your work on time . Please text me and explain me all the details.I am looking for your response. Thank you.
$100 USD trong 4 ngày
5,0 (23 nhận xét)
5,6
5,6
Avatar người dùng
Hello. how are you ? i am exeprt in pandas. please check my profile my lastest project with one client is also python pandas i can help you perfectly as your requriemtns.
$100 USD trong 1 ngày
5,0 (14 nhận xét)
5,3
5,3
Avatar người dùng
Hi there, I have read your project description. Its an easy task for me. Just hit me a message so we can discuss and start your work.
$140 USD trong 7 ngày
5,0 (5 nhận xét)
5,1
5,1
Avatar người dùng
hello sir , I am a full time freelancer and have 10 years of experience in 1 web and window development in asp.net c#, javascript,sql server 2 Android mobile development i can do work as per your requirement . I can quickly understand the details and idea of your project so I think my technology is suitable for your project. please inbox me so that we can talk. Thanks Sanjay
$250 USD trong 7 ngày
5,0 (7 nhận xét)
4,5
4,5
Avatar người dùng
I've 3+ years of experience of development in python. I also have experience in database management with both sql and nosql, to add that I also have experience with large data manipulation, and that's why I believe I'll be the perfect candidate for this job
$70 USD trong 1 ngày
4,9 (22 nhận xét)
4,7
4,7
Avatar người dùng
This is an easy statement..used pandas to import the data and us numpy to convert the data to matrix..on numpy matrix it's easy to work on...I can do this very easily
$35 USD trong 1 ngày
5,0 (13 nhận xét)
4,0
4,0
Avatar người dùng
Hi I am python expert and I am sure I can help you perfectly. I have rich experience with python/Sqlite. And I always focus on the delivery and the best quality. Let's discuss with your job via private chat. Thanks.
$150 USD trong 7 ngày
5,0 (7 nhận xét)
4,0
4,0
Avatar người dùng
Hi. I think that will be able to do this. Please provide more information and I will tell if sure and my final bid. Regards.
$150 USD trong 5 ngày
5,0 (13 nhận xét)
4,1
4,1
Avatar người dùng
Hi I can make this script using python. It will read csv and compare ids from mysql db. using match it will generate a csv and using non match it will create other csv. Thanks
$67 USD trong 2 ngày
4,9 (17 nhận xét)
4,1
4,1
Avatar người dùng
I have good experience in both Pandas and Mysql and I am sure that I can do this work easily for you. Kindly ping me to continue firher on this project..
$76 USD trong 1 ngày
5,0 (7 nhận xét)
3,3
3,3
Avatar người dùng
Hi there. Nice to meet you. I'm a Python expert and FULL Time Django Developer. I have checked your requirements carefully. I have rich experience in WordPress, PHP, Website design, CSS, Javascript, etc. I can start work immediately now and can provide you perfect result for your requirements. Please let's discuss your project and reasonable price for this project in more detail. Thanks.
$45 USD trong 2 ngày
5,0 (14 nhận xét)
3,4
3,4
Avatar người dùng
Hi there! Hope you are doing great. I can help you in that. We can figure out the solution of this problem. I am experienced python developer and researcher. I can give you the solution within few hours. Just send me a message with the files, we can discuss about it. If you have questions please ask me. Feel free to contact me Thanks
$30 USD trong 1 ngày
4,9 (11 nhận xét)
2,9
2,9
Avatar người dùng
Hi there, Hope you doing well. I can do this using pandas in python. Please let me when you want me to start this. Thanks, Purna.
$100 USD trong 1 ngày
4,5 (2 nhận xét)
3,1
3,1

Về khách hàng

Cờ của ROMANIA
Băilești, Romania
5,0
1
Thành viên từ thg 3 8, 2020

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.