KISSmetrics生成我需要解析的无效JSON字符串。我犯了很多错误,比如
ERROR 2013-03-04 04:31:12,253 Invalid \escape: line 1 column 132 (char 132): {"search engine":"Google","_n":"search engine hit","_p":"z392cpdpnm6silblq5mac8kiugq=","search terms":"happy new year animation 1920\303\2271080 hd","_t":1356390128}
ERROR 2013-03-04 04:34:19,153 Invalid \escape: line 1 column 101 (char 101): {"search engine":"Google","_n":"ad campaign hit","_p":"byskpczsw6sorbmzqi0tk1uimgw=","search terms":"\331\203\330\261\330\252\331\207 \331\201\331\212\330\257\331\212\330\244\331\211 \330\256\331\212\331\204\330\247\330\255\331\211 \331\203\331\210\330\261\330\257\331\211","_t":1356483052}
我的代码是:
for line in lines:
try:
data = self.clean_data(json.loads(line))
except ValueError, e:
logger.error('%s: %s' % (e.message, line))
原始数据示例:
{"search engine":"Google","_n":"search engine hit","_p":"kvceh84hzbhywcnlivv+hdztizw=","search terms":"military sound effects programs","_t":1356034177}
有没有机会清理这个混乱的JSON并解析它?谢谢你的帮助
考虑CJSON用于这个精确的场景(https://pypi.python.org/pypi/python-cjson)
似乎能处理逃逸的八进制(而且很快)
您的输入数据包含八进制转义;这些都是无效的。使用正则表达式将其替换为解码字节:
这使您的输入工作:
我遇到了类似的问题,用yaml替换json库就解决了这个问题。(YAML与JSON兼容。)
例如:
相关问题 更多 >
编程相关推荐