如何将json转换为带有适当头文件的csv python

bihw5rsg 于 2022-11-26 发布在 Python

关注(0)|答案(3)|浏览(93)

尝试将Json数据转换为csv，我正在获取值，但结果中有一个块显示为一行，这是Python的新特性，因此需要任何帮助。我已经尝试了以下代码来做同样的事情。

import pandas as pd

with open(r'C:\Users\anath\hard.json', encoding='utf-8') as inputfile:
    df = pd.read_json(inputfile)

    df.to_csv(r'C:\Users\anath\csvfile.csv', encoding='utf-8', index=True)

源文件中的示例Json，简短代码段

{
  "issues": [
    {
      "issueId": 110052,
      "revision": 84,
      "definitionId": "DNS1012",
      "subject": "urn:h:domain:fitestdea.com",
      "subjectDomain": "fitestdea.com",
      "title": "Nameserver name doesn\u0027t resolve to an IPv6 address",
      "category": "DNS",
      "severity": "low",
      "cause": "urn:h:domain:ns1.gname.net",
      "causeDomain": "ns1.gname.net",
      "open": true,
      "status": "active",
      "auto": true,
      "autoOpen": true,
      "createdOn": "2022-09-01T02:29:09.681451Z",
      "lastUpdated": "2022-11-23T02:26:28.785601Z",
      "lastChecked": "2022-11-23T02:26:28.785601Z",
      "lastConfirmed": "2022-11-23T02:26:28.785601Z",
      "details": "{}"
    },
    {
      "issueId": 77881,
      "revision": 106,
      "definitionId": "DNS2001",
      "subject": "urn:h:domain:origin-mx.stagetest.test.com.test.com",
      "subjectDomain": "origin-mx.stagetest.test.com.test.com",
      "title": "Dangling domain alias (CNAME)",
      "category": "DNS",
      "severity": "high",
      "cause": "urn:h:domain:origin-www.stagetest.test.com.test.com",
      "causeDomain": "origin-www.stagetest.test.com.test.com",
      "open": true,
      "status": "active",
      "auto": true,
      "autoOpen": true,
      "createdOn": "2022-08-10T09:34:36.929071Z",
      "lastUpdated": "2022-11-23T09:33:32.553663Z",
      "lastChecked": "2022-11-23T09:33:32.553663Z",
      "lastConfirmed": "2022-11-23T09:33:32.553663Z",
      "details": "{\"@type\": \"hardenize/com.hardenize.schemas.dns.DanglingProblem\", \"rrType\": \"CNAME\", \"rrDomain\": \"origin-mx.stagetest.test.com.test.com\", \"causeDomain\": \"origin-www.stagetest.test.com.test.com\", \"danglingType\": \"nxdomain\", \"rrEffectiveDomain\": \"origin-mx.stagetest.test.com.test.com\"}"
    }
    }
  ]
}

我得到的输出如下所示，是寻找一种方法，可以字段名称在标题和值在一列或单元格到目前为止得到整个记录在1个单元格。任何方式，我们可以只得到特定的字段，如标题，严重性或issueid不是一切，但只有我需要的字段。

JSON

来源：https://stackoverflow.com/questions/74549835/how-to-convert-json-to-csv-python-with-proper-headers

3条答案

按热度按时间

gab6jxml1#

试试看：

import json
import pandas as pd

with open("your_file.json", "r") as f_in:
    data = json.load(f_in)

df = pd.DataFrame(data["issues"])
print(df[["title", "severity", "issueId"]])

印刷品：

title severity  issueId
0  Nameserver name doesn't resolve to an IPv6 address      low   110052
1                       Dangling domain alias (CNAME)     high    77881

要另保存为CSV，您可以执行以下操作：

df[["title", "severity", "issueId"]].to_csv('data.csv', index=False)

赞(0）回复(0）举报 2022-11-26

2q5ifsrm2#

试试这个
df = pd.json_normalize（输入文件）
代替你的台词。

赞(0）回复(0）举报 2022-11-26

3qpi33ja3#

最后，这对我有用@Andrej Kesely感谢你的投入。分享可能会帮助别人。

import pandas as pd
import json

with open(r'C:\Users\anath\hard.json', encoding='utf-8') as inputfile:
    data = json.load(inputfile)

df = pd.DataFrame(data["issues"])
print(df[["title", "severity", "issueId"]])
df[["title", "severity", "issueId"]].to_csv('data.csv', index=False)

赞(0）回复(0）举报 2022-11-26

我来回答

如何将json转换为带有适当头文件的csv python

3条答案

相关问题

热门标签

最新问答