# Duplicate Holidays **URL:** \ **Category:** Power Laws\ **Created:** [February 14, 2018, 4:18am UTC](https://community.drivendata.org/t/duplicate-holidays/1972 "2018-02-14T04:18:09Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![rchesak](https://avatars.discourse-cdn.com/v4/letter/r/ea666f/32.png) [@rchesak](https://community.drivendata.org/u/rchesak)\ **Post date:** [February 14, 2018, 4:18am UTC](https://community.drivendata.org/t/duplicate-holidays/1972/1 "2018-02-14T04:18:09Z")
Hi folks, There are 3,790 duplicate holidays in the holidays.csv file, when using SiteId and Date as a key. Some of these duplicates are due to actual coinciding holidays, but others are due to erroneous data (e.g. Christmas Eve is not on 12/25). Has anyone any recommendations for cleaning this up? There are far too many to clean by hand, so I am just going to remove duplicates and hope all is well unless anyone has a better solution. ![image](https://canada1.discourse-cdn.com/flex028/uploads/drivendata1/original/1X/cd7d82b99283f223a8981037d3267967bccb7615.png) ---
**Author:** ![bull](https://yyz2.discourse-cdn.com/flex028/user_avatar/community.drivendata.org/bull/32/8_2.png) [@bull](https://community.drivendata.org/u/bull)\ **Post date:** [February 23, 2018, 9:26pm UTC](https://community.drivendata.org/t/duplicate-holidays/1972/2 "2018-02-23T21:26:41Z")
In order to give the same number of days off per year, some companies “observe” holidays on different dates than the actual holiday if the holiday happens to fall on a weekend. ---
**Author:** ![Yijing](https://avatars.discourse-cdn.com/v4/letter/y/43a26b/32.png) [@Yijing](https://community.drivendata.org/u/Yijing)\ **Post date:** [March 19, 2018, 8:52pm UTC](https://community.drivendata.org/t/duplicate-holidays/1972/3 "2018-03-19T20:52:24Z")
Is it possible to provide the country location of the site so that we can calculate the missing holidays? Thanks!