python pandas: transform x-y-list to x-y-coordinate system

Question

I have a dataframe df like

X Y value
1 1 foo
1 2 bar
2 1 lo
2 2 la

is there an elegant way to transform it into a x-y-map like

  1   2
1 foo bar
2 lo  la

Answer 1

try:

df.set_index(['X', 'Y'])['value'].unstack()

---

Y   1   2
X       
1   foo bar
2   lo  la