> ## Documentation Index
> Fetch the complete documentation index at: https://docs.exploratory.io/llms.txt
> Use this file to discover all available pages before exploring further.

# How to Set Holidays Data for Time Series 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.

![](https://mintcdn.com/exploratory-inc/m5S7Pfr13E6f1q8Y/en/howto/images/extension_data.png?fit=max\&auto=format\&n=m5S7Pfr13E6f1q8Y\&q=85\&s=99e7c1b1fb7abfd021ad528abc5d1837)

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".

![](https://mintcdn.com/exploratory-inc/m5S7Pfr13E6f1q8Y/en/howto/images/holiday_extension.png?fit=max\&auto=format\&n=m5S7Pfr13E6f1q8Y\&q=85\&s=965f44f9da4f2e57052ac4d5c8f87314)

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

![](https://mintcdn.com/exploratory-inc/m5S7Pfr13E6f1q8Y/en/howto/images/holiday_dialog.png?fit=max\&auto=format\&n=m5S7Pfr13E6f1q8Y\&q=85\&s=b38e2937928a3a94f5bb7f765f02966f)

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

![](https://mintcdn.com/exploratory-inc/m5S7Pfr13E6f1q8Y/en/howto/images/holiday_data.png?fit=max\&auto=format\&n=m5S7Pfr13E6f1q8Y\&q=85\&s=03d920d2d09d3201d0ddebd9e9b23dbd)

## 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.

![](https://mintcdn.com/exploratory-inc/m5S7Pfr13E6f1q8Y/en/howto/images/holiday_rename.png?fit=max\&auto=format\&n=m5S7Pfr13E6f1q8Y\&q=85\&s=4ec4677cf13836e103e32eed0d311472)

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

![](https://mintcdn.com/exploratory-inc/m5S7Pfr13E6f1q8Y/en/howto/images/holiday_column.png?fit=max\&auto=format\&n=m5S7Pfr13E6f1q8Y\&q=85\&s=bd4a1f1af1e312348c070004310fee07)

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.

![](https://mintcdn.com/exploratory-inc/m5S7Pfr13E6f1q8Y/en/howto/images/holiday_command.png?fit=max\&auto=format\&n=m5S7Pfr13E6f1q8Y\&q=85\&s=2d9a6583007c36ebf8dffe73c8cb9568)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.