我正在将一个数组转换为csv,这样我就可以快速地导入商品进行购物。According to Shopify,导入时必须执行以下操作以添加多个图像:
插入新行(每张图片一行)。
复制并粘贴“句柄”。
复制并粘贴图像URL。
因此,第一个图像进入第一行,所有后续图像进入下一行。示例CSV位于此处:https://help.shopify.com/csv/product_template.csv
因此,我想编程一些东西,它将循环通过一个数组,看起来像下面的(明显较长的除外),并将其转换为CSV,将除第一个以外的所有照片放入一个新行。
var array = [
{
"brief": "Brief 1",
"description": "Description 1",
"photos": [
"https://cdn.shopify.com/s/files/1/01/01/01/files/imgs-example.jpg?0101010101010",
"https://cdn.shopify.com/s/files/1/01/01/01/files/imgs-example2.jpg?0101010101010",
"https://cdn.shopify.com/s/files/1/01/01/01/files/imgs-example3.jpg?0101010101010"
],
"price": "145",
"tags": [
"tag1",
"tag2",
"tag3"
],
"title": "Title 1"
},
{
"brief": "Brief 2",
"description": "Description 2",
"photos": [
"https://cdn.shopify.com/s/files/1/01/01/01/files/imgs-example4.jpg?0101010101010",
"https://cdn.shopify.com/s/files/1/01/01/01/files/imgs-example5.jpg?0101010101010"
],
"price": "150",
"tags": [
"tag4",
"tag5",
"tag6",
"tag7",
"tag8",
],
"title": "Title 2"
}
]
我通常用json2csv来做这种事情,它看起来像下面这样,只是我不知道如何处理多行方面。
json2csv -i data_in.json -f title,description,price,etc -o data_out.csv
Python可能也是一个不错的选择,如下所示this post,但多行方面同样令人困惑:
import csv
import json
x = """[
{
"brief": "Brief 1",
"description": "Description 1",
"photos": [
"https://cdn.shopify.com/s/files/1/01/01/01/files/imgs-example.jpg?0101010101010",
"https://cdn.shopify.com/s/files/1/01/01/01/files/imgs-example2.jpg?0101010101010",
"https://cdn.shopify.com/s/files/1/01/01/01/files/imgs-example3.jpg?0101010101010"
],
"price": "145",
"tags": [
"tag1",
"tag2",
"tag3"
],
"title": "Title 1"
},
{
"brief": "Brief 2",
"description": "Description 2",
"photos": [
"https://cdn.shopify.com/s/files/1/01/01/01/files/imgs-example4.jpg?0101010101010",
"https://cdn.shopify.com/s/files/1/01/01/01/files/imgs-example5.jpg?0101010101010"
],
"price": "150",
"tags": [
"tag4",
"tag5",
"tag6",
"tag7",
"tag8",
],
"title": "Title 2"
}
]"""
x = json.loads(x)
f = csv.writer(open("example.csv", "wb+"))
# Write CSV Header, If you dont need that, remove this line
f.writerow(["title", "description", "price"])
for x in x:
f.writerow([x["title"],
x["description"],
x["price"])
CSV的输出行顶部如下所示(必须“运行Snippet”才能显示为表)-请注意,我没有试图创建HTML表:
<style type="text/css">
.tg {border-collapse:collapse;border-spacing:0;}
.tg td{font-family:Arial, sans-serif;font-size:14px;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;border-color:black;}
.tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;border-color:black;}
.tg .tg-yw4l{vertical-align:top}
</style>
<table class="tg">
<tr>
<th class="tg-yw4l">Handle</th>
<th class="tg-yw4l">Title</th>
<th class="tg-yw4l">Body (HTML)</th>
<th class="tg-yw4l">Vendor</th>
<th class="tg-yw4l">Type</th>
<th class="tg-yw4l">Tags</th>
<th class="tg-yw4l">Published</th>
<th class="tg-yw4l">Option1 Name</th>
<th class="tg-yw4l">Option1 Value</th>
<th class="tg-yw4l">Option2 Name</th>
<th class="tg-yw4l">Option2 Value</th>
<th class="tg-yw4l">Option3 Name</th>
<th class="tg-yw4l">Option3 Value</th>
<th class="tg-yw4l">Variant SKU</th>
<th class="tg-yw4l">Variant Grams</th>
<th class="tg-yw4l">Variant Inventory Tracker</th>
<th class="tg-yw4l">Variant Inventory Qty</th>
<th class="tg-yw4l">Variant Inventory Policy</th>
<th class="tg-yw4l">Variant Fulfillment Service</th>
<th class="tg-yw4l">Variant Price</th>
<th class="tg-yw4l">Variant Compare At Price</th>
<th class="tg-yw4l">Variant Requires Shipping</th>
<th class="tg-yw4l">Variant Taxable</th>
<th class="tg-yw4l">Variant Barcode</th>
<th class="tg-yw4l">Image Src</th>
<th class="tg-yw4l">Image Alt Text</th>
<th class="tg-yw4l">Gift Card</th>
<th class="tg-yw4l">Google Shopping / MPN</th>
<th class="tg-yw4l">Google Shopping / Age Group</th>
<th class="tg-yw4l">Google Shopping / Gender</th>
<th class="tg-yw4l">Google Shopping / Google Product Category</th>
<th class="tg-yw4l">SEO Title</th>
<th class="tg-yw4l">SEO Description</th>
<th class="tg-yw4l">Google Shopping / AdWords Grouping</th>
<th class="tg-yw4l">Google Shopping / AdWords Labels</th>
<th class="tg-yw4l">Google Shopping / Condition</th>
<th class="tg-yw4l">Google Shopping / Custom Product</th>
<th class="tg-yw4l">Google Shopping / Custom Label 0</th>
<th class="tg-yw4l">Google Shopping / Custom Label 1</th>
<th class="tg-yw4l">Google Shopping / Custom Label 2</th>
<th class="tg-yw4l">Google Shopping / Custom Label 3</th>
<th class="tg-yw4l">Google Shopping / Custom Label 4</th>
<th class="tg-yw4l">Variant Image</th>
<th class="tg-yw4l">Variant Weight Unit</th>
<th class="tg-yw4l"></th>
<th class="tg-yw4l"></th>
</tr>
<tr>
<td class="tg-yw4l">Title 1</td>
<td class="tg-yw4l">Title 1</td>
<td class="tg-yw4l">Description 1</td>
<td class="tg-yw4l">Vendor Name</td>
<td class="tg-yw4l">Product Type</td>
<td class="tg-yw4l">"tag1,tag2,tag3"</td>
<td class="tg-yw4l">TRUE</td>
<td class="tg-yw4l">Title 1</td>
<td class="tg-yw4l">Default Title</td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l">1</td>
<td class="tg-yw4l">deny</td>
<td class="tg-yw4l">manual</td>
<td class="tg-yw4l">145</td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l">TRUE</td>
<td class="tg-yw4l">TRUE</td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l">https://cdn.shopify.com/s/files/1/01/01/01/files/imgs-example.jpg?0101010101010</td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
</tr>
<tr>
<td class="tg-yw4l">Title 1</td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l">https://cdn.shopify.com/s/files/1/01/01/01/files/imgs-example2.jpg?0101010101010</td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
</tr>
<tr>
<td class="tg-yw4l">Title 1</td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l">https://cdn.shopify.com/s/files/1/01/01/01/files/imgs-example3.jpg?0101010101010</td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
<td class="tg-yw4l"></td>
</tr>
</table>
最佳答案
不是特别难。您的代码几乎是正确的(假设列是按您所希望的方式排列的,并且假设您传入了有效的JSON,因为您的列有一个额外的逗号),您只需要添加一点:
for x in x:
images = x["photos"]
f.writerow([x["title"],
x["description"],
x["price"],
images.pop(0) if images else None])
while images:
f.writerow([None, None, None, images.pop(0)])
简而言之,这样做的目的是按顺序循环所有图像,并将它们打印成新的或空的行。在原始代码上运行时,
example.csv
的结果如下:title,description,price
Title 1,Description 1,145,https://cdn.shopify.com/s/files/1/01/01/01/files/imgs-example.jpg?0101010101010
,,,https://cdn.shopify.com/s/files/1/01/01/01/files/imgs-example2.jpg?0101010101010
,,,https://cdn.shopify.com/s/files/1/01/01/01/files/imgs-example3.jpg?0101010101010
Title 2,Description 2,150,https://cdn.shopify.com/s/files/1/01/01/01/files/imgs-example4.jpg?0101010101010
,,,https://cdn.shopify.com/s/files/1/01/01/01/files/imgs-example5.jpg?0101010101010
很明显,如何将这些内容放入不同的列中,
None
s使单元格保持空状态,因此可以将它们用作所有其他列的占位符。如果这需要易于修改,我会推荐一种不同的方法。不过,这看起来像一个一次性的转换脚本,所以一个快速、简单的黑客操作就可以了。
几点注意事项
csv.writer
,如果a if b else c
计算为b
,则表示True
;如果计算为a
,则表示False
。c
从ary.pop(n)
中弹出(移除并返回)索引n
处的对象。空数组的计算结果为
ary
(因此我只测试False
,而不是images
)您可能还需要更新标题。我只是按原样修改,所以我的唯一更改是最后一个
len(images) == 0
;您可能需要修改它们以准确地标记列。