Group column names and their values in two separate columns

Question

I have the following dataframe:

      averageNumberOfOperationsPerPath  id   get  post  put  delete  
0                             1.285714           84  12.0   4.0  1.0     1.0   
1                             1.266667           84  13.0   4.0  1.0     1.0   
2                             1.266667           84  13.0   4.0  1.0     1.0   
3                             3.333333          124   3.0   1.0  2.0     1.0   
4                             3.333333          124   3.0   1.0  2.0     1.0

I need all the different columns get, post, put, delete and there are a few more(I haven't mentioned here, the dataframe becomes too big for readability), under one column methods and other column value with their respective values.

Any help on how can I merge them to get the desired output while keeping the number of rows same.

please provide expected output. – Bushmaster Nov 14 '22 at 09:58 — Bushmaster, Nov 14 '22 at 09:58

score 2 · Answer 1 · answered Nov 14 '22 at 10:02

2

I think you can use stack method:

df= (df
     .set_index(['averageNumberOfOperationsPerPath','api_spec_id'])
     .stack()
     .reset_index()
     .rename(columns={'level_2': 'methods', 0:'values'}))

print(df)

   averageNumberOfOperationsPerPath  api_spec_id methods  values
0                          1.285714           84     get    12.0
1                          1.285714           84    post     4.0
2                          1.285714           84     put     1.0
3                          1.285714           84  delete     1.0
4                          1.266667           84     get    13.0

answered Nov 14 '22 at 10:02

YOLO

20,181
5
20
40

Amazing solution. I will have to research how the code works though xD – C-3PO Nov 14 '22 at 10:04
This gives me an error unhashable type 'dict' at set_index statement. – Brie MerryWeather Nov 14 '22 at 10:23
@BrieMerryWeather may be one of your column is a dict? – YOLO Nov 14 '22 at 10:26
I figured two of my columns have some values stored as dict, and i am not able to print out the unique values so i can delete them. Do you have any idea how can I rectify this error? – Brie MerryWeather Nov 14 '22 at 11:12

Group column names and their values in two separate columns

1 Answers1