0

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

enter image description here

Required result

enter image description here

I have tried several time including below

df.pivot(index=['Account', 'Name'], columns='Currency', values='Amount')
Viki_29
  • 3
  • 3

0 Answers0