I have an excel with a surface column (number) and another contract column. I need that when a record has the same contract as the previous one, it adds the two surfaces
Can u share the screenshot of the input and output u need in final?
The input table is this:Data.xlsx (10.1 KB)
in the output table , I need one column for surfaces and other column for contratc. I need when the contract is the same, sum the surfaces
we can do it with a groupby and summing up. Getting an introduction to it have a look here:
Thank you very much
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.