Hi,
I have below pandas dataframe:
I am very new to python, can anybody kindly help me how to do this,
I have below pandas dataframe:
Trial1 Trial1 Trial1 Trial2 Trial2 Name Sub_item1 Sub_item2 Sub_item3 Sub_item4 Sub_item5 2019-06-01 2016-06-01 2019-06-01 2019-06-01 2019-06-01 VBA 1 0 0 1 1 VLK 0 0 1 1 1 VBN 1 1 1 1 1Now I want to arrange as below(desired output):
Name Date Trail Sub_item value VBA 2019-06-01 Sub_item1 1 VBA 2019-06-01 Sub_item2 0 VBA 2019-06-01 Sub_item3 0 VBA 2019-06-01 Sub_item4 1 VBA 2019-06-01 Sub_item5 1 VLK 2019-06-01 Sub_item1 0 VLK 2019-06-01 Sub_item2 0 VLK 2019-06-01 Sub_item3 1 VLK 2019-06-01 Sub_item4 1 VLK 2019-06-01 Sub_item5 1 VBN 2019-06-01 Sub_item1 1 VBN 2019-06-01 Sub_item2 1 VBN 2019-06-01 Sub_item3 1 VBN 2019-06-01 Sub_item4 1 VBN 2019-06-01 Sub_item5 1
I am very new to python, can anybody kindly help me how to do this,