[
{
"name":"Iphone XR",
"price" :"$500",
"Reviews":{"user":{"Name":"mr.Y","id":122145,"review":'Wow'},
"user2":{"Name":"mr.Z","id":545145,"review":'Wow 1'},
"user3":{"Name":"mr.A","id":541274,"review":'Wow 2'},}
},
{
"name":"Iphone 13",
"price" :"$1500",
"Reviews":{"user1":{"Name":"mr.S","id":5435632,"review":'Wow11'},
"user2":{"Name":"mr.F","id":546645,"review":'Wow22'},
"user3":{"Name":"mr.G","id":255863,"review":'Wow33'},}
},
]
我正在使用python。我有这些数据。如何获得漂亮的excel或任何类似excel的输出。
我不太擅长节目。输出如下:
No. P-name price Reviews Name id review Name id review
1 Ipho.. $500 Name 4.. Good Phone Mr.. .... ......
2
................................................
我正在使用Pandas,但我没有得到同样的结果。对此数据的任何建议或解决方案。
1条答案
按热度按时间axzmvihb1#
尝试通过
json_normalize()
,rename()
及to_excel()
方法:excel文件的输出:
或
分3个步骤: