0

I would like to print 3 columns, but as the lenght of variable name is not the same for all, it causes disorder at printing time.

a = data_m.columns
miss_val = data_m.isnull().sum() 
per_lost_val = []
j = 0
k = 0
for i in miss_val:
    if i == 0:
        miss_val = miss_val.drop(a[j])
    else:
        per_lost_val.append(round(miss_val[a[j]]/data_m.shape[0],2)*100)
    j += 1
    
print("Variable                      Num Lost Data                  %\n\n")
j = 0
for i in miss_val:
    print(" ",miss_val.index[j],"                          ",miss_val[j],
          "                  ",per_lost_val[j])
    j += 1

#miss_val[0:]   

Resault:

Variable                      Num Lost Data                  %


  1                                8880                    23.0
  2                                8880                    23.0
  3                                8880                    23.0
  var                                20422                    52.0
  var4                                 20422                    52.0
  var5                                 20422                    52.0

Is there any way to obtain straight columns? Thanks

nz_J
  • 3
  • 1

0 Answers0