May-09-2020, 10:25 AM
Are you expecting this output?
list2=[(('ATM',), ('ROA',)), (('ATM',), ('ROE',)), (('ATM',), ('NIM',)), (('ATM',), ('ROA', 'ROE'))] tm_final = {0: 3, 1: 6, 2: 4, 3: 2, 4: 0} totalrows=sum(tm_final[i]>0 for i in tm_final) df=pd.DataFrame(columns=['A','B','C']) for i in tm_final: if tm_final[i]>0: df=df.append({'A':i,'B':list2[i],'C':tm_final[i]},ignore_index=True) print(df)