将JSON数据写入CSV

2024-03-29 08:02:59 发布

您现在位置:Python中文网/ 问答频道 /正文

我有一个动态的json,在whcih键(属性)会根据记录不同。你知道吗

我想将以下json数据写入csv文件:

[{"Id": "12345",
  "attributes": {"Address": [{"label": "United Kingdom",
                              "value": {"AddressLine": [{"value": "Baker "
                                                                  "Street"}]}},
                             {"label": "United States",
                              "value": {"AddressLine": [{"value": "Florida"}]}}],
                 "CountryCode": [{"value": "Australia"}],
                 "Identifiers": [{"value": {"Type": [{"value": "Licence Id"}]}},
                                 {"value": {"Type": [{"value": "NPI"}]}}],
                 "StatusReasonCode": [{"value": "XXX"}],
                 "UniqueId": [{"value": "71581742"}]},
  "createdBy": "Rahul"}]

数据应为以下csv格式:

ID, createdBy, CountryCode, StatusReasonCode, Identifiers, UniqueId, AddressLine
12345,Rahul,Australia,XXX,Licence Id,71581742,Baker Street
12345,Rahul,Australia,XXX,NPI,71581742,Florida

下面是我从json中提取数据的代码:

import json

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

for key,value in data.items():

    if(type(value))==str:
        print(key + ',' + value)
    # global res
    res =[]
    if(type(value))==list:
        for fg in value:
            crosswalk_final=fg['value']
    if (type(value))== dict:
        for key1,val in value.items():
            for k in val:
                if type(k['value']) == dict:

                   for sub_key,sub_value in k.items():

                      if(type(sub_value)) == dict:
                          for child_key,child_value in sub_value.items():

                              if(type(child_value)) == list:
                                for m in child_value:

                                    if type(m['value']) == dict:
                                        for qaq,waq in m.items():

                                            if (isinstance(waq, dict)):
                                                for our,pur in waq.items():

                                                    for qq in pur:
                                                       print(our+','+qq['value'])

                                    else:
                                        pass
                                        print(key1+'_'+sub_key+'_'+child_key+','+m['value'])

                else:
                    attr1=(key+'_'+key1+','+k['value'])
                    print((attr1))

以上代码以以下格式给出结果:

Id,12345
createdBy,Rahul
attributes_UniqueId,71581742
attributes_CountryCode,Australia
attributes_StatusReasonCode,XXX
Address_value_AddressLine,Baker Street
Address_value_AddressLine,Florida
Identifiers_value_Type,Licence Id
Identifiers_value_Type,NPI

但是,我不知道如何写在我的csv格式(在上面显示的相同格式)。你知道吗


Tags: keyinidjsonchildforifvalue
1条回答
网友
1楼 · 发布于 2024-03-29 08:02:59

编写一个函数,将字典展平为一个长度恒定的列表。如果缺少键,请将值设置为“无”。 示例:

data_dict = {"a": 1, "c": 12, "b": 0}
data_list = [data_dict.get("a"), data_dict.get("b"), data_dict.get("c")]

然后插入csv。你知道吗

相关问题 更多 >