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.