Please help, I want to combine rows in a pandas dataframe like this
idx SKUID currItemCnt moving expDate entryDate batchNo cntMax Lbl Lvl Aisle Row Rack wMax Coord
0 195 100 Fast 2022-01-31 1900-01-01 1 4444.0 1AP-01-01-01 1 A 1 1 1000000 [1,1]
80 185 19 Medium 2022-01-31 1900-01-01 1 37.0 1AP-01-03-01 3 A 1 1 1000000 [1,1]
81 185 10 Medium 2022-02-28 1900-01-01 2 37.0 1AP-01-03-01 3 A 1 1 1000000 [1,1]
if there are multiple rows have the same 'SKUID' and 'Lbl', i want to sum their currItemCnt into one, and combine them into one so they can be like this:
idx SKUID currItemCnt moving expDate entryDate batchNo cntMax Lbl Lvl Aisle Row Rack wMax Coord
0 195 100 Fast 2022-01-31 1900-01-01 1 4444.0 1AP-01-01-01 1 A 1 1 1000000 [1,1]
80 185 29 Medium 2022-01-31 1900-01-01 1 37.0 1AP-01-03-01 3 A 1 1 1000000 [1,1]