I have this dataframe and would like to divide the quantity column by the cell values so that the quantity column will only be populated with “1” for each row.
Also, the other columns would have to be divided by the quantity as well.
Not sure it’s clear but thanks for your help.
(https://i.sstatic.net/656J6T3B.png)
Desired output for the first 3 lines:
Quantity Product Amount Collected
1 19.84
1 20
1 20
New contributor
Riyad B is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.