How to implement accurate counts or sums when you have different numbers of days of the week?
I would add a column that is a 3 if it's a weekday and a 4 if it's not using an apply, something like this:

df['divide_by'] = df.apply(lambda x: 3 if x['Day_int']&lt;5 else 4, axis=1)


Assuming days are Monday 0 to Sunday 6. Then you can add the column as follows:

df['adj_total'] = df.apply(lambda x: x['Total']/x['divide_by'], axis=1)


Then you can remove the divide_by column and you have the result