您好,登錄后才能下訂單哦!
這篇文章主要講解了python如何實(shí)現(xiàn)把json數(shù)據(jù)轉(zhuǎn)換成Excel表格,內(nèi)容清晰明了,對(duì)此有興趣的小伙伴可以學(xué)習(xí)一下,相信大家閱讀完之后會(huì)有幫助。
json數(shù)據(jù):
[{"authenticate":-99,"last_ip":"156.2.98.429","last_time":"2020/05/23 01:41:36","member_id":5067002,"mg_id":1,"name":"yuanfang","status":0,"username":"L7898"},{"authenticate":-99,"last_ip":"156.2.98.421","last_time":"2020/05/20 14:16:02","member_id":1012304,"mg_id":1,"name":"管理員","status":0,"username":"aaaap"},{"authenticate":-99,"last_ip":"134.212.156.178","last_time":"2020/04/20 14:16:03","member_id":1012305,"mg_id":1,"name":"lily","status":0,"username":"aaaaa8"}]
將json數(shù)據(jù)轉(zhuǎn)化為Excel表格
首先在cmd里安裝tablib模塊,tablib 模塊可以完美實(shí)現(xiàn),json 轉(zhuǎn) excel,安裝方法:pip instal tablib
#!/usr/bin/python3 #防止出現(xiàn)中文亂碼 # -*- coding:utf-8 -*- import json import tablib # json.text文件的格式: [{"a":1},{"a":2},{"a":3},{"a":4},{"a":5}] # 獲取json數(shù)據(jù) with open('F:\\閱維科技2020.4\\python測(cè)試數(shù)據(jù)\\json1.txt', 'r',encoding='utf-8',errors='ignore') as f: rows = json.load(f) # 將json中的key作為header, 也可以自定義header(列名) header=tuple([ i for i in rows[0].keys()]) data = [] # 循環(huán)里面的字典,將value作為數(shù)據(jù)寫入進(jìn)去 for row in rows: body = [] for v in row.values(): body.append(v) data.append(tuple(body)) #將含標(biāo)題和內(nèi)容的數(shù)據(jù)放到data里 data = tablib.Dataset(*data,headers=header) #寫到桌面 open('C:\\Users\\91911\\Desktop\\data.xls', 'wb').write(data.xls)
結(jié)果放到了桌面,名為data.xls:
看完上述內(nèi)容,是不是對(duì)python如何實(shí)現(xiàn)把json數(shù)據(jù)轉(zhuǎn)換成Excel表格有進(jìn)一步的了解,如果還想學(xué)習(xí)更多內(nèi)容,歡迎關(guān)注億速云行業(yè)資訊頻道。
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。