Electricity consumption UK 2009-2024

National Grid ESO is the electricity system operator for Great Britain. They have gathered information of the electricity demand in Great Britain from 2009. The is updated **twice an hour**, which means 48 entries per day. This makes this dataset ideal for time series forecasting.

## File information
The dataset consists of three type of files:
- Historic_demand_year_20xx.csv: electricity demand in that year
- Historic_demand_year_2009_2024.csv: all the yearly datasets merged in one
- Historic_demand_year_2009_2024_noNaN.csv: same as above, but NaN values have been removed and the date includes the hour as opposed to only the day

## Columns
The columns in the dataset are:
* SETTLEMET_DATA: date in format dd/mm/yyyy
* SETTLEMENT_PERIOD: half hourly period for the historic outtunr occurred
* ND (National Demand). National Demand is the sum of metered generation, but excludes generation required to meet station load, pump storage pumping and interconnector exports. National Demand is calculated as a sum of generation based on National Grid ESO operational generation metering. Measured in MW.
* TSD (Transmission System Demand). Transmission System Demand is equal to the ND plus the additional generation required to meet station load, pump storage pumping and interconnector exports. Measured in MW.
* ENGLAND_WALES_DEMAND. England and Wales Demand, as ND above but on an England and Wales basis. Measured in MW.
* EMBEDDED_WIND_GENERATION. This is an **estimate** of the GB wind generation from wind farms which do not have Transmission System metering installed. These wind farms are embedded in the distribution network and invisible to National Grid ESO. Their effect is to suppress the electricity demand during periods of high wind. The true output of these generators is not known so an estimate is provided based on National Grid ESO’s best model. Measured in MW.
* EMBEDDED_WIND_CAPACITY. This is National Grid ESO’s best view of the installed embedded wind capacity in GB. This is based on publicly available information compiled from a variety of sources and is not the definitive view. It is consistent with the generation estimate provided above. Measured in MW
* EMBEDDED_SOLAR_GENERATION. This is an **estimate** of the GB solar generation from PV panels. These are embedded in the distribution network and invisible to National Grid ESO. Their effect is to suppress the electricity demand during periods of high radiation. The true output of these generators is not known so an estimate is provided based on National Grid ESO’s best model. Measured in MW.
* EMBEDDED_SOLAR_CAPACITY. As embedded wind capacity above, but for solar generation. Measured in MW.
* NON_BM_STOR (Non-Balancing Mechanism SHort-Term Operating Reserve). For units that are not included in the ND generator definition. This can be in the form of generation or demand reduction. Measured in MW.
* PUMP_STORAGE_PUMPING. The demand due to pumping at hydro pump storage units; the -ve signifies pumping load.
* IFA_FLOW (IFA Interconnector Flow). The flow on on the respective interconnector. -ve signifies export power out from GB; +ve signifies import power into GB. Measured in MW.
* IFA2_FLOW (IFA Interconnector Flow). The flow on the respective interconnector. -ve signifies export power out from GB; +ve signifies import power into GB. Measured in MW.
* MOYLE_FLOW (Moyle Interconnector FLow). The flow on the respective interconnector. -ve signifies export power out from GB; +ve signifies import power into GB. Measured in MW.
* EAST_WEST_FLOW (East West Innterconnector FLow). The flow on the respective interconnector. -ve signifies export power out from GB; +ve signifies import power into GB. Measured in MW.
* NEMO_FLOW (Nemo Interconnector FLow). The flow on the respective interconnector. -ve signifies export power out from GB; +ve signifies import power into GB. Measured in MW.
* NSL_FLOW (North Sea Link Interconnector Flow). The flow on the respective interconnector. -ve signifies export power out from GB; +ve signifies import power into GB. Measured in MW.
* ELCLINK_FLOW. *Blank*

国家电网ESO是英国电力系统的运营商。自2009年起，他们已收集了英国电力需求的相关信息。该数据集每半小时更新一次，意味着每天包含48个条目。这使得该数据集非常适合进行时间序列预测。

数据集包含以下三种类型的文件：
- Historic_demand_year_20xx.csv：该年度的电力需求数据
- Historic_demand_year_2009_2024.csv：所有年度数据集合并为一个文件
- Historic_demand_year_2009_2024_noNaN.csv：与上述文件相同，但已移除NaN值，且日期包括小时而非仅限于日期。

数据集中的列包括：
* SETTLEMENT_DATA：格式为dd/mm/yyyy的日期
* SETTLEMENT_PERIOD：历史输出发生的半小时周期
* ND（国家需求）。国家需求是计量发电的总和，但排除满足电站负荷、泵储能泵送和联络线出口所需的发电。国家需求是根据国家电网ESO操作发电计量计算得出的总和。以兆瓦（MW）为单位。
* TSD（输电系统需求）。输电系统需求等于ND加上满足电站负荷、泵储能泵送和联络线出口所需的额外发电。以兆瓦（MW）为单位。
* ENGLAND_WALES_DEMAND。英格兰和威尔士需求，如同上述ND，但基于英格兰和威尔士的基准。以兆瓦（MW）为单位。
* EMBEDDED_WIND_GENERATION。这是对没有安装输电系统计量设备的英国风力发电场的GB风力发电量的**估算**。这些风力发电场嵌入在配电网中，对国家电网ESO不可见。它们的作用是在风速较高的时期抑制电力需求。由于这些发电机的真实输出量未知，因此根据国家电网ESO的最佳模型提供估算。以兆瓦（MW）为单位。
* EMBEDDED_WIND_CAPACITY。这是国家电网ESO对GB中安装的嵌入式风力发电容量的最佳看法。这是基于从各种来源收集的公开可用信息编制而成的，并非最终视图。它与上述提供的发电估算一致。以兆瓦（MW）为单位。
* EMBEDDED_SOLAR_GENERATION。这是对GB光伏电池板产生的GB太阳能发电量的**估算**。这些光伏电池板嵌入在配电网中，对国家电网ESO不可见。它们的作用是在辐射强度较高的时期抑制电力需求。由于这些发电机的真实输出量未知，因此根据国家电网ESO的最佳模型提供估算。以兆瓦（MW）为单位。
* EMBEDDED_SOLAR_CAPACITY。与上述嵌入式风力发电容量类似，但针对太阳能发电。
* NON_BM_STOR（非平衡机制短期运行储备）。对于不包括在国家需求发电机定义中的单元。这可以是发电或需求减少的形式。以兆瓦（MW）为单位。
* PUMP_STORAGE_PUMPING。水力泵储能单元抽水的需求；负值表示抽水负荷。
* IFA_FLOW（IFA联络线流量）。相应联络线上的流量。-负值表示从GB出口的电力；正值表示进入GB的电力。以兆瓦（MW）为单位。
* IFA2_FLOW（IFA联络线流量）。相应联络线上的流量。-负值表示从GB出口的电力；正值表示进入GB的电力。以兆瓦（MW）为单位。
* MOYLE_FLOW（莫伊尔联络线流量）。相应联络线上的流量。-负值表示从GB出口的电力；正值表示进入GB的电力。以兆瓦（MW）为单位。
* EAST_WEST_FLOW（东西部联络线流量）。相应联络线上的流量。-负值表示从GB出口的电力；正值表示进入GB的电力。以兆瓦（MW）为单位。
* NEMO_FLOW（Nemo联络线流量）。相应联络线上的流量。-负值表示从GB出口的电力；正值表示进入GB的电力。以兆瓦（MW）为单位。
* NSL_FLOW（北海连接联络线流量）。相应联络线上的流量。-负值表示从GB出口的电力；正值表示进入GB的电力。以兆瓦（MW）为单位。
* ELCLINK_FLOW。空白。