Geek Answers Handbook

How to collapse a frame with pandas

I currently have the following data framework:

Current df :

  type part number part description waiting period hours 0 service item SOME-X1R-1807 SOME 1 day 24 1 CONSUMABLE RANDOM-462-1171 DESCRIPTION 6 days 144 2 wheel PART-7W-2326 ABOUT THE 7 days 168 3 tyre NUMBER-1R-0762 PARTS FROM THE 8 days 192 4 other NUMBER-XL-0747 PREVIOUS COLUMN 9 days 216

I want to expand the table and get the following result:

Expected df :

  SOME-X1R-1807 RANDOM-462-1171 PART-7W-2326 NUMBER-1R-076 NUMBER-XL-0747 part description SOME DESCRIPTION ABOUT THE PARTS FROM THE PREVIOUS COLUMN type service item CONSUMABLE wheel tyre other waiting period 1 day 6 days 7 days 8 days 9 days hours 24 144 168 192 216

Question:

How can I create a data frame to get this result?

What I tried:

+1
python pandas dataframe
source share
1 answer

I don't think this is a pivot

 df.set_index('part number').T Out[214]: part number SOME-X1R-1807 RANDOM-462-1171 PART-7W-2326 \ type service item CONSUMABLE wheel part description SOME ESCRIPTION ABOUT THE waiting period 1 day 6 days 7 days hours 24 144 168 part number NUMBER-1R-0762 NUMBER-XL-0747 type tyre other part description PARTS FROM THE PREVIOUS COLUMN waiting period 8 days 9 days hours 192 216
+2
source share

More articles:


All Articles