Transposing only specific columns to reshape Panda dataframe

Asked Dec 05 '18 at 07:31

Active Dec 05 '18 at 07:35

Viewed 22 times

I have a csv having data like :

I want only the last two columns to be somewhat like transposed like below :

Im using pandas to read in the csv and what the output dataframe to be as above.

Im not sure if we can pivot only specific columns as I want this only applied to last two columns , also I think pivot kind of aggregates the data under same column which i dont want.

edited Dec 05 '18 at 07:35

asked Dec 05 '18 at 07:31

ASHISH M.G

Use `df1 = df.set_index(['A','B','C','D'])['E'].unstack().reset_index()` – jezrael Dec 05 '18 at 07:32
This is not at all a transpose, use group by with `pivot` or `unstack` – Mohamed Thasin ah Dec 05 '18 at 07:32
@jezrael I used your solution but it is giving wrong results for A , though not the structure is correct. EG: My 'A' column has one of the value as 1020, but i can see 20 in the output. – ASHISH M.G Dec 05 '18 at 09:12
Can we achieve the same with melt ? – ASHISH M.G Dec 05 '18 at 10:09
@jezrael Can you help me with with how to reverse the same now – ASHISH M.G Dec 19 '18 at 09:45

Transposing only specific columns to reshape Panda dataframe

0 Answers0