‘’’
将大数组[00000011100
10000001000
…
]
0表示无 1表示有
变成:
310102193301180000,A00
310102194107100000,A00
310102194503180000,A00
310102194908250000,A00
txt格式
...
'''
import pandas as pd
import os
feature =[]
fea = pd.read_excel('data/originalData/feature01.xlsx')
feature = list(fea)
# print (feature)
df = pd.read_excel('data/originalData/病人_诊断情况_特征.xlsx')
file = open('data/newData/zjhm_zdbm.csv',mode='w')
#按列遍历数组
for j in feature:
for zj in range(1,len(df)):
# print (df.loc[zj][j])
if (df.loc[zj][j]>0):
file.writelines(str(df.loc[zj]['zjhm'])+','+j+'\n')
file.close()