python dataframe : How to transpose distinct column values

Question

I have below dataframe with unique combination of level and match,

Input Data:

level  match params  value
    0      0      m  value1
    0      1      p  value2
    1      0      m  value3
    1      1      p  value4

want to convert into below format, so that I got values in one line for level and match.

m         p
value1    value2
value3    value4

put data as `pd.DataFrame(...)` so we could copy data and use it in solutions. — furas, Sep 27 '22 at 00:33
I don't understand your output. Why do you have values `m` and `p` in column `m`? — furas, Sep 27 '22 at 00:33

score 0 · Answer 1 · answered Sep 27 '22 at 02:41

0

Found solution :
df_out = pd.pivot(df1, index='level', columns="params", values="value").reset_index()

answered Sep 27 '22 at 02:41

Kamlesh

1 Answers1