I need to convert the following output:
col1    col2    col3
---------------------
NAME    1        9
NAME    0        129
CITY    1        6
CITY    0        37
STATE   1        48
STATE   0        5
Desired output:
col0    col1    count_1s  count_0s  
-----------------------------------
95      NAME    9        129
95      CITY    6        37
95      STATE   48       48
Can anyone please help me with this? Thank you
