Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Date ID Name Category Group Amount
- 2018-02-28 123 ABC Fruits INT 22345
- 2018-02-28 456 JFGT Veg FEE 56789
- 2018-02-28 5687 AST Seeds FEE 4567
- 2018-02-28 5687 AST Seeds INT 236
- .............
- .............
- 2018-03-31 123 ABC Fruits INT 790
- 2018-03-31 456 JFGT Veg FEE 35637
- 2018-03-31 5687 AST Seeds FEE 4567
- 2018-03-31 5687 AST Seeds INT 236
- .............
- .............
- ID Name Category INT_2018-02 INT_2018-03 FEE_2018-02 FEE_2018-03
- 123 ABC Fruits 22345 790
- 456 JFGT Veg 56789 35637
- 5687 AST Seeds 4567 4567
- 5687 AST Seeds 236 236
- .............
- .............
- df = df.set_index(['Date','ID','Name','Category','Group'])['Amount'].unstack().reset_index()
Add Comment
Please, Sign In to add comment