Hello, I am trying to transfer over from excel to pandas.
I want to add new column called 'daily_volume' where if the 'project_name' is equal to the above row project_name then calculate the difference.
For example, 1,424.53 - 1,343.68 = 80.85
My goal is to see 80.85 in row 2 under the newly created 'daily_volume' column for $LONDON Gift.
Basically, the first row for a project name will always be blank.