Hi guys.
Hope you can helped. I have been thinking about how to solve this problem, but I cant. Basically, I have a dataset of around 800 rows, with a name that contains a value. The dataset have multiple of the same values. What I am trying to solve, is how to iterate over all the rows and add together the Number_Count, each time they have the same NameOfProduct, and then in the end, give me all the unique values with overall sum. There around 750 NameOfProducts and maybe 400 unique NameOfProduct.
Here is a part of the data.
Hope you can help! :)
Thank you!
Hope you can helped. I have been thinking about how to solve this problem, but I cant. Basically, I have a dataset of around 800 rows, with a name that contains a value. The dataset have multiple of the same values. What I am trying to solve, is how to iterate over all the rows and add together the Number_Count, each time they have the same NameOfProduct, and then in the end, give me all the unique values with overall sum. There around 750 NameOfProducts and maybe 400 unique NameOfProduct.
Here is a part of the data.
NameOfProduct Number_Count Number_of_times 0 Minilæssere 1 1 1 Pallegafler 1 1 2 Rendegravere 1 1 3 Saltspreder 1 1 4 Sneplov 2 1 5 Vogne 2 1 6 Gps 1 1 7 Skovle 1 1 8 Brakslåmaskiner 2 1 9 River Og Vendere 16 1 10 Selvkørende Finsnittere 7 1Hope it makes sense :/
Hope you can help! :)
Thank you!