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