首页 > 判断ID为标准,写入数据~~

判断ID为标准,写入数据~~

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数据

【热门文章】
【热门文章】