Reshape pandas dataframe using easier fonctions

Question

How it would be possible in the easiest way to reshape this data ? I succeded coding a really long fonction but I was wondering wheather there's an easier way or not.

Here there is the image of the dataframe sample I would like to reshape

And here is the dataframe sample:

L = range(0,12)
df = pd.DataFrame({'Col_1': ['a', 'b', 'c','a', 'b', 'c','a', 'b', 'c','a', 'b', 'c'], 'Col_2': ['', '', '','', '', '','', '', '','', '', ''], 'Col_3': ['x', 'y', 'z','xx', 'yy', 'zz','xxx', 'yyy', 'zzz','x1', 'y2', 'z3']},index = L)

[Please do not upload images of code/data/errors when asking a question.](//meta.stackoverflow.com/q/285551) — Josh Friedlander, Oct 06 '22 at 12:05

score 0 · Answer 1 · answered Oct 06 '22 at 12:09

0

I think this might work :

df.set_index(["Col_1",df.groupby("Col_1").cumcount()]).unstack().T.droplevel(1)

next time pls offer a minimal reproducible example for the community to help you out ^^

answered Oct 06 '22 at 12:09

grymlin

492
1
9

I have a problem with the droplevel function, does it work for any dataframe ? – Alan Nuñez Oct 06 '22 at 12:53
what error do you get ? @AlanNuñez – grymlin Oct 06 '22 at 12:55
This one : : 'DataFrame' object has no attribute 'droplevel' – Alan Nuñez Oct 06 '22 at 15:48

Reshape pandas dataframe using easier fonctions

1 Answers1