b_list=[]
dd=did6.loc[0]
dd1=pd.DataFrame(dd)
list2=[x[0] for x in dd1.values]
a_list=[]
for y in range(20):
if list2[y5] in top_20:
a_list.append([list2[y5+1]])
a_list.append([list2[y5+2]])
a_list.append([list2[y5+3]])
a_list.append([list2[y*5+4]])
else:
a_list.append([0])
a_list.append([0])
a_list.append([0])
a_list.append([0])
a_array=np.array(a_list)
a_date = pd.DataFrame(a_array)
for i in range(1,36):
dd=did6.loc[i]
dd1=pd.DataFrame(dd)
list2=[x[0] for x in dd1.values]
a_list=[]
for y in range(20):
if list2[y*5] in top_20:
a_list.append([list2[y*5+1]])
a_list.append([list2[y*5+2]])
a_list.append([list2[y*5+3]])
a_list.append([list2[y*5+4]])
else:
a_list.append([0])
a_list.append([0])
a_list.append([0])
a_list.append([0])
a_array=np.array(a_list)
a_date1 = pd.DataFrame(a_array)
a_date=pd.concat([a_date,a_date1],axis=1)