Transforming data with a partial transpose

[DivyaDS]

Hello,

I have a requirement of transposing my data partially

Here is the sample Input & output I am looking for..

Pid Mkdn Date Clr Sls$ Mkdn $
1 14-Apr 100 10
1 22-Apr 200 20
1 28-Apr 300 30
2 14-Apr 100 10
2 22-Apr 200 20
2 28-Apr 300 30
3 14-Apr 100 10
3 22-Apr 200 20
3 28-Apr 300 30


Pid Mkdn Date Metric Name Value
1 14/4 Clr Sls$ 100
1 22/4 Clr Sls$ 200
1 28/4 Clr Sls$ 300
1 14/4 Mkdn$ 10
1 22/4 Mkdn$ 20
1 28/4 Mkdn$ 30
2 14/4 Clr Sls$ 100
2 22/4 Clr Sls$ 200
2 28/4 Clr Sls$ 300
2 14/4 Mkdn$ 10
2 22/4 Mkdn$ 20
2 28/4 Mkdn$ 30
3 14/4 Clr Sls$ 100
3 22/4 Clr Sls$ 200
3 28/4 Clr Sls$ 300
3 14/4 Mkdn$ 10
3 22/4 Mkdn$ 20
3 28/4 Mkdn$ 30

[Larz60+]

what have you tried, please show code

[DivyaDS]

I am new to Python, so I just have thought process.. I was just thinking.. extract each column ,make it repeat the number of times as per the product of (count of dates & number of metrics-> in this case 2 metrics, Clr Sls$, Mkdn$) for a particular Pid, then repeat the dates similarly, and then integrate the columns or something.. Please guide me on the thought process.. May be not code for now..