Using Python to edit Shopify csv
Budget: $250 – $750 AUD
Seeking a Python developer to help me edit my Shopify csv file.
Based on the requirements you described, here's an overview of the tasks:
1. Task 1: Deleting variables from specific columns:
- Delete the values in columns 'Option1 Name (I)', 'Option1 Value (J)', 'Option2 Name (K)', 'Option2 Value (L)', 'Option3 Name (M)', 'Option3 Value (N)' where the value is "Assembly Options: Flat Packed, Assembled".
2. Task 2: Allocating SKUs to product variables:
- Find products where the 'Body (HTML)' column (C) contains the "<th>Product Code:</th>" tag.
- Extract the product codes from the table under the "Product Code:" heading.
- If there is only one product code listed, allocate that SKU to each variable in the handle group.
To accomplish these tasks, a Python script can be written using libraries such as `pandas` and `BeautifulSoup` to manipulate the CSV file and extract the required information.
Based on the requirements you described, here's an overview of the tasks:
1. Task 1: Deleting variables from specific columns:
- Delete the values in columns 'Option1 Name (I)', 'Option1 Value (J)', 'Option2 Name (K)', 'Option2 Value (L)', 'Option3 Name (M)', 'Option3 Value (N)' where the value is "Assembly Options: Flat Packed, Assembled".
2. Task 2: Allocating SKUs to product variables:
- Find products where the 'Body (HTML)' column (C) contains the "<th>Product Code:</th>" tag.
- Extract the product codes from the table under the "Product Code:" heading.
- If there is only one product code listed, allocate that SKU to each variable in the handle group.
To accomplish these tasks, a Python script can be written using libraries such as `pandas` and `BeautifulSoup` to manipulate the CSV file and extract the required information.