0

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

Cosmo Boy
  • 39
  • 3

0 Answers0