How to compute avg of an index for x days before a date (if the day is not a holiday) and merge it to dataframe?

Eklenme Tarih 1 hour ago
Active 19
Görüntülenme 89
S

img description