import json
import pandas as pd
import numpy as np
jsonOne = {
"data": [
{
"id": "123456",
"create_time": "2016-03-28 11:41:00",
"phone": "138888****",
"name": "aaa"
},
{
"id": "456789",
"create_time": "2016-03-30 11:41:00",
"phone": "138888****",
"name": "bbb"
}
]
}
jsonTwo = {
"data": [
{
"id": "123456",
"driver": "330602198110264356",
"work": "work1",
"type": "A"
},
{
"id": "456789",
"driver": "511702198504283656",
"work": "work2",
"type": "B"
}
]
}
newJson = {
"data": []
}
for index,item in enumerate(jsonOne['data']):
newObj = {
"id": item["id"],
"create_time": item["create_time"],
"phone": item["phone"],
"name": item["name"],
"driver": jsonTwo["data"][index]["driver"],
};
newJson["data"].append(newObj)
test = pd.DataFrame(newJson["data"])
test.to_csv('hello2.csv')
print(test)
print '------------OK-------------'
输出这个表格的 driver 参数 是身份证信息
但是变成尾数0000
怎么设置字符串~~
从文本打开身份证是正确的,从表格打开,内容是错误的,显示0000改为文本也没办法
你这个是在excel里显示的不对吧,直接用EditPlus或UltraEdit以二进制模式打开查看,可以看到写入的数据是正确的。
因此你需要设置下Excel里的身份证显示方式
http://jingyan.baidu.com/article/8ebacdf...