如何在pandas[duplicate]中将重复的索引值转换为新列

print(df.groupby(level=0).agg(list)["x"].apply(pd.Series))

   0  1  2
0  a  a  a
1  b  b  b
2  c  c  c

要重命名列:

print(
    df.groupby(level=0)
    .agg(list)["x"]
    .apply(pd.Series)
    .rename(columns={0: "x", 1: "y", 2: "z"})
)

   x  y  z
0  a  a  a
1  b  b  b
2  c  c  c

#change column name as required.
new_df = pd.DataFrame(df.groupby(df.index).values.apply(list).to_list())