Electrical consumption of household appliances

This dataset contains the load curves of various household appliances with a fine resolution (1 second) collected during 2020 over a period of one month using connected sockets installed in 13 households.

### Description of data
#### 1. Information about connected sockets
The file ‘smart_plug_devices.csv’ contains information about the 46 connected sockets that allowed power consumption readings.
The file contains the following columns:
| Column | Comments |
| — | — - |
| id | Id of the socket |
| first_ts | Date of the first measure available|
| last_ts |Date of the latest measure available|
| available_duration | Total duration of measurements available (number of days)|
| plug_name | Name of device connected to the socket|
| appliance_category | Category of device connected to the socket|
| how | Possible comments on the connected device|
| files_names | Associated csv filename|
| power_max | Maximum registered power (W)|
The possible categories of the column ‘appliance_category’ based on the column ‘plug_name’ are as follows:
— *Multimedia* = [computer, 3D_printer, internet_router, laptop, phone_charger, printer, screen, tv, sound_system]
— *Kitchen* = [boiler, coffee, freezer, fridge, micro_wave_oven]
— *washing* = [dishwasher, dryer, washing_machine]
— *Cooling* = [air_conditioner, fan]
— *Other* = [air_purify, dehumidifier, radiator, solar_panel, vacuum]

#### 2. Data collected
The file ‘data_smart_plugs.zip’ contains the ‘data’ folder in which there are 46 csv files corresponding to each row of the file ‘smart_plug_devices.csv’ (see previous section). File names can be found in the ‘files_names’ column of the file ‘smart_plug_devices.csv’ and are constructed as follows: ‘<plug_name>_<id>.csv’
Each file contains the following columns:
| Column | Comments |
| — | — - |
| timestamp | Date and time of measurement |
| power | Power (W)|

## Contact
For any questions or requests regarding this dataset, please contact [e-mail].

本数据集收录了2020年期间，通过安装于13户家庭中的智能插座（connected sockets）采集的各类家用电器负载曲线，采样分辨率高达1秒，采集周期为一个月。

### 数据说明
#### 1. 智能插座相关信息
文件‘smart_plug_devices.csv’收录了46个可采集功耗读数的智能插座的相关信息。该文件包含以下列：
| 列名 | 说明 |
| — | — - |
| id | 插座ID |
| first_ts | 首次有效测量的日期 |
| last_ts | 末次有效测量的日期 |
| available_duration | 有效测量总时长（单位：天） |
| plug_name | 插座连接设备的名称 |
| appliance_category | 连接设备的品类 |
| how | 连接设备的补充说明 |
| files_names | 关联的CSV文件名 |
| power_max | 记录到的最大功率（单位：瓦，W） |

根据‘plug_name’列，‘appliance_category’列的可选品类如下：
— *多媒体类（Multimedia）* = [电脑、3D打印机、互联网路由器、笔记本电脑、手机充电器、打印机、显示器、电视、音响系统]
— *厨房类（Kitchen）* = [热水器、咖啡机、冷柜、冰箱、微波炉]
— *洗涤类（Washing）* = [洗碗机、干衣机、洗衣机]
— *制冷类（Cooling）* = [空调、风扇]
— *其他类（Other）* = [空气净化器、除湿机、暖气片、太阳能板、吸尘器]

#### 2. 采集数据
文件‘data_smart_plugs.zip’内含‘data’文件夹，其中包含46个CSV文件，分别对应‘smart_plug_devices.csv’中的每一行数据（详见前文）。文件名可在‘smart_plug_devices.csv’的‘files_names’列中查询，命名格式为：'<plug_name>_<id>.csv'。

每个CSV文件包含以下列：
| 列名 | 说明 |
| — | — - |
| timestamp | 测量时间戳 |
| power | 功率（单位：瓦，W） |

## 联系方式
若对本数据集有任何疑问或需求，请联系 [e-mail]。