我正在尝试转换以下内容.json
文件至.csv
使用熊猫。
输入 json 文件名:my_json_file.json
{
"profile_set":[
{
"doc_type":"PROFILE",
"key":"123",
"mem_list":{
"mem_num":"10001",
"current_flag":"Y",
"mem_flag":[
],
"child_mem_list":{
"child_mem_num":[
]
}
},
"first_name":"Robert",
"middle_name":[
],
"last_name":"John",
"created_datetime":"2018-01-06T12:52:09"
},
{
"doc_type":"PROFILE",
"key":"456",
"mem_list":{
"mem_num":"10002",
"current_flag":"Y",
"mem_flag":"Y",
"child_mem_list":{
"child_mem_num":[
]
}
},
"first_name":"Lily",
"middle_name":[
],
"last_name":"Hubert",
"created_datetime":"2018-01-07T11:32:07"
}
]
}
期望的输出是my_csv_file.csv
doc_type key mem_num current_flag mem_flag child_mem_num first_name middle_name last_name created_datetime
PROFILE 123 1001 Y Robert John 2018-01-06T12:52:09
PROFILE 456 1002 Y Y Lily Hubert 2018-01-07T11:32:07
我正在使用下面的代码,但无法获得正确的输出。有人能帮我得到正确的代码吗?
Code:
import csv
import json
import pandas as pd
from pandas.io.json import json_normalize
def json_csv():
with open('my_json_file.JSON') as data_file:
data=json.load(data_file)
normalized_df = pd.io.json.json_normalize(data)
normalized_df.to_csv('my_csv_file.csv',index=False)
return
def main():
json_csv()
main()