python将json数据转excel或csv

需要用到的模块

python pandas模块

pip install pandas

python pandas

pandas是python语言的一个扩展程序库，用于数据分析。

示例

将json数据转换为excel数据

import pandas as pd
df = pd.read_json('1.json')
df.to_excel('aaa.xlsx')
print("*****************************")

输出如下

将json数据转换为csv数据

import pandas as pd
df = pd.read_json('1.json')
df.to_csv('demo.csv')
print("*****************************")

输出如下

json数组转换

import pandas as pd
df = pd.read_json("demo.json")
print(df)
print("================================")
data = pd.DataFrame(df["namelist"]["names"])
data.to_excel("demo.xlsx")
print("********************************")

输出如下

其他

import pandas as pd

# 你的 JSON 数据
data = {
  "TraceApps": [
    {
      "ResourceGroupId": "rg-xssd2ee",
      "ClusterId": "xxxxxssxcssd2",
      "CreateTime": 1620000000,
      "Pid": "xxxx@xxx",
      "Labels": [],
      "Source": "ACSK8S",
      "Namespace": "tr",
      "AppName": "xx-xx-xx-xx",
      "Type": "TRACE",
      "AppId": 123456,
      "Language": "java",
      "UserId": "xxxxx",
      "UpdateTime": 1620000000,
      "Show": True,
      "RegionId": "cn-shanghai"
    }
  ]
}

# 提取数据
trace_apps = data['TraceApps']

# 只保留指定的键
selected_keys = ["ResourceGroupId", "ClusterId", "AppName", "Language"]
filtered_data = [{key: app.get(key, None) for key in selected_keys} for app in trace_apps]

# 将数据转换为 DataFrame
df = pd.DataFrame(filtered_data)

# 将 DataFrame 保存为 Excel 文件
df.to_excel('trace_apps_filtered.xlsx', index=False)

print("数据已成功保存为 trace_apps_filtered.xlsx")