Automatic conversion of Excel price list into import format (Python or Excel)
It is necessary to automate the conversion of an Excel price list with data about textile products into a format suitable for import into CMS.
Output data:
- Excel file with approximately 300+ product entries.
- The table contains fields: name, density, width, length, retail price (UAH/m), unique identifier (UUID).
- During import, not all fields are filled. Some values are empty.
What is needed:
Write a script (Python or macro) that:
- Reads the table from the input Excel file.
- Creates a new table with the following columns:
- name – product name.
- article – first 8 characters from the "Unique Identifier (Nomenclature)" column or generated UUID.
- group identifier – sequence 1, 2, 3... etc. Group = items with the same value in the Product Name column.
- attributes – a string in the format brand:K.tex|width:X|length:Y|density:Z, plus additional as needed.
- price – taken from UAH/m.
- unit of measurement – "m.linear"
Other columns remain empty (discounted price, quantity, etc.). They will be filled manually.
Output:
CSV or Excel file in the target format. The script will be used with new files monthly.
Expected:
- Clear code with explanations.
- Instructions for running (locally or in Google Colab).
- (Optional) the ability to refine the logic in the future.
Budget: propose your own.
Client's review of cooperation with Mykhailo P.
Automatic conversion of Excel price list into import format (Python or Excel)Very meaningful communication, clear and quick execution
Freelancer's review of cooperation with Oleksii Malitsky
Automatic conversion of Excel price list into import format (Python or Excel)Payment, Task setting, Requirements, Contactability, All super!
10\10
Current freelance projects in the category Python
Development of software for managing iPhone via USB cable from PC
223 USD
A program needs to be developed for Windows that allows connecting a jailbroken iPhone via USB cable and controlling it from a computer. Main functionality: Connecting the iPhone via USB. The program should quickly recognize the connected iPhone and operate through the cable… C & C++, Python ∙ 14 hours 59 minutes back ∙ 13 proposals |
BuzzPost automation for Facebook in IsraelThe project already exists and it works - the task is to solve the issue of Facebook restrictions when the number of posts per hour exceeds 3-4 (from 7 AM to 12 AM), client accounts are restricted by Facebook. Website - https://buzzpost.co.il/ Also, look for loopholes in the… Python, Customer Support ∙ 1 day 11 hours back ∙ 12 proposals |
Creation of a TikTok farm with income generation
601 USD
Looking for a person who can write software for a TikTok farm, so we can generate traffic and earn income. We are seeking a ready-made solution with a full cycle. Python, Bot Development ∙ 4 days 6 hours back ∙ 16 proposals |
AI Commenting Platform for TikTok and Instagram.Project Goal Develop a system that allows managing a large number of TikTok and Instagram accounts and automatically posting relevant comments under selected videos using AI. Main Functionality1. Account Management It is necessary to implement the ability to connect accounts:… AI & Machine Learning, Python ∙ 5 days 13 hours back ∙ 23 proposals |
Build a customer classification model1. There is client data in Mongo/SQL (approximately 20,000 entries with raw data). 2. It is necessary to build features and a classification model of clients into behavioral groups based on this data. 3. The project should be completed in Python. AI & Machine Learning, Python ∙ 7 days 7 hours back ∙ 46 proposals |