You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
31 lines
580 B
31 lines
580 B
# -*- coding: utf-8 -*-
|
|
|
|
"""
|
|
@Time : 2023/3/3 14:55
|
|
@Author :
|
|
@FileName:
|
|
@Software:
|
|
@Describe:
|
|
"""
|
|
import pandas as pd
|
|
import json
|
|
|
|
|
|
yy_data_1 = "../data/论文_yy_小说.xlsx"
|
|
yy_data_2 = "../data/论文_yy_小说_1.xlsx"
|
|
df_1 = pd.read_excel(yy_data_1).values.tolist()
|
|
df_2 = pd.read_excel(yy_data_2).values.tolist()
|
|
df = df_1 + df_2
|
|
|
|
return_data = {}
|
|
for i in range(len(df)):
|
|
return_data[str(i)] = df[i][0]
|
|
|
|
# import json
|
|
#
|
|
# names = ['joker','joe','nacy','timi']
|
|
#
|
|
filename='yy_data.json'
|
|
with open(filename, 'w') as file_obj:
|
|
json.dump(return_data,file_obj)
|
|
|
|
|