我是python的新手。
我有两组JSON输出文件,我需要将它们转换为csv或dataframe。
File 1
{
"lastFileTime" : "2020-06-08T00:23:05.986-07:00",
"lastFileTimeMs" : "1591600985986",
"statNames" : ["stat1", "stat2", "stat3", "stat4", "stat5", "stat6", "stat7", "stat8", "stat9"],
"values" : [[1, 2, 3, 4, 5, 6, 7, 8, 9],[9, 8, 7, 6, 5, 4, 3, 2, 1]]
}
Desired Output
stat1,stat2,stat3,stat4,stat5,stat6,stat7,stat8,stat9
1,2,3,4,5,6,7,8,9
9,8,7,6,5,4,3,2,1
因此,我需要丢弃lastFileTime和lastFileTimeMs并读取csv中的显示。我尝试了以下方法:
# Import the json module
import json
# Open a json file into a json object
with open('a.json') as F:
json_data = json.loads(F.read())
# Print loaded json object
print(json_data)
但我不断得到:
Traceback (most recent call last):
File "t.py", line 9, in <module>
json_data = json.loads(F.read())
File "/usr/lib64/python2.7/json/__init__.py", line 338, in loads
return _default_decoder.decode(s)
File "/usr/lib64/python2.7/json/decoder.py", line 366, in decode
obj, end = self.raw_decode(s, idx=_w(s, 0).end())
File "/usr/lib64/python2.7/json/decoder.py", line 384, in raw_decode
raise ValueError("No JSON object could be decoded")
ValueError: No JSON object could be decoded
任何帮助表示赞赏...我遇到的另一个问题是我被绑定到python 2.7.5 :(
import json
import itertools
if __name__ == "__main__":
jsons = json.load(open("config2.json"))
lastFileTime = jsons["lastFileTime"]
lastFileTimeMs = jsons["lastFileTimeMs"]
statNames = jsons["statNames"]
values = jsons["values"]
print(lastFileTime)
print(lastFileTimeMs)
list_to_str_statNames = ' '.join([str(element) for element in statNames])
print(str(list_to_str_statNames))
v1 = values[0]
list_to_str_v1 = ' '.join([str(element) for element in v1])
print(list_to_str_v1)
v2 = values[1]
list_to_str_v2 = ' '.join([str(element) for element in v2])
print(list_to_str_v2)
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句