Aug-20-2020, 09:15 PM
I have a dataframe like shown below -
Col X Col 1 Col 2 Col 3 Col 4 Col 5 Col 6 Col 7 Col 8 Col 9 Col 10
AA A 1 1 1 1 1 1 1 1 1
BB B 3 3 3 3 3 3 3 3 3
There may be no limitation on number of columns. Col2 - Col 10 are just for example .. There could be may such columns.
What i need is a dataframe using Panda which looks like below -
Col X Col 1 New Column New Column Value
AA A Col2 1
AA A Col3 1
AA A Col4 1
AA A Col5 1
AA A Col6 1
AA A Col7 1
AA A Col8 1
AA A Col9 1
AA A Col10 1
BB B Col2 3
BB B Col3 3
BB B Col4 3
BB B Col5 3
BB B Col6 3
BB B Col7 3
BB B Col8 3
Col X Col 1 Col 2 Col 3 Col 4 Col 5 Col 6 Col 7 Col 8 Col 9 Col 10
AA A 1 1 1 1 1 1 1 1 1
BB B 3 3 3 3 3 3 3 3 3
There may be no limitation on number of columns. Col2 - Col 10 are just for example .. There could be may such columns.
What i need is a dataframe using Panda which looks like below -
Col X Col 1 New Column New Column Value
AA A Col2 1
AA A Col3 1
AA A Col4 1
AA A Col5 1
AA A Col6 1
AA A Col7 1
AA A Col8 1
AA A Col9 1
AA A Col10 1
BB B Col2 3
BB B Col3 3
BB B Col4 3
BB B Col5 3
BB B Col6 3
BB B Col7 3
BB B Col8 3