1

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]
RamaH
  • 43
  • 4

0 Answers0