将数组转换为CSV，包括多行imag

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" } ]

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"])

1条回答

网友

1楼 · 发布于 2024-05-27 10:31:24

这并不特别难。您的代码几乎是正确的（假设列是按您想要的方式排列的，并且假设您传入了有效的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就是这样csv.writer将单元格留空，所以将它们用作所有其他列的占位符。你知道吗

如果这需要很容易修改，我会推荐一种不同的方法。不过，这看起来像是一个一次性的转换脚本，所以一个快速、简单的黑客程序可以很好地工作。你知道吗

注意事项：

a if b else c，如果b求值为True，则表示a；如果求值为False，则表示c。你知道吗
ary.pop(n)从ary弹出（删除并返回）索引n处的对象。你知道吗
空数组的计算结果为False（因此我只测试images，而不是len(images) == 0）
您可能还需要更新标题。我只是按原样对它们进行了修改，所以我只对最后一个while进行了更改；您可能需要修复它们以准确地标记列。你知道吗

相关问题更多 >

编程相关推荐

热门问题

热门文章