python读取文档列表数据为列表并统计某一项数据制成邻接矩阵
import json
from pandas import DataFrame
import json
import numpy as np
file = open('db.txt', encoding='UTF-8')
js = file.read()
dic = json.loads(js)
file.close()
authors=[]
authors_id={}
empty=[]
author_name={}
maxtrix = np.zeros((100, 100))
for leng_dic in range(len(dic)):
author_dic=dic[leng_dic].get('authors', [])
if author_dic is None:
empty.append(leng_dic)
else:
author_now = []
for i in range( len(author_dic)):
author_name[author_dic[i]['_id']] = author_dic[i]['name']
if author_dic[i]['_id'] not in authors:
authors.append(author_dic[i]['_id'])
authors_id[author_dic[i]['_id']]=len(authors)
else:
authors_id[author_dic[i]['_id']]=authors_id[author_dic[i]['_id']]
author_now.append(author_dic[i]['_id'])
for author_id_now in author_now:
for author_id_now1 in author_now:
a=authors_id[author_id_now]
b=authors_id[author_id_now1]
maxtrix[a][b]=maxtrix[a ][b ]+1
maxtrix[b][a] = maxtrix[b][a] + 1
print(maxtrix)
data_frame = DataFrame(data=maxtrix)
data_frame.to_csv('maxtrix.csv')
print(authors_id)
print(author_name)
print(len(authors_id))
print(len(author_name))
|