本文介绍了如何使用pandas的read_json函数将JSON数据转换为DataFrame，并以记录（records）格式处理内存效率问题，避免内存溢出。通过示例代码展示了如何将JSON字符串导入Excel，以及DataFrame的to_excel方法的使用。
今天展示一个利用pandas将json数据导入excel例子,主要利用的是pandas里的read_json函数将json数据转化为dataframe。
先拿出我要处理的json字符串：
strtext='[{"ttery":"min","issue":"20130801-3391","code":"8,4,5,2,9","code1":"297734529","code2":null,"time":1013395466000},\
{"ttery":"min","issue":"20130801-3390","code":"7,8,2,1,2","code1":"298058212","code2":null,"time":1013395406000},\
{"ttery":"min","issue":"20130801-3389","code":"5,9,1,2,9","code1":"298329129","code2":null,"time":1013395346000},\
{"ttery":"min","issue":"20130801-3388","code":"3,8,7,3,3","code1":"298588733","code2":null,"time":1013395286000},\
{"ttery&
最低0.47元/天 解锁文章
127
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
