Python Script - for the merge 3 excel sheets
- or -
Post a project like this914
£25/hr(approx. $31/hr)
- Posted:
- Proposals: 9
- Remote
- #3404499
- Awarded
Full Stack Developer | React | Node | PHP | Python | Matlab | Data Scraping | Computer Vision | C++
Chuhar Jamali
Computer Engineer || Python Dev || Web Scraping || Image Processing || Stable Diffusion || Data Scientist || Machine & Deep Learning || Automation
Konya
410328426979874349153505311356231486016231607526161959526290279
Description
Experience Level: Expert
A client has found a new supplier and would like to populate his ecommerce store with their products, i've reviewed the data sheets that come via FTP (daily) from their supplier and they have 3 excel sheets - one contains products information, the other contains price/stock then last contains promo prices.
I would like to have a script made so that there is one main excel sheet that outputs as a CSV UTF-8 file but it needs to be able to match up rows by us choosing a unique identifier (in this case it'll be "model number") and then add columns into the matching. Leaving us with 1 CSV that has all the information from the 1st sheet and columns added for images, prices etc allowing me to process the feed through their ecommerce platform.
Will send over the excel sheets and explain some more when i have evaluated the proposals.
I would like to have a script made so that there is one main excel sheet that outputs as a CSV UTF-8 file but it needs to be able to match up rows by us choosing a unique identifier (in this case it'll be "model number") and then add columns into the matching. Leaving us with 1 CSV that has all the information from the 1st sheet and columns added for images, prices etc allowing me to process the feed through their ecommerce platform.
Will send over the excel sheets and explain some more when i have evaluated the proposals.
Mehdi R.
100% (17)Projects Completed
12
Freelancers worked with
11
Projects awarded
28%
Last project
10 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies