将json文件映射到CSV行

Question

我正在尝试用python进行一些类型转换。我想我应该使用一个函数头名称字典，并将这些函数映射到每个CSV行

  'page':'ProductPage'
  'OAM':'False'
  'storeNum':'029'
  'brand':'Opti-UPS'
  'productPrice':'114.99'
 'SKU':'349829'
 'productID':'405220'
 'mpn':'GS1100B'
 'ean':'766908091211'
  'category':'UPS Systems'
 'isMobile':'False'

'page':'ProductPage'
  'OAM':'False'
  'storeNum':'029'
  'brand':'Aven'
  'productPrice':'2.99'
 'SKU':'563197'
 'productID':'442744'
 'mpn':'17551LF'
 'ean':'766955340416'
  'category':'Soldering
 'isMobile':'False'

现在要将此列表写入csv，在MS Excel中显示如下-

Output

提前谢谢

Answer 1

假设您的JSON输入如下所示：

[{  "page":"ProductPage",
  "OAM":"False",
  "storeNum":"029",
  "brand":"Opti-UPS",
  "productPrice":"114.99",
 "SKU":"349829",
 "productID":"405220",
 "mpn":"GS1100B",
 "ean":"766908091211",
  "category":"UPS Systems",
 "isMobile":"False"},

{"page":"ProductPage",
  "OAM":"False",
  "storeNum":"029",
  "brand":"Aven",
  "productPrice":"2.99",
 "SKU":"563197",
 "productID":"442744",
 "mpn":"17551LF",
 "ean":"766955340416",
 "category":"Soldering",
 "isMobile":"False"}]

然后此程序可能会执行您想要的操作：

import json
import csv

with open('in.json') as data:
    data = json.load(data)

headers = set().union(*data)

with open('out.csv', 'w') as result:
    result = csv.DictWriter(result, sorted(headers))
    result.writeheader()
    result.writerows(data)