how to group two columns in one column order by id python

Question

Hy I have a dataframe with the following structure

And I want to group in one dataframe with onlyone column vehicle with that structure

how can I do it with python/pandas?

I tried with groupby but i failed.

Thanks!

`df.set_index("Id").stack()`? – not_speshal Dec 13 '21 at 14:36 — not_speshal, Dec 13 '21 at 14:36

score 0 · Answer 1 · answered Dec 13 '21 at 14:42

0

df.set_index("Id").stack()

This will sort all elements with the same Id by their respective column order.

answered Dec 13 '21 at 14:42

BVB44

Please note that there is no need to answer a duplicate questions like this one. – BigBen Dec 13 '21 at 14:42

1 Answers1