import json
import pandas as pd
import numpy as np
jsonOne = {
"data": [
{
"id": "123456",
"create_time": "2016-03-28 11:41:00",
"phone": "13123456****",
"name": "aaa123456"
},
{
"id": "8888",
"create_time": "2016-03-30 11:41:00",
"phone": "138888****",
"name": "bbb8888"
},
{
"id": "456789",
"create_time": "2016-03-30 11:41:00",
"phone": "13456789**",
"name": "cccc456789"
}
]
}
jsonTwo = {
"data": [
{
"id": "123456",
"driver": "2016-03-123456",
"work": "work123456",
"type": "A123456"
},
{
"id": "456789",
"driver": "2016-03-456789",
"work": "work456789",
"type": "B456789"
},
{
"id": "8888",
"driver": "2016-03-128888",
"work": "work2",
"type": "B8888"
}
]
}
jsonThree = {
"data": [
{
"id": "8888",
"type": "511702198504288888"
},
{
"id": "456789",
"type": "511702198504456789"
},
{
"id": "123456",
"type": "511702198504123456"
}
]
}
newJson = {
"data": []
}
for index,item in enumerate(jsonOne['data']):
newObj = {
"Aid": item["id"],
"Bcreate_time": item["create_time"],
"Cphone": item["phone"],
"Dname": item["name"],
"Edriver": jsonTwo["data"][index]["driver"],
"Ftype": jsonTwo["data"][index]["type"],
"Gtype2": jsonThree["data"][index]["type"]
};
newJson["data"].append(newObj)
test = pd.DataFrame(newJson["data"])
test.to_csv('hello22.csv')
print(test)
需求:
ID是唯一的
需要判断相同的ID来写进数据
这里的案例代码 没有添加判断 不能调用对应的ID数据