python处理json文件

python处理json文件
把json文件里的数据（对应关系）存到一个文件里
存储成两列，用\t分隔
第一列命名为key，一列命名为value

img


import json

with open('untitled.json', 'r') as f:
    dct = json.load(f)
with open('output.txt', 'w') as f:
    for k,v in dct.items():
        f.writelines('{}\t{}\n'.format(k, v))


json_data = {"TCGA": "Tumor", "A40B": "Primary"}
with open('test.txt', 'w') as f:
    for key, value in json_data.items():
        f.write(key + '\t' + value + '\n')

import json
data = '{"TCGA-A2_A0CY":"Primary Tumor","TCGA-B6_A408":"Primary Tumor"}'
with open('/home/xufive/demo.csv', 'w') as fp:
    for item in json.loads(data).items():
        fp.write('%s\t%s\n'%item)

import json

f = open("1.json", "r", encoding="utf_8")
txt = open('1.txt', 'w')
dat = json.load(f)

for key, value in dict(dat).items():
    txt.write(key + '\t' + value + '\n')
txt.close()

dirname=r'C:\Users\Administrator\Desktop'

import json

res = json.load(open(dirname + r"\test.json"))
with open(dirname + r"\testN.txt", 'w', encoding ='utf-8') as fp:    
    for k, v in res.items():
        print(k + '\t' + v, file =fp)

img


import random
import pandas as pd

a_l=[chr(66+random.randint(1,24)) for i in range(10)]

fi=open("data.csv",'w')                                 ##自己修改

d={}
for i in a_l:
    d[i]=d.get(i,0)+1

df=pd.DataFrame(data=d,index=[0])
df.to_csv("data.csv",index=False,encoding='utf-8-sig')
fi.close()