I have a data with columns Account, Name, Currency, Amount. Need to reshape/aggregate the data based on the Currency. I have tried groupby & Pivot but not getting the desired result
data
Required result
I have tried several time including below
df.pivot(index=['Account', 'Name'], columns='Currency', values='Amount')