Manipulation of a csv file using ipython notebook [closed]

edit

I have a csv file which includes:

Branch       Ra   L       C        Rb
 1           1    10      1        1
 2           13   100     15       6

How can I get an output from this csv file which will look like`

Branch1:
Ra1 ndT nd1b 1
L1   nd1b nd1c  10
C1   nd1c  0      1
Rb1   nd1c  0      1

Branch2:
Ra2 ndT nd2b 13
L2   nd2b nd2c  100
C2   nd2c  0      15 
Rb2   nd2c  0      6