# Holidays Data for Forecast

In this page, I will introduce how to set holidays data for time series forecasting.

## Import Holiday Data

We provide a data extension to get bank holidays, so let's import data from it.

It can be used from this "Import Extension Data" dropdown menu.

![](/files/-M4oNFgo_5xMywP830y9)

If you haven't installed the extension yet, please add it from "Add New" button. Then, the plugin is added to "Installed" and you can import data from "Import Data".

![](/files/-M4oNFgqp6BiC3YRDHAM)

You can choose holiday type, start year and end year.

![](/files/-M4oNFgtmRVtRocwhK8C)

If you import the data, it will be like this.

![](/files/-M4oNFgxH_407wPMOJ46)

## Set Up Data Format

do\_prophet, which is the function for time series forecast, expect the name of the date column to be "ds", so let's rename it.

![](/files/-M4oNFh1svHdhM8HNi9B)

And it also need "holiday" column, so let's create it.

![](/files/-M4oNFh39P1IB5omto4X)

If you'd like to to have the effect of holiday before or after the holiday too, you can also add "lower\_window" column and "upper\_window" column. For example, if you want the holiday effect to take effect from 1 day before the holiday to 1 day after the holiday, you can set -1 to the "lower\_window" column, and 1 to the "upper\_window" column. For more detail on the content of the data frame for holidays, refer to [the official document of Prophet](https://facebook.github.io/prophet/docs/seasonality,_holiday_effects,_and_regressors.html).

## Use it from Time Series Forecast

Then, you can choose this data frame from Time Series Forecast dialog and the dates in the data frame are recognized as holidays.

![](/files/-M4oNFh5Zp9UJ_2ClkSW)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.exploratory.io/setup/holiday.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.