0
df = pd.DataFrame(rows, columns=cols)
df_grouped = df.groupby(['request_key'])
print(df_grouped.first())

I have dataframe like this,

df
                  request_key         value_1  ...   value_2   value_3   
0           ABC_100_ALL_20230101  4.911432e+08  ...  0.000525  0.000059
1           ABC_100_ALL_20230101  4.936805e+08  ...  0.000404  0.000020
2           ABC_100_ALL_20230101  5.040532e+08  ...  0.000371  0.000019
...                                 ...           ...  ...       ...       ...
69002       XYZ_Z100_ALL_20230101  1.464886e+00  ...  0.000000  0.230000
69003       XYZ_Z100_ALL_20230101  1.472658e+00  ...  0.000000  0.000010
69004       XYZ_Z100_ALL_20230101  1.469952e+00  ...  0.000000  0.400000

Basically, I want output like this where I need to group all the values of respective column in a list based on request_key column,

request_key          value_1        value_3
ABC_100_ALL_20230101  [4.911432e+08, 4.936805e+08, 5.040532e+08] [0.000059, 0.000020, 0.000019]
...                                 ...           ...  ...       ...       ...
XYZ_Z100_ALL_20230101 [1.464886e+00, 1.472658e+00, 1.469952e+00] [0.230000, 0.000010, 0.400000]

Please suggest a way to do this.

Thanks in advance.

Murtuza Z
  • 5,639
  • 1
  • 28
  • 52

0 Answers0