hope1234567hope 发表于 2016-08-25 14:32

json格式的编辑

将csv的转换为json后,此时为tst.json文件如下:
[{"a":"10.100.121.187","b":"liux18","c":"2015-11-02 00:00:36","d":"GET /1jsp"},
{"a":"10.100.91.88","b":"liyunguo","c":"2012-01-01 00:01:19","d":"GET /p2.jsp"},
{"a":"10.208.26.203","b":"xuaiping1","c":"2010-12-01 00:01:31","d":"GET /in.jsp"},
{"a":"10.100.91.88","b":"liyunguo","c":"2013-12-31 00:01:32","d":"GET /n.jsp"},
{"a":"10.100.59.3","b":"liushubin2","c":"2014-12-14 00:02:46","d":"GET /2"},
{"a":"10.100.59.3","b":"liushubin2","c":"2011-12-12 00:11:46","d":"GET /1"}]

想将文件中所有的c中的内容改为类似如下的(此举例第一行的)
"c":"2015-11-02 00:00:36"改为 "c" : {"$date" : "2015-11-02T00:00:36Z"}

刚开始学python,这个python脚本怎么写?

命令行中,可以这么做:
>>> d = {"a":"10.100.121.187","b":"liux18","c":"2015-11-02 00:00:36","d":"GET /1jsp"}
>>> d['c']= "%sT%sZ" % tuple(d['c'].split())
>>> d['c']
'2015-11-02T00:00:36Z'
>>> d['c']={'$date':d['c']}
>>> d['c']
{'$date': '2015-11-02T00:00:36Z'}

251744647 发表于 2016-08-30 11:40

先json.loads(str)然后json.dumps(dic)
页: [1]
查看完整版本: json格式的编辑